public static GenerateReportViewModel InitGRVM(string DID)
{
var grvm = new GenerateReportViewModel
{
fDate = new DateTime(2017, 1, 1),
tDate = DateTime.Today,
module = "Disbursements",
deptID = DID,
statcategory = new List <string>(),
entcategory = new List <string>(),
employee = new List <string>(),
supplier = new List <string>(),
selectentcategory = new List <string>(),
selectstatcategory = new List <string>(),
data = new List <ChartViewModel>(),
entdata = new List <ChartViewModel>(),
stattimeDP = new ChartViewModel("Breakdown by Stationery over Time", "", new List <StringDoubleDPViewModel>()),
enttimeDP = new ChartViewModel("Breakdown by Entity over Time", "", new List <StringDoubleDPViewModel>()),
statDP = new ChartViewModel("Breakdown by Stationery Category", "", new List <StringDoubleDPViewModel>()),
deptDP = new ChartViewModel("Breakdown by Entity", "", new List <StringDoubleDPViewModel>())
};
LogicDB context = new LogicDB();
var slist = context.Stationery.GroupBy(x => x.Category).Select(y => y.Key);
foreach (var l in slist)
{
grvm.statcategory.Add(l);
}
grvm.selectstatcategory = grvm.statcategory;
if (DID == "STAT")
{
var sslist = context.PurchaseOrder.GroupBy(x => x.SupplierId).Select(y => y.Key);
foreach (var l in sslist)
{
grvm.supplier.Add(l);
}
var eelist = context.StationeryRetrieval.GroupBy(x => x.AspNetUsers.EmployeeName).Select(y => y.Key);
foreach (var l in eelist)
{
grvm.employee.Add(l);
}
var elist = context.Department.GroupBy(x => x.DepartmentId).Select(y => y.Key);
foreach (var l in elist)
{
grvm.entcategory.Add(l);
}
grvm.selectentcategory = grvm.entcategory;
}
else
{
grvm.entcategory.Add(DID);
grvm.selectentcategory.Add(DID);
}
return(grvm);
}
public static GenerateReportViewModel InitGRVM(string DID, DateTime?fromDateTP, DateTime?toDateTP,
string module, List <string> selstatcat, List <string> seldeptcat, List <string> seleecat, List <string> selsscat)
{
LogicDB context = new LogicDB();
var grvm = new GenerateReportViewModel
{
fDate = (DateTime)fromDateTP,
tDate = (DateTime)toDateTP,
module = module,
deptID = DID,
statcategory = new List <string>(),
entcategory = new List <string>(),
employee = new List <string>(),
supplier = new List <string>(),
selectentcategory = new List <string>(),
selectstatcategory = new List <string>(),
data = new List <ChartViewModel>(),
entdata = new List <ChartViewModel>(),
stattimeDP = new ChartViewModel("Breakdown by Stationery over Time", "", new List <StringDoubleDPViewModel>()),
enttimeDP = new ChartViewModel("Breakdown by Entity over Time", "", new List <StringDoubleDPViewModel>()),
statDP = new ChartViewModel("Breakdown by Stationery Category", "", new List <StringDoubleDPViewModel>()),
deptDP = new ChartViewModel("Breakdown by Entity", "", new List <StringDoubleDPViewModel>())
};
var slist = context.Stationery.GroupBy(x => x.Category).Select(y => y.Key);
foreach (var l in slist)
{
grvm.statcategory.Add(l);
}
if (selstatcat == null)
{
foreach (var l in grvm.statcategory)
{
grvm.selectstatcategory.Add(l);
}
}
else
{
foreach (var l in selstatcat)
{
grvm.selectstatcategory.Add(l);
}
}
if (DID == "STAT")
{
var sslist = context.PurchaseOrder.GroupBy(x => x.SupplierId).Select(y => y.Key);
foreach (var l in sslist)
{
grvm.supplier.Add(l);
}
var eelist = context.StationeryRetrieval.GroupBy(x => x.AspNetUsers.EmployeeName).Select(y => y.Key);
foreach (var l in eelist)
{
grvm.employee.Add(l);
}
var entlist = context.Department.GroupBy(x => x.DepartmentId).Select(y => y.Key);
foreach (var l in entlist)
{
grvm.entcategory.Add(l);
}
if (module == "Purchases")
{
if (selsscat == null)
{
foreach (var l in sslist)
{
grvm.selectentcategory.Add(l);
}
}
else
{
foreach (var l in selsscat)
{
grvm.selectentcategory.Add(l);
}
}
}
if (module == "Retrieval")
{
if (seleecat == null)
{
foreach (var l in eelist)
{
grvm.selectentcategory.Add(l);
}
}
else
{
foreach (var l in seleecat)
{
grvm.selectentcategory.Add(l);
}
}
}
else if (module == "Disbursements" || module == "ChargeBack" || module == "Requests")
{
if (seldeptcat == null)
{
foreach (var l in grvm.entcategory)
{
grvm.selectentcategory.Add(l);
}
}
else
{
foreach (var l in seldeptcat)
{
grvm.selectentcategory.Add(l);
}
}
}
}
else
{
grvm.entcategory.Add(DID);
grvm.selectentcategory.Add(DID);
}
return(grvm);
}