protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SearchInput.Text = "Update"; countAVGInput.Value = "10"; stock_symbolCollection = stock_SymbolService.Getstock_SymbolList(stock_SymbolColumns.Symbol, "ASC"); } }
public virtual stock_SymbolCollection Getstock_SymbolList(stock_SymbolColumns orderBy, string orderDirection, int page, int pageSize, out int totalRecords) { try { //Database database = DatabaseFactory.CreateDatabase(); Database database = DatabaseFactory.CreateDatabase("DestinationConnection"); DbCommand dbCommand = database.GetStoredProcCommand("spstock_SymbolsGetList"); database.AddInParameter(dbCommand, "@OrderBy", DbType.AnsiString, orderBy.ToString()); database.AddInParameter(dbCommand, "@OrderDirection", DbType.AnsiString, orderDirection.ToString()); database.AddInParameter(dbCommand, "@Page", DbType.Int32, page); database.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize); database.AddOutParameter(dbCommand, "@TotalRecords", DbType.Int32, 4); stock_SymbolCollection stock_SymbolCollection = new stock_SymbolCollection(); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { stock_Symbol stock_Symbol = Createstock_SymbolFromReader(reader); stock_SymbolCollection.Add(stock_Symbol); } reader.Close(); } totalRecords = (int)database.GetParameterValue(dbCommand, "@TotalRecords"); return stock_SymbolCollection; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessGetstock_SymbolListException, ex); } }