/// <summary> /// This method fetches a 'List<Admin>' object. /// This method uses the 'Admins_FetchAll' procedure. /// </summary> /// <returns>A 'List<Admin>'</returns> /// </summary> public List <Admin> FetchAllAdmins(FetchAllAdminsStoredProcedure fetchAllAdminsProc, DataConnector databaseConnector) { // Initial Value List <Admin> adminCollection = null; // Verify database connection is connected if ((databaseConnector != null) && (databaseConnector.Connected)) { // First Get Dataset DataSet allAdminsDataSet = this.DataHelper.LoadDataSet(fetchAllAdminsProc, databaseConnector); // Verify DataSet Exists if (allAdminsDataSet != null) { // Get DataTable From DataSet DataTable table = this.DataHelper.ReturnFirstTable(allAdminsDataSet); // if table exists if (table != null) { // Load Collection adminCollection = AdminReader.LoadCollection(table); } } } // return value return(adminCollection); }
/// <summary> /// This method finds a 'Admin' object. /// This method uses the 'Admin_Find' procedure. /// </summary> /// <returns>A 'Admin' object.</returns> /// </summary> public Admin FindAdmin(FindAdminStoredProcedure findAdminProc, DataConnector databaseConnector) { // Initial Value Admin admin = null; // Verify database connection is connected if ((databaseConnector != null) && (databaseConnector.Connected)) { // First Get Dataset DataSet adminDataSet = this.DataHelper.LoadDataSet(findAdminProc, databaseConnector); // Verify DataSet Exists if (adminDataSet != null) { // Get DataTable From DataSet DataRow row = this.DataHelper.ReturnFirstRow(adminDataSet); // if row exists if (row != null) { // Load Admin admin = AdminReader.Load(row); } } } // return value return(admin); }