internal List<SearchAll> GetItemsList(int mId) { List<SearchAll> list = new List<SearchAll>(); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } DataRow[] dr = itemData.Tables[0].Select("MId = '" + mId + "'"); if (dr.Length > 0) { foreach (DataRow dtr in dr) { SearchAll prj = new SearchAll(); prj.ItemId = Convert.ToInt32(dtr["ItemId"].ToString()); prj.value = dtr["ItemName"].ToString(); list.Add(prj); } } return list.ToList(); }
internal List <SearchAll> GetItemsList(int mId) { List <SearchAll> list = new List <SearchAll>(); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } DataRow[] dr = itemData.Tables[0].Select("MId = '" + mId + "'"); if (dr.Length > 0) { foreach (DataRow dtr in dr) { SearchAll prj = new SearchAll(); prj.ItemId = Convert.ToInt32(dtr["ItemId"].ToString()); prj.value = dtr["ItemName"].ToString(); list.Add(prj); } } return(list.ToList()); }
public List<SearchAll> FetchMerchantItemNames() { DataTable mdt = (DataTable)this.Session["MId"]; int mId = Convert.ToInt32(mdt.Rows[0]["MId"].ToString()); var searchObj = new SearchAll(); var fetchItems = (List<SearchAll>)null; fetchItems = searchObj.GetItemsList(mId); return fetchItems.ToList(); }
public List<SearchAll> FetchItemNames() { //public List<BusinessLogicAutoRaksha.ServiceClasses.Area> FetchAreaNames(string areaString) var searchObj = new SearchAll(); var fetchItems = (List<SearchAll>)null; // var items = (List<SearchAll>)null; fetchItems = searchObj.GetSearchList();//items.Where(str => str.SearchString.ToLower().Contains(prefixText.ToLower())); // var filteredAreas= fetchAreas.Where(m => m.AreaName.ToLower().Contains(areaString.ToLower())); return fetchItems.ToList(); }
public List<SearchAll> GetModels(string model) { // Data access here to retrieve data for autocomplete box then convert to list var searchObj = new SearchAll(); var fetchItems = (List<SearchAll>)null; fetchItems = searchObj.GetSearchList(); // var filteredAreas= fetchAreas.Where(m => m.AreaName.ToLower().Contains(areaString.ToLower())); List<SearchAll> List = fetchItems.ToList(); // or however you get the data into list format return List; }
internal List <SearchAll> GetSearchList() { DataTable dt = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems allData = new BusinessLogicBS.BusinessClasses.ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); DataSet allDataDS = callCache.getCache(); dt = allDataDS.Tables[0]; dtg = allDataDS.Tables[1]; List <SearchAll> list = new List <SearchAll>(); int cnt = dt.Rows.Count; for (int i = 0; i < cnt; i++) { // ProjectActivity prj = new ProjectActivity(); SearchAll prj = new SearchAll(); int id = int.Parse(dt.Rows[i]["ItemId"].ToString()); int grp = int.Parse(dt.Rows[i]["CategoryId"].ToString()); prj.value = dt.Rows[i]["ItemName"].ToString(); prj.ItemLink = "../fulldetails.aspx?id=" + id + "&grp=" + grp; //prj.ActualHours = int.Parse(dt.Rows[i]["ActualHours"].ToString()); list.Add(prj); } int cnt2 = dtg.Rows.Count; for (int i = 0; i < cnt2; i++) { SearchAll prj2 = new SearchAll(); int idg = int.Parse(dtg.Rows[i]["GroupId"].ToString()); int grpg = 1; prj2.value = dtg.Rows[i]["GroupName"].ToString(); prj2.ItemLink = "../fulldetails.aspx?id=" + idg + "&grp=" + grpg; list.Add(prj2); } return(list.ToList()); }
internal List<SearchAll> GetSearchList() { DataTable dt = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems allData = new BusinessLogicBS.BusinessClasses.ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); DataSet allDataDS = callCache.getCache(); dt = allDataDS.Tables[0]; dtg = allDataDS.Tables[1]; List<SearchAll> list = new List<SearchAll>(); int cnt = dt.Rows.Count; for (int i = 0; i < cnt; i++) { // ProjectActivity prj = new ProjectActivity(); SearchAll prj = new SearchAll(); int id = int.Parse(dt.Rows[i]["ItemId"].ToString()); int grp = int.Parse(dt.Rows[i]["CategoryId"].ToString()); prj.value = dt.Rows[i]["ItemName"].ToString(); prj.ItemLink = "../fulldetails.aspx?id=" + id + "&grp=" + grp; //prj.ActualHours = int.Parse(dt.Rows[i]["ActualHours"].ToString()); list.Add(prj); } int cnt2 = dtg.Rows.Count; for (int i = 0; i < cnt2; i++) { SearchAll prj2 = new SearchAll(); int idg = int.Parse(dtg.Rows[i]["GroupId"].ToString()); int grpg = 1; prj2.value = dtg.Rows[i]["GroupName"].ToString(); prj2.ItemLink = "../fulldetails.aspx?id=" + idg + "&grp=" + grpg; list.Add(prj2); } return list.ToList(); }