public static bool insert(Models.surat_jalan data)
{
bool result = false;
try
{
using (var db = new Models.jotunContext())
{
db.Entry(data).State = 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 (cbo_no_po.EditValue == null)
{
Helpers.Generic.MsgEx("No. PO tidak boleh kosong");
return;
}
var data = new Models.surat_jalan()
{
no_surat_jalan = txt_no_sj.EditValue.ToString(),
no_po = cbo_no_po.EditValue.ToString(),
kd_customer = txt_kd_customer.EditValue.ToString(),
tgl = Convert.ToDateTime(dtp_tgl_sj.EditValue),
total_ukuran = Convert.ToDouble(txt_sub_total.EditValue),
po_pr = txt_po_pr.EditValue.ToString()
};
for (int i = 0; i < gridView1.RowCount; i++)
{
var detail = new Models.detail_surat_jalan()
{
no_surat_jalan = txt_no_sj.EditValue.ToString(),
kd_barang = gridView1.GetRowCellValue(i, "kd_barang").ToString(),
qty = Convert.ToInt32(gridView1.GetRowCellValue(i, "qty")),
ukuran = Convert.ToDouble(gridView1.GetRowCellValue(i, "barang.ukuran")),
total_ukuran = Convert.ToDouble(gridView1.GetRowCellValue(i, "liter"))
};
data.detail_surat_jalans.Add(detail);
}
if (Controllers.Penjualan.CSuratJalan.insert(data))
{
Helpers.Generic.MsgInfo("Surat jalan berhasil disimpan");
if (Helpers.Generic.MsgQuestion("Cetak surat jalan ?") == DialogResult.Yes)
{
this.cetak();
}
}
this.init();
}
