public ArrayList RetrieveList(string userid) { try { int iuserid = Common.SafeIntParse(userid); SqlParameter[] spParameters = new SqlParameter[1]; spParameters[0] = new SqlParameter("@" + UParameter.UserId, userid); ArrayList arrayList = new ArrayList(); DataAccess data = new DataAccess(AccessType.User); SqlDataReader reader = data.GetSqlDataReader(StoredProcedure.RetrieveListByUser, spParameters); while (reader.Read()) { UList ulist = new UList(); ulist.ListId = reader[UParameter.ListId].ToString(); ulist.BookName = reader[UParameter.BookName].ToString(); ulist.AuthorNames = reader[UParameter.AuthorNames].ToString(); ulist.Edition = reader[UParameter.Edition].ToString(); ulist.ISBN = reader[UParameter.ISBN].ToString(); ulist.EAN = reader[UParameter.EAN].ToString(); ulist.Condition = reader[UParameter.Condition].ToString(); ulist.Price = reader[UParameter.Price].ToString(); ulist.Area = reader[UParameter.Area].ToString(); ulist.NumberOfOffers = reader[UParameter.NumberOfOffers].ToString(); ulist.TimePosted = reader[UParameter.TimePosted].ToString(); arrayList.Add(ulist); } return(arrayList); } catch (Exception ex) { Log.LogError(MethodInfo.GetCurrentMethod().Name, ex.Message + ex.StackTrace); } return(null); }
public ArrayList RetrieveSearch(string searchBy, string keywords, string area, string price, string time, string sortBy) { try { int iprice = Common.SafeIntParse(price); SqlParameter[] spParameters = new SqlParameter[6]; spParameters[0] = new SqlParameter("@" + UParameter.SearchType, searchBy); spParameters[1] = new SqlParameter("@" + UParameter.Keywords, keywords); spParameters[2] = new SqlParameter("@" + UParameter.Area, area); spParameters[3] = new SqlParameter("@" + UParameter.Price, iprice); spParameters[4] = new SqlParameter("@" + UParameter.EarliestTimeListed, time); spParameters[5] = new SqlParameter("@" + UParameter.SortBy, sortBy); ArrayList arrayList = new ArrayList(); DataAccess data = new DataAccess(AccessType.Visitor); SqlDataReader reader = data.GetSqlDataReader(StoredProcedure.RetrieveSearch, spParameters); while (reader.Read()) { UList ulist = new UList(); ulist.ListId = reader[UParameter.ListId].ToString(); ulist.BookName = reader[UParameter.BookName].ToString(); ulist.AuthorNames = reader[UParameter.AuthorNames].ToString(); ulist.Edition = reader[UParameter.Edition].ToString(); ulist.ISBN = reader[UParameter.ISBN].ToString(); ulist.EAN = reader[UParameter.EAN].ToString(); ulist.Condition = reader[UParameter.Condition].ToString(); ulist.Price = reader[UParameter.Price].ToString(); ulist.Area = reader[UParameter.Area].ToString(); ulist.NumberOfOffers = reader[UParameter.NumberOfOffers].ToString(); ulist.TimePosted = reader[UParameter.TimePosted].ToString(); arrayList.Add(ulist); } return(arrayList); } catch (Exception ex) { Log.LogError(MethodInfo.GetCurrentMethod().Name, ex.Message + ex.StackTrace); } return(null); }