public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRCheckout rpt = new CRCheckout();
rpt.Site = this.Site;
return(rpt);
}
private void btnBayar_Click(object sender, EventArgs e)
{
try
{
String query = $"Update H_Booking set TANGGAL_CHECK_OUT=to_Date('{DateTime.Now.ToLocalTime()}','dd/MM/yyyy hh24:mi:ss'),STATUS_BOOKING=2,TOTAL_HARGA={total} where ROW_ID_BOOKING={Login.id_booking}";
Login.db.executeNonQuery(query);
query = $"Select ROW_ID_KAMAR FROM D_BOOKING_KAMAR WHERE ROW_ID_BOOKING={Login.id_booking}";
DataTable dt = Login.db.executeDataTable(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
query = $"Update KAMAR SET STATUS_TERSEDIA=1 WHERE ROW_ID_KAMAR={dt.Rows[i]["ROW_ID_KAMAR"].ToString()}";
Login.db.executeNonQuery(query);
}
if (tbTambahan.Text != "" && tbKeterangan.Text != "")
{
query = $"Update H_Booking set KETERANGAN='{tbKeterangan.Text}',BIAYA_TAMBAHAN={Convert.ToInt32(tbTambahan.Text)} where ROW_ID_BOOKING='{Login.id_booking}'";
Login.db.executeNonQuery(query);
}
MessageBox.Show("Sukses melakukan proses checkout");
String query2 = "Select * from H_BOOKING H,TAMU T where ROW_ID_BOOKING=" + $"'{Login.id_booking}' AND H.ROW_ID_TAMU = T.ROW_ID_TAMU";
DataTable dt2 = Login.db.executeDataTable(query2);
CRCheckout rpt = new CRCheckout();
rpt.SetDatabaseLogon("proyekbisnis1", "proyekbisnis1", "orcl", "");
rpt.SetParameterValue(0, dt2.Rows[0]["KODE_BOOKING"].ToString());
Nota nota = new Nota();
nota.crystalReportViewer1.ReportSource = rpt;
nota.ShowDialog();
Login.booking.loadDGV();
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show("Terdapat nilai yang tidak valid, harap inputkan data lagi");
}
}
