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