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