public List <TransferHistory> GetTransferHistory(string chkAcctNum) { List <TransferHistory> TList = null; try { string key = String.Format("TransferHistory_{0}", chkAcctNum); TList = webCache.Retrieve <List <TransferHistory> >(key); if (TList == null) { //TList = new List<TransferHistory>(); DataTable dt = GetTransferHistoryDB(chkAcctNum); TList = RepositoryHelper.ConvertDataTableToList <TransferHistory>(dt); //foreach (DataRow dr in dt.Rows) //{ // TransferHistory the = new TransferHistory(); // the.SetFields(dr); // TList.Add(the); //} webCache.Insert(key, TList); } } catch (Exception ex) { throw ex; }; return(TList); }
public List <Products> GetProductsByCategory(string catId) { List <Products> Plist = null; try { if (Plist == null) { DataTable dt = GetProductsByCategoryDB(catId); Plist = RepositoryHelper.ConvertDataTableToList <Products>(dt); } } catch (Exception ex) { throw ex; } return(Plist); }
public List <Products> GetProductsBySearch(string ProdName) { DataTable dt = null; List <Products> Plist = null; try { if (Plist == null) { string sql = "Select * from Products where ProductSDesc LIKE '%" + ProdName + "%'"; dt = _idataAccess.GetDataTable(sql); Plist = RepositoryHelper.ConvertDataTableToList <Products>(dt); } } catch (Exception ex) { throw ex; } return(Plist); }