public string FindById(int id)
{
Context.SalesOrder item = RepoSalesOrder.FindByKonsolidasi(id);
SalesOrderKonsolidasi data = new SalesOrderKonsolidasi(item);
return(new JavaScriptSerializer().Serialize(data));
}
public ActionResult batalInap(SolarInap model)
{
if (ModelState.IsValid)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(model.Id);
Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSO.Value);
model.setDbSolarInap(dbitem);
RepoSolarInap.save(dbitem, UserPrincipal.id);
if (dbitem.Transfer > 0)
{
//#Jurnal Kasbon Driver pada Biaya
string so_code = (dbso.SalesOrderOncallId.HasValue ? dbso.SalesOrderOncall.SONumber : dbso.SalesOrderProsesKonsolidasiId.HasValue ? dbso.SalesOrderProsesKonsolidasi.SONumber : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.SONumber : dbso.SalesOrderKontrak.SONumber);
string code = "SIBI-" + dbitem.TanggalDari.ToString() + so_code;
Context.ERPConfig erpConfig = RepoERPConfig.FindByFrist();
Repoglt_det.saveFromAc(1, code, model.Transfer, 0, Repoac_mstr.FindByPk(erpConfig.IdKasbonDriver)); //D, Kasbon Driver
Repoglt_det.saveFromAc(2, code, 0, model.Transfer, Repoac_mstr.FindByPk(erpConfig.IdBiayaInap)); //K, Biaya Inap
//masuklah ke saldo piutang driver, save to pby_mstr&det
try{
var glt_oid = Guid.NewGuid().ToString();
Repopbyd_det.saveMstr(glt_oid, dbitem.Code, erpConfig.IdTfCredit.Value, "Batal Inap " + code, dbitem.IdDriver.Value);
Repopbyd_det.save(glt_oid, dbitem.Code, erpConfig.IdTfCredit.Value, "Batal Inap " + code, dbitem.IdDriver.Value, erpConfig.IdKasbonDriver.Value, Repoac_mstr.FindByPk(erpConfig.IdKasbonDriver).ac_name, model.Transfer);
}
catch (Exception e)
{
}
}
return(RedirectToAction("Index"));
}
return(View("batalInap", model));
}
public ActionResult Add(SalesOrderPickup model, string btnsave)
{
SalesOrderLoadUnload[] resultLoad = JsonConvert.DeserializeObject <SalesOrderLoadUnload[]>(model.StrLoad);
model.ListLoad = resultLoad.ToList();
SalesOrderLoadUnload[] resultUnload = JsonConvert.DeserializeObject <SalesOrderLoadUnload[]>(model.StrUnload);
model.ListUnload = resultUnload.ToList();
if (ModelState.IsValid)
{
Context.SalesOrder dbso = new Context.SalesOrder();
Context.SalesOrderPickup dbitem = new Context.SalesOrderPickup();
model.setDb(dbitem);
dbitem.Urutan = RepoSalesOrder.getUrutanPickup(model.TanggalPickup.Value) + 1;
dbitem.SONumber = RepoSalesOrder.generatePickup(model.TanggalPickup.Value, dbitem.Urutan);
dbso.SalesOrderPickup = dbitem;
if (btnsave == "save")
{
dbso.Status = "save";
}
else if (btnsave == "draft")
{
dbso.Status = "draft";
}
else
{
dbso.Status = model.Status;
}
RepoSalesOrder.save(dbso);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public void save(int seq, Context.glt_det model, Context.SalesOrder soitem, string code, decimal?nominalDb, decimal?nominalCr, Models.ac_mstr ac_mstr)
{
model.glt_oid = Guid.NewGuid().ToString();
model.glt_dom_id = 1;
model.glt_en_id = 1;
model.glt_add_by = "";
model.glt_add_date = DateTime.Now;
model.glt_upd_by = "";
model.glt_upd_date = DateTime.Now;
model.glt_code = code;
model.glt_date = DateTime.Now; //soitem.SalesOrderOncallId.HasValue ? soitem.SalesOrderOncall.TanggalMuat : soitem.SalesOrderProsesKonsolidasiId.HasValue ? soitem.SalesOrderProsesKonsolidasi.TanggalMuat : soitem.SalesOrderPickupId.HasValue ? soitem.SalesOrderPickup.TanggalPickup : DateTime.Now;
model.glt_type = "SO"; //?
model.glt_cu_id = 1;
model.glt_exc_rate = 1;
model.glt_seq = seq;
model.glt_ac_id = ac_mstr.id;
model.glt_cc_id = 0;
model.glt_sb_id = 1;
model.glt_desc = ac_mstr.ac_name;
model.glt_debit = nominalDb;
model.glt_credit = nominalCr;
model.glt_posted = "N";
model.glt_dt = DateTime.Now;
model.glt_branch_id = 10001;
model.glt_driver_id = soitem.SalesOrderOncallId.HasValue ? (soitem.SalesOrderOncall.Driver1Id.HasValue ? soitem.SalesOrderOncall.Driver1Id.Value + 7000000 : 0) : soitem.SalesOrderProsesKonsolidasiId.HasValue ? (soitem.SalesOrderProsesKonsolidasi.Driver1Id.HasValue ? soitem.SalesOrderProsesKonsolidasi.Driver1Id.Value + 7000000 : 0) : soitem.SalesOrderPickupId.HasValue ? (soitem.SalesOrderPickup.Driver1Id.HasValue ? soitem.SalesOrderPickup.Driver1Id.Value + 7000000 : 0) : 0;
model.glt_no_pol = soitem.SalesOrderOncallId.HasValue ? (soitem.SalesOrderOncall.DataTruck == null ? null : soitem.SalesOrderOncall.DataTruck.VehicleNo) : soitem.SalesOrderProsesKonsolidasiId.HasValue ? (soitem.SalesOrderProsesKonsolidasi.DataTruck == null ? null : soitem.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo) : soitem.SalesOrderPickupId.HasValue ? (soitem.SalesOrderPickup.DataTruck == null ? null : soitem.SalesOrderPickup.DataTruck.VehicleNo) : null;
context.glt_det.Add(model);
context.SaveChanges();
}
public Kasirkas(Context.SalesOrder dbso, List <Context.SalesOrderKontrakListSo> dbitem)
{
Context.AdminUangJalanUangTf dbkas = dbitem.FirstOrDefault().AdminUangJalan.AdminUangJalanUangTf.Where(n => n.Keterangan == "Tunai").FirstOrDefault();
IdSalesOrder = dbso.Id;
if (dbitem.FirstOrDefault().Status == "settlement")
{
Status = "Close";
}
else
{
Status = dbkas.isTf ? "Sudah" : "Belum";
}
Jumlah = dbkas.Value;
Realisasi = dbkas.JumlahTransfer;
Waktu = dbkas.TanggalAktual + dbkas.JamAktual;
Tanggal = dbkas.Tanggal;
Penerima = dbkas.IdDriverPenerima.HasValue ? dbkas.Driver.NamaDriver : "";
DnNo = "";
SoNo = string.Join(", ", dbitem.Select(s => s.NoSo).ToList());
IdDriver = dbitem.FirstOrDefault().Driver1.KodeDriver;
Driver = dbitem.FirstOrDefault().Driver1.NamaDriver;
VehicleNo = dbitem.FirstOrDefault().DataTruck.VehicleNo;
KodeNama = dbso.SalesOrderKontrak.Customer.CustomerNama;
Customer = dbso.SalesOrderKontrak.Customer.CustomerNama;
//TanggalJalan = dbitem.SalesOrderOncall.TanggalMuat;
JenisOrder = "Kontrak";
ListIdSo = string.Join(".", dbitem.Select(d => d.Id.ToString()).ToList());
ModifiedDate = dbso.DateStatus;
}
public ActionResult View(int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(id);
if (dbitem.SalesOrderOncallId != null)
{
SalesOrderOncall model = new SalesOrderOncall(dbitem);
ViewBag.name = model.SONumber;
return(View("SalesOrderOncall/FormReadOnly", model));
}
else if (dbitem.SalesOrderPickupId != null)
{
SalesOrderPickup model = new SalesOrderPickup(dbitem);
ViewBag.name = model.SONumber;
return(View("SalesOrderPickup/FormReadOnly", model));
}
else if (dbitem.SalesOrderProsesKonsolidasiId != null)
{
SalesOrderProsesKonsolidasi model = new SalesOrderProsesKonsolidasi(dbitem);
ViewBag.name = model.SONumber;
return(View("SalesOrderProsesKonsolidasi/FormReadOnly", model));
}
else if (dbitem.SalesOrderKontrakId != null)
{
SalesOrderKontrak model = new SalesOrderKontrak(dbitem);
ViewBag.name = model.SONumber;
return(View("SalesOrderKontrak/FormReadOnly", model));
}
return(RedirectToAction("", ""));
}
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 RevisiRute(Context.SalesOrder dbitem)
{
IdSalesOrder = dbitem.Id;
if (dbitem.SalesOrderOncallId.HasValue)
{
ModelOncall = new SalesOrderOncall(dbitem);
RuteLama = ModelOncall.Rute;
MultidropLama = ModelOncall.StrMultidrop;
ListLoad = ModelOncall.ListLoad;
ListUnload = ModelOncall.ListUnload;
}
else if (dbitem.SalesOrderPickupId.HasValue)
{
ModelPickup = new SalesOrderPickup(dbitem);
RuteLama = ModelPickup.Rute;
ListLoad = ModelPickup.ListLoad;
ListUnload = ModelPickup.ListUnload;
}
else if (dbitem.SalesOrderProsesKonsolidasiId.HasValue)
{
ModelKonsolidasi = new SalesOrderProsesKonsolidasi(dbitem);
RuteLama = ModelKonsolidasi.Rute;
}
}
public KasirTf(Context.SalesOrder dbso, List <Context.SalesOrderKontrakListSo> dbitem)
{
IdSalesOrder = dbso.Id;
Jumlah = 0; Realisasi = 0;
if (dbitem.FirstOrDefault().Status == "settlement")
{
Status = "Close";
}
else
{
Status = dbitem.FirstOrDefault().AdminUangJalan.AdminUangJalanUangTf.Where(s => s.Keterangan != "Tunai").Any(n => n.isTf == false) ? "Belum" : "Sudah";
}
JenisOrder = "Kontrak";
Waktu = dbitem.FirstOrDefault().AdminUangJalan.AdminUangJalanUangTf.Where(d => d.TanggalAktual != null).OrderByDescending(t => t.TanggalAktual).Select(t => t.TanggalAktual).FirstOrDefault();
Tanggal = dbitem.FirstOrDefault().AdminUangJalan.AdminUangJalanUangTf.Where(d => d.TanggalAktual != null).OrderByDescending(t => t.TanggalAktual).Select(t => t.Tanggal).FirstOrDefault();
SoNo = string.Join(", ", dbitem.Select(s => s.NoSo).ToList());
IdDriver = dbitem.FirstOrDefault().Driver1.KodeDriver;
Driver = dbitem.FirstOrDefault().Driver1.NamaDriver;
VehicleNo = dbitem.FirstOrDefault().DataTruck.VehicleNo;
Customer = dbso.SalesOrderKontrak.Customer.CustomerNama;
foreach (var item in dbitem.FirstOrDefault().AdminUangJalan.AdminUangJalanUangTf.Where(n => n.Keterangan != "Tunai"))
{
Jumlah = Jumlah + item.Value;
Realisasi = Realisasi + item.JumlahTransfer;
}
ListIdSo = string.Join(".", dbitem.Select(d => d.Id.ToString()).ToList());
ModifiedDate = dbso.DateStatus;
}
public string getDetailByRange(int Id, string StrDate, string EndDate)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(Id);
DateTime strDate = DateTime.Parse(StrDate);
DateTime endDate = DateTime.Parse(EndDate);
List <Context.SalesOrderKontrakListSo> listDetail = dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.IsProses == false && (d.MuatDate >= strDate && d.MuatDate <= endDate) && d.IdDataTruck != null).ToList();
listDetail = listDetail.OrderBy(d => d.MuatDate).ToList();
return(new JavaScriptSerializer().Serialize(listDetail.Select(d => new
{
Id = d.Id,
NoSo = d.NoSo,
TaggalMuat = d.MuatDate.ToShortDateString(),
IdTruk = d.IdDataTruck,
VehicleNumber = d.DataTruck == null ? "" : d.DataTruck.VehicleNo,
JenisTruck = d.DataTruck == null ? "" : d.DataTruck.JenisTrucks.StrJenisTruck,
IdDriver1 = d.Driver1Id,
KodeDriver1 = d.Driver1Id.HasValue ? d.Driver1.KodeDriver : "",
NamaDriver1 = d.Driver1Id.HasValue ? d.Driver1.NamaDriver : "",
IdDriver2 = d.Driver2Id,
KodeDriver2 = d.Driver2Id.HasValue ? d.Driver2.KodeDriver : "",
NamaDriver2 = d.Driver2Id.HasValue ? d.Driver2.NamaDriver : "",
})));
}
public JsonResult Submit(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
List <Context.DaftarHargaOnCall> dummy = RepoDaftarHarga.FindAll().Where(d => d.IdCust == dbItem.SalesOrderOncall.CustomerId && (dbItem.SalesOrderOncall.TanggalMuat >= d.PeriodStart && dbItem.SalesOrderOncall.TanggalMuat <= d.PeriodEnd)).ToList();
if (dummy.Where(d => d.DaftarHargaOnCallItem.Any(i => i.IdJenisTruck == dbItem.SalesOrderOncall.JenisTruckId)).Count() < 1)
{
response.Success = false;
response.Message = "Tidak terdapat daftar harga untuk jenis truck " + dbItem.SalesOrderOncall.JenisTrucks.StrJenisTruck;
}
else
{
dbItem.Status = "save";
dbItem.isReturn = false;
dbItem.UpdatedBy = UserPrincipal.id;
RepoAuditrail.saveOrderHistory(dbItem);
RepoSalesOrder.save(dbItem);
//{ 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 : " + dbItem.SalesOrderOncall.SONumber + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " belum diproses.",
"PLANNING SO : " + dbItem.SalesOrderOncall.SONumber + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " belum diproses.");
}
return(Json(response));
}
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 string GetDetailSo(int idSo, string ListIdSo)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(idSo);
AdminUangJalan model = new AdminUangJalan();
if (dbitem.SalesOrderKontrakId.HasValue)
{
List <int> ListIdDumy = ListIdSo.Split(new string[] { "." }, StringSplitOptions.None).ToList().Select(int.Parse).ToList();
List <Context.SalesOrderKontrakListSo> dbsoDummy = dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => ListIdDumy.Contains(d.Id)).ToList();
dbitem.SalesOrderKontrak.SalesOrderKontrakListSo = dbsoDummy;
if (dbsoDummy.FirstOrDefault().IdAdminUangJalan.HasValue)
{
model = new AdminUangJalan(dbsoDummy.FirstOrDefault().AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
}
}
else
{
try
{
model = new AdminUangJalan(dbitem.AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
}
catch { }
}
return(new JavaScriptSerializer().Serialize(model));
}
public string GetDetailSo(int idSo, string ListIdSo)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(idSo);
AdminUangJalan model = new AdminUangJalan();
if (dbitem.SalesOrderKontrakId.HasValue)
{
List <int> ListIdDumy = ListIdSo.Split(new string[] { "." }, StringSplitOptions.None).ToList().Select(int.Parse).ToList();
List <Context.SalesOrderKontrakListSo> dbsoDummy = dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => ListIdDumy.Contains(d.Id)).ToList();
dbitem.SalesOrderKontrak.SalesOrderKontrakListSo = dbsoDummy;
if (dbsoDummy.FirstOrDefault().IdAdminUangJalan.HasValue)
{
model = new AdminUangJalan(dbsoDummy.FirstOrDefault().AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
}
}
else
{
model = new AdminUangJalan(dbitem.AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
}
var tempModel = model.ModelListRemoval.Where(d => d.Status == "dispatched");
if (tempModel.Count() > 0)
{
return(new JavaScriptSerializer().Serialize(tempModel.OrderBy(d => d.Id).Last()));
}
else
{
return(new JavaScriptSerializer().Serialize(model));
}
}
public PartialViewResult GetPartialSo(int idSo, int IdSoKontrak = 0)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(idSo);
if (dbitem.SalesOrderOncallId.HasValue)
{
AdminUangJalan model = new AdminUangJalan(dbitem.AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
model.ModelOncall = new SalesOrderOncall(dbitem);
return(PartialView("SalesOrderOncall/_PartialFormReadOnly", model.ModelOncall));
}
else if (dbitem.SalesOrderPickupId.HasValue)
{
AdminUangJalan model = new AdminUangJalan(dbitem.AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
model.ModelPickup = new SalesOrderPickup(dbitem);
return(PartialView("SalesOrderPickup/_PartialFormReadOnly", model.ModelPickup));
}
else if (dbitem.SalesOrderProsesKonsolidasiId.HasValue)
{
AdminUangJalan model = new AdminUangJalan(dbitem.AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
model.ModelKonsolidasi = new SalesOrderProsesKonsolidasi(dbitem);
return(PartialView("SalesOrderProsesKonsolidasi/_PartialFormReadOnly", model.ModelKonsolidasi));
}
else if (IdSoKontrak != 0)
{
//List<int> ListIdDumy = ListIdSo.Split(new string[] { "." }, StringSplitOptions.None).ToList().Select(int.Parse).ToList();
Context.SalesOrderKontrakListSo dbsoDummy = dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.Id == IdSoKontrak).FirstOrDefault();
dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Clear();
dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Add(dbsoDummy);
AdminUangJalan model = new AdminUangJalan(dbsoDummy.AdminUangJalan, RepoAtm.FindAll(), RepoBor.FindAll());
model.ModelKontrak = new SalesOrderKontrak(dbitem);
return(PartialView("SalesOrderKontrak/_PartialFormReadOnly", model));
}
return(PartialView(""));
}
private void IsValidSo(int idSo, int idTruck, List <string> MsgError)
{
//cokot satuan anu tina so berdasarkan id kon truk,
Context.SalesOrder dbso = RepoSalesOrder.FindByKonsolidasi(idSo);
List <Context.DaftarHargaKonsolidasiItem> dbItems = RepoDaftarHarga.FindByItemId(dbso.SalesOrderKonsolidasi.IdDaftarHargaItem.Value).DaftarHargaKonsolidasiItem.ToList();
if (dbItems != null)
{
//cokot item daftar harga sesuai anu dipilih tina so
Context.DaftarHargaKonsolidasiItem dbItemHarga = dbItems.Where(d => d.Id == dbso.SalesOrderKonsolidasi.IdDaftarHargaItem.Value).FirstOrDefault();
if (dbso.SalesOrderKonsolidasi.PerhitunganDasar != "Manual")
{
//cek aya teu data na berdasar kan truk jeung satuana na
//khusus tonase
if (dbso.SalesOrderKonsolidasi.PerhitunganDasar == "Tonase")
{
if (dbItemHarga.IdJenisKendaraan != idTruck || (dbItemHarga.LookupCodeSatuan.Nama.ToLower() != "kg" && dbItemHarga.LookupCodeSatuan.Nama.ToLower() != "ton"))
{
MsgError.Add("Tidak terdapat Daftar harga pada " + dbso.SalesOrderKonsolidasi.SONumber + " untuk satuan " + dbso.SalesOrderKonsolidasi.PerhitunganDasar);
}
}
else
{
if (dbItemHarga.IdJenisKendaraan != idTruck || dbItemHarga.LookupCodeSatuan.Nama.ToLower() != dbso.SalesOrderKonsolidasi.PerhitunganDasar.ToLower())
{
MsgError.Add("Tidak terdapat Daftar harga pada " + dbso.SalesOrderKonsolidasi.SONumber + " untuk satuan " + dbso.SalesOrderKonsolidasi.PerhitunganDasar);
}
}
}
}
}
public ActionResult Edit(int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(id);
SalesOrderKontrak model = new SalesOrderKontrak(dbitem);
ViewBag.name = model.SONumber;
return(View("Form", model));
}
public ActionResult Edit(int idSo)
{
Context.SalesOrder dbso = RepoSalesOrder.FindByPK(idSo);
RevisiKeterangan model = new RevisiKeterangan(dbso);
return(View("Form", model));
}
public ActionResult InputDp(int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(id);
SalesOrderProsesKonsolidasi model = new SalesOrderProsesKonsolidasi(dbitem);
ViewBag.name = model.SONumber;
ViewBag.kondisi = "inputdp";
return(View("SalesOrderProsesKonsolidasi/FormReadOnly", model));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
RepoSalesOrder.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public JsonResult Submit(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
dbItem.Status = "save";
RepoSalesOrder.save(dbItem);
return(Json(response));
}
public void SyncToERP(Context.SalesOrder dbso, string sod_guid)
{
decimal harga = RepoSalesOrder.Harga(dbso);
Context.SalesOrderOncall dbitem = dbso.SalesOrderOncall;
string guid = Guid.NewGuid().ToString();
Reposo_mstr.saveSoMstr(dbso, UserPrincipal.username, guid, dbitem.CustomerId.Value, harga);
Reposo_mstr.saveSoDet(dbso, UserPrincipal.username, guid, sod_guid);
}
public JsonResult Return(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
dbItem.Status = "draft planning";
dbItem.isReturn = true;
RepoSalesOrder.save(dbItem);
return(Json(response));
}
public JsonResult DeleteDp(int IdSo, int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByKontrak(IdSo);
Context.SalesOrderKontrakDp dbdp = dbitem.SalesOrderKontrak.SalesOrderKontrakDp.Where(d => d.Id == id).FirstOrDefault();
dbitem.SalesOrderKontrak.SalesOrderKontrakDp.Remove(dbdp);
ResponeModel response = new ResponeModel(true);
RepoSalesOrder.save(dbitem);
return(Json(response));
}
public String CheckLeadTimeDriver(int id)
{
Context.SalesOrder dbso = RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save planning" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && (d.SalesOrderOncall.Driver1Id == id || d.SalesOrderOncall.Driver2Id == id)) ||
(d.SalesOrderPickupId.HasValue && (d.SalesOrderPickup.Driver1Id == id || d.SalesOrderPickup.Driver2Id == id)) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && (d.SalesOrderProsesKonsolidasi.Driver1Id == id || d.SalesOrderProsesKonsolidasi.Driver2Id == id)) ||
(d.SalesOrderKontrakId.HasValue && (d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.IdDriver1 == id || k.IdDriver2 == id)))
)
).FirstOrDefault();
List <Context.SalesOrder> soList = RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save planning" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && (d.SalesOrderOncall.Driver1Id == id || d.SalesOrderOncall.Driver2Id == id)) ||
(d.SalesOrderPickupId.HasValue && (d.SalesOrderPickup.Driver1Id == id || d.SalesOrderPickup.Driver2Id == id)) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && (d.SalesOrderProsesKonsolidasi.Driver1Id == id || d.SalesOrderProsesKonsolidasi.Driver2Id == id)) ||
(d.SalesOrderKontrakId.HasValue && (d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.IdDriver1 == id || k.IdDriver2 == id)))
)
).ToList();
if (dbso != null && dbso.SalesOrderOncallId.HasValue)
{
int maxUrutan = soList.Count() > 0 ? RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save planning" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && (d.SalesOrderOncall.Driver1Id == id || d.SalesOrderOncall.Driver2Id == id)) ||
(d.SalesOrderPickupId.HasValue && (d.SalesOrderPickup.Driver1Id == id || d.SalesOrderPickup.Driver2Id == id)) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && (d.SalesOrderProsesKonsolidasi.Driver1Id == id || d.SalesOrderProsesKonsolidasi.Driver2Id == id)) ||
(d.SalesOrderKontrakId.HasValue && (d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.IdDriver1 == id || k.IdDriver2 == id)))
)
).Max(d => d.urutan) : 0;
Context.Rute rute = RepoSalesOrder.FindRute(dbso.SalesOrderOncall.IdDaftarHargaItem.Value);
double wktkrj = rute.WaktuKerja;
int waktuKerja = int.Parse(rute.WaktuKerja.ToString());
return(new JavaScriptSerializer().Serialize(new {
waktupulang = DateTime.Parse(dbso.SalesOrderOncall.TanggalMuat.ToString()).AddDays(waktuKerja).ToString(), orderCount = maxUrutan
}));
}
else if (dbso != null && dbso.SalesOrderKontrakId.HasValue)
{
int maxUrutan = soList.Count() > 0 ? RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save planning" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && (d.SalesOrderOncall.Driver1Id == id || d.SalesOrderOncall.Driver2Id == id)) ||
(d.SalesOrderPickupId.HasValue && (d.SalesOrderPickup.Driver1Id == id || d.SalesOrderPickup.Driver2Id == id)) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && (d.SalesOrderProsesKonsolidasi.Driver1Id == id || d.SalesOrderProsesKonsolidasi.Driver2Id == id)) ||
(d.SalesOrderKontrakId.HasValue && (d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.IdDriver1 == id || k.IdDriver2 == id)))
)
).Max(d => d.urutan) : 0;
return(new JavaScriptSerializer().Serialize(new {
waktupulang = dbso.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.Driver1Id == id).Select(d => d.MuatDate).Max().ToString(),
waktuMuat = dbso.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.Driver1Id == id).Select(d => d.MuatDate).Min().ToString(), orderCount = 0,
}));
}
return(new JavaScriptSerializer().Serialize(new { success = true }));
}
public string FindDetailSo(int id)
{
Context.SalesOrder item = RepoSalesOrder.FindByProsesKonsolidasi(id);
List <SalesOrderKonsolidasi> listModel = new List <SalesOrderKonsolidasi>();
foreach (Context.SalesOrderProsesKonsolidasiItem Detail in item.SalesOrderProsesKonsolidasi.SalesOrderProsesKonsolidasiItem)
{
listModel.Add(new SalesOrderKonsolidasi(Detail.SalesOrderKonsolidasi));
}
return(new JavaScriptSerializer().Serialize(new { total = listModel.Count(), data = listModel }));
}
public string GetItemTruck(int idSo)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByKontrak(idSo);
List <SalesOrderKontrakItemTruck> model = new List <SalesOrderKontrakItemTruck>();
foreach (Context.SalesOrderKontrakTruck item in dbitem.SalesOrderKontrak.SalesOrderKontrakTruck)
{
model.Add(new SalesOrderKontrakItemTruck(item));
}
return(new JavaScriptSerializer().Serialize(model));
}
public string GetTruckImport(int idSo)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByKontrak(idSo);
List <DataTruckDetail> model = new List <DataTruckDetail>();
foreach (Context.SalesOrderKontrakTruck item in dbitem.SalesOrderKontrak.SalesOrderKontrakTruck)
{
model.Add(new DataTruckDetail(item.DataTruck, null, RepoSalesOrder.FindAll()));
}
return(new JavaScriptSerializer().Serialize(model));
}
public ActionResult Edit(int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(id);
SalesOrderKontrak model = new SalesOrderKontrak(dbitem);
ViewBag.kondisi = "planning";
ViewBag.name = model.SONumber;
ViewBag.Title = "Planning Sales Order Kontrak " + model.SONumber;
ViewBag.PostData = "Edit";
return(View("SalesOrderKontrak/FormReadOnly", model));
}
public ActionResult EditKontrak(int id, int idsokontrak)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(id);
Context.SalesOrderKontrakListSo soKontrak = dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.Id == idsokontrak).FirstOrDefault();
//ambil jumlah so yang sama admin uang jalan nya
int jumSo = dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.IdAdminUangJalan == soKontrak.IdAdminUangJalan).Count();
ViewBag.dbsoPerDriverCount = jumSo;
dbitem.SalesOrderKontrak.SalesOrderKontrakListSo = new List <Context.SalesOrderKontrakListSo>();
dbitem.SalesOrderKontrak.SalesOrderKontrakListSo.Add(soKontrak);
AdminUangJalan model = new AdminUangJalan();
if (soKontrak.IdAdminUangJalan.HasValue)
{
model = new AdminUangJalan(soKontrak.AdminUangJalan, Repoatm.FindAll(), RepoBor.FindAll());
}
model.IdSalesOrder = dbitem.Id;
model.ListIdSo = idsokontrak.ToString();
ViewBag.Status = soKontrak.Status;
model.ModelKontrak = new SalesOrderKontrak(dbitem);
if (soKontrak.Status.ToLower().Contains("konfirmasi"))
{
model.StatusSo = "Konfirmasi";
}
if (model.IdDriver1.HasValue)
{
model.IdDriver1 = model.IdDriver1;
model.NamaDriver1 = model.NamaDriver1;
model.KeteranganGanti1 = model.KeteranganGanti1;
}
else
{
model.IdDriver1 = soKontrak.Driver1Id;
model.NamaDriver1 = soKontrak.Driver1.KodeDriver + " - " + soKontrak.Driver1.NamaDriver;
}
if (model.IdDriver2.HasValue)
{
model.IdDriver2 = model.IdDriver2;
model.NamaDriver2 = model.NamaDriver2;
model.KeteranganGanti2 = model.KeteranganGanti2;
}
else
{
if (soKontrak.Driver2Id.HasValue)
{
model.IdDriver2 = soKontrak.Driver2Id;
model.NamaDriver2 = soKontrak.Driver2.KodeDriver + " - " + soKontrak.Driver2.NamaDriver;
}
}
ViewBag.Title = "Batal Truk " + dbitem.SalesOrderKontrak.SONumber;
return(View("Form", model));
}
