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"); } }