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