private void BindGridViewLocation(string search) { //User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; //QueryBuilder qb = new QueryBuilder(); //string query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser); //List<Location> _View = da.Locations.Where(query).OrderBy(s=>s.LocName).ToList(); GridViewLocation.DataSource = da.Locations.Where(aa => aa.LocName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewLocation.DataBind(); }
private void BindGridViewLocation(string search) { User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewLinq(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from Location "); List <Location> _View = new List <Location>(); _View = dt.ToList <Location>().AsQueryable().SortBy("LocName").ToList(); GridViewLocation.DataSource = _View.Where(aa => aa.LocName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewLocation.DataBind(); }
private void BindGridViewLocation(string search) { TAS2013Entities db = new TAS2013Entities(); User LoggedInUser = Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewLinq(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from Location "); List <Location> _View = new List <Location>(); List <Location> _TempView = new List <Location>(); _View = dt.ToList <Location>().AsQueryable().SortBy("LocName").ToList(); foreach (var item in db.UserSections.Where(aa => aa.UserID == LoggedInUser.UserID && aa.LocationOrSection == "Location").ToList()) { _TempView.AddRange(_View.Where(aa => aa.LocID == item.LocationID).ToList()); } GridViewLocation.DataSource = _TempView.Where(aa => aa.LocName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewLocation.DataBind(); }
private void BindGridViewLocation(string search) { FiltersModel fm = Session["FiltersModel"] as FiltersModel; List <HR_Location> _View = new List <HR_Location>(); List <HR_Location> _TempView = new List <HR_Location>(); ViewUserEmp LoggedInUser = HttpContext.Current.Session["LoggedUser"] as ViewUserEmp; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForLocReport(LoggedInUser); DataTable dt = new DataTable(); if (query != "where") { dt = qb.GetValuesfromDB("select * from HR_Location" + query + " LocationName"); } _View = dt.ToList <HR_Location>(); GridViewLocation.DataSource = _View.Where(aa => aa.LocationName.ToUpper().Contains(search.ToUpper()) && aa.Status == true).OrderBy(aa => aa.LocationName).ToList(); GridViewLocation.DataBind(); }
private void BindGridViewLocation(string search) { FiltersModel fm = Session["FiltersModel"] as FiltersModel; List <Location> _View = new List <Location>(); List <Location> _TempView = new List <Location>(); TAS2013Entities db = new TAS2013Entities(); User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForLocReport(LoggedInUser); List <City> city = db.Cities.ToList(); DataTable dt = qb.GetValuesfromDB("select * from Location " + query + " order by LocName asc"); _View = dt.ToList <Location>(); if (fm.RegionFilter.Count > 0) { _TempView.Clear(); foreach (var region in fm.RegionFilter) { short regionID = Convert.ToInt16(region.ID); foreach (var c in city.Where(aa => aa.RegionID == regionID)) { _TempView.AddRange(_View.Where(aa => aa.CityID == c.CityID).ToList()); } } _View = _TempView.ToList(); } if (fm.CityFilter.Count > 0) { _TempView.Clear(); foreach (var citi in fm.CityFilter) { short _compID = Convert.ToInt16(citi.ID); _TempView.AddRange(_View.Where(aa => aa.CityID == _compID).ToList()); } _View = _TempView.ToList(); } GridViewLocation.DataSource = _View.Where(aa => aa.LocName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewLocation.DataBind(); }
private void BindGridViewLocation(string search) { GridViewLocation.DataSource = db.Locations.ToList(); GridViewLocation.DataBind(); }