public void delete(RevisiJenisTruk dbitem)
{
context.RevisiJenisTruk.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Revisi Jenis Truk", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public ActionResult Edit(int idSo)
{
Context.SalesOrder dbso = RepoSalesOrder.FindByPK(idSo);
Context.RevisiJenisTruk dbitem = RepoRevisiJenisTruk.FindBySo(idSo);
RevisiJenisTruk model = new RevisiJenisTruk(dbso);
if (RepoRevisiJenisTruk.FindBySo(idSo) != null)
{
model = new RevisiJenisTruk(dbitem);
}
return(View("Form", model));
}
public void save(RevisiJenisTruk dbitem)
{
if (dbitem.Id == 0) //create
{
context.RevisiJenisTruk.Add(dbitem);
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Revisi Jenis Truk", QueryDetail = "Add " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.RevisiJenisTruk.Attach(dbitem);
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Revisi Jenis Truk", QueryDetail = "Edit " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public ActionResult Edit(RevisiJenisTruk model)
{
Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSalesOrder.Value);
Context.RevisiJenisTruk revisiTgl = new Context.RevisiJenisTruk();
if (ModelState.IsValid)
{
if (dbso.Status == "dispatched" || dbso.Status == "admin uang jalan")
{
//batalkeun so na
Context.SettlementBatal dbsettlement = new Context.SettlementBatal();
Context.AdminUangJalan dummyAdminUangJalan = dbso.AdminUangJalan;
Context.BatalOrder batalOrder = new Context.BatalOrder();
//batal
dbso.Status = "batal order";
batalOrder.IdSalesOrder = dbso.Id;
batalOrder.Keterangan = "Revisi JenisTruk";
batalOrder.ModifiedDate = DateTime.Now;
RepoSalesOrder.save(dbso);
RepoBatalOrder.save(batalOrder, UserPrincipal.id);
//settlement batal
dbsettlement.IdDriver = dummyAdminUangJalan.IdDriver1;
dbsettlement.IdSalesOrder = dbso.Id;
if (dummyAdminUangJalan.AdminUangJalanUangTf.Any(d => d.Keterangan == "Tunai"))
{
dbsettlement.KasDiterima = dummyAdminUangJalan.AdminUangJalanUangTf.Where(d => d.Keterangan == "Tunai").FirstOrDefault().JumlahTransfer;
}
if (dummyAdminUangJalan.AdminUangJalanUangTf.Any(d => d.Keterangan.Contains("Transfer")))
{
dbsettlement.TransferDiterima = dummyAdminUangJalan.AdminUangJalanUangTf.Where(d => d.Keterangan.Contains("Transfer")).Sum(t => t.JumlahTransfer);
}
dbsettlement.SolarDiterima = dummyAdminUangJalan.AdminUangJalanVoucherSpbu.Sum(s => s.Value);
dbsettlement.KapalDiterima = dummyAdminUangJalan.AdminUangJalanVoucherKapal.Sum(s => s.Value);
dbsettlement.JenisBatal = "Batal Order";
dbsettlement.IdDriver = dbso.SalesOrderOncallId.HasValue ? dbso.SalesOrderOncall.Driver1Id : dbso.SalesOrderProsesKonsolidasiId.HasValue ? dbso.SalesOrderProsesKonsolidasi.Driver1Id : dbso.SalesOrderPickup.Driver1Id;
RepoSettBatal.save(dbsettlement, UserPrincipal.id, "Revisi Jenis Truk");
//create so baru
Context.SalesOrder dummySo = new Context.SalesOrder();
dummySo.isReturn = true;
dummySo.Status = "Draft";
dummySo.AdminUangJalanId = null;
dummySo.AdminUangJalan = null;
dummySo.DateStatus = DateTime.Now;
if (dbso.SalesOrderOncallId.HasValue)
{
//urus anak na
Context.SalesOrderOncall dboncall = new Context.SalesOrderOncall();
SalesOrderOncall modelOncall = new SalesOrderOncall(dbso);
modelOncall.setDb(dboncall);
dboncall.SalesOrderOnCallId = 0;
dboncall.JenisTruckId = model.JenisTruckIdBaru;
dboncall.Urutan = RepoSalesOrder.getUrutanOnCAll(modelOncall.TanggalMuat.Value) + 1;
dboncall.SONumber = RepoSalesOrder.generateCodeOnCall(modelOncall.TanggalMuat.Value, dboncall.Urutan);
dboncall.DN = "DN" + dboncall.SONumber;
dummySo.SalesOrderOncall = dboncall;
RepoAuditrail.SetAuditTrail("INSERT INTO dbo.\"SalesOrderOncall\" (\"SONumber\", \"Urutan\", \"TanggalOrder\", \"JamOrder\", \"CustomerId\", \"PrioritasId\", \"JenisTruckId\", \"ProductId\", " +
"\"TanggalMuat\", \"JamMuat\", \"Keterangan\", \"KeteranganLoading\", \"KeteranganUnloading\", \"IdDaftarHargaItem\", \"StrDaftarHargaItem\", \"StrMultidrop\", \"IdDataTruck\", \"Driver1Id\", " +
"\"KeteranganDriver1\", \"Driver2Id\", \"KeteranganDriver2\", \"IsCash\", \"KeteranganRek\", \"IdDriverTitip\", \"DN\", \"KeteranganDataTruck\", \"AtmId\") VALUES (" + dboncall.SONumber + ", "
+ dboncall.Urutan + ", " + dboncall.TanggalOrder + ", " + dboncall.JamOrder + ", " + dboncall.CustomerId + ", " + dboncall.PrioritasId + ", " + dboncall.JenisTruckId + ", " + dboncall.ProductId +
", " + dboncall.TanggalMuat + ", " + dboncall.JamMuat + ", " + dboncall.Keterangan + ", " + dboncall.KeteranganLoading + ", " + dboncall.KeteranganUnloading + ", " + dboncall.IdDaftarHargaItem +
"," + dboncall.StrDaftarHargaItem + ", " + dboncall.StrMultidrop + ", " + dboncall.IdDataTruck + ", " + dboncall.Driver1Id + ", " + dboncall.KeteranganDriver1 + ", " + dboncall.Driver2Id + ", " +
dboncall.KeteranganDriver2 + ", " + dboncall.IsCash + ", " + dboncall.KeteranganRek + ", " + dboncall.IdDriverTitip + ", " + dboncall.DN + ", " + dboncall.KeteranganDataTruck + ", " +
dboncall.AtmId + ");", "List Order", "Revisi Jenis Truk", UserPrincipal.id);
}
else if (dbso.SalesOrderProsesKonsolidasiId.HasValue)
{
Context.SalesOrderProsesKonsolidasi dbkonsolidasi = new Context.SalesOrderProsesKonsolidasi();
SalesOrderProsesKonsolidasi modelKonsolidasi = new SalesOrderProsesKonsolidasi(dbso);
modelKonsolidasi.setDb(dbkonsolidasi);
dbkonsolidasi.SalesOrderProsesKonsolidasiId = 0;
dbkonsolidasi.JenisTruckId = model.JenisTruckIdBaru;
dbkonsolidasi.Urutan = RepoSalesOrder.getUrutanProsesKonsolidasi(modelKonsolidasi.TanggalMuat.Value) + 1;
dbkonsolidasi.SONumber = RepoSalesOrder.generateProsesKonsolidasi(modelKonsolidasi.TanggalMuat.Value, dbkonsolidasi.Urutan);
dbkonsolidasi.DN = "DN" + dbkonsolidasi.SONumber;
dummySo.SalesOrderProsesKonsolidasi = dbkonsolidasi;
RepoAuditrail.saveSalesOrderProsesKonsolidasiQuery(dbso.SalesOrderProsesKonsolidasi, UserPrincipal.id);
}
dummySo.Id = 0;
RepoSalesOrder.save(dummySo);
}
else
{
if (dbso.SalesOrderOncallId.HasValue)
{
dbso.SalesOrderOncall.JenisTruckId = model.JenisTruckIdBaru;
RepoAuditrail.SetAuditTrail(
"UPDATE dbo.\"SalesOrderOncall\" SET \"JenisTruckId\" = " + model.JenisTruckIdBaru + " WHERE \"SalesOrderOnCallId\" = " + dbso.SalesOrderOncallId + ";",
"List Order", "Revisi Jenis Truk", UserPrincipal.id
);
}
else if (dbso.SalesOrderProsesKonsolidasiId.HasValue)
{
dbso.SalesOrderProsesKonsolidasi.JenisTruckId = model.JenisTruckIdBaru;
}
RepoSalesOrder.save(dbso);
RepoAuditrail.saveUpdSalesOrderProsesKonsolidasiQuery(dbso.SalesOrderProsesKonsolidasi, UserPrincipal.id);
}
return(RedirectToAction("Index", "ListOrder"));
}
return(View("Form", model));
}
