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);
}
private string GetStatValue(StockStat stat, int selectedIndex, int dataPricesLength)
{
int emptyStart = dataPricesLength - stat.Data(0).Length;
if (selectedIndex < emptyStart)
{
return("");
}
List <string> values = new List <string>();
for (int i = 0; i < stat.DataCount; i++)
{
values.Add(DataFormatting.FormatStatValue(stat.Data(i)[selectedIndex - emptyStart]));
}
return(string.Join(", ", values));
}
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");
}
}
/// <summary> /// returns format string to convert datetime acording to range /// </summary> /// <param name="data"></param> /// <returns></returns> public static string DataRangeFormatString(this StockPricesData data) => DataFormatting.DataRangeFormatString(data.Range);
/// <summary> /// returns datetime format for data range select controls /// </summary> /// <param name="data"></param> /// <returns></returns> public static string DataRangeDateTimeInputFormat(this StockPricesData data) => DataFormatting.DataRangeDateTimeInputFormat(data.Range);
/// <summary> /// returns formatted string of price value /// </summary> /// <param name="stockData"></param> /// <param name="value"></param> /// <returns></returns> public static string FormatPrice(this StockDefinition stockData, double value) => DataFormatting.FormatPrice(stockData.Type, value);
