public HomeIndexViewModel LoadCIUnavailabilitiesWithCache(DataCenterDB _db) { var vModel = new HomeIndexViewModel(); if (SessionHelper.GetSessionHomeIndexViewModel() == null) { vModel = new HomeIndexViewModel { CIUnavailability = _db.CIUnavailabilities.Where(x => x.IS_FINALIZED != "Y").ToList() }; SessionHelper.StoreSessionHomeIndexViewModel(vModel); } else { vModel = SessionHelper.GetSessionHomeIndexViewModel(); } return vModel; }
public ActionResult ApproveAll(string selected_company_name) { if (selected_company_name == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } List<CIUnavailability> records = _db.CIUnavailabilities.Where(x => x.COMPANY == selected_company_name).ToList(); if (records != null) { foreach (CIUnavailability item in records) { item.IS_FINALIZED = "Y"; item.FINALIZED_BY = User.Identity.Name; item.FINALIZED_DATE = DateTime.Now; _db.Entry(item).State = EntityState.Modified; } try { int success = _db.SaveChanges(); if (success != 0) { TempData["type"] = "success"; TempData["title"] = "Approved All Record's"; TempData["message"] = string.Format("The record( '{0}' ) is successfully approved.", selected_company_name); } } catch (Exception e) { string error = e.Message; throw; } } var vModel = new HomeIndexViewModel(); vModel.CIUnavailability = _db.CIUnavailabilities.Where(x => x.IS_FINALIZED != "Y").ToList(); vModel.ListOfCompanies = SelectedByCompanyName(); LoadDropdowns(); //filtered List<CIUnavailability> vModelFiltered = vModel.CIUnavailability .Where(c => (string.IsNullOrEmpty(selected_company_name) || c.COMPANY == selected_company_name)).ToList(); vModel.CIUnavailability = vModelFiltered; vModel.SELECTED_COMPANY = selected_company_name; return View("Index", vModel); }
public ActionResult Index(string selected_company_name) { var vModel = new HomeIndexViewModel(); vModel.CIUnavailability = _db.CIUnavailabilities.Where(x => x.IS_FINALIZED != "Y").ToList(); vModel.ListOfCompanies = SelectedByCompanyName(); LoadDropdowns(); //filtered var vModelFiltered = vModel.CIUnavailability .Where(c => (string.IsNullOrEmpty(selected_company_name) || c.COMPANY == selected_company_name)).ToList(); vModel.CIUnavailability = vModelFiltered; vModel.SELECTED_COMPANY = selected_company_name; return View(vModel); }
public static void StoreSessionHomeIndexViewModel(HomeIndexViewModel list) { HttpContext.Current.Session.Add("HomeIndexViewModel", list); }
public IEnumerable<SelectListItem> LoadCompanyNameDataWithCache(DataCenterDB _db) { IEnumerable<SelectListItem> selectList; if (SessionHelper.GetSessionCompanyName() == null) { HomeIndexViewModel vModel = new HomeIndexViewModel { CIUnavailability = _db.CIUnavailabilities.ToList() }; var stands = vModel.CIUnavailability.Select(x => x.COMPANY).Where(e => e != null).Distinct().ToList(); selectList = from s in stands select new SelectListItem { Value = s, Text = s }; vModel.ListOfCompanies = selectList; SessionHelper.StoreSessionCompanyName(selectList); } else { selectList = SessionHelper.GetSessionCompanyName(); } return selectList; }
public HomeIndexViewModel LoadCIUnavailabilities(DataCenterDB _db) { var vModel = new HomeIndexViewModel(); vModel = new HomeIndexViewModel { CIUnavailability = _db.CIUnavailabilities.Where(x => x.IS_FINALIZED != "Y").ToList() }; return vModel; }