public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EventJual rpt = new EventJual();
rpt.Site = this.Site;
return(rpt);
}
private void btnInsert_Click(object sender, EventArgs e)
{
MySqlTransaction trans = MainForm.c.BeginTransaction();
try
{
MainForm.adapterMgr.EVENT_PENJUALANTableAdapter.Transaction = trans;
MainForm.adapterMgr.EVENT_PENJUALAN_DETAILTableAdapter.Transaction = trans;
if (eprow == null)
{
eprow = dataep.NewEVENT_PENJUALANRow();
}
eprow.EVENT_ID = Convert.ToInt64(cbEvent.SelectedValue.ToString());
eprow.TOTAL = Convert.ToDecimal(data.Compute("SUM(SUBTOTAL)", ""));
eprow.EVENT_PENJUALAN_ID = MainForm.adapterMgr.EVENT_PENJUALANTableAdapter.autogen().ToString();
eprow.USER_ID = MainForm.peg.USER_ID;
eprow.PELANGGAN_ID = cbCustomer.SelectedValue.ToString();
dataep.AddEVENT_PENJUALANRow(eprow);
MainForm.adapterMgr.EVENT_PENJUALANTableAdapter.Update(dataep);
//trans.Commit();
foreach (FSRESTAURANT.EVENT_PENJUALAN_DETAILRow item in data)
{
item.EVENT_PENJUALAN_ID = eprow.EVENT_PENJUALAN_ID;
}
MainForm.adapterMgr.EVENT_PENJUALAN_DETAILTableAdapter.Update(data);
MessageBox.Show("insert sukses");
trans.Commit();
syncToDatabase();
Event.Report.EventJual p = new Report.EventJual();
Report.PrintPreview pp = new Report.PrintPreview(p, MainForm.FS);
pp.setParam("PENJUALAN_ID", eprow.EVENT_PENJUALAN_ID);
pp.setReport();
pp.ShowDialog();
reverseState();
}
catch (Exception ex)
{
trans.Rollback();
dataep.Clear();
MessageBox.Show(ex.Message);
}
finally
{
trans.Dispose();
}
}