public void setDb(Context.Spk dbitem) { dbitem.Id = Id; dbitem.Jenis = Jenis; dbitem.Workshop_id = Workshop_id; dbitem.Permintaan = Permintaan; dbitem.KeteranganSPK = KeteranganSpk; dbitem.Keterangan = Keterangan; dbitem.Mekanik1 = Mekanik1; dbitem.Mekanik2 = Mekanik2; dbitem.Status = Status; if (ServiceIn != "" && ServiceIn != null) { dbitem.ServiceIn = DateTime.ParseExact(ServiceIn, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } if (Estimasi != "" && Estimasi != null) { dbitem.Estimasi = DateTime.ParseExact(Estimasi, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } if (ServiceOut != "" && ServiceOut != null) { dbitem.ServiceOut = DateTime.ParseExact(ServiceOut, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } dbitem.RevEstimasi = RevEstimasi; }
public ActionResult Spk(int id) { Context.Workshop dbitem2 = RepoWorkshop.FindByPK(id); Context.Spk dbitem = new Context.Spk(); dbitem.Workshop_id = dbitem2.Id; dbitem.Workshop = dbitem2; Workshop model2 = new Workshop(dbitem2); Spk model = new Spk(dbitem); model.Workshop = model2; ViewBag.name = model.Workshop.NoPPK; return(View("Spk", model)); }
public ActionResult UpdateSpk(Spk model) { int w_id = 0; if (ModelState.IsValid) { w_id = model.Workshop_id ?? default(int); Context.Spk dbitem = new Context.Spk(); model.setDb(dbitem); RepoSpk.save(dbitem, UserPrincipal.id); } Context.Workshop dbitem2 = RepoWorkshop.FindByPK(w_id); Workshop model2 = new Workshop(dbitem2); return(RedirectToAction("Spk", new { Id = w_id, idnya = w_id })); }
public Spk(Context.Spk dbitem) { Id = dbitem.Id; Jenis = dbitem.Jenis; Permintaan = dbitem.Permintaan; KeteranganSpk = dbitem.KeteranganSPK; Keterangan = dbitem.Keterangan; Mekanik1 = dbitem.Mekanik1; Mekanik2 = dbitem.Mekanik2; Status = dbitem.Status; ServiceIn = (dbitem.ServiceIn.ToString().Split())[0]; Estimasi = (dbitem.Estimasi.ToString().Split())[0]; ServiceOut = (dbitem.ServiceOut.ToString().Split())[0]; Workshop_id = dbitem.Workshop_id; RevEstimasi = dbitem.RevEstimasi; if (dbitem.Mekanik != null) { OmMekanik1 = dbitem.Mekanik.NamaMekanik; } if (dbitem.Mekanikk != null) { OmMekanik2 = dbitem.Mekanikk.NamaMekanik; } }
public ActionResult PpkIn(Workshop model) { if (ModelState.IsValid) { Context.Workshop dbitem = RepoWorkshop.FindByPK(model.id); model.setDbPpkIn(dbitem); RepoWorkshop.save(dbitem, UserPrincipal.id); dbitem.Spk.Clear(); RepoAuditrail.saveDelAllSpkQuery(dbitem, UserPrincipal.id); if (model.IsAc == true) { Context.Spk spk_dbitem = RepoSpk.FindByWorkshopAndType(dbitem.Id, "AC"); if (spk_dbitem == null) { spk_dbitem = new Context.Spk(); spk_dbitem.Id = spk_dbitem.Id; Spk model2 = new Spk(); model2.Jenis = "AC"; model2.Permintaan = model.KetAc; model2.Keterangan = model.KetKerjaAc; model2.Workshop_id = model.id; model2.RevEstimasi = 0; model2.setDb(spk_dbitem); RepoSpk.save(spk_dbitem, UserPrincipal.id); } else { spk_dbitem.Permintaan = model.KetAc; spk_dbitem.Keterangan = model.KetKerjaAc; RepoSpk.save(spk_dbitem, UserPrincipal.id); } } if (model.IsBan == true) { Context.Spk spk_dbitem = RepoSpk.FindByWorkshopAndType(dbitem.Id, "Ban"); if (spk_dbitem == null) { spk_dbitem = new Context.Spk(); spk_dbitem.Id = spk_dbitem.Id; Spk model2 = new Spk(); model2.Jenis = "Ban"; model2.Permintaan = model.KetBan; model2.Keterangan = model.KetKerjaBan; model2.Workshop_id = model.id; model2.RevEstimasi = 0; model2.setDb(spk_dbitem); RepoSpk.save(spk_dbitem, UserPrincipal.id); } else { spk_dbitem.Permintaan = model.KetBan; spk_dbitem.Keterangan = model.KetKerjaBan; RepoSpk.save(spk_dbitem, UserPrincipal.id); } } if (model.IsBox == true) { Context.Spk spk_dbitem = RepoSpk.FindByWorkshopAndType(dbitem.Id, "Box"); if (spk_dbitem == null) { spk_dbitem = new Context.Spk(); spk_dbitem.Id = spk_dbitem.Id; Spk model2 = new Spk(); model2.Jenis = "Box"; model2.Permintaan = model.KetBox; model2.Keterangan = model.KetKerjaBox; model2.Workshop_id = model.id; model2.RevEstimasi = 0; model2.setDb(spk_dbitem); RepoSpk.save(spk_dbitem, UserPrincipal.id); } else { spk_dbitem.Permintaan = model.KetBox; spk_dbitem.Keterangan = model.KetKerjaBox; RepoSpk.save(spk_dbitem, UserPrincipal.id); } } if (model.IsGps == true) { Context.Spk spk_dbitem = RepoSpk.FindByWorkshopAndType(dbitem.Id, "GPS"); if (spk_dbitem == null) { spk_dbitem = new Context.Spk(); spk_dbitem.Id = spk_dbitem.Id; Spk model2 = new Spk(); model2.Jenis = "GPS"; model2.Permintaan = model.KetGps; model2.Keterangan = model.KetKerjaGps; model2.Workshop_id = model.id; model2.RevEstimasi = 0; model2.setDb(spk_dbitem); RepoSpk.save(spk_dbitem, UserPrincipal.id); } else { spk_dbitem.Permintaan = model.KetGps; spk_dbitem.Keterangan = model.KetKerjaGps; RepoSpk.save(spk_dbitem, UserPrincipal.id); } } if (model.IsTruck == true) { Context.Spk spk_dbitem = RepoSpk.FindByWorkshopAndType(dbitem.Id, "Truck"); if (spk_dbitem == null) { spk_dbitem = new Context.Spk(); spk_dbitem.Id = spk_dbitem.Id; Spk model2 = new Spk(); model2.Jenis = "Truck"; model2.Permintaan = model.KetTruck; model2.Keterangan = model.KetKerjaTruck; model2.Workshop_id = model.id; model2.RevEstimasi = 0; model2.setDb(spk_dbitem); RepoSpk.save(spk_dbitem, UserPrincipal.id); } else { spk_dbitem.Permintaan = model.KetTruck; spk_dbitem.Keterangan = model.KetKerjaTruck; RepoSpk.save(spk_dbitem, UserPrincipal.id); } } return(RedirectToAction("Index")); } return(View("PpkIn", model)); }