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 int Insert(BookingRecord saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@TimeArrived", saveThis.TimeArrived.ToString());
_dataEngine.AddParameter("@ArrivalRegistrationMethod", ((int)saveThis.ArrivalRegistrationMethod).ToString());
_dataEngine.AddParameter("@BookingStatus", ((int)saveThis.BookingStatus).ToString());
_dataEngine.AddParameter("@BookingRecordUniqueId", saveThis.BookingRecordUniqueId.ToString());
_dataEngine.AddParameter("@BookingRecordPin", saveThis.BookingRecordPin.ToString());
_sqlToExecute = "INSERT INTO [dbo].[BookingRecord] ";
_sqlToExecute += "([TimeArrived]";
_sqlToExecute += ",[ArrivalRegistrationMethod]";
_sqlToExecute += ",[BookingStatus]";
_sqlToExecute += ",[BookingRecordUniqueId]";
_sqlToExecute += ",[BookingRecordPin]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("BookingRecord - Save failed");
}
return(insertedRowId);
}
public int Insert(LinkObjectMaster saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@MasterLinkTypeId", ((int)saveThis.MasterLinkType).ToString());
_dataEngine.AddParameter("@MasterLinkId", saveThis.MasterLinkId.ToString());
_dataEngine.AddParameter("@ChildLinkTypeId", ((int)saveThis.ChildLinkType).ToString());
_dataEngine.AddParameter("@ChildLinkId", saveThis.ChildLinkId.ToString());
_sqlToExecute = "INSERT INTO [dbo].[LinkObjectMaster] ";
_sqlToExecute += "([MasterLinkTypeId]";
_sqlToExecute += ",[MasterLinkId]";
_sqlToExecute += ",[ChildLinkTypeId]";
_sqlToExecute += ",[ChildLinkId]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("Link - Save failed");
}
return(insertedRowId);
}
public int Insert(Member saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@FirstName", saveThis.FirstName);
_dataEngine.AddParameter("@LastName", saveThis.LastName);
_dataEngine.AddParameter("@EmailAddress", saveThis.EmailAddress);
_dataEngine.AddParameter("@MobileNumber", saveThis.MobileNumber);
_dataEngine.AddParameter("@MembershipNumber", saveThis.MembershipNumber);
_sqlToExecute = "INSERT INTO [dbo].[Member] ";
_sqlToExecute += "([FirstName]";
_sqlToExecute += ",[LastName]";
_sqlToExecute += ",[EmailAddress]";
_sqlToExecute += ",[MobileNumber]";
_sqlToExecute += ",[MembershipNumber]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("Member - Save failed");
}
return(insertedRowId);
}
public int Insert(Facility saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@FacilityBookAheadDays", saveThis.FacilityBookAheadDays.ToString());
_sqlToExecute = "INSERT INTO [dbo].[Facility] ";
_sqlToExecute += "([FacilityBookAheadDays]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("Facility - Save failed");
}
return(insertedRowId);
}
public int Insert(Court saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@CourtDescription", saveThis.CourtDescription);
_sqlToExecute = "INSERT INTO [dbo].[Court] ";
_sqlToExecute += "([CourtDescription]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("Court - Save failed");
}
return(insertedRowId);
}
public int Insert(Customer saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@CustomerName", saveThis.CustomerName);
_dataEngine.AddParameter("@Active", saveThis.Active == true ? "1" : "0");
_sqlToExecute = "INSERT INTO [dbo].[Customer] ";
_sqlToExecute += "([CustomerName] ";
_sqlToExecute += ",[Active]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("Customer - Save failed");
}
return(insertedRowId);
}
public int Insert(Address saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@Address1", saveThis.Address1);
_dataEngine.AddParameter("@Address2", saveThis.Address2);
_dataEngine.AddParameter("@Address3", saveThis.Address3);
_dataEngine.AddParameter("@Town", saveThis.Town);
_dataEngine.AddParameter("@County", saveThis.County);
_dataEngine.AddParameter("@Country", saveThis.Country);
_dataEngine.AddParameter("@AddressOther", saveThis.AddressOther);
_dataEngine.AddParameter("@PostCode", saveThis.PostCode);
_sqlToExecute = "INSERT INTO [dbo].[Address] ";
_sqlToExecute += "([Address1]";
_sqlToExecute += ",[Address2]";
_sqlToExecute += ",[Address3]";
_sqlToExecute += ",[Town]";
_sqlToExecute += ",[County]";
_sqlToExecute += ",[Country]";
_sqlToExecute += ",[AddressOther]";
_sqlToExecute += ",[PostCode]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("Address - Save failed");
}
return(insertedRowId);
}
public int Insert(FacilitySchedule saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@FacilityBookAheadDays", saveThis.FacilityScheduleDescription);
_dataEngine.AddParameter("@StartMinuteMonday", saveThis.StartMinuteMonday.ToString());
_dataEngine.AddParameter("@EndMinuteMonday", saveThis.EndMinuteMonday.ToString());
_dataEngine.AddParameter("@MondayFacilityBookLength", saveThis.MondayFacilityBookLength.ToString());
_dataEngine.AddParameter("@StartMinuteTuesday", saveThis.StartMinuteTuesday.ToString());
_dataEngine.AddParameter("@EndMinuteTuesday", saveThis.EndMinuteTuesday.ToString());
_dataEngine.AddParameter("@TuesdayFacilityBookLength", saveThis.TuesdayFacilityBookLength.ToString());
_dataEngine.AddParameter("@StartMinuteWednesday", saveThis.StartMinuteWednesday.ToString());
_dataEngine.AddParameter("@EndMinuteWednesday", saveThis.EndMinuteWednesday.ToString());
_dataEngine.AddParameter("@WednesdayFacilityBookLength", saveThis.WednesdayFacilityBookLength.ToString());
_dataEngine.AddParameter("@StartMinuteThursday", saveThis.StartMinuteThursday.ToString());
_dataEngine.AddParameter("@EndMinuteThursday", saveThis.EndMinuteThursday.ToString());
_dataEngine.AddParameter("@ThursdayFacilityBookLength", saveThis.ThursdayFacilityBookLength.ToString());
_dataEngine.AddParameter("@StartMinuteFriday", saveThis.StartMinuteFriday.ToString());
_dataEngine.AddParameter("@EndMinuteFriday", saveThis.EndMinuteFriday.ToString());
_dataEngine.AddParameter("@FridayFacilityBookLength", saveThis.FridayFacilityBookLength.ToString());
_dataEngine.AddParameter("@StartMinuteSaturday", saveThis.StartMinuteSaturday.ToString());
_dataEngine.AddParameter("@EndMinuteSaturday", saveThis.EndMinuteSaturday.ToString());
_dataEngine.AddParameter("@SaturdayFacilityBookLength", saveThis.SaturdayFacilityBookLength.ToString());
_dataEngine.AddParameter("@StartMinuteSunday", saveThis.StartMinuteSunday.ToString());
_dataEngine.AddParameter("@EndMinuteSunday", saveThis.EndMinuteSunday.ToString());
_dataEngine.AddParameter("@SundayFacilityBookLength", saveThis.SundayFacilityBookLength.ToString());
_sqlToExecute = "INSERT INTO [dbo].[FacilitySchedule] ";
_sqlToExecute += "([FacilityScheduleDescription]";
_sqlToExecute += ",[StartMinuteMonday]";
_sqlToExecute += ",[EndMinuteMonday]";
_sqlToExecute += ",[MondayFacilityBookLength]";
_sqlToExecute += ",[StartMinuteTuesday]";
_sqlToExecute += ",[EndMinuteTuesday]";
_sqlToExecute += ",[TuesdayFacilityBookLength]";
_sqlToExecute += ",[StartMinuteWednesday]";
_sqlToExecute += ",[EndMinuteWednesday]";
_sqlToExecute += ",[WednesdayFacilityBookLength]";
_sqlToExecute += ",[StartMinuteThursday]";
_sqlToExecute += ",[EndMinuteThursday]";
_sqlToExecute += ",[ThursdayFacilityBookLength]";
_sqlToExecute += ",[StartMinuteFriday]";
_sqlToExecute += ",[EndMinuteFriday]";
_sqlToExecute += ",[FridayFacilityBookLength]";
_sqlToExecute += ",[StartMinuteSaturday]";
_sqlToExecute += ",[EndMinuteSaturday]";
_sqlToExecute += ",[SaturdayFacilityBookLength]";
_sqlToExecute += ",[StartMinuteSunday]";
_sqlToExecute += ",[EndMinuteSunday]";
_sqlToExecute += ",[SundayFacilityBookLength]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
{
throw new Exception("FacilitySchedule - Save failed");
}
return(insertedRowId);
}
