public static TMSBusDetails Get(System.Int64 bdBusDetailsId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSBusDetails instance;
instance = new TMSBusDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBusDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, bdBusDetailsId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSBusDetails ID:" + bdBusDetailsId.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
public static TMSBusDetails[] Search(System.Int64?bdBusDetailsId, System.String bdBusId, System.String bdBusType, System.Int64?bdTransportManagerID, System.String bdBusName, System.String bdBusNumber, System.String bdTotalNoOfSeats, System.String bdBusKMTravels, System.String bdMiledge, System.String bdCost, System.String bdMonthlyMaintanceCost, System.String bdFuel, System.String bdServicing, System.String bdOtherBusParts, System.String bdCostNeeded, System.String bdTransport, System.String bdDescription, System.String bdVia, System.String bdPrbFacing, System.String bdAddedBy, System.DateTime?bdDate, System.Int32?bdStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBusDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, bdBusDetailsId, bdBusId, bdBusType, bdTransportManagerID, bdBusName, bdBusNumber, bdTotalNoOfSeats, bdBusKMTravels, bdMiledge, bdCost, bdMonthlyMaintanceCost, bdFuel, bdServicing, bdOtherBusParts, bdCostNeeded, bdTransport, bdDescription, bdVia, bdPrbFacing, bdAddedBy, bdDate, bdStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSBusDetails.MapFrom(ds));
}
public static TMSBusDetails[] MapFrom(DataSet ds)
{
List <TMSBusDetails> objects;
// Initialise Collection.
objects = new List <TMSBusDetails>();
// Validation.
if (ds == null)
{
throw new ApplicationException("Cannot map to dataset null.");
}
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
{
return(objects.ToArray());
}
if (ds.Tables[TABLE_NAME] == null)
{
throw new ApplicationException("Cannot find table [dbo].[TMS_BusDetails] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_BusDetails] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSBusDetails instance = new TMSBusDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
public static void Update(TMSBusDetails tMSBusDetails, DbTransaction transaction)
{
tMSBusDetails.Update(transaction);
}
public static void Update(TMSBusDetails tMSBusDetails)
{
tMSBusDetails.Update();
}
public static TMSBusDetails[] Search(TMSBusDetails searchObject)
{
return Search ( searchObject.BDBusDetailsId, searchObject.BDBusId, searchObject.BDBusType, searchObject.BDTransportManagerID, searchObject.BDBusName, searchObject.BDBusNumber, searchObject.BDTotalNoOfSeats, searchObject.BDBusKMTravels, searchObject.BDMiledge, searchObject.BDCost, searchObject.BDMonthlyMaintanceCost, searchObject.BDFuel, searchObject.BDServicing, searchObject.BDOtherBusParts, searchObject.BDCostNeeded, searchObject.BDTransport, searchObject.BDDescription, searchObject.BDVia, searchObject.BDPrbFacing, searchObject.BDAddedBy, searchObject.BDDate, searchObject.BDStatus);
}
public static TMSBusDetails[] MapFrom(DataSet ds)
{
List<TMSBusDetails> objects;
// Initialise Collection.
objects = new List<TMSBusDetails>();
// Validation.
if (ds == null)
throw new ApplicationException("Cannot map to dataset null.");
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
return objects.ToArray();
if (ds.Tables[TABLE_NAME] == null)
throw new ApplicationException("Cannot find table [dbo].[TMS_BusDetails] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_BusDetails] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSBusDetails instance = new TMSBusDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSBusDetails Get(System.Int64 bdBusDetailsId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSBusDetails instance;
instance = new TMSBusDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSBusDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, bdBusDetailsId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSBusDetails ID:" + bdBusDetailsId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
public static DataSet GetSearch(TMSBusDetails searchObject)
{
return(GetSearch(searchObject.BDBusDetailsId, searchObject.BDBusId, searchObject.BDBusType, searchObject.BDTransportManagerID, searchObject.BDBusName, searchObject.BDBusNumber, searchObject.BDTotalNoOfSeats, searchObject.BDBusKMTravels, searchObject.BDMiledge, searchObject.BDCost, searchObject.BDMonthlyMaintanceCost, searchObject.BDFuel, searchObject.BDServicing, searchObject.BDOtherBusParts, searchObject.BDCostNeeded, searchObject.BDTransport, searchObject.BDDescription, searchObject.BDVia, searchObject.BDPrbFacing, searchObject.BDAddedBy, searchObject.BDDate, searchObject.BDStatus));
}
public static void Update(TMSBusDetails tMSBusDetails, DbTransaction transaction)
{
tMSBusDetails.Update(transaction);
}
public static void Update(TMSBusDetails tMSBusDetails)
{
tMSBusDetails.Update();
}
