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