public int Insert(CourtBookingSheet saveThis) { _dataEngine.InitialiseParameterList(); _dataEngine.AddParameter("@CourtBookingStartTime", saveThis.CourtBookingStartTime.ToString()); _dataEngine.AddParameter("@CourtBookingEndTime", saveThis.CourtBookingEndTime.ToString()); _dataEngine.AddParameter("@CourtBookingDate", DataFormatting.FormatDateTime(saveThis.CourtBookingDate)); _sqlToExecute = "INSERT INTO [dbo].[CourtBookingSheet] "; _sqlToExecute += "([CourtBookingStartTime]"; _sqlToExecute += ",[CourtBookingEndTime]"; _sqlToExecute += ",[CourtBookingDate]) "; _sqlToExecute += "OUTPUT INSERTED.Id "; _sqlToExecute += "VALUES "; _sqlToExecute += "("; _sqlToExecute += _dataEngine.GetParametersForQuery(); _sqlToExecute += ")"; int insertedRowId = 0; if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId)) { throw new Exception("CourtBookingSheet - Save failed"); } return(insertedRowId); }
public void Update(CourtBookingSheet saveThis) { _dataEngine.InitialiseParameterList(); _dataEngine.AddParameter("@CourtBookingStartTime", saveThis.CourtBookingStartTime.ToString()); _dataEngine.AddParameter("@CourtBookingEndTime", saveThis.CourtBookingEndTime.ToString()); _dataEngine.AddParameter("@CourtBookingDate", DataFormatting.FormatDateTime(saveThis.CourtBookingDate)); _sqlToExecute = "UPDATE [dbo].[CourtBookingSheet] SET "; _sqlToExecute += "[CourtBookingStartTime] = @CourtBookingStartTime"; _sqlToExecute += ",[CourtBookingEndTime] = @CourtBookingEndTime"; _sqlToExecute += ",[CourtBookingDate] = CourtBookingDate "; _sqlToExecute += "WHERE [Id] = " + saveThis.Id;; if (!_dataEngine.ExecuteSql(_sqlToExecute)) { throw new Exception("CourtBookingSheet - Update failed"); } }