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