public void delete(RevisiTanggal dbitem) { context.RevisiTanggal.Remove(dbitem); var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Revisi Rute", 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.RevisiTanggal dbitem = RepoRevisiTanggal.FindBySo(idSo); RevisiTanggal model = new RevisiTanggal(dbso); if (RepoRevisiTanggal.FindBySo(idSo) != null) { model = new RevisiTanggal(dbitem); } return(View("Form", model)); }
public void save(RevisiTanggal dbitem) { if (dbitem.Id == 0) //create { context.RevisiTanggal.Add(dbitem); var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Revisi Tanggal", QueryDetail = "Add " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); } else //edit { context.RevisiTanggal.Attach(dbitem); var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Revisi Rute", 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(RevisiTanggal model) { Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSalesOrder.Value); Context.RevisiTanggal revisiTgl = new Context.RevisiTanggal(); if (ModelState.IsValid) { if (dbso.Status == "dispatched") { //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 Tanggal"; batalOrder.ModifiedDate = DateTime.Now; dbso.KeteranganBatal = "Revisi tanggal dari " + (dbso.SalesOrderOncallId.HasValue ? (dbso.SalesOrderOncall.TanggalMuat.ToString()).Split(' ')[0] : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.TanggalPickup.ToString().Split(' ')[0] : dbso.SalesOrderProsesKonsolidasi.TanggalMuat.ToString().Split(' ')[0]) + " ke " + model.TanggalBaru.ToString().Split(' ')[0] + " - " + model.KeteranganRevisi; 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"; RepoSettBatal.save(dbsettlement, UserPrincipal.id, "Revisi Tanggal"); //create so baru Context.SalesOrder dummySo = new Context.SalesOrder(); dummySo.isReturn = true; dummySo.DateRevised = 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.TanggalMuat = model.TanggalBaru; dboncall.JamMuat = model.JamBaru.Value; dboncall.Urutan = RepoSalesOrder.getUrutanOnCAll(modelOncall.TanggalMuat.Value) + 1; dboncall.SONumber = RepoSalesOrder.generateCodeOnCall(modelOncall.TanggalMuat.Value, dboncall.Urutan); dboncall.DN = "DN" + dboncall.SONumber; dboncall.Keterangan = "Revisi tanggal dari " + (dbso.SalesOrderOncallId.HasValue ? (dbso.SalesOrderOncall.TanggalMuat.ToString()).Split(' ')[0] : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.TanggalPickup.ToString().Split(' ')[0] : dbso.SalesOrderProsesKonsolidasi.TanggalMuat.ToString().Split(' ')[0]) + " ke " + model.TanggalBaru.ToString().Split(' ')[0] + " - " + model.KeteranganRevisi + " - " + dbso.SalesOrderOncall.Keterangan; 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.SalesOrderPickupId.HasValue) { Context.SalesOrderPickup dbpickup = new Context.SalesOrderPickup(); SalesOrderPickup modelPickup = new SalesOrderPickup(dbso); modelPickup.setDb(dbpickup); dbpickup.SalesOrderPickupId = 0; dbpickup.TanggalPickup = model.TanggalBaru.Value; dbpickup.JamPickup = model.JamBaru.Value; dbpickup.Urutan = RepoSalesOrder.getUrutanPickup(modelPickup.TanggalPickup.Value) + 1; dbpickup.SONumber = RepoSalesOrder.generatePickup(modelPickup.TanggalPickup.Value, dbpickup.Urutan); dbpickup.Keterangan = "Revisi tanggal dari " + (dbso.SalesOrderOncallId.HasValue ? (dbso.SalesOrderOncall.TanggalMuat.ToString()).Split(' ')[0] : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.TanggalPickup.ToString().Split(' ')[0] : dbso.SalesOrderProsesKonsolidasi.TanggalMuat.ToString().Split(' ')[0]) + " ke " + model.TanggalBaru.ToString().Split(' ')[0] + " - " + model.KeteranganRevisi + " - " + dbso.SalesOrderPickup.Keterangan; dummySo.SalesOrderPickup = dbpickup; } else if (dbso.SalesOrderProsesKonsolidasiId.HasValue) { Context.SalesOrderProsesKonsolidasi dbkonsolidasi = new Context.SalesOrderProsesKonsolidasi(); SalesOrderProsesKonsolidasi modelKonsolidasi = new SalesOrderProsesKonsolidasi(dbso); modelKonsolidasi.setDb(dbkonsolidasi); dbkonsolidasi.SalesOrderProsesKonsolidasiId = 0; dbkonsolidasi.TanggalMuat = model.TanggalBaru.Value; dbkonsolidasi.JamMuat = model.JamBaru.Value; dbkonsolidasi.Urutan = RepoSalesOrder.getUrutanProsesKonsolidasi(modelKonsolidasi.TanggalMuat.Value) + 1; dbkonsolidasi.SONumber = RepoSalesOrder.generateProsesKonsolidasi(modelKonsolidasi.TanggalMuat.Value, dbkonsolidasi.Urutan); dbkonsolidasi.DN = "DN" + dbkonsolidasi.SONumber; dbkonsolidasi.Keterangan = "Revisi tanggal dari " + (dbso.SalesOrderOncallId.HasValue ? (dbso.SalesOrderOncall.TanggalMuat.ToString()).Split(' ')[0] : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.TanggalPickup.ToString().Split(' ')[0] : dbso.SalesOrderProsesKonsolidasi.TanggalMuat.ToString().Split(' ')[0]) + " ke " + model.TanggalBaru.ToString().Split(' ')[0] + " - " + model.KeteranganRevisi + " - " + dbso.SalesOrderProsesKonsolidasi.Keterangan; dummySo.SalesOrderProsesKonsolidasi = dbkonsolidasi; RepoAuditrail.saveSalesOrderProsesKonsolidasiQuery(dummySo.SalesOrderProsesKonsolidasi, UserPrincipal.id); } dummySo.Id = 0; string sod_guid = Guid.NewGuid().ToString(); dummySo.oidErp = sod_guid; RepoSalesOrder.save(dummySo); SyncToERP(dummySo, sod_guid); } else { if (dbso.SalesOrderOncallId.HasValue) { dbso.SalesOrderOncall.TanggalMuat = model.TanggalBaru; dbso.SalesOrderOncall.JamMuat = model.JamBaru.Value; RepoAuditrail.SetAuditTrail( "UPDATE dbo.\"SalesOrderOncall\" SET \"TanggalMuat\" = " + model.TanggalBaru + ", \"JamMuat\" = " + model.JamBaru.Value + " WHERE \"SalesOrderOnCallId\" = " + dbso.SalesOrderOncallId + ";", "List Order", "Revisi Rute", UserPrincipal.id ); } else if (dbso.SalesOrderPickupId.HasValue) { dbso.SalesOrderPickup.TanggalPickup = model.TanggalBaru.Value; dbso.SalesOrderPickup.JamPickup = model.JamBaru.Value; } else if (dbso.SalesOrderProsesKonsolidasiId.HasValue) { dbso.SalesOrderProsesKonsolidasi.TanggalMuat = model.TanggalBaru.Value; dbso.SalesOrderProsesKonsolidasi.JamMuat = model.JamBaru.Value; RepoAuditrail.saveUpdSalesOrderProsesKonsolidasiQuery(dbso.SalesOrderProsesKonsolidasi, UserPrincipal.id); } revisiTgl.IdSalesOrder = model.IdSalesOrder.Value; dbso.DateRevised = true; RepoSalesOrder.save(dbso); RepoRevisiTanggal.save(revisiTgl); } return(RedirectToAction("Index", "ListOrder")); } return(View("Form", model)); }