public PartialViewResult GetSelectListByModule(string module)
{
ReqRpt018MainViewModel Rpt018MainViewModel = new ReqRpt018MainViewModel();
try
{
if (module.ToUpper() == "ALL")
{
EqpTypeListViewModel = Rpt018MainViewModel.EqpType.Select(s => new ReqRpt018EqpTypeListViewModel()
{
EpqType = s, EqpTypeValue = s
}).ToList();
}
else
{
EqpTypeListViewModel = Rpt018MainViewModel.db.EQPType_Department_Mapping.Where(w => w.Department == module).Select(s => new ReqRpt018EqpTypeListViewModel()
{
EpqType = s.EqpType, EqpTypeValue = s.EqpType
}).Distinct().ToList();
EqpTypeListViewModel.Insert(0, new ReqRpt018EqpTypeListViewModel()
{
EpqType = "ALL", EqpTypeValue = "ALL"
});
}
return(PartialView(EqpTypeListViewModel));
}
catch (Exception)
{ return(null); }
}
// GET: ReqRpt018
public ActionResult Index()
{
ReqRpt018MainViewModel Rpt018MainViewModel = new ReqRpt018MainViewModel();
try
{
ViewBag.Modules = Rpt018MainViewModel.Modules;
ViewBag.EqpTypes = Rpt018MainViewModel.EqpType;
ViewBag.EqpID = Rpt018MainViewModel.EqpID;
ViewBag.ClickCount = Rpt018MainViewModel.StrClickCount;
return(View(ViewBag));
}
catch (Exception)
{
return(null);
}
}
public PartialViewResult GetSelectListByEqpType(string eqpType, string module)
{
ReqRpt018MainViewModel Rpt018MainViewModel = new ReqRpt018MainViewModel();
try
{
if (eqpType.ToUpper() == "ALL")
{
if (module.ToUpper() == "ALL")
{
EqpIDListViewModel = Rpt018MainViewModel.EqpID.Select(s => new ReqRpt018EqpIDListViewModel()
{
EqpID = s, EqpIDValue = s
}).ToList();
}
else
{
var eqptypelist = Rpt018MainViewModel.db.EQPType_Department_Mapping.Where(w => w.Department == module).Select(s => s.EqpType).Distinct().ToList();
EqpIDListViewModel = Rpt018MainViewModel.db.EQP_UPm_018.Where(w => eqptypelist.Contains(w.EqpType) && w.EqpID.Substring(0, 2) != "IT").Select(s => new ReqRpt018EqpIDListViewModel()
{
EqpID = s.EqpID, EqpIDValue = s.EqpID
}).Distinct().ToList();
}
}
else
{
EqpIDListViewModel = Rpt018MainViewModel.db.EQP_UPm_018.Where(w => w.EqpType == eqpType && w.EqpID.Substring(0, 2) != "IT").Select(s => new ReqRpt018EqpIDListViewModel()
{
EqpID = s.EqpID, EqpIDValue = s.EqpID
}).Distinct().ToList();
}
return(PartialView(EqpIDListViewModel));
}
catch (Exception)
{ return(null); }
}
