public JsonResult SaveDp(Context.SalesOrderPickupDp model) { Context.SalesOrder dbitem = RepoSalesOrder.FindByPickup(model.SalesOrderPickupId); if (model.Id == 0) { dbitem.SalesOrderPickup.SalesOrderPickupDp.Add(model); var query = "INSERT INTO \"dbo\".\"SalesOrderPickupDp\" (\"SalesOrderPickupId\", \"Tanggal\", \"Penerima\", \"Jenis\", \"RekeningId\", \"Jumlah\") VALUES (" + model.SalesOrderPickupId + ", " + model.Tanggal + ", " + model.Penerima + ", " + model.Jenis + ", " + model.RekeningId + ", " + model.Jumlah + ");"; RepoAuditrail.SetAuditTrail(query, "Input DP", "List Order", UserPrincipal.id); } else { Context.SalesOrderPickupDp dbdp = dbitem.SalesOrderPickup.SalesOrderPickupDp.Where(d => d.Id == model.Id).FirstOrDefault(); dbdp.Tanggal = model.Tanggal; dbdp.Penerima = model.Penerima; dbdp.RekeningId = model.RekeningId; dbdp.Jenis = model.Jenis; dbdp.Jumlah = model.Jumlah; var query = "UPDATE \"dbo\".\"SalesOrderPickupDp\" SET \"Tanggal\" = " + dbdp.Tanggal + ", \"Penerima\" = " + dbdp.Penerima + ", \"Jenis\" = \" = " + dbdp.Jenis + ", \"RekeningId\" = " + dbdp.RekeningId + "\"Jumlah\" = " + dbdp.Jumlah + " WHERE \"Id\" = " + dbdp.Id + ";"; RepoAuditrail.SetAuditTrail(query, "Input DP", "List Order", UserPrincipal.id); } RepoSalesOrder.save(dbitem); ResponeModel response = new ResponeModel(true); return(Json(response)); }
public ActionResult Edit(RevisiKeterangan model) { var query = ""; Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSalesOrder.Value); if (ModelState.IsValid) { if (dbso.SalesOrderOncallId.HasValue) { dbso.SalesOrderOncall.Keterangan = model.KeteranganRevisi; } else if (dbso.SalesOrderPickupId.HasValue) { dbso.SalesOrderPickup.Keterangan = model.KeteranganRevisi; query += "UPDATE dbo.\"SalesOrderPickup\" SET \"Keterangan\" = " + model.KeteranganRevisi + " WHERE \"SalesOrderPickupId\" = " + dbso.SalesOrderPickupId + ";"; } RepoSalesOrder.save(dbso); RepoAuditrail.SetAuditTrail(query, "List Order", "Revisi Keterangan", UserPrincipal.id); return(RedirectToAction("Index", "ListOrder")); } return(View("Form", model)); }
public ActionResult EditPickup(SalesOrderPickup model, string btnsave) { //validasi manual bool palid = true; if (btnsave != "draft") { if (!model.IdDataTruck.HasValue) { ModelState.AddModelError("IdDataTruck", "Truk harus diisi."); palid = false; } if (!model.Driver1Id.HasValue || model.Driver1Id.Value == 0) { ModelState.AddModelError("Driver1Id", "Driver harus diisi."); palid = false; } Context.Driver item = RepoDriver.FindAll().Where(d => d.Id == model.Driver1Id.Value).FirstOrDefault(); List <Context.SalesOrder> dbso = RepoSalesOrder.FindAll().ToList(); List <Context.SettlementBatal> dbsb = RepoSettlementBatal.FindAll().Where(s => s.IsProses == false).ToList(); Driver driver = new Driver(item, dbso, dbsb); if (driver.StatusSo != "Available") { ModelState.AddModelError("Driver1Id", "Driver tidak tersedia, harap pilih driver lain."); palid = false; } } if (model.Status == "draft") { if (model.CommentUser == "" || model.CommentUser == null) { ModelState.AddModelError("CommentUser", "Comment harus diisi."); palid = false; } } if (palid) { Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(model.SalesOrderId.Value); dbitem.isReturn = false; string act = ""; if (btnsave != null && btnsave != "") { act = "Draft"; dbitem.Status = btnsave; } else { if (model.Status.ToLower() == "save") { act = "Return"; dbitem.isReturn = true; } else { dbitem.isReturn = false; act = "Submit"; } dbitem.Status = model.Status; } model.setDbOperasional(dbitem.SalesOrderPickup, act, "Operational"); RepoSalesOrder.save(dbitem); var query = "UPDATE dbo.\"SalesOrderPickup\" SET \"SONumber\" = " + dbitem.SalesOrderPickup.SONumber + ", \"Urutan\" = " + dbitem.SalesOrderPickup.Urutan + ", TanggalOrder\" = " + dbitem.SalesOrderPickup.TanggalOrder + ", \"CustomerId\" = " + dbitem.SalesOrderPickup.CustomerId + ", \"JenisTruckId\" = " + dbitem.SalesOrderPickup.JenisTruckId + ", \"ProductId\" = " + dbitem.SalesOrderPickup.ProductId + ", \"TanggalPickup\" = " + dbitem.SalesOrderPickup.TanggalPickup + ", \"JamPickup\" = " + dbitem.SalesOrderPickup.JamPickup + ", \"IsSelect\" = " + dbitem.SalesOrderPickup.IsSelect + ", \"Keterangan\" = " + dbitem.SalesOrderPickup.Keterangan + ", \"KeteranganLoading\" = " + dbitem.SalesOrderPickup.KeteranganLoading + ", \"KeteranganUnloading\" = " + dbitem.SalesOrderPickup.KeteranganUnloading + ", \"JamOrder\" = " + dbitem.SalesOrderPickup.JamOrder + ", \"StrMultidrop\" = " + dbitem.SalesOrderPickup.StrMultidrop + ", \"RuteId\" = " + dbitem.SalesOrderPickup.RuteId + ", \"IdDataTruck\" = " + dbitem.SalesOrderPickup.IdDataTruck + ", \"KeteranganDataTruck\" = " + dbitem.SalesOrderPickup.KeteranganDataTruck + ", \"Driver1Id\" = " + dbitem.SalesOrderPickup.Driver1Id + ", \"KeteranganDriver1\" = " + dbitem.SalesOrderPickup.KeteranganDriver1 + ", \"Driver2Id\" = " + dbitem.SalesOrderPickup.Driver2Id + ", \"KeteranganDriver2\" = " + dbitem.SalesOrderPickup.KeteranganDriver2 + ", \"IsCash\" = " + dbitem.SalesOrderPickup.IsCash + ", \"IdDriverTitip\" = " + dbitem.SalesOrderPickup.IdDriverTitip + ", \"KeteranganRek\" = " + dbitem.SalesOrderPickup.KeteranganRek + ", \"AtmId\" = " + dbitem.SalesOrderPickup.AtmId + " WHERE \"SalesOrderPickupId\" = " + dbitem.SalesOrderPickupId + ";INSERT INTO dbo.\"SalesOrderPickupComment\" (\"SalesOrderPickupId\", \"Tanggal\", \"CommentUser\", \"Action\", \"Username\") VALUES (" + dbitem.SalesOrderPickupId + ", " + DateTime.Now + ", " + model.CommentUser + ", " + act + ", " + UserPrincipal.username + ");"; RepoAuditrail.SetAuditTrail(query, "Planning Pickup", "Edit", UserPrincipal.id); return(RedirectToAction("Index")); } else { ViewBag.kondisi = "planning"; ViewBag.name = model.SONumber; ViewBag.Title = "Planning Sales Order Pickup " + model.SONumber; ViewBag.PostData = "EditPickup"; return(View("SalesOrderPickup/FormReadOnly", model)); } }
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)); }
public ActionResult EditPickup(SalesOrderPickup model, string btnsave) { //validasi manual bool palid = true; if (btnsave != "draft planning") { if (!model.IdDataTruck.HasValue) { ModelState.AddModelError("IdDataTruck", "Truk harus diisi."); palid = false; } if (!model.Driver1Id.HasValue) { ModelState.AddModelError("Driver1Id", "Driver harus diisi."); palid = false; } } if (!model.AtmId.HasValue || model.AtmId.Value == 0) { ModelState.AddModelError("AtmId", "Rekening harus diisi."); palid = false; } if (palid) { Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(model.SalesOrderId.Value); string act = ""; if (btnsave != null && btnsave != "") { act = "Draft"; dbitem.Status = btnsave; } else { if (model.Status.ToLower() == "save") { act = "Return"; dbitem.isReturn = true; } else { act = "Submit"; dbitem.isReturn = false; } dbitem.Status = model.Status; } model.setDbOperasional(dbitem.SalesOrderPickup, act, "Operational"); RepoSalesOrder.save(dbitem); var query = "UPDATE dbo.\"SalesOrderPickup\" SET \"SONumber\" = " + dbitem.SalesOrderPickup.SONumber + ", \"Urutan\" = " + dbitem.SalesOrderPickup.Urutan + ", TanggalOrder\" = " + dbitem.SalesOrderPickup.TanggalOrder + ", \"CustomerId\" = " + dbitem.SalesOrderPickup.CustomerId + ", \"JenisTruckId\" = " + dbitem.SalesOrderPickup.JenisTruckId + ", \"ProductId\" = " + dbitem.SalesOrderPickup.ProductId + ", \"TanggalPickup\" = " + dbitem.SalesOrderPickup.TanggalPickup + ", \"JamPickup\" = " + dbitem.SalesOrderPickup.JamPickup + ", \"IsSelect\" = " + dbitem.SalesOrderPickup.IsSelect + ", \"Keterangan\" = " + dbitem.SalesOrderPickup.Keterangan + ", \"KeteranganLoading\" = " + dbitem.SalesOrderPickup.KeteranganLoading + ", \"KeteranganUnloading\" = " + dbitem.SalesOrderPickup.KeteranganUnloading + ", \"JamOrder\" = " + dbitem.SalesOrderPickup.JamOrder + ", \"StrMultidrop\" = " + dbitem.SalesOrderPickup.StrMultidrop + ", \"RuteId\" = " + dbitem.SalesOrderPickup.RuteId + ", \"IdDataTruck\" = " + dbitem.SalesOrderPickup.IdDataTruck + ", \"KeteranganDataTruck\" = " + dbitem.SalesOrderPickup.KeteranganDataTruck + ", \"Driver1Id\" = " + dbitem.SalesOrderPickup.Driver1Id + ", \"KeteranganDriver1\" = " + dbitem.SalesOrderPickup.KeteranganDriver1 + ", \"Driver2Id\" = " + dbitem.SalesOrderPickup.Driver2Id + ", \"KeteranganDriver2\" = " + dbitem.SalesOrderPickup.KeteranganDriver2 + ", \"IsCash\" = " + dbitem.SalesOrderPickup.IsCash + ", \"IdDriverTitip\" = " + dbitem.SalesOrderPickup.IdDriverTitip + ", \"KeteranganRek\" = " + dbitem.SalesOrderPickup.KeteranganRek + ", \"AtmId\" = " + dbitem.SalesOrderPickup.AtmId + " WHERE \"SalesOrderPickupId\" = " + dbitem.SalesOrderPickupId + ";INSERT INTO dbo.\"SalesOrderPickupComment\" (\"SalesOrderPickupId\", \"Tanggal\", \"CommentUser\", \"Action\", \"Username\") VALUES (" + dbitem.SalesOrderPickupId + ", " + DateTime.Now + ", " + model.CommentUser + ", " + act + ", " + UserPrincipal.username + ");"; RepoAuditrail.SetAuditTrail(query, "Konfirmasi Pickup", "Edit", UserPrincipal.id); return(RedirectToAction("Index")); } else { ViewBag.kondisi = "konfirmasi"; ViewBag.name = model.SONumber; ViewBag.Title = "Konfirmsai Sales Order Pickup " + model.SONumber; ViewBag.PostData = "EditPickup"; return(View("SalesOrderPickup/FormReadOnly", model)); } }
public ActionResult Edit(SalesOrderOncall model, string btnsave) { //validasi tambahan bool palid = true; if (ModelState.IsValid) { if (btnsave == null && model.Status == "save") { List <Context.DaftarHargaOnCall> dummy = RepoDaftarHarga.FindAll().Where(d => d.IdCust == model.CustomerId && (model.TanggalMuat >= d.PeriodStart && model.TanggalMuat <= d.PeriodEnd)).ToList(); if (dummy.Where(d => d.DaftarHargaOnCallItem.Any(i => i.IdJenisTruck == model.JenisTruckId)).Count() < 1) { palid = false; ViewBag.errorMsg = "Tidak terdapat daftar harga untuk jenis truck " + RepoJnsTruck.FindByPK(model.JenisTruckId.Value).StrJenisTruck; } } } SalesOrderLoadUnload[] resultLoad = JsonConvert.DeserializeObject <SalesOrderLoadUnload[]>(model.StrLoad); model.ListLoad = resultLoad.ToList(); SalesOrderLoadUnload[] resultUnload = JsonConvert.DeserializeObject <SalesOrderLoadUnload[]>(model.StrUnload); model.ListUnload = resultUnload.ToList(); //if (!model.ListLoad.Any(d => d.IsSelect == true)) //{ // ModelState.AddModelError("StrLoad", "Alamat muat harus dipilih."); //} //if (!model.ListLoad.Any(d => d.IsSelect == true)) //{ // ModelState.AddModelError("StrUnload", "Alamat bongkar harus dipilih."); //} if (palid) { if (ModelState.IsValid) { Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(model.SalesOrderId.Value); if (btnsave == "save") { dbitem.Status = "save"; } else if (btnsave == "draft") { dbitem.Status = "draft"; } else { dbitem.Status = model.Status; } if (model.Status == "save") { //{ Nama: "Sales Order", Id: "S" }, //{ Nama: "Planning Order", Id: "P" }, //{ Nama: "Konfirmasi Planning", Id: "KP" }, //{ Nama: "Admin Uang Jalan", Id: "A" }, //{ Nama: "Kasir", Id: "K" } RepoListNotif.save("P", "PLANNING SO : " + model.SONumber + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " belum diproses.", "PLANNING SO : " + model.SONumber + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " belum diproses."); } model.setDb(dbitem.SalesOrderOncall, model.Status == "save" ? "Submit" : model.Status == "draft" ? "Draft" : "", "Marketing"); dbitem.isReturn = false; dbitem.UpdatedBy = UserPrincipal.id; RepoSalesOrder.save(dbitem); //RepoAuditrail.saveOrderHistory(dbitem); RepoAuditrail.SetAuditTrail( "UPDATE dbo.\"SalesOrderOncall\" SET \"TanggalOrder\" = " + model.TanggalOrder + ", \"JamOrder\" = " + model.JamOrder + ", \"CustomerId\" = " + model.CustomerId + ", \"PrioritasId\" = " + model.PrioritasId + ", \"JenisTruckId\" = " + model.JenisTruckId + ", \"ProductId\" = " + model.ProductId + ", \"TanggalMuat\" = " + model.TanggalMuat + ", \"JamMuat\" = " + model.JamMuat + ", \"Keterangan\" = " + model.Keterangan + ", \"KeteranganLoading\" = " + model.KeteranganLoading + ", \"KeteranganUnloading\" = " + model.KeteranganUnloading + ", \"IdDaftarHargaItem\" = " + dbitem.SalesOrderOncall.IdDaftarHargaItem + ", \"StrDaftarHargaItem\" = " + dbitem.SalesOrderOncall.StrDaftarHargaItem + ", \"StrMultidrop\" = " + model.StrMultidrop + ", \"IdDataTruck\" = " + model.IdDataTruck + ", \"Driver1Id\" = " + model.Driver1Id + ", \"KeteranganDriver1\" = " + model.KeteranganDriver1 + ", \"Driver2Id\" = " + model.Driver2Id + ", \"KeteranganDriver2\" = " + model.KeteranganDriver2 + ", \"IsCash\" = " + model.IsCash + ", \"KeteranganRek\" = " + model.KeteranganRek + ", \"IdDriverTitip\" = " + model.IdDriverTitip + ", \"DN\" = " + model.DN + ", \"KeteranganDataTruck\" = " + model.KeteranganDataTruck + ", \"AtmId\" = " + model.AtmId + " WHERE \"SalesOrderOnCallId\" = " + model.SalesOrderOnCallId + ";", "List Order", "Revisi Rute", UserPrincipal.id ); return(RedirectToAction("Index")); } } return(View("Form", model)); }
public ActionResult Edit(RevisiRute model) { Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSalesOrder.Value); Context.RevisiRute revisiRute = new Context.RevisiRute(); revisiRute.Code = "RR" + (dbso.SalesOrderOncallId.HasValue ? dbso.SalesOrderOncall.SONumber : dbso.SalesOrderProsesKonsolidasiId.HasValue ? dbso.SalesOrderProsesKonsolidasi.SONumber : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.SONumber : dbso.SalesOrderKontrak.SONumber); Context.SalesOrder dummySo = new Context.SalesOrder(); if (ModelState.IsValid) { if (dbso.Status == "dispatched" || dbso.Status == "admin uang jalan") { Context.AdminUangJalan dummyAdminUangJalan = dbso.AdminUangJalan; Context.BatalOrder batalOrder = new Context.BatalOrder(); //batal dbso.Status = "batal order"; dbso.KeteranganBatal = "Revisi rute dari " + model.RuteLama + " ke " + model.RuteBaru;//"Revisi RUte" dari <rute sebelumnya> ke <rute yang dipilih > [isi dari keterangan revisi rute ] batalOrder.IdSalesOrder = dbso.Id; batalOrder.Keterangan = "Revisi Rute"; batalOrder.ModifiedDate = DateTime.Now; RepoSalesOrder.save(dbso); RepoBatalOrder.save(batalOrder, UserPrincipal.id); if (dbso.Status == "dispatched") { //batalkeun so na Context.SettlementBatal dbsettlement = new Context.SettlementBatal(); //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, "Batal Order"); } else { //jurnal balik cynt Context.ERPConfig erpConfig = RepoERPConfig.FindByFrist(); decimal? tambahanRute = dummyAdminUangJalan.AdminUangJalanTambahanRute.Sum(s => s.values); decimal? boronganDasar = dummyAdminUangJalan.TotalAlokasi - dummyAdminUangJalan.Kawalan - dummyAdminUangJalan.Timbangan - dummyAdminUangJalan.Karantina - dummyAdminUangJalan.SPSI - dummyAdminUangJalan.Multidrop - tambahanRute - dummyAdminUangJalan.AdminUangJalanTambahanLain.Sum(s => s.Values); Repoglt_det.saveFromAc(1, revisiRute.Code, 0, boronganDasar, Repoac_mstr.FindByPk(erpConfig.IdBoronganDasar)); Repoglt_det.saveFromAc(2, revisiRute.Code, 0, dummyAdminUangJalan.Kawalan, Repoac_mstr.FindByPk(erpConfig.IdKawalan)); Repoglt_det.saveFromAc(3, revisiRute.Code, 0, dummyAdminUangJalan.Timbangan, Repoac_mstr.FindByPk(erpConfig.IdTimbangan)); Repoglt_det.saveFromAc(4, revisiRute.Code, 0, dummyAdminUangJalan.Karantina, Repoac_mstr.FindByPk(erpConfig.IdKarantina)); Repoglt_det.saveFromAc(5, revisiRute.Code, 0, dummyAdminUangJalan.SPSI, Repoac_mstr.FindByPk(erpConfig.IdSPSI)); Repoglt_det.saveFromAc(6, revisiRute.Code, 0, dummyAdminUangJalan.Multidrop, Repoac_mstr.FindByPk(erpConfig.IdMultidrop)); Repoglt_det.saveFromAc(7, revisiRute.Code, 0, tambahanRute, Repoac_mstr.FindByPk(erpConfig.IdTambahanRuteMuat)); Repoglt_det.saveFromAc(8, revisiRute.Code, 0, dummyAdminUangJalan.AdminUangJalanTambahanLain.Sum(s => s.Values), Repoac_mstr.FindByPk(erpConfig.IdTambahanRuteLain)); Repoglt_det.saveFromAc(9, revisiRute.Code, dummyAdminUangJalan.KasbonDriver1, 0, Repoac_mstr.FindByPk(erpConfig.IdKasbonAuj)); Repoglt_det.saveFromAc(10, revisiRute.Code, dummyAdminUangJalan.KlaimDriver1, 0, Repoac_mstr.FindByPk(erpConfig.IdKlaimAuj)); Repoglt_det.saveFromAc(11, revisiRute.Code, dummyAdminUangJalan.AdminUangJalanPotonganDriver.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdPotonganLainAuj)); Repoglt_det.saveFromAc(12, revisiRute.Code, dummyAdminUangJalan.AdminUangJalanVoucherKapal.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdVoucherKapal)); Repoglt_det.saveFromAc(13, revisiRute.Code, dummyAdminUangJalan.AdminUangJalanVoucherSpbu.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdVoucherSolar)); Repoglt_det.saveFromAc(14, revisiRute.Code, dummyAdminUangJalan.AdminUangJalanUangTf.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdAUJCredit)); } //create so baru dummySo.isReturn = true; dummySo.Status = "Draft"; dummySo.AdminUangJalanId = null; dummySo.AdminUangJalan = null; dummySo.DateStatus = DateTime.Now; try{ SalesOrderLoadUnload[] resultLoad = JsonConvert.DeserializeObject <SalesOrderLoadUnload[]>(model.StrLoad); model.ListLoad = resultLoad.ToList(); SalesOrderLoadUnload[] resultUnload = JsonConvert.DeserializeObject <SalesOrderLoadUnload[]>(model.StrUnload); model.ListUnload = resultUnload.ToList(); } catch (Exception e) { } 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.Urutan = RepoSalesOrder.getUrutanOnCAll(modelOncall.TanggalMuat.Value) + 1; dboncall.SONumber = RepoSalesOrder.generateCodeOnCall(modelOncall.TanggalMuat.Value, dboncall.Urutan); dboncall.DN = "DN" + dboncall.SONumber; dboncall.IdDaftarHargaItem = model.IdRute; dboncall.StrDaftarHargaItem = model.RuteBaru; dboncall.StrMultidrop = model.MultidropBaru; dboncall.SalesOrderOnCallLoadingAdd.Clear(); dboncall.Keterangan = "Revisi rute dari " + model.RuteLama + " ke " + model.RuteBaru + " - " + dbso.SalesOrderOncall.Keterangan; foreach (SalesOrderLoadUnload item in model.ListLoad) { dboncall.SalesOrderOnCallLoadingAdd.Add(new Context.SalesOrderOnCallLoadingAdd() { CustomerId = dboncall.CustomerId, CustomerLoadingAddressId = item.Id, urutan = item.urutan, IsSelect = item.IsSelect }); } dboncall.SalesOrderOnCallUnLoadingAdd.Clear(); foreach (SalesOrderLoadUnload item in model.ListUnload) { dboncall.SalesOrderOnCallUnLoadingAdd.Add(new Context.SalesOrderOnCallUnLoadingAdd() { CustomerId = dboncall.CustomerId, CustomerUnloadingAddressId = item.Id, urutan = item.urutan, IsSelect = item.IsSelect }); } 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.Urutan = RepoSalesOrder.getUrutanPickup(modelPickup.TanggalPickup.Value) + 1; dbpickup.SONumber = RepoSalesOrder.generatePickup(modelPickup.TanggalPickup.Value, dbpickup.Urutan); dbpickup.Keterangan = "Revisi rute dari " + model.RuteLama + " ke " + model.RuteBaru + " - " + dbso.SalesOrderPickup.Keterangan; dbpickup.SalesOrderPickupLoadingAdd.Clear(); foreach (SalesOrderLoadUnload item in model.ListLoad) { dbpickup.SalesOrderPickupLoadingAdd.Add(new Context.SalesOrderPickupLoadingAdd() { CustomerId = dbpickup.CustomerId, CustomerLoadingAddressId = item.Id, urutan = item.urutan, IsSelect = item.IsSelect }); } dbpickup.SalesOrderPickupUnLoadingAdd.Clear(); RepoAuditrail.saveDelAllSalesOrderPickupUnLoadingAddQuery(dbpickup, UserPrincipal.id); foreach (SalesOrderLoadUnload item in model.ListUnload) { dbpickup.SalesOrderPickupUnLoadingAdd.Add(new Context.SalesOrderPickupUnLoadingAdd() { CustomerId = dbpickup.CustomerId, CustomerUnloadingAddressId = item.Id, urutan = item.urutan, IsSelect = item.IsSelect }); } 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; try{ dbkonsolidasi.Urutan = RepoSalesOrder.getUrutanProsesKonsolidasi(modelKonsolidasi.TanggalMuat.Value) + 1; } catch (Exception e) { dbkonsolidasi.Urutan = 0; } dbkonsolidasi.SONumber = RepoSalesOrder.generateProsesKonsolidasi(modelKonsolidasi.TanggalMuat.Value, dbkonsolidasi.Urutan); dbkonsolidasi.DN = "DN" + dbkonsolidasi.SONumber; dbkonsolidasi.IdDaftarHargaItem = model.IdRute; dbkonsolidasi.StrDaftarHargaItem = model.RuteBaru; dbkonsolidasi.Multidrop = model.MultidropBaru; dbkonsolidasi.Keterangan = "Revisi rute dari " + model.RuteLama + " ke " + model.RuteBaru + " - " + dbso.SalesOrderProsesKonsolidasi.Keterangan; dummySo.SalesOrderProsesKonsolidasi = dbkonsolidasi; RepoAuditrail.saveSalesOrderProsesKonsolidasiQuery(dummySo.SalesOrderProsesKonsolidasi, UserPrincipal.id); } dummySo.Id = 0; RepoSalesOrder.save(dummySo); if (dbso.SalesOrderPickupId.HasValue) { foreach (Context.SalesOrderPickupUnLoadingAdd sopula in dbso.SalesOrderPickup.SalesOrderPickupUnLoadingAdd) { RepoAuditrail.saveSalesOrderPickupUnLoadingAddQuery(sopula, UserPrincipal.id); } } } else { if (dbso.SalesOrderOncallId.HasValue) { dbso.SalesOrderOncall.IdDaftarHargaItem = model.IdRute; dbso.SalesOrderOncall.StrDaftarHargaItem = model.RuteBaru; dbso.SalesOrderOncall.StrMultidrop = model.MultidropBaru; RepoAuditrail.SetAuditTrail( "UPDATE dbo.\"SalesOrderOncall\" SET \"IdDaftarHargaItem\" = " + model.IdRute + ", \"StrDaftarHargaItem\" = " + model.RuteBaru + ", \"StrMultidrop\" = " + model.MultidropBaru + " WHERE \"SalesOrderOnCallId\" = " + dbso.SalesOrderOncallId + ";", "List Order", "Revisi Rute", UserPrincipal.id ); } else if (dbso.SalesOrderPickupId.HasValue) { dbso.SalesOrderPickup.RuteId = model.IdRute; } else if (dbso.SalesOrderProsesKonsolidasiId.HasValue) { dbso.SalesOrderProsesKonsolidasi.IdDaftarHargaItem = model.IdRute; dbso.SalesOrderProsesKonsolidasi.StrDaftarHargaItem = model.RuteBaru; dbso.SalesOrderProsesKonsolidasi.Multidrop = model.MultidropBaru; RepoAuditrail.saveUpdSalesOrderProsesKonsolidasiQuery(dbso.SalesOrderProsesKonsolidasi, UserPrincipal.id); } revisiRute.IdSalesOrder = model.IdSalesOrder.Value; dbso.RuteRevised = true; dbso.AdminUangJalanId = null; dbso.AdminUangJalan = null; RepoSalesOrder.save(dbso); string sod_guid = Guid.NewGuid().ToString(); SyncToERP(dummySo, sod_guid); dbso.oidErp = sod_guid; RepoRevisiRute.save(revisiRute); } return(RedirectToAction("Index", "ListOrder")); } model = new RevisiRute(dbso); if (dbso.SalesOrderOncallId.HasValue) { return(View("FormOncall", model)); } else if (dbso.SalesOrderPickupId.HasValue) { return(View("FormPickup", model)); } else if (dbso.SalesOrderProsesKonsolidasiId.HasValue) { return(View("FormKonsolidasi", model)); } return(View("")); }
public ActionResult Edit(AdminUangJalan model, string Keterangan, string IsTransfer) { Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(model.IdSalesOrder.Value); Context.AdminUangJalan dummyAdminUangJalan = dbitem.AdminUangJalan; Context.BatalOrder batalOrder = new Context.BatalOrder(); string code = "BT-" + (dbitem.SalesOrderOncallId.HasValue ? dbitem.SalesOrderOncall.SONumber : dbitem.SalesOrderProsesKonsolidasiId.HasValue ? dbitem.SalesOrderProsesKonsolidasi.SONumber : dbitem.SalesOrderPickup.SONumber); int? urutanBatal = RepoBatalOrder.FindAll().Where(d => d.Code == code).Count() == 0 ? 1 : RepoBatalOrder.FindAll().Where(d => d.Code == code).Max(d => d.UrutanBatal) + 1; //cek status na Context.ERPConfig erpConfig = RepoERPConfig.FindByFrist(); if (dbitem.Status == "dispatched") { Context.SettlementBatal dbsettlement = new Context.SettlementBatal(); decimal?tambahanRute = dummyAdminUangJalan.AdminUangJalanTambahanRute.Sum(s => s.values); decimal?boronganDasar = dummyAdminUangJalan.TotalAlokasi - dummyAdminUangJalan.Kawalan - dummyAdminUangJalan.Timbangan - dummyAdminUangJalan.Karantina - dummyAdminUangJalan.SPSI - dummyAdminUangJalan.Multidrop - tambahanRute - dummyAdminUangJalan.AdminUangJalanTambahanLain.Sum(s => s.Values); //ambil data dbsettlement.IdSalesOrder = model.IdSalesOrder; 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 Truk"; dbsettlement.IdDriver = dbitem.SalesOrderOncallId.HasValue ? dbitem.SalesOrderOncall.Driver1Id : dbitem.SalesOrderProsesKonsolidasiId.HasValue ? dbitem.SalesOrderProsesKonsolidasi.Driver1Id : dbitem.SalesOrderPickup.Driver1Id; dbsettlement.IdDataTruck = dbitem.SalesOrderOncallId.HasValue ? dbitem.SalesOrderOncall.IdDataTruck : dbitem.SalesOrderProsesKonsolidasiId.HasValue ? dbitem.SalesOrderProsesKonsolidasi.IdDataTruck : dbitem.SalesOrderPickup.IdDataTruck; RepoSettBatal.save(dbsettlement, UserPrincipal.id, "Batal Truk"); decimal?TotalBiaya = (dummyAdminUangJalan.KasbonDriver1 ?? 0) + (dummyAdminUangJalan.KlaimDriver1 ?? 0) + dummyAdminUangJalan.AdminUangJalanPotonganDriver.Select(d => d.Value).Sum() + dummyAdminUangJalan.AdminUangJalanVoucherKapal.Select(d => d.Value).Sum() + dummyAdminUangJalan.AdminUangJalanVoucherSpbu.Select(d => d.Value).Sum() + dummyAdminUangJalan.AdminUangJalanUangTf.Select(d => d.Value).Sum(); decimal TotalUtangDriver = (dbsettlement.SolarDiterima == null ? 0 : dbsettlement.SolarDiterima.Value) + (dbsettlement.KapalDiterima == null ? 0 : dbsettlement.KapalDiterima.Value) + (dbsettlement.TransferDiterima == null ? 0 : dbsettlement.TransferDiterima.Value) + (dbsettlement.KasDiterima == null ? 0 : dbsettlement.KasDiterima.Value); Repoglt_det.saveFromAc(1, code + "-" + urutanBatal, TotalBiaya, 0, Repoac_mstr.FindByPk(erpConfig.IdAUJCredit)); Repoglt_det.saveFromAc(2, code + "-" + urutanBatal, 0, boronganDasar, Repoac_mstr.FindByPk(erpConfig.IdBoronganDasar)); Repoglt_det.saveFromAc(3, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Kawalan, Repoac_mstr.FindByPk(erpConfig.IdKawalan)); Repoglt_det.saveFromAc(4, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Timbangan, Repoac_mstr.FindByPk(erpConfig.IdTimbangan)); Repoglt_det.saveFromAc(5, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Karantina, Repoac_mstr.FindByPk(erpConfig.IdKarantina)); Repoglt_det.saveFromAc(6, code + "-" + urutanBatal, 0, dummyAdminUangJalan.SPSI, Repoac_mstr.FindByPk(erpConfig.IdSPSI)); Repoglt_det.saveFromAc(7, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Multidrop, Repoac_mstr.FindByPk(erpConfig.IdMultidrop)); Repoglt_det.saveFromAc(8, code + "-" + urutanBatal, 0, tambahanRute + dummyAdminUangJalan.AdminUangJalanTambahanLain.Sum(s => s.Values), Repoac_mstr.FindByPk(erpConfig.IdTambahanRuteMuat)); Repoglt_det.saveFromAc(9, code + "-" + urutanBatal, RepoSalesOrder.Harga(dbitem), 0, Repoac_mstr.FindByPk(erpConfig.IdPendapatanUsahaBlmInv)); Repoglt_det.saveFromAc(10, code + "-" + urutanBatal, 0, RepoSalesOrder.Harga(dbitem), Repoac_mstr.FindByPk(erpConfig.IdPiutangDagang)); // try {//masuklah ke saldo piutang driver, save to pby_mstr&det var glt_oid = Guid.NewGuid().ToString(); Repopbyd_det.saveMstr(glt_oid, code + "-" + urutanBatal, erpConfig.IdAUJCredit.Value, "Batal Order " + code, dbsettlement.IdDriver.Value + 7000000); Repopbyd_det.save( glt_oid, code + "-" + urutanBatal, erpConfig.IdAUJCredit.Value, "Batal Order " + code, dbsettlement.IdDriver.Value + 7000000, erpConfig.IdAUJCredit.Value, Repoac_mstr.FindByPk(erpConfig.IdAUJCredit).ac_name, TotalUtangDriver ); // } // catch (Exception e) {} } else if (dbitem.Status == "admin uang jalan") { //lebah dieu sync ERPna decimal?tambahanRute = dummyAdminUangJalan.AdminUangJalanTambahanRute.Sum(s => s.values); decimal?boronganDasar = dummyAdminUangJalan.TotalAlokasi - dummyAdminUangJalan.Kawalan - dummyAdminUangJalan.Timbangan - dummyAdminUangJalan.Karantina - dummyAdminUangJalan.SPSI - dummyAdminUangJalan.Multidrop - tambahanRute - dummyAdminUangJalan.AdminUangJalanTambahanLain.Sum(s => s.Values); Repoglt_det.save(1, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, boronganDasar, Repoac_mstr.FindByPk(erpConfig.IdBoronganDasar)); Repoglt_det.save(2, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Kawalan, Repoac_mstr.FindByPk(erpConfig.IdKawalan)); Repoglt_det.save(3, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Timbangan, Repoac_mstr.FindByPk(erpConfig.IdTimbangan)); Repoglt_det.save(4, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Karantina, Repoac_mstr.FindByPk(erpConfig.IdKarantina)); Repoglt_det.save(5, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, dummyAdminUangJalan.SPSI, Repoac_mstr.FindByPk(erpConfig.IdSPSI)); Repoglt_det.save(6, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, dummyAdminUangJalan.Multidrop, Repoac_mstr.FindByPk(erpConfig.IdMultidrop)); Repoglt_det.save(7, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, tambahanRute, Repoac_mstr.FindByPk(erpConfig.IdTambahanRuteMuat)); Repoglt_det.save(8, new Context.glt_det(), dbitem, code + "-" + urutanBatal, 0, dummyAdminUangJalan.AdminUangJalanTambahanLain.Sum(s => s.Values), Repoac_mstr.FindByPk(erpConfig.IdTambahanRuteLain)); Repoglt_det.save(9, new Context.glt_det(), dbitem, code + "-" + urutanBatal, dummyAdminUangJalan.KasbonDriver1, 0, Repoac_mstr.FindByPk(erpConfig.IdKasbonAuj)); Repoglt_det.save(10, new Context.glt_det(), dbitem, code + "-" + urutanBatal, dummyAdminUangJalan.KlaimDriver1, 0, Repoac_mstr.FindByPk(erpConfig.IdKlaimAuj)); Repoglt_det.save(11, new Context.glt_det(), dbitem, code + "-" + urutanBatal, dummyAdminUangJalan.AdminUangJalanPotonganDriver.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdPotonganLainAuj)); Repoglt_det.save(12, new Context.glt_det(), dbitem, code + "-" + urutanBatal, dummyAdminUangJalan.AdminUangJalanVoucherKapal.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdVoucherKapal)); Repoglt_det.save(13, new Context.glt_det(), dbitem, code + "-" + urutanBatal, dummyAdminUangJalan.AdminUangJalanVoucherSpbu.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdVoucherSolar)); Repoglt_det.save(14, new Context.glt_det(), dbitem, code + "-" + urutanBatal, dummyAdminUangJalan.AdminUangJalanUangTf.Sum(s => s.Value), 0, Repoac_mstr.FindByPk(erpConfig.IdAUJCredit)); } if (dbitem.Status != "batal order") { dbitem.Status = "save"; dbitem.IsBatalTruk = true; if (dbitem.SalesOrderOncallId.HasValue) { dbitem.KeteranganBatal = "Ganti truck dari " + dbitem.SalesOrderOncall.DataTruck.VehicleNo + " " + Keterangan; //Ganti truck dari <nopol sebelumnya > ke <nopol yang dipilih> [isi dari keterangan batal truck ] dbitem.SalesOrderOncall.Keterangan = "Ganti truck dari " + dbitem.SalesOrderOncall.DataTruck.VehicleNo + " " + Keterangan; //Ganti truck dari <nopol sebelumnya > ke <nopol yang dipilih> [isi dari keterangan batal truck ] dbitem.SalesOrderOncall.Driver1Id = null; dbitem.SalesOrderOncall.Driver2Id = null; dbitem.SalesOrderOncall.IdDataTruck = null; RepoAuditrail.SetAuditTrail( "UPDATE dbo.\"SalesOrderOncall\" SET \"Driver1Id\" = NULL , Driver2Id = NULL, IdDataTruck = NULL WHERE \"SalesOrderOnCallId\" = " + dbitem.SalesOrderOncallId, "List Order", "Batal Truk", UserPrincipal.id ); } else if (dbitem.SalesOrderPickupId.HasValue) { dbitem.KeteranganBatal = "Ganti truck dari " + dbitem.SalesOrderPickup.DataTruck.VehicleNo + " " + Keterangan; //Ganti truck dari <nopol sebelumnya > ke <nopol yang dipilih> [isi dari keterangan batal truck ] dbitem.SalesOrderPickup.Keterangan = "Ganti truck dari " + dbitem.SalesOrderPickup.DataTruck.VehicleNo + " " + Keterangan; //Ganti truck dari <nopol sebelumnya > ke <nopol yang dipilih> [isi dari keterangan batal truck ] dbitem.SalesOrderPickup.Driver1Id = null; dbitem.SalesOrderPickup.Driver2Id = null; dbitem.SalesOrderPickup.IdDataTruck = null; } else if (dbitem.SalesOrderProsesKonsolidasiId.HasValue) { dbitem.KeteranganBatal = "Ganti truck dari " + dbitem.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo + " " + Keterangan; //Ganti truck dari <nopol sebelumnya > ke <nopol yang dipilih> [isi dari keterangan batal truck ] dbitem.SalesOrderProsesKonsolidasi.Keterangan = "Ganti truck dari " + dbitem.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo + " " + Keterangan; //Ganti truck dari <nopol sebelumnya > ke <nopol yang dipilih> [isi dari keterangan batal truck ] dbitem.SalesOrderProsesKonsolidasi.Driver1Id = null; dbitem.SalesOrderProsesKonsolidasi.Driver2Id = null; dbitem.SalesOrderProsesKonsolidasi.IdDataTruck = null; } batalOrder.IdSalesOrder = dbitem.Id; batalOrder.Keterangan = Keterangan; batalOrder.ModifiedDate = DateTime.Now; batalOrder.IsBatalTruk = true; batalOrder.Code = code; batalOrder.UrutanBatal = urutanBatal; batalOrder.IsTransfer = IsTransfer == "1"; RepoSalesOrder.save(dbitem); RepoBatalOrder.save(batalOrder, UserPrincipal.id); return(RedirectToAction("index", "ListOrder")); } ViewBag.status = "batal order"; return(View("Form", model)); }
public ActionResult Add(PenetapanDriver model) { if (ModelState.IsValid) { bool isPalid = true; if (RepoPenetapanDriver.IsExist(model.IdDataTruck.Value)) { isPalid = false; ModelState.AddModelError("IdDataTruck", "Data truck sudah digunakan."); } if (RepoPenetapanDriver.isExistDriver(model.IdDriver1.Value, 0)) { isPalid = false; ModelState.AddModelError("idDriver1", "Driver sudah digunakan."); } if (model.IdDriver2.HasValue) { if (RepoPenetapanDriver.isExistDriver(model.IdDriver2.Value, 0)) { isPalid = false; ModelState.AddModelError("IdDriver2", "Driver sudah digunakan."); } if (model.IdDriver1 == model.IdDriver2) { isPalid = false; ModelState.AddModelError("IdDriver1", "Driver tidak boleh sama."); ModelState.AddModelError("IdDriver2", "Driver tidak boleh sama."); } if (model.IdDitetapkanOleh2 == null) { isPalid = false; ModelState.AddModelError("IdDitetapkanOleh2", "Penetap Driver 2 Belum Ditentukan."); } } if (model.IdDitetapkanOleh1 == null) { isPalid = false; ModelState.AddModelError("IdDitetapkanOleh1", "Penetap Driver 1 Belum Ditentukan."); } if (!isPalid) { return(View("Form", model)); } Context.PenetapanDriver dbitem = new Context.PenetapanDriver(); Context.PenetapanDriverHistory dbitemHistory = new Context.PenetapanDriverHistory(); //history model.SetDb(dbitem, UserPrincipal.firstname + ' ' + UserPrincipal.lastname); model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname); dbitemHistory.CreatedBy = UserPrincipal.firstname + " " + UserPrincipal.lastname; dbitemHistory.CreatedDate = DateTime.Now; dbitem.PenetapanDriverHistory.Add(dbitemHistory); //history driver Context.DataTruck dbtruck = RepoTruck.FindByPK(model.IdDataTruck.Value); Context.Driver dbdriver1 = RepoDriver.FindByPK(model.IdDriver1.Value); Context.DriverTruckHistory dbdriverHistory1 = new Context.DriverTruckHistory(); dbdriver1.NoHp1 = model.NoHp1Driver1; dbdriver1.NoHp2 = model.NoHp2Driver1; dbdriverHistory1.Tanggal = DateTime.Now; dbdriverHistory1.Nopol = dbtruck.VehicleNo; dbdriverHistory1.Type = model.JenisTruck; dbdriver1.DriverTruckHistory.Add(dbdriverHistory1); RepoDriver.save(dbdriver1); string query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dbdriver1.NoHp1 + ", \"NoHp2\" = " + dbdriver1.NoHp2 + " WHERE \"Id\" = " + dbdriver1.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" (\"IdDriver\", " + "\"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory1.IdDriver + ", " + dbdriverHistory1.Tanggal + ", " + dbdriverHistory1.Type + ", " + dbdriverHistory1.Nopol + ");"; RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Add", UserPrincipal.id); if (model.IdDriver2.HasValue) { Context.Driver dbdriver2 = RepoDriver.FindByPK(model.IdDriver2.Value); Context.DriverTruckHistory dbdriverHistory2 = new Context.DriverTruckHistory(); dbdriver2.NoHp1 = model.NoHp1Driver2; dbdriver2.NoHp2 = model.NoHp2Driver2; dbdriverHistory2.Tanggal = DateTime.Now; dbdriverHistory2.Nopol = dbtruck.VehicleNo; dbdriverHistory2.Type = model.JenisTruck; dbdriver2.DriverTruckHistory.Add(dbdriverHistory2); RepoDriver.save(dbdriver2); query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dbdriver2.NoHp1 + ", \"NoHp2\" = " + dbdriver2.NoHp2 + " WHERE \"Id\" = " + dbdriver2.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" ( " + "\"IdDriver\", \"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory2.IdDriver + ", " + dbdriverHistory2.Tanggal + ", " + dbdriverHistory2.Type + ", " + dbdriverHistory2.Nopol + ");"; RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Add", UserPrincipal.id); } RepoPenetapanDriver.save(dbitem); return(RedirectToAction("Index")); } return(View("Form", model)); }