public static bool insert(Models.penjualan data)
{
bool result = false;
try
{
using (var db = new Models.sim_penjualanContext())
{
db.Entry(data).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
private void btn_simpan_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.RowCount == 0)
{
Helpers.Generic.MsgEx("Detail barang tidak boleh kosong");
return;
}
var penjualan = new Models.penjualan()
{
no_faktur = txt_no_faktur.EditValue.ToString(),
kd_konsumen = cbo_kd_konsumen.EditValue.ToString(),
kd_karyawan = txt_kd_karyawan.EditValue.ToString(),
tgl = Convert.ToDateTime(dtp_tgl.EditValue),
total = Convert.ToInt32(txt_total_bayar.EditValue),
status = 0
};
for (int i = 0; i < gridView1.RowCount; i++)
{
var no_faktur = gridView1.GetRowCellValue(i, "nama").ToString();
if (no_faktur != "")
{
var detail = new Models.detail_penjualan()
{
no_faktur = txt_no_faktur.EditValue.ToString(),
kd_barang = gridView1.GetRowCellValue(i, "kd_barang").ToString(),
harga = Convert.ToInt32(gridView1.GetRowCellValue(i, "harga")),
jumlah = Convert.ToInt32(gridView1.GetRowCellValue(i, "jumlah_beli")),
total = Convert.ToInt32(gridView1.GetRowCellValue(i, "total"))
};
penjualan.detail_penjualans.Add(detail);
}
}
Controllers.CPenjualan.insert(penjualan);
Helpers.Generic.MsgInfo("Data penjualan berhasil disimpan");
this.init();
}
