bool IDeleteReservation.DeleteReservation(int reservationId)
{
var deleteReservation = SDeleteReservationScript.SqlLiteDBDeleteReservation(reservationId);
string result = DBConnectAndExecute.ExecuteQuery(deleteReservation);
if (result != string.Empty)
{
SLogToFile.SaveInfoInFile(result);
return(false);
}
return(true);
}
public bool UpdateObject(Reservation dataobjectForChange, int id)
{
var updateReservation = SUpdateScripts.SqlLiteDBUpdateReservation(dataobjectForChange, id);
string result = DBConnectAndExecute.ExecuteQuery(updateReservation);
if (result != string.Empty)
{
return(false);
}
return(VerifyUpdateData(dataobjectForChange, selectReservation.GetRowsForTable(SGetAllRowsFromSpecificTable.ReservationSelectAllRowsQuery())
.Where(x => x.reservation_id == id).First()));
}
public bool UpdateObject(Client dataobjectForChange, int id)
{
var updateClient = SUpdateScripts.SqlLiteDBUpdateClient(dataobjectForChange, id);
string result = DBConnectAndExecute.ExecuteQuery(updateClient);
if (result != string.Empty)
{
return(false);
}
return(VerifyUpdateData(dataobjectForChange, selectClient.GetRowsForTable(SGetAllRowsFromSpecificTable.ClientSelectAllRowsQuery())
.Where(x => x.client_id == id).First()));
}
public int InsertObjectToDB(Employee dataObject)
{
var insertEmployes = SInsertScripts.SqlLiteDBInsertEmployee(dataObject);
string result = DBConnectAndExecute.ExecuteQuery(insertEmployes);
if (result != string.Empty)
{
return(-1);
}
var lastAddedServices = selectEmployee.GetRowsForTable(SGetAllRowsFromSpecificTable.EmployeeSelectAllRowsQuery())
.Where(x => x.employee_id == dataObject.employee_id).First();
return(lastAddedServices.employee_id);
}
public int InsertObjectToDB(Reservation dataObject)
{
var insertReservation = SInsertScripts.SqlLiteDBInsertReservation(dataObject, dataObject.client_id, dataObject.services_id, dataObject.employee_id);
string result = DBConnectAndExecute.ExecuteQuery(insertReservation);
if (result != string.Empty)
{
return(-1);
}
var lastAddedReservation = selectReservation.GetRowsForTable(SGetAllRowsFromSpecificTable.ReservationSelectAllRowsQuery())
.Where(x => x.reservation_id == dataObject.reservation_id).First();
return(lastAddedReservation.reservation_id);
}
public int InsertObjectToDB(Client dataObject)
{
var insertClient = SInsertScripts.SqlLiteDBInsertClient(dataObject);
string result = DBConnectAndExecute.ExecuteQuery(insertClient);
if (result != string.Empty)
{
return(-1);
}
//this is not nessery because i passes in client_id in the parameter
var lastAddedClient = selectClient.GetRowsForTable(SGetAllRowsFromSpecificTable.ClientSelectAllRowsQuery())
.Where(x => x.client_id == dataObject.client_id).First();
return(lastAddedClient.client_id);
}
