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;
}
