private void btnTampil_Click(object sender, EventArgs e)
{
LaporanLabaRugi rprtTransaksi = new LaporanLabaRugi();
try
{
rprtTransaksi.SetDatabaseLogon("probis", "probis");
}
catch (Exception)
{
throw;
}
if (dtAwal.Value > dtAkhir.Value)
{
MessageBox.Show("Tanggal Awal Harus Lebih Kecil Dari Tanggal Akhir");
}
else
{
CultureInfo culture = new CultureInfo("USA");
string dtawal = dtAwal.Value.ToString("dd MMM yyyy", culture);
string dtakhir = dtAkhir.Value.ToString("dd MMM yyyy", culture);
OracleCommand query = new OracleCommand();
query.Connection = conn;
OracleDataAdapter adapter = new OracleDataAdapter(query);
DataSet dataset = new DataSet();
query.CommandText = "SELECT * FROM CUSTOMER";
adapter.Fill(dataset, "CUSTOMER");
query.CommandText = "SELECT * FROM DHOTEL";
adapter.Fill(dataset, "DHOTEL");
query.CommandText = "SELECT * FROM DPAKET";
adapter.Fill(dataset, "DPAKET");
query.CommandText = "SELECT * FROM DTRANS";
adapter.Fill(dataset, "DTRANS");
query.CommandText = "SELECT * FROM FLIGHT";
adapter.Fill(dataset, "FLIGHT");
query.CommandText = "SELECT * FROM HOTEL";
adapter.Fill(dataset, "HOTEL");
//query.CommandText = "SELECT * FROM HTRANS where TRANS_DATE>TO_DATE('"+dtawal+ "','dd mm yyyy') and TRANS_DATE<TO_DATE('" + dtakhir + "','dd mm yyyy') ; ";
query.CommandText = "SELECT * FROM HTRANS where TRANS_DATE BETWEEN '" + dtawal + "' AND '" + dtakhir + "' ";
adapter.Fill(dataset, "HTRANS");
query.CommandText = "SELECT * FROM MASKAPAI";
adapter.Fill(dataset, "MASKAPAI");
query.CommandText = "SELECT * FROM PAKET_TOUR";
adapter.Fill(dataset, "PAKET_TOUR");
query.CommandText = "SELECT * FROM PEGAWAI";
adapter.Fill(dataset, "PEGAWAI");
query.CommandText = "SELECT * FROM TRAINS";
adapter.Fill(dataset, "TRAINS");
rprtTransaksi.SetDataSource(dataset);
rprtTransaksi.SetParameterValue("tanggal_awal", dtAwal.Value);
rprtTransaksi.SetParameterValue("tanggal_akhir", dtAkhir.Value);
crystalReportViewer1.ReportSource = rprtTransaksi;
}
}