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 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 batalInap(int id)
{
Context.SolarInap dbitem = RepoSolarInap.FindByPK(id);
SolarInap model = new SolarInap(dbitem);
ViewBag.name = model.Id;
return(View("batalInap", model));
}
public ActionResult Add()
{
SolarInap model = new SolarInap();
model.StepKe = 1;
ViewBag.IdSO = 0;
return(View("Form", model));
}
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 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 void delete(SolarInap dbitem, int id)
{
context.SolarInap.Remove(dbitem);
var query = "DELETE FROM dbo.\"SolarInap\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "SolarInap", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
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 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 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 void save(SolarInap dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.SolarInap.Add(dbitem);
var query = "INSERT INTO dbo.\"SolarInap\" (\"IdSO\", \"TanggalDari\", \"TanggalHingga\", \"NilaiYgDiajukan\", \"KeteranganOperation\", \"Nominal\", \"KeteranganMarketing\", " +
"\"KeteranganAdmin\", \"StatusTagihan\", \"IdDriver\", \"Cash\", \"Transfer\", \"TglTransfer\", \"TglCash\", \"DititipKe\", \"IdAtm\", \"StepKe\", \"Status\", \"AktualCash\", " +
"\"AktualTransfer\", \"KeteranganKasirCash\", \"KeteranganBatal\", \"KeteranganKasirTransfer\", \"TanggalAktualCash\", \"JamAktualCash\", \"TanggalAktualTransfer\", " +
"\"JamAktualTransfer\", \"AktualDititipkanKepada\", \"TanggalBatal\", \"AktualIdAtm\", \"CashBack\", \"SalesOrderKontrakListSOId\", \"Code\") VALUES ( " + dbitem.IdSO + ", " +
dbitem.TanggalDari + ", " + dbitem.TanggalHingga + ", " + dbitem.NilaiYgDiajukan + ", " + dbitem.KeteranganOperation + ", " + dbitem.Nominal + ", " + dbitem.KeteranganMarketing + ", " +
dbitem.KeteranganAdmin + ", " + dbitem.StatusTagihan + ", " + dbitem.IdDriver + ", " + dbitem.Cash + ", " + dbitem.Transfer + ", " + dbitem.TglTransfer + ", " + dbitem.TglCash + ", " +
dbitem.DititipKe + ", " + dbitem.IdAtm + ", " + dbitem.StepKe + ", " + dbitem.Status + ", " + dbitem.AktualCash + ", " + dbitem.AktualTransfer + ", " + dbitem.KeteranganKasirCash +
", " + dbitem.KeteranganBatal + ", " + dbitem.KeteranganKasirTransfer + ", " + dbitem.TanggalAktualCash + ", " + dbitem.JamAktualCash + ", " + dbitem.TanggalAktualTransfer + ", " +
dbitem.JamAktualTransfer + ", " + dbitem.AktualDititipkanKepada + ", " + dbitem.TanggalBatal + ", " + dbitem.AktualIdAtm + ", " + dbitem.CashBack + ", " +
dbitem.SalesOrderKontrakListSOId + ", " + dbitem.Code + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "SolarInap", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.SolarInap.Attach(dbitem);
var query = "UPDATE dbo.\"SolarInap\" SET \"TanggalDari\" = " + dbitem.TanggalDari + ", \"TanggalHingga\" = " + dbitem.TanggalHingga + ", \"NilaiYgDiajukan\" = " + dbitem.NilaiYgDiajukan +
", \"KeteranganOperation\" = " + dbitem.KeteranganOperation + ", \"Nominal\" = " + dbitem.Nominal + ", \"KeteranganMarketing\" = " + dbitem.KeteranganMarketing +
", \"KeteranganAdmin\" = " + dbitem.KeteranganAdmin + ", \"StatusTagihan\" = " + dbitem.StatusTagihan + ", \"IdDriver\" = " + dbitem.IdDriver + ", \"Cash\" = " + dbitem.Cash +
", \"Transfer\" = " + dbitem.Transfer + ", \"TglTransfer\" = " + dbitem.TglTransfer + ", \"TglCash\" = " + dbitem.TglCash + ", \"DititipKe\" = " + dbitem.DititipKe +
", \"IdAtm\" = " + dbitem.IdAtm + ", \"StepKe\" = " + dbitem.StepKe + ", \"Status\" = " + dbitem.Status + ", \"AktualCash\" = " + dbitem.AktualCash + ", \"AktualTransfer\" = " +
dbitem.AktualTransfer + ", \"KeteranganKasirCash\" = " + dbitem.KeteranganKasirCash + ", \"KeteranganBatal\" = " + dbitem.KeteranganBatal + ", \"KeteranganKasirTransfer\" = " +
dbitem.KeteranganKasirTransfer + ", \"TanggalAktualCash\" = " + dbitem.TanggalAktualCash + ", \"JamAktualCash\" = " + dbitem.JamAktualCash + ", \"TanggalAktualTransfer\" = " +
dbitem.TanggalAktualTransfer + ", \"JamAktualTransfer\" = " + dbitem.JamAktualTransfer + ", \"AktualDititipkanKepada\" = " + dbitem.AktualDititipkanKepada + ", \"TanggalBatal\" = " +
dbitem.TanggalBatal + ", \"AktualIdAtm\" = " + dbitem.AktualIdAtm + ", \"CashBack\" = " + dbitem.CashBack + ", \"SalesOrderKontrakListSOId\" = " + dbitem.SalesOrderKontrakListSOId +
", \"Code\" = " + dbitem.Code + "WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "SolarInap", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
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));
}
