public ActionResult Edit(int i) { LossEventModel le = new LossEventModel(); le.lossEvent = db.LossEvents.Single(p => p.LossEventId == i); Dictionary <string, string> catList = new Dictionary <string, string>(); foreach (var Klasifikasi in db.KlasifikasiKerugians.OrderBy(m => m.KlasifikasiId)) { catList.Add(Klasifikasi.KlasifikasiId, Klasifikasi.Klasifikasi); } le.klasifikasi = new SelectList(catList, "Key", "Value", 1); Dictionary <string, string> coverageList = new Dictionary <string, string> { { "Nasional", "Nasional" }, { "Kantor Pusat", "Kantor Pusat" }, { "Kantor Cabang", "Kantor Cabang" }, { "Korwil", "Korwil" }, { "Kelas KC", "Kelas KC" }, }; le.cakupan = new SelectList(coverageList, "Key", "Value", 1); return(View(le)); }
public Task <int> CreateAsync(LossEventModel model) { do { model.Code = CodeGenerator.Generate(); }while (DbSet.Any(d => d.Code.Equals(model.Code))); LossEventLogic.CreateModel(model); return(DbContext.SaveChangesAsync()); }
public ActionResult Approve(LossEventModel le) { Askrindo.Models.LossEvent loss = db.LossEvents.Single(p => p.LossEventId == le.lossEvent.LossEventId); loss.ApproveDate = DateTime.Now; loss.ApproveId = data.UserId; loss.Status = "1"; //db.LossEvents.Attach(loss); db.SaveChanges(); return(RedirectToAction("lossEventApprove")); }
public ActionResult Detail(int?id) { LossEventModel le = new LossEventModel(); le.lossEvent = db.LossEvents.Single(p => p.LossEventId == id); Dictionary <string, string> catList = new Dictionary <string, string>(); foreach (var Klasifikasi in db.KlasifikasiKerugians.OrderBy(m => m.KlasifikasiId)) { catList.Add(Klasifikasi.KlasifikasiId, Klasifikasi.Klasifikasi); } le.klasifikasi = new SelectList(catList, "Key", "Value", 1); return(View(le)); }
public ActionResult LossEventApprove() { if (!data.IsAdmin && !data.IsRiskOwner) { LossEventModel le = new LossEventModel(); le.tglAwal = DateTime.Now; le.tglAkhir = DateTime.Now; var query = from l in db.LossEvents join k in db.KlasifikasiKerugians on l.KlasifikasiId equals k.KlasifikasiId join s in db.SubDivs on l.SubDivId equals s.SubDivId where l.SubDivId == data.SubDivId where l.ApproveDate == null select new joinLossEvent { lossEvent = l, klas = k, subdiv = s, pos = 1 }; if (data.BranchId != null) { query = from l in db.LossEvents join k in db.KlasifikasiKerugians on l.KlasifikasiId equals k.KlasifikasiId join b in db.Branches on l.BranchId equals b.BranchId where l.BranchId == data.BranchId where l.ApproveDate == null select new joinLossEvent { lossEvent = l, klas = k, branch = b, pos = 2 }; } le.joinLossEvent = query;//.Where(m => m.lossEvent.ApproveDate == null).ToList(); Dictionary <string, string> catList = new Dictionary <string, string>(); foreach (var Klasifikasi in db.KlasifikasiKerugians.OrderBy(m => m.KlasifikasiId)) { catList.Add(Klasifikasi.KlasifikasiId, Klasifikasi.Klasifikasi); } le.klasifikasi = new SelectList(catList, "Key", "Value", 1); return(View(le)); } else { ViewBag.Message = "Tidak bisa melakukan approve loss event "; return(View("Error")); } }
public ActionResult LossEventNew(LossEventModel le) { //Askrindo.Models.LossEvent loss = new Askrindo.Models.LossEvent(); //var id = db.LossEvents.OrderByDescending(p => p.LossEventId).FirstOrDefault(); /*loss.Action = le.lossEvent.Action; * loss.Assets = le.lossEvent.Assets; * loss.BizUnitId = data.BizUnitId; * loss.BranchId = data.BranchId; * loss.DeptId = data.DeptId; * loss.DivisionId = data.DivisionId; * loss.ImpactFinancial = le.lossEvent.ImpactFinancial; * loss.ImpactNonFinancial = le.lossEvent.ImpactNonFinancial; * loss.InputDate = DateTime.Now; * loss.JobTitle = data.JobTitle; * loss.Keterangan = le.lossEvent.Keterangan; * loss.KlasifikasiId = le.lossEvent.KlasifikasiId; * loss.Location = le.lossEvent.Location; * loss.LossCause = le.lossEvent.LossCause; * loss.LossDate = le.lossDate; * loss.LossEventCode = le.code; * loss.LossEventName = le.lossEvent.LossEventName; * loss.PihakTerlibat = le.lossEvent.PihakTerlibat; * loss.SubBranchIs = data.SubBranchId; * loss.SubDeptId = data.SubDeptId; * loss.SubDivId = data.SubDivId; * loss.UserId = data.UserId;*/ le.lossEvent.LossEventCode = le.code; le.lossEvent.JobTitle = data.JobTitle; le.lossEvent.SubDeptId = data.SubDeptId; le.lossEvent.SubDivId = data.SubDivId; le.lossEvent.UserId = data.UserId; le.lossEvent.BizUnitId = data.BizUnitId; le.lossEvent.BranchId = data.BranchId; le.lossEvent.DeptId = data.DeptId; le.lossEvent.DivisionId = data.DivisionId; le.lossEvent.InputDate = DateTime.Now; le.lossEvent.LossDate = le.lossDate; db.LossEvents.Add(le.lossEvent); db.SaveChanges(); Utils.IncrementSerialNumberLossEvent(db); return(RedirectToAction("LossEventList")); }
public ActionResult LossEventApprove(LossEventModel le) { var query = from l in db.LossEvents join k in db.KlasifikasiKerugians on l.KlasifikasiId equals k.KlasifikasiId join s in db.SubDivs on l.SubDivId equals s.SubDivId where l.SubDivId == data.SubDivId where l.ApproveDate == null where l.KlasifikasiId == le.lossEvent.KlasifikasiId where l.LossDate >= le.tglAwal where l.LossDate <= le.tglAkhir select new joinLossEvent { lossEvent = l, klas = k, subdiv = s, pos = 1 }; if (data.BranchId != null) { query = from l in db.LossEvents join k in db.KlasifikasiKerugians on l.KlasifikasiId equals k.KlasifikasiId join b in db.Branches on l.BranchId equals b.BranchId where l.BranchId == data.BranchId where l.ApproveDate == null where l.KlasifikasiId == le.lossEvent.KlasifikasiId where l.LossDate >= le.tglAwal where l.LossDate <= le.tglAkhir select new joinLossEvent { lossEvent = l, klas = k, branch = b, pos = 2 }; } le.joinLossEvent = query.ToList(); Dictionary <string, string> catList = new Dictionary <string, string>(); foreach (var Klasifikasi in db.KlasifikasiKerugians.OrderBy(m => m.KlasifikasiId)) { catList.Add(Klasifikasi.KlasifikasiId, Klasifikasi.Klasifikasi); } le.klasifikasi = new SelectList(catList, "Key", "Value", 1); return(View(le)); }
public ActionResult LossEventNew() { string riskOwner = db.SubDivs.Where(x => x.SubDivId == data.SubDivId).FirstOrDefault().SubDivName; LossEventModel le = new LossEventModel(); le.inputDate = DateTime.Now; le.lossDate = DateTime.Now; le.code = "L" + Utils.GetFormattedSerialNumberLossEvent(data); le.lossEvent = new Askrindo.Models.LossEvent(); le.lossEvent.LossOwner = riskOwner; Dictionary <string, string> catList = new Dictionary <string, string>(); foreach (var Klasifikasi in db.KlasifikasiKerugians.OrderBy(m => m.KlasifikasiId)) { catList.Add(Klasifikasi.KlasifikasiId, Klasifikasi.Klasifikasi); } le.klasifikasi = new SelectList(catList, "Key", "Value", 1); Dictionary <string, string> coverageList = new Dictionary <string, string> { { "Nasional", "Nasional" }, { "Kantor Pusat", "Kantor Pusat" }, { "Kantor Cabang", "Kantor Cabang" }, { "Korwil", "Korwil" }, { "Kelas KC", "Kelas KC" }, }; le.cakupan = new SelectList(coverageList, "Key", "Value", 1); if (data.IsAdmin) { ViewBag.Message = "Tidak Bisa Melakukan Input Loss Event"; return(View("Error")); } else { return(View(le)); } }
public ActionResult ShowApproved() { if (!data.IsAdmin || !data.IsRiskOwner) { LossEventModel le = new LossEventModel(); var query = from l in db.LossEvents join k in db.KlasifikasiKerugians on l.KlasifikasiId equals k.KlasifikasiId join s in db.SubDivs on l.SubDivId equals s.SubDivId where l.SubDivId == data.SubDivId where l.ApproveDate != null select new joinLossEvent { lossEvent = l, klas = k, subdiv = s, pos = 1 }; if (data.BranchId != null) { query = from l in db.LossEvents join k in db.KlasifikasiKerugians on l.KlasifikasiId equals k.KlasifikasiId join b in db.Branches on l.BranchId equals b.BranchId where l.BranchId == data.BranchId where l.ApproveDate != null select new joinLossEvent { lossEvent = l, klas = k, branch = b, pos = 2 }; query.Where(m => m.lossEvent.BranchId == data.BranchId); } le.joinLossEvent = query;//.Where(m => m.lossEvent.ApproveDate != null).ToList(); return(View(le)); } else { ViewBag.Message = "Tidak bisa melakukan approve loss event "; return(View("Error")); } }
public ActionResult Edit(LossEventModel le) { Askrindo.Models.LossEvent loss = db.LossEvents.Single(p => p.LossEventId == le.lossEvent.LossEventId); loss.Action = le.lossEvent.Action; loss.Assets = le.lossEvent.Assets; loss.ImpactFinancial = le.lossEvent.ImpactFinancial; loss.ImpactNonFinancial = le.lossEvent.ImpactNonFinancial; loss.Keterangan = le.lossEvent.Keterangan; loss.KlasifikasiId = le.lossEvent.KlasifikasiId; loss.Location = le.lossEvent.Location; loss.LossCause = le.lossEvent.LossCause; loss.LossDate = le.lossEvent.LossDate; loss.LossEventName = le.lossEvent.LossEventName; loss.PihakTerlibat = le.lossEvent.PihakTerlibat; loss.LossOwner = le.lossEvent.LossOwner; loss.ProductType = le.lossEvent.ProductType; loss.Tertanggung = le.lossEvent.Tertanggung; loss.DebiturTertanggung = le.lossEvent.DebiturTertanggung; loss.Obligee = le.lossEvent.Obligee; loss.Principal = le.lossEvent.Principal; loss.NilaiJaminan = le.lossEvent.NilaiJaminan; loss.Collateral = le.lossEvent.Collateral; loss.Project = le.lossEvent.Project; loss.CasePosition = le.lossEvent.CasePosition; loss.Affiliate = le.lossEvent.Affiliate; loss.CaseType = le.lossEvent.CaseType; loss.Coverage = le.lossEvent.Coverage; loss.Units = le.lossEvent.Units; loss.LossType = le.lossEvent.LossType; db.SaveChanges(); return(RedirectToAction("LossEventList")); }
public async Task <int> UpdateAsync(int id, LossEventModel model) { await LossEventLogic.UpdateModelAsync(id, model); return(await DbContext.SaveChangesAsync()); }
public ActionResult delete(LossEventModel le) { db.LossEvents.Remove(db.LossEvents.Single(m => m.LossEventId == le.lossEvent.LossEventId)); db.SaveChanges(); return(RedirectToAction("LossEventList")); }