/**
* Return all reservations of user define by user name.
*
* @param user User name
* @return ArrayList Reservation
*/
public ArrayList<Reservation> getUserReservation(String user) {
if (doLog) Log.d(TAG, "get reservations for user");
ArrayList<Reservation> comments = new ArrayList<Reservation>();
Cursor cursor =
database.query(
MySQLiteOpenHelper.TABLE_RESERVATION,
allColumnsReservation,
null,
null,
null,
null,
null);
cursor.moveToFirst();
while (!cursor.isAfterLast()) {
Reservation record = cursorToReservation(cursor);
if (record.getUser().equals(user)) {
comments.add(record);
}
cursor.moveToNext();
}
cursor.close();
if (doLog) Log.d(TAG, comments.size() + "is returned");
return comments;
}
/**
* Check if reservation with same reservation id is not already in database.
*
* @param id Reservation id
* @return True if exist.
*/
public boolean getReservationsById(long id) {
ArrayList<Reservation> res = getAllReservations();
Iterator<Reservation> it = res.iterator();
while (it.hasNext()) {
Reservation help = it.next();
Log.d(TAG, help.getUser() + " " + help.getReservationId());
if (help.getReservationId() == id) {
if (doLog) Log.d(TAG, "reservation with id: " + id + " exist");
return true;
}
}
if (doLog) Log.d(TAG, "reservation with id: " + id + " doesnt exist");
return false;
}
/**
* Insert reservation into database.
*
* @param res Reservation
*/
public void createReservation(Reservation res) {
if (doLog) Log.d(TAG, "DatabaseController - creating reservation");
Log.d(
TAG,
res.getReservationId()
+ " - "
+ res.getUser()
+ " - "
+ res.getStart()
+ " - "
+ res.getEnd()
+ " - "
+ res.getUserId());
ContentValues values = new ContentValues();
values.put(MySQLiteOpenHelper.COLUMN_RESERVATION_ID, res.getReservationId());
values.put(MySQLiteOpenHelper.COLUMN_USER, res.getUser());
values.put(MySQLiteOpenHelper.COLUMN_USER_PASSWORD, res.getPassword());
values.put(MySQLiteOpenHelper.COLUMN_RESERVATION_START, res.getStart());
values.put(MySQLiteOpenHelper.COLUMN_RESERVATION_END, res.getEnd());
values.put(MySQLiteOpenHelper.COLUMN_USER_ID, res.getUserId());
database.insert(MySQLiteOpenHelper.TABLE_RESERVATION, null, values);
if (doLog) Log.d(TAG, "reservation created");
}
