private void CalcLossEventKantor(LossEventViewModel vm)
{
var LossK = db.LossEventKantorViews.Where(m => m.tanggal <= vm.Param.ReportDate2 && m.tanggal >= vm.Param.ReportDate);
if (vm.Param.BranchId != null)
{
LossK = LossK.Where(m => m.id_pemilik == vm.Param.BranchId);
}
vm.LossList = new List <LossRecord>();
foreach (var r in LossK)
{
LossRecord lr = new LossRecord();
lr.lossEventKantor = r;
vm.LossList.Add(lr);
}
}
private void CalcLossEventTahun(LossEventViewModel vm)
{
var LossT = db.LossEventTahunViews.Where(m => m.tahun <= vm.Param.ReportDate2.Year && m.tahun >= vm.Param.ReportDate.Year);
//var LossP = db.LossEventBulanViews.Where(m => m.tahun <= vm.Param.ReportDate2.Year && m.bulan <= vm.Param.ReportDate2.Month);
//LossP = db.LossEventBulanViews.Where(m => m.tahun >= vm.Param.ReportDate.Year && m.bulan >= vm.Param.ReportDate.Month);
if (vm.Param.BranchId != null)
{
LossT = LossT.Where(m => m.id_pemilik == vm.Param.BranchId);
}
vm.LossList = new List <LossRecord>();
foreach (var r in LossT)
{
LossRecord lr = new LossRecord();
lr.lossEventTahun = r;
vm.LossList.Add(lr);
}
}
private void CalcLossEvent(LossEventViewModel vm)
{
var loss = lossvm(vm);
vm.LossList = new List <LossRecord>();
foreach (var r in loss)
{
LossRecord lr = new LossRecord();
lr.lossEvent = r;
lr.klas = db.KlasifikasiKerugians.Where(p => p.KlasifikasiId == r.KlasifikasiId).SingleOrDefault();
if (r.BranchId == null)
{
var pemilik = db.SubDivs.Where(p => p.SubDivId == r.SubDivId).FirstOrDefault();
lr.pemilik = pemilik.SubDivName;
}
else
{
var pemilik = db.Branches.Where(p => p.BranchId == r.BranchId).FirstOrDefault();
lr.pemilik = pemilik.BranchName;
}
vm.LossList.Add(lr);
}
}
private void CalcPemilik(LossEventViewModel vm)
{
var lossP = db.LossEventPemilikViews.Where(m => m.tahun <= vm.Param.ReportDate2.Year && m.tahun >= vm.Param.ReportDate.Year);
if (vm.Param.BranchId != null)
{
lossP = lossP.Where(m => m.id_pemilik == vm.Param.BranchId);
}
if (vm.Param.KlasId != null)
{
var i = vm.Param.KlasId.ToString();
lossP = lossP.Where(k => k.id_klasifikasi == i);
}
vm.LossList = new List <LossRecord>();
foreach (var r in lossP)
{
LossRecord lr = new LossRecord();
lr.lossEventPemilik = r;
vm.LossList.Add(lr);
}
}
