private void btnMakeReport_Click(object sender, EventArgs e)
{
DTO_AmenityReport amenityReport = new DTO_AmenityReport(
tbFlightNumber.Text,
dtFrom.Value,
dtTo.Value
);
BUS_AmenityReport bus_amenityReport = new BUS_AmenityReport();
dataGridView1.DataSource = bus_amenityReport.GetAmenitiesReportTable(amenityReport);
}
public DataTable GetAmenitiesReportTable(DTO_AmenityReport amenityReport)
{
try
{
DataTable result = new DataTable();
DAL_Amenities dal_amenities = new DAL_Amenities();
DAL_CabinTypes dal_cabinTypes = new DAL_CabinTypes();
DataTable amenitiesTable = dal_amenities.GetAllAmenities();
DataTable cabinTypesTable = dal_cabinTypes.GetAllCabinTypesTable();
result.Columns.Add("Name");
foreach (DataRow dr in amenitiesTable.Rows)
{
result.Columns.Add(dr["Service"].ToString());
}
foreach (DataRow drCabin in cabinTypesTable.Rows)
{
DataRow newDr;
newDr = result.NewRow();
newDr["Name"] = drCabin["Name"].ToString();
foreach (DataRow drAmenity in amenitiesTable.Rows)
{
DataTable dt = this.GetReportByAmenityIDAndCabinID(
amenityReport.FlightNumber,
drAmenity["ID"].ToString(),
drCabin["ID"].ToString(),
amenityReport.From.ToString("yyyy/MM/dd"),
amenityReport.To.ToString("yyyy/MM/dd")
);
if (dt.Rows.Count > 0)
{
newDr[drAmenity["Service"].ToString()] = dt.Rows[0]["Total"].ToString();
}
else
{
newDr[drAmenity["Service"].ToString()] = 0;
}
}
result.Rows.Add(newDr);
}
return(result);
}
catch (Exception e)
{
return(null);
}
}
public DataTable GetAmenitiesReportTable(DTO_AmenityReport amenityReport)
{
return(dal_amenityReport.GetAmenitiesReportTable(amenityReport));
}
