/// <summary>
/// This method fetches a 'List<DTNProcedure>' object.
/// This method uses the 'DTNProcedures_FetchAll' procedure.
/// </summary>
/// <returns>A 'List<DTNProcedure>'</returns>
/// </summary>
public List <DTNProcedure> FetchAllDTNProcedures(FetchAllDTNProceduresStoredProcedure fetchAllDTNProceduresProc, DataConnector databaseConnector)
{
// Initial Value
List <DTNProcedure> dTNProcedureCollection = null;
// Verify database connection is connected
if ((databaseConnector != null) && (databaseConnector.Connected))
{
// First Get Dataset
DataSet allDTNProceduresDataSet = this.DataHelper.LoadDataSet(fetchAllDTNProceduresProc, databaseConnector);
// Verify DataSet Exists
if (allDTNProceduresDataSet != null)
{
// Get DataTable From DataSet
DataTable table = this.DataHelper.ReturnFirstTable(allDTNProceduresDataSet);
// if table exists
if (table != null)
{
// Load Collection
dTNProcedureCollection = DTNProcedureReader.LoadCollection(table);
}
}
}
// return value
return(dTNProcedureCollection);
}
/// <summary>
/// This method finds a 'DTNProcedure' object.
/// This method uses the 'DTNProcedure_Find' procedure.
/// </summary>
/// <returns>A 'DTNProcedure' object.</returns>
/// </summary>
public DTNProcedure FindDTNProcedure(FindDTNProcedureStoredProcedure findDTNProcedureProc, DataConnector databaseConnector)
{
// Initial Value
DTNProcedure dTNProcedure = null;
// Verify database connection is connected
if ((databaseConnector != null) && (databaseConnector.Connected))
{
// First Get Dataset
DataSet dTNProcedureDataSet = this.DataHelper.LoadDataSet(findDTNProcedureProc, databaseConnector);
// Verify DataSet Exists
if (dTNProcedureDataSet != null)
{
// Get DataTable From DataSet
DataRow row = this.DataHelper.ReturnFirstRow(dTNProcedureDataSet);
// if row exists
if (row != null)
{
// Load DTNProcedure
dTNProcedure = DTNProcedureReader.Load(row);
}
}
}
// return value
return(dTNProcedure);
}
