private void btn_pembayaran_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (cbo_no_faktur.EditValue == null)
{
Helpers.Generic.MsgEx("Data Penjualan tidak boleh kosong");
return;
}
if (Convert.ToInt32(txt_kembali.EditValue) < 0)
{
Helpers.Generic.MsgEx("Uang yang dibayarkan belum cukup");
return;
}
var main = (MainMenu)this.MdiParent;
var data = new Models.pembayaran()
{
no_faktur = cbo_no_faktur.EditValue.ToString(),
tgl = Convert.ToDateTime(dtp_tgl.EditValue),
kd_karyawan = main.kd_karyawan,
total_bayar = Convert.ToInt32(txt_total_bayar.EditValue),
dibayar = Convert.ToInt32(txt_dibayar.EditValue),
kembali = Convert.ToInt32(txt_kembali.EditValue)
};
if (Controllers.CPembayaran.insert(data))
{
Helpers.Generic.MsgInfo("Data Pembayaran berhasil disimpan");
var frm = new Laporan.FrmCetak()
{
no_faktur = cbo_no_faktur.EditValue.ToString()
};
Helpers.Generic.ShowAdd(this, frm);
this.init();
}
}
public static bool insert(Models.pembayaran data)
{
bool result = false;
try
{
using (var db = new Models.sim_penjualanContext())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
List <Models.detail_penjualan> detail = db.detail_penjualan.Where(t => t.no_faktur == data.no_faktur).ToList();
foreach (var dt in detail)
{
var barang = db.barangs.Where(t => t.kd_barang == dt.kd_barang).Single();
barang.stok -= dt.jumlah;
db.Entry(barang).State = EntityState.Modified;
}
db.Entry(data).State = EntityState.Added;
db.SaveChanges();
result = true;
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
