private void FrmAllReturnedCars_Load(object sender, EventArgs e)
{
try
{
OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\DbCarRental.accdb;Persist Security Info=True");
//OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Project 2016\ComputerizedCarRentalSystem\ComputerizedCarRentalSystem\DbCarRental.accdb;Persist Security Info=True");
OleDbDataAdapter adapter;
DataSet ds = new DataSet();
if (userType == "Customer")
{
adapter = new OleDbDataAdapter("select a.CarRegId, a.CustomerId, b.CarType, b.CarModel, a.TotalCarRentageCost, a.BookingDate, a.ReturnDate from tblBooking a, tblCar b WHERE (a.CarRegId = b.CarRegId) AND (a.BookingStatus = 0) AND (a.CustomerId = '" + userName + "')", cn);
adapter.Fill(ds, "TblReturnedCar");
}
else
{
adapter = new OleDbDataAdapter("select a.CarRegId, a.CustomerId, b.CarType, b.CarModel, a.TotalCarRentageCost, a.BookingDate, a.ReturnDate from tblBooking a, tblCar b WHERE (a.CarRegId = b.CarRegId) AND (a.BookingStatus = 0)", cn);
adapter.Fill(ds, "TblReturnedCar");
}
CrystalReportAllReturnedCars rpt = new CrystalReportAllReturnedCars();
rpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rpt;
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportAllReturnedCars rpt = new CrystalReportAllReturnedCars();
rpt.Site = this.Site;
return(rpt);
}
