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(SolarInap model)
{
bool palid = true;
if (ModelState.IsValid)
{
Context.SolarInap dbitem = new Context.SolarInap();
if (RepoSolarInap.FindBySOAndDate(model.IdSO, DateTime.Parse(model.TanggalDari)) != null)
{
ModelState.AddModelError("IdSO", "Order terpilih sudah diset di tanggal " + model.TanggalDari);
palid = false;
}
if (palid)
{
model.setDb(dbitem);
RepoSolarInap.save(dbitem, UserPrincipal.id);
}
else
{
ViewBag.IdSO = model.IdSO;
return(View("Form", model));
}
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public void setDbKasirCash(Context.SolarInap dbitem)
{
dbitem.AktualCash = Cash;
dbitem.TanggalAktualCash = TanggalAktualCash;
dbitem.JamAktualCash = JamAktualCash;
dbitem.AktualDititipkanKepada = AktualDititipkanKepada;
dbitem.KeteranganKasirCash = KeteranganKasirCash;
}
public ActionResult kasirTransfer(int id)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(id);
SolarInap model = new SolarInap(dbitem);
ViewBag.name = model.Id;
return(View("kasirTransfer", model));
}
public void setDbKasirTransfer(Context.SolarInap dbitem)
{
dbitem.AktualTransfer = Transfer;
dbitem.AktualIdAtm = IdAtm;
dbitem.TanggalAktualTransfer = TanggalAktualTransfer;
dbitem.JamAktualTransfer = JamAktualTransfer;
dbitem.KeteranganKasirTransfer = KeteranganKasirTransfer;
}
public ActionResult batalInap(int id)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(id);
SolarInap model = new SolarInap(dbitem);
ViewBag.name = model.Id;
return(View("batalInap", model));
}
public ActionResult pengembalianUang(int id)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(id);
SolarInap model = new SolarInap(dbitem);
ViewBag.name = model.Id;
return(View("pengembalianUang", model));
}
public ActionResult Edit(int id)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(id);
SolarInap model = new SolarInap(dbitem);
model.StepKe += 1;
ViewBag.name = model.Id;
ViewBag.IdSO = 0;
return(View("Form", model));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SolarInap dbItem = RepoSolarInap.FindByPK(id);
RepoSolarInap.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public ActionResult pengembalianUang(SolarInap model)
{
if (ModelState.IsValid)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(model.Id);
model.setPengembalianUangSolarInap(dbitem);
RepoSolarInap.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("pengembalianUang", model));
}
public ActionResult kasirCash(SolarInap model)
{
if (ModelState.IsValid)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(model.Id);
model.setDbKasirCash(dbitem);
RepoSolarInap.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("kasirCash", model));
}
public ActionResult Edit(SolarInap model)
{
bool palid = true;
if (model.Cash == null || model.Cash <= 0)
{
model.Cash = 0;
}
if (ModelState.IsValid)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(model.Id);
Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSO.Value);
if (dbitem.StepKe == 2 && model.Transfer <= 0)
{
ModelState.AddModelError("Transfer", "Harus lebih besar dari 0");
palid = false;
}
if (palid)
{
if (dbitem.StepKe == 1 && model.StatusTagihan == "Ditagih")
{
//#Jurnal Piutang Customer 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 = "SIM-" + dbitem.TanggalDari.ToString() + so_code;
Context.ERPConfig erpConfig = RepoERPConfig.FindByFrist();
Repoglt_det.saveFromAc(1, code, model.Nominal, 0, Repoac_mstr.FindByPk(erpConfig.IdPiutangCustomer)); //D, Piutang Customer
Repoglt_det.saveFromAc(2, code, 0, model.Nominal, Repoac_mstr.FindByPk(erpConfig.IdBiayaInap)); //K, Biaya Inap
}
else if (dbitem.StepKe == 2)
{
//#Jurnal Piutang Customer 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 = "SIAUJ-" + dbitem.TanggalDari.ToString() + so_code;
Context.ERPConfig erpConfig = RepoERPConfig.FindByFrist();
Repoglt_det.saveFromAc(1, code, dbitem.NilaiYgDiajukan, 0, Repoac_mstr.FindByPk(erpConfig.IdTambahanRuteMuat)); //D, Piutang Customer
Repoglt_det.saveFromAc(2, code, 0, dbitem.NilaiYgDiajukan, Repoac_mstr.FindByPk(erpConfig.IdAUJCredit)); //K, Biaya Inap
}
model.setDb(dbitem);
RepoSolarInap.save(dbitem, UserPrincipal.id);
}
else
{
return(View("Form", model));
}
return(RedirectToAction("Index"));
}
ViewBag.IdSO = 0;
return(View("Form", model));
}
public ActionResult kasirTransfer(SolarInap model)
{
if (ModelState.IsValid)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(model.Id);
Context.SalesOrder dbso = RepoSalesOrder.FindByPK(model.IdSO.Value);
if (dbitem.Cash <= 0)
{
dbitem.Cash = 0;
}
model.setDbKasirTransfer(dbitem);
dbitem.IdCreditTf = model.IdCreditTf;
//#Marketing, Status Ditagih, Piutang Customer pada Biaya Inapdbitem
string code = "SIKT-" + dbitem.TanggalDari.ToString() + (dbso.SalesOrderOncallId.HasValue ? dbso.SalesOrderOncall.SONumber : dbso.SalesOrderProsesKonsolidasiId.HasValue ? dbso.SalesOrderProsesKonsolidasi.SONumber : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.SONumber : dbso.SalesOrderKontrak.SONumber);
Context.ERPConfig erpConfig = RepoERPConfig.FindByFrist();
Repoglt_det.saveFromAc(1, code, model.Transfer, 0, Repoac_mstr.FindByPk(erpConfig.IdAUJCredit)); //D, Biaya Inap
Repoglt_det.saveFromAc(2, code, 0, model.Transfer, Repoac_mstr.FindByPk(dbitem.IdCreditTf)); //K, Transfer / Bank
RepoSolarInap.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("kasirCash", model));
}
public void setDb(Context.SolarInap dbitem)
{
dbitem.Id = Id;
dbitem.IdSO = IdSO;
if (TanggalDari != null && TanggalDari != "")
{
dbitem.TanggalDari = DateTime.ParseExact(TanggalDari, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
if (TanggalHingga != null && TanggalHingga != "")
{
dbitem.TanggalHingga = DateTime.ParseExact(TanggalHingga, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
dbitem.SalesOrderKontrakListSOId = SalesOrderKontrakListSOId;
dbitem.NilaiYgDiajukan = NilaiYgDiajukan;
dbitem.KeteranganAdmin = KeteranganAdmin;
dbitem.KeteranganMarketing = KeteranganMarketing;
dbitem.KeteranganOperation = KeteranganOperation;
dbitem.Nominal = Nominal;
dbitem.StatusTagihan = StatusTagihan;
dbitem.IdDriver = IdDriver;
dbitem.Cash = Cash == null ? 0 : Cash;
dbitem.Transfer = Transfer;
if (TglCash != null && TglCash != "")
{
dbitem.TglCash = DateTime.ParseExact(TglCash, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
if (TglTransfer != null && TglTransfer != "")
{
dbitem.TglTransfer = DateTime.ParseExact(TglTransfer, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
dbitem.DititipKe = DititipKe;
dbitem.IdAtm = IdAtm;
dbitem.StepKe = StepKe;
dbitem.TanggalTiba = TanggalTiba.Value;
dbitem.JamTiba = JamTiba;
}
public void setDbSolarInap(Context.SolarInap dbitem)
{
dbitem.TanggalBatal = TanggalBatal;
dbitem.KeteranganBatal = KeteranganBatal;
dbitem.StepKe = 4;
}
public void setPengembalianUangSolarInap(Context.SolarInap dbitem)
{
dbitem.CashBack = CashBack;
}
public SolarInap(Context.SolarInap dbitem, Context.SalesOrderKontrakListSo sokontrak = null)
{
Id = dbitem.Id;
IdSO = dbitem.IdSO;
KasirDiberikanUntuk = dbitem.SO.SalesOrderOncallId.HasValue ? dbitem.SO.SalesOrderOncall.Driver1.NamaDriver : dbitem.SO.SalesOrderProsesKonsolidasiId.HasValue ? dbitem.SO.SalesOrderProsesKonsolidasi.Driver1.NamaDriver : dbitem.SO.SalesOrderPickupId.HasValue ? dbitem.SO.SalesOrderPickup.Driver1.NamaDriver : "";
Status = dbitem.StepKe == 1 ? "Marketing" : dbitem.StepKe == 2 ? "Finance" : dbitem.StepKe == 3 ? (dbitem.AktualCash > 0 && dbitem.AktualTransfer > 0 ? "Sudah" : dbitem.AktualCash > 0 ? (dbitem.Transfer > 0 ? "Kasir Transfer" : "Sudah") : dbitem.AktualTransfer > 0 ? (dbitem.Cash > 0 ? "Kasir Kas" : "Sudah") : "Kasir") : dbitem.StepKe == 4 ? "Batal Inap" : "Sudah";
TanggalMuat = dbitem.SO.SalesOrderOncallId.HasValue ? dbitem.SO.SalesOrderOncall.TanggalMuat : dbitem.SO.SalesOrderProsesKonsolidasiId.HasValue ? dbitem.SO.SalesOrderProsesKonsolidasi.TanggalMuat : dbitem.SO.SalesOrderPickup.TanggalPickup;
TanggalDari = (dbitem.TanggalDari.Date.ToString().Split())[0];
TanggalHingga = (dbitem.TanggalHingga.Date.ToString().Split())[0];
NilaiYgDiajukan = dbitem.NilaiYgDiajukan;
CashBack = dbitem.CashBack;
KeteranganAdmin = dbitem.KeteranganAdmin;
KeteranganMarketing = dbitem.KeteranganMarketing;
KeteranganOperation = dbitem.KeteranganOperation;
KeteranganKasirCash = dbitem.KeteranganKasirCash;
Nominal = dbitem.Nominal;
StatusTagihan = dbitem.StatusTagihan == null ? "Negosiasi" : dbitem.StatusTagihan;
IdDriver = dbitem.IdDriver;
Cash = dbitem.Cash;
Transfer = dbitem.Transfer;
TglCash = (dbitem.TglCash.Date.ToString().Split())[0];
TglTransfer = (dbitem.TglTransfer.Date.ToString().Split())[0];
DititipKe = dbitem.DititipKe;
IdAtm = dbitem.IdAtm;
StepKe = dbitem.StepKe;
TanggalTiba = dbitem.TanggalTiba;
JamTiba = dbitem.JamTiba;
if (dbitem.IdAtm.HasValue)
{
AtasNama = dbitem.Atm.AtasNama;
BankNama = dbitem.Atm.LookupCodeBank.Nama;
NoRek = dbitem.Atm.NoRekening;
}
if (dbitem.SO.SalesOrderOncallId.HasValue)
{
NoSO = dbitem.SO.SalesOrderOncall.SONumber;
VehicleNo = dbitem.SO.SalesOrderOncall.DataTruck.VehicleNo;
NamaDriver = dbitem.SO.SalesOrderOncall.Driver1.NamaDriver;
KodeDriver = dbitem.SO.SalesOrderOncall.Driver1.KodeDriver;
JenisTruk = dbitem.SO.SalesOrderOncall.JenisTrucks.StrJenisTruck;
Customer = dbitem.SO.SalesOrderOncall.Customer.CustomerNama;
TanggalBerangkat = dbitem.SO.SalesOrderOncall.TanggalMuat;
}
else if (dbitem.SO.SalesOrderPickupId.HasValue)
{
NoSO = dbitem.SO.SalesOrderPickup.SONumber;
VehicleNo = dbitem.SO.SalesOrderPickup.DataTruck.VehicleNo;
NamaDriver = dbitem.SO.SalesOrderPickup.Driver1.NamaDriver;
KodeDriver = dbitem.SO.SalesOrderPickup.Driver1.KodeDriver;
JenisTruk = dbitem.SO.SalesOrderPickup.JenisTrucks.StrJenisTruck;
Customer = dbitem.SO.SalesOrderPickup.Customer.CustomerNama;
}
else if (dbitem.SO.SalesOrderProsesKonsolidasiId.HasValue)
{
NoSO = dbitem.SO.SalesOrderProsesKonsolidasi.SONumber;
VehicleNo = dbitem.SO.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo;
NamaDriver = dbitem.SO.SalesOrderProsesKonsolidasi.Driver1.NamaDriver;
KodeDriver = dbitem.SO.SalesOrderProsesKonsolidasi.Driver1.KodeDriver;
JenisTruk = dbitem.SO.SalesOrderProsesKonsolidasi.JenisTrucks.StrJenisTruck;
TanggalBerangkat = dbitem.SO.SalesOrderProsesKonsolidasi.TanggalMuat;
}
else if (sokontrak != null)
{
NoSO = sokontrak.NoSo;
VehicleNo = sokontrak.DataTruck.VehicleNo;
NamaDriver = sokontrak.Driver1.NamaDriver;
KodeDriver = sokontrak.Driver1.KodeDriver;
JenisTruk = sokontrak.DataTruck.JenisTrucks.StrJenisTruck;
TanggalBerangkat = sokontrak.MuatDate;
}
}
