// // GET: /AttProcessors/Create public ActionResult Create() { TAS2013Entities db = new TAS2013Entities(); User LoggedInUser = Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); String query = qb.QueryForCompanyViewLinq(LoggedInUser); ViewBag.PeriodTag = new SelectList(new List<SelectListItem> { new SelectListItem { Selected = true, Text = "Daily", Value = "D"}, new SelectListItem { Selected = false, Text = "Monthly", Value = "M"}, new SelectListItem { Selected = false, Text = "Summary", Value = "S"}, }, "Value" , "Text",1); ViewBag.CriteriaID = new SelectList(new List<SelectListItem> { new SelectListItem { Selected = true, Text = "Company", Value = "C"}, new SelectListItem { Selected = false, Text = "Location", Value = "L"}, }, "Value", "Text", 1); ViewBag.ProcessCats = new SelectList(new List<SelectListItem> { new SelectListItem { Selected = true, Text = "Yes", Value = "1"}, new SelectListItem { Selected = false, Text = "No", Value = "0"}, }, "Value", "Text", 1); ViewBag.CompanyID = new SelectList(db.Companies.Where(query).OrderBy(s=>s.CompName), "CompID", "CompName"); query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser); ViewBag.LocationID = new SelectList(db.Locations.Where(query).OrderBy(s=>s.LocName), "LocID", "LocName"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName"); return View(); }
private void BindGridView(string search) { User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewLinq(LoggedInUser); List<Company> _View = da.Companies.Where(query).ToList(); GridViewCompany.DataSource = _View.Where(aa => aa.CompName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewCompany.DataBind(); }
private void BindGridViewDivision(string search) { FiltersModel fm = Session["FiltersModel"] as FiltersModel; List<ViewDivision> _View = new List<ViewDivision>(); List<ViewDivision> _TempView = new List<ViewDivision>(); User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewLinq(LoggedInUser); _View = da.ViewDivisions.Where(query).AsQueryable().OrderBy("DivisionName ASC").ToList(); if (fm.CompanyFilter.Count > 0) { foreach (var comp in fm.CompanyFilter) { short _compID = Convert.ToInt16(comp.ID); _TempView.AddRange(_View.Where(aa => aa.CompID == _compID).ToList()); } _View = _TempView.ToList(); } GridViewDivision.DataSource = _View.Where(aa => aa.DivisionName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewDivision.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); }
private void BindGridView(string search) { User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewLinq(LoggedInUser); GridViewCompany.DataBind(); }
private void BindGridViewSection(string search) { FiltersModel fm = Session["FiltersModel"] as FiltersModel; List<ViewSection> _View = new List<ViewSection>(); List<ViewSection> _TempView = new List<ViewSection>(); User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.QueryForCompanyViewLinq(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from ViewSection where " + query); _View = dt.ToList<ViewSection>(); if (fm.CompanyFilter.Count > 0) { foreach (var comp in fm.CompanyFilter) { short _compID = Convert.ToInt16(comp.ID); _TempView.AddRange(_View.Where(aa => aa.CompID == _compID).ToList()); } _View = _TempView.ToList(); } if (fm.DivisionFilter.Count > 0) { _TempView.Clear(); foreach (var comp in fm.DivisionFilter) { short _compID = Convert.ToInt16(comp.ID); _TempView.AddRange(_View.Where(aa => aa.DivID == _compID).ToList()); } _View = _TempView.ToList(); } if (fm.DepartmentFilter.Count > 0) { _TempView.Clear(); foreach (var comp in fm.DepartmentFilter) { short _compID = Convert.ToInt16(comp.ID); _TempView.AddRange(_View.Where(aa => aa.DeptID == _compID).ToList()); } _View = _TempView.ToList(); } GridViewSection.DataSource = _View.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper())).ToList(); GridViewSection.DataBind(); }