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); }