// GET: /Crew/ public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page) { ViewBag.CurrentSort = sortOrder; ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; User LoggedInUser = Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewForLinq(LoggedInUser); var crew = db.Crews.AsQueryable(); if (!String.IsNullOrEmpty(searchString)) { crew = crew.Where(s => s.CrewName.ToUpper().Contains(searchString.ToUpper())); } switch (sortOrder) { case "name_desc": crew = crew.OrderByDescending(s => s.CrewName); break; default: crew = crew.OrderBy(s => s.CrewName); break; } int pageSize = 8; int pageNumber = (page ?? 1); return View(crew.ToPagedList(pageNumber, pageSize)); }
// GET: /Section/ public ActionResult Index(string sortOrder, string searchString, string currentFilter, int? page) { if (Session["LogedUserFullname"].ToString() != "") { ViewBag.CurrentSort = sortOrder; ViewBag.SectionSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; User LoggedInUser = HttpContext.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewForLinq(LoggedInUser); var sections = db.Sections.Where(query).AsQueryable(); if (!String.IsNullOrEmpty(searchString)) { sections = sections.Where(s => s.SectionName.ToUpper().Contains(searchString.ToUpper()) || s.Department.DeptName.ToUpper().Contains(searchString.ToUpper()) || s.Company.CompName.ToUpper().Contains(searchString.ToUpper())); } switch (sortOrder) { case "name_desc": sections = sections.OrderByDescending(s => s.SectionName); break; default: sections = sections.OrderBy(s => s.SectionName); break; } int pageSize = 8; int pageNumber = (page ?? 1); return View(sections.ToPagedList(pageNumber, pageSize)); } else return Redirect(Request.UrlReferrer.ToString()); }
private void BindGridViewType(string search) { FiltersModel fm = Session["FiltersModel"] as FiltersModel; List<ViewEmpType> _View = new List<ViewEmpType>(); List<ViewEmpType> _TempView = new List<ViewEmpType>(); User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewForLinq(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from ViewEmpType where " + query); _View = dt.ToList<ViewEmpType>(); if (fm.CompanyFilter.Count > 0) { foreach (var comp in fm.CompanyFilter) { short _compID = Convert.ToInt16(comp.ID); _TempView.AddRange(_View.Where(aa => aa.CompanyID == _compID).ToList()); } _View = _TempView.ToList(); } GridViewType.DataSource = _View.Where(aa => aa.TypeName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewType.DataBind(); }
public ActionResult Edit(short? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Department department = db.Departments.Find(id); if (department == null) { return HttpNotFound(); } User LoggedInUser = Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewForLinq(LoggedInUser); string query1 = qb.QueryForCompanyViewLinq(LoggedInUser); ViewBag.DivID = new SelectList(db.Divisions.Where(query).AsQueryable().OrderBy(s=>s.DivisionName), "DivisionID", "DivisionName", department.DivID); ViewBag.CompanyID = new SelectList(db.Companies.Where(query1).AsQueryable().OrderBy(s => s.CompName), "CompID", "CompName"); return View(department); }