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 Facility GetById(int id) { _dataEngine.InitialiseParameterList(); _dataEngine.AddParameter("@Id", id.ToString()); _sqlToExecute = "SELECT * FROM [dbo].[Facility] WHERE Id = " + _dataEngine.GetParametersForQuery(); if (!_dataEngine.CreateReaderFromSql(_sqlToExecute)) { throw new Exception("Facility - GetById failed"); } if (_dataEngine.Dr.Read()) { var facility = CreateFacilityFromData(); return(facility); } else { throw new Exception("Facility Id " + id.ToString() + " does not exist in database"); } }
public Court GetById(int id) { _dataEngine.InitialiseParameterList(); _dataEngine.AddParameter("@Id", id.ToString()); _sqlToExecute = "SELECT * FROM [dbo].[Court] WHERE Id = " + _dataEngine.GetParametersForQuery(); if (!_dataEngine.CreateReaderFromSql(_sqlToExecute)) { throw new Exception("Court - GetById failed"); } if (_dataEngine.Dr.Read()) { Court court = CreateCourtFromData(); return(court); } else { throw new Exception("Court Id " + id.ToString() + " does not exist in database"); } }
public BookingRecord GetById(int id) { _dataEngine.InitialiseParameterList(); _dataEngine.AddParameter("@Id", id.ToString()); _sqlToExecute = "SELECT * FROM [dbo].[BookingRecord] WHERE Id = " + _dataEngine.GetParametersForQuery(); if (!_dataEngine.CreateReaderFromSql(_sqlToExecute)) { throw new Exception("BookingRecord - GetById failed"); } if (_dataEngine.Dr.Read()) { BookingRecord bookingRecord = CreateBookingRecordFromData(); return(bookingRecord); } else { throw new Exception("BookingRecord Id " + id.ToString() + " does not exist in database"); } }
public Location GetById(int id) { _dataEngine.InitialiseParameterList(); _dataEngine.AddParameter("@Id", id.ToString()); _sqlToExecute = "SELECT * FROM [dbo].[Customer] WHERE Id = " + _dataEngine.GetParametersForQuery(); if (!_dataEngine.CreateReaderFromSql(_sqlToExecute)) { throw new Exception("Location - GetById failed"); } if (_dataEngine.Dr.Read()) { var location = CreateLocationFromData(); return(location); } else { throw new Exception("Location Id " + id.ToString() + " does not exist in database"); } }