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