public string select(int id, int ac_id, string type)
{
Context.ERPDynamicConfig eRPDynamicConfig = RepoERPConfig.FindByIdAndType(id, type);
ac_mstr ac = Repoac_mstr.FindByPk(ac_id);
return(new JavaScriptSerializer().Serialize(new { id = id, ac_id = ac.id, ac_code = ac.ac_code, ac_name = ac.ac_name }));
}
public ActionResult Edit(int id)
{
Context.MasterPool dbitem = RepoPool.FindByPK(id);
MasterPool model = new MasterPool(dbitem);
ViewBag.name = model.NamePool;
if (dbitem.IdCreditCash.HasValue)
{
ac_mstr bk_credit_cash = Repoac_mstr.FindByPk(dbitem.IdCreditCash);
model.IdCreditCash = bk_credit_cash.id;
model.CodeCreditCash = bk_credit_cash.ac_code;
model.NamaCreditCash = bk_credit_cash.ac_name;
}
return(View("Form", model));
}
public ActionResult Edit()
{
ERPConfig model = new ERPConfig();
Context.ERPConfig dbitem = RepoERPConfig.FindByFrist();
if (dbitem != null)
{
if (dbitem.IdDP.HasValue)
{
ac_mstr ac_mstr_DP = Repoac_mstr.FindByPk(dbitem.IdDP);
model.IdDP = ac_mstr_DP.id;
model.CodeDP = ac_mstr_DP.ac_code;
model.NamaDP = ac_mstr_DP.ac_name;
}
if (dbitem.IdBiayaPerjalanan.HasValue)
{
ac_mstr ac_mstr_BiayaPerjalanan = Repoac_mstr.FindByPk(dbitem.IdBiayaPerjalanan);
model.IdBiayaPerjalanan = ac_mstr_BiayaPerjalanan.id;
model.CodeBiayaPerjalanan = ac_mstr_BiayaPerjalanan.ac_code;
model.NamaBiayaPerjalanan = ac_mstr_BiayaPerjalanan.ac_name;
}
if (dbitem.IdBiayaInap.HasValue)
{
ac_mstr ac_mstr_BiayaInap = Repoac_mstr.FindByPk(dbitem.IdBiayaInap);
model.IdBiayaInap = ac_mstr_BiayaInap.id;
model.CodeBiayaInap = ac_mstr_BiayaInap.ac_code;
model.NamaBiayaInap = ac_mstr_BiayaInap.ac_name;
}
if (dbitem.IdKasbonDriver.HasValue)
{
ac_mstr ac_mstr_KasbonDriver = Repoac_mstr.FindByPk(dbitem.IdKasbonDriver);
model.IdKasbonDriver = ac_mstr_KasbonDriver.id;
model.CodeKasbonDriver = ac_mstr_KasbonDriver.ac_code;
model.NamaKasbonDriver = ac_mstr_KasbonDriver.ac_name;
}
if (dbitem.IdVoucherKapal.HasValue)
{
ac_mstr ac_mstr_VoucherKapal = Repoac_mstr.FindByPk(dbitem.IdVoucherKapal);
model.IdVoucherKapal = ac_mstr_VoucherKapal.id;
model.CodeVoucherKapal = ac_mstr_VoucherKapal.ac_code;
model.NamaVoucherKapal = ac_mstr_VoucherKapal.ac_name;
}
if (dbitem.IdVoucherSolar.HasValue)
{
ac_mstr ac_mstr_VoucherSolar = Repoac_mstr.FindByPk(dbitem.IdVoucherSolar);
model.IdVoucherSolar = ac_mstr_VoucherSolar.id;
model.CodeVoucherSolar = ac_mstr_VoucherSolar.ac_code;
model.NamaVoucherSolar = ac_mstr_VoucherSolar.ac_name;
}
if (dbitem.IdBoronganDasar.HasValue)
{
ac_mstr ac_mstr_BoronganDasar = Repoac_mstr.FindByPk(dbitem.IdBoronganDasar);
model.IdBoronganDasar = ac_mstr_BoronganDasar.id;
model.CodeBoronganDasar = ac_mstr_BoronganDasar.ac_code;
model.NamaBoronganDasar = ac_mstr_BoronganDasar.ac_name;
}
if (dbitem.IdKawalan.HasValue)
{
ac_mstr ac_mstr_kawalan = Repoac_mstr.FindByPk(dbitem.IdKawalan);
model.IdKawalan = ac_mstr_kawalan.id;
model.CodeKawalan = ac_mstr_kawalan.ac_code;
model.NamaKawalan = ac_mstr_kawalan.ac_name;
}
if (dbitem.IdTimbangan.HasValue)
{
ac_mstr ac_mstr_timbangan = Repoac_mstr.FindByPk(dbitem.IdTimbangan);
model.IdTimbangan = ac_mstr_timbangan.id;
model.CodeTimbangan = ac_mstr_timbangan.ac_code;
model.NamaTimbangan = ac_mstr_timbangan.ac_name;
}
if (dbitem.IdKarantina.HasValue)
{
ac_mstr ac_mstr_karantina = Repoac_mstr.FindByPk(dbitem.IdKarantina);
model.IdKaarantina = ac_mstr_karantina.id;
model.CodeKaarantina = ac_mstr_karantina.ac_code;
model.NamaKaarantina = ac_mstr_karantina.ac_name;
}
if (dbitem.IdSPSI.HasValue)
{
ac_mstr ac_mstr_spsi = Repoac_mstr.FindByPk(dbitem.IdSPSI);
model.IdSPSI = ac_mstr_spsi.id;
model.CodeSPSI = ac_mstr_spsi.ac_code;
model.NamaSPSI = ac_mstr_spsi.ac_name;
}
if (dbitem.IdMultidrop.HasValue)
{
ac_mstr ac_mstr_multidrop = Repoac_mstr.FindByPk(dbitem.IdMultidrop);
model.IdMultidrop = ac_mstr_multidrop.id;
model.CodeMultidrop = ac_mstr_multidrop.ac_code;
model.NamaMultidrop = ac_mstr_multidrop.ac_name;
}
if (dbitem.IdTambahanRuteMuat.HasValue)
{
ac_mstr ac_mstr_tambahan_rute_muat = Repoac_mstr.FindByPk(dbitem.IdTambahanRuteMuat);
model.IdRutemuat = ac_mstr_tambahan_rute_muat.id;
model.CodeRutemuat = ac_mstr_tambahan_rute_muat.ac_code;
model.NamaRutemuat = ac_mstr_tambahan_rute_muat.ac_name;
}
if (dbitem.IdTambahanRuteLain.HasValue)
{
ac_mstr ac_mstr_tambahan_rute_lain = Repoac_mstr.FindByPk(dbitem.IdTambahanRuteLain);
model.IdRuteLain = ac_mstr_tambahan_rute_lain.id;
model.CodeRuteLain = ac_mstr_tambahan_rute_lain.ac_code;
model.NamaRuteLain = ac_mstr_tambahan_rute_lain.ac_name;
}
if (dbitem.IdKasirCash.HasValue)
{
ac_mstr ac_mstr_kasir_cash = Repoac_mstr.FindByPk(dbitem.IdKasirCash);
model.IdOprCash = ac_mstr_kasir_cash.id;
model.CodeOprCash = ac_mstr_kasir_cash.ac_code;
model.NamaOprCash = ac_mstr_kasir_cash.ac_name;
}
if (dbitem.IdKasirTf.HasValue)
{
ac_mstr ac_mstr_kasir_tf = Repoac_mstr.FindByPk(dbitem.IdKasirTf);
model.IdOprTf = ac_mstr_kasir_tf.id;
model.CodeOprTf = ac_mstr_kasir_tf.ac_code;
model.NamaOprTf = ac_mstr_kasir_tf.ac_name;
}
//credit
if (dbitem.IdAUJCredit.HasValue)
{
ac_mstr ac_credit_auj = Repoac_mstr.FindByPk(dbitem.IdAUJCredit);
model.IdCreditAuj = ac_credit_auj.id;
model.CodeCreditAuj = ac_credit_auj.ac_code;
model.NamaCreditAuj = ac_credit_auj.ac_name;
}
if (dbitem.IdCashCredit.HasValue)
{
ac_mstr bk_credit_cash = Repoac_mstr.FindByPk(dbitem.IdCashCredit);
model.IdCreditCash = bk_credit_cash.id;
model.CodeCreditCash = bk_credit_cash.ac_code;
model.NamaCreditCash = bk_credit_cash.ac_name;
}
if (dbitem.IdTfCredit.HasValue)
{
ac_mstr bk_credit_tf = Repoac_mstr.FindByPk(dbitem.IdTfCredit);
model.IdCreditTf = bk_credit_tf.id;
model.CodeCreditTf = bk_credit_tf.ac_code;
model.NamaCreditTf = bk_credit_tf.ac_name;
}
if (dbitem.IdKasbonAuj.HasValue)
{
ac_mstr kasbon_auj = Repoac_mstr.FindByPk(dbitem.IdKasbonAuj);
model.IdKasbonAuj = kasbon_auj.id;
model.CodeKasbonAuj = kasbon_auj.ac_code;
model.NamaKasbonAuj = kasbon_auj.ac_name;
}
if (dbitem.IdKlaimAuj.HasValue)
{
ac_mstr klaim_auj = Repoac_mstr.FindByPk(dbitem.IdKlaimAuj);
model.IdKlaimAuj = klaim_auj.id;
model.CodeKlaimAuj = klaim_auj.ac_code;
model.NamaKlaimAuj = klaim_auj.ac_name;
}
if (dbitem.IdPotonganLainAuj.HasValue)
{
ac_mstr potongan_lain_auj = Repoac_mstr.FindByPk(dbitem.IdPotonganLainAuj);
model.IdPotonganLainAuj = potongan_lain_auj.id;
model.CodePotonganLainAuj = potongan_lain_auj.ac_code;
model.NamaPotonganLainAuj = potongan_lain_auj.ac_name;
}
if (dbitem.IdPiutangCustomer.HasValue)
{
ac_mstr piutangCustomer = Repoac_mstr.FindByPk(dbitem.IdPiutangCustomer);
model.IdPiutangCustomer = piutangCustomer.id;
model.CodePiutangCustomer = piutangCustomer.ac_code;
model.NamaPiutangCustomer = piutangCustomer.ac_name;
}
if (dbitem.IdBiayaKlaim.HasValue)
{
ac_mstr biayaKlaim = Repoac_mstr.FindByPk(dbitem.IdBiayaKlaim);
model.IdBiayaKlaim = biayaKlaim.id;
model.CodeBiayaKlaim = biayaKlaim.ac_code;
model.NamaBiayaKlaim = biayaKlaim.ac_name;
}
if (dbitem.IdKreditKlaim.HasValue)
{
ac_mstr kreditKlaim = Repoac_mstr.FindByPk(dbitem.IdKreditKlaim);
model.IdKreditKlaim = kreditKlaim.id;
model.CodeKreditKlaim = kreditKlaim.ac_code;
model.NamaKreditKlaim = kreditKlaim.ac_name;
}
if (dbitem.IdPiutangDagang.HasValue)
{
ac_mstr piutangBlmInv = Repoac_mstr.FindByPk(dbitem.IdPiutangDagang);
model.IdPiutangBlmInv = piutangBlmInv.id;
model.CodePiutangBlmInv = piutangBlmInv.ac_code;
model.NamaPiutangBlmInv = piutangBlmInv.ac_name;
}
if (dbitem.IdPendapatanUsahaBlmInv.HasValue)
{
ac_mstr penjualanBlmInv = Repoac_mstr.FindByPk(dbitem.IdPendapatanUsahaBlmInv);
model.IdPenjualanBlmInv = penjualanBlmInv.id;
model.CodePenjualanBlmInv = penjualanBlmInv.ac_code;
model.NamaPenjualanBlmInv = penjualanBlmInv.ac_name;
}
if (dbitem.IdPiutangDailySupir.HasValue)
{
ac_mstr piutangDailySupir = Repoac_mstr.FindByPk(dbitem.IdPiutangDailySupir);
model.IdPiutangDailySupir = piutangDailySupir.id;
model.CodePiutangDailySupir = piutangDailySupir.ac_code;
model.NamaPiutangDailySupir = piutangDailySupir.ac_name;
}
if (dbitem.IdKlaimSupir.HasValue)
{
ac_mstr klaimSupir = Repoac_mstr.FindByPk(dbitem.IdKlaimSupir);
model.IdKlaimSupir = klaimSupir.id;
model.CodeKlaimSupir = klaimSupir.ac_code;
model.NamaKlaimSupir = klaimSupir.ac_name;
}
}
return(View("Form", model));
}
