/// <summary> /// This method fetches a 'List<Adverb>' object. /// This method uses the 'Adverbs_FetchAll' procedure. /// </summary> /// <returns>A 'List<Adverb>'</returns> /// </summary> public List <Adverb> FetchAllAdverbs(FetchAllAdverbsStoredProcedure fetchAllAdverbsProc, DataConnector databaseConnector) { // Initial Value List <Adverb> adverbCollection = null; // Verify database connection is connected if ((databaseConnector != null) && (databaseConnector.Connected)) { // First Get Dataset DataSet allAdverbsDataSet = this.DataHelper.LoadDataSet(fetchAllAdverbsProc, databaseConnector); // Verify DataSet Exists if (allAdverbsDataSet != null) { // Get DataTable From DataSet DataTable table = this.DataHelper.ReturnFirstTable(allAdverbsDataSet); // if table exists if (table != null) { // Load Collection adverbCollection = AdverbReader.LoadCollection(table); } } } // return value return(adverbCollection); }
/// <summary> /// This method finds a 'Adverb' object. /// This method uses the 'Adverb_Find' procedure. /// </summary> /// <returns>A 'Adverb' object.</returns> /// </summary> public Adverb FindAdverb(FindAdverbStoredProcedure findAdverbProc, DataConnector databaseConnector) { // Initial Value Adverb adverb = null; // Verify database connection is connected if ((databaseConnector != null) && (databaseConnector.Connected)) { // First Get Dataset DataSet adverbDataSet = this.DataHelper.LoadDataSet(findAdverbProc, databaseConnector); // Verify DataSet Exists if (adverbDataSet != null) { // Get DataTable From DataSet DataRow row = this.DataHelper.ReturnFirstRow(adverbDataSet); // if row exists if (row != null) { // Load Adverb adverb = AdverbReader.Load(row); } } } // return value return(adverb); }