private void btnConfirmFlight_Click(object sender, EventArgs e)
{
if (dgv.CurrentCell == null)
{
return;
}
schedule = schedules.ElementAt(dgv.CurrentCell.RowIndex);
SchedulesDTO schedulesDTO = new SchedulesDTO();
if (schedule.Confirmed == 1)
{
schedulesDTO.Confirmed = 0;
btnConfirmlFlight.Text = "Confirm Flight";
}
else
{
schedulesDTO.Confirmed = 1;
btnConfirmlFlight.Text = "Cancel Flight";
}
schedulesDTO.ScheduleID = schedule.SchedulesID;
schedulesBUL.updateConfirmed(schedulesDTO);
schedules = schedulesBUL.getList();
this.loadData();
}
private void btnApply_Click(object sender, EventArgs e)
{
RoutesDTO route = new RoutesDTO();
ScheduleManagersDTO scheduleManager = new ScheduleManagersDTO();
string order;
route.ArrivalAirportID = cbbFrom.SelectedValue.ToString();
route.DepartureAirportID = cbbTo.SelectedValue.ToString();
if (cbbSortBy.SelectedItem.ToString() == "Price")
{
order = "EconomyPrice";
}
else if (cbbSortBy.SelectedItem.ToString() == "Confirmed")
{
order = "Confirmed";
}
else
{
order = "DateFlight";
}
dtpOutbound.CustomFormat = "dd/MM/yyyy";
scheduleManager.Date = dtpOutbound.Value;
scheduleManager.FlightNumber = txtFlightNumber.Text;
if (cbbFrom.SelectedValue.Equals(cbbTo.SelectedValue))
{
MessageBox.Show("Sân bay đi và Sân bay đến không được trùng nhau");
}
else
{
schedules = schedulesBUL.search(scheduleManager, route, order);
this.loadData();
}
}
public List <ScheduleManagersDTO> getList() // Trả về 1 ds Schedule
{
// Tạo 1 biến danh sách ScheduleManagers để lưu trữ
List <ScheduleManagersDTO> schedules = new List <ScheduleManagersDTO>();
try
{
conn.Open();
string sql = "select DateFlight, TimeFlight, fromAirport.IATAcode as frmAirIATACode, " +
"toAirport.IATAcode as toAirIATACode, FlightNumber, Aircrafts.AircraftID, " +
"EconomyPrice, Confirmed, Routes.RouteID, AircraftName, SchedulesID from Schedules " +
"join Routes on Schedules.RouteID=Routes.RouteID " +
"join Airports as fromAirport on Routes.ArrivalAirportID=fromAirport.AirportID " +
"join Airports as toAirport on Routes.DepartureAirportID=toAirport.AirportID " +
"join Aircrafts on Schedules.AircraftID=Aircrafts.AircraftID";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
float economyPrice = float.Parse(dr["EconomyPrice"].ToString().Trim());
float bussinessPrice = economyPrice * 35 / 100 + economyPrice;
float firstClassPrice = bussinessPrice * 30 / 100 + bussinessPrice;
ScheduleManagersDTO schedule = new ScheduleManagersDTO();
schedule.Date = DateTime.Parse(dr["DateFlight"].ToString().Trim());
schedule.Time = DateTime.Parse(dr["TimeFlight"].ToString().Trim());
schedule.From = dr["frmAirIATACode"].ToString().Trim();
schedule.To = dr["toAirIATACode"].ToString().Trim();
schedule.FlightNumber = dr["FlightNumber"].ToString().Trim();
schedule.AircraftID = dr["AircraftID"].ToString().Trim();
schedule.EconomyPrice = economyPrice;
schedule.BusinessPrice = bussinessPrice;
schedule.FirstClassPrice = firstClassPrice;
schedule.Confirmed = int.Parse(dr["Confirmed"].ToString().Trim());
schedule.RoutesID = dr["RouteID"].ToString().Trim();
schedule.AircraftName = dr["AircraftName"].ToString().Trim();
schedule.SchedulesID = dr["SchedulesID"].ToString().Trim();
schedules.Add(schedule);
}
conn.Close();
}
catch (Exception ex)
{
conn.Close();
MessageBox.Show(ex.Message);
return(null);
}
return(schedules);
}
private void btnEditFlight_Click(object sender, EventArgs e)
{
schedule = schedules.ElementAt(dgv.CurrentCell.RowIndex);
frmScheduleEdit frmEdit = new frmScheduleEdit();
if (schedule.Confirmed == 1)
{
frmEdit.ShowDialog();
this.Hide();
}
else
{
MessageBox.Show("Chuyến bay nay đã bị hủy, vui lòng chọn 'Confirm Flight'");
}
}
public frmScheduleEdit()
{
InitializeComponent();
this.scheduleManager = frmMain.schedule;
}
public List <ScheduleManagersDTO> search(ScheduleManagersDTO scheduleManager,
RoutesDTO route, string order)
{
return(schedulesDAL.search(scheduleManager, route, order));
}
public List <ScheduleManagersDTO> search(ScheduleManagersDTO scheduleManager,
RoutesDTO route, string order)
{
// Tạo 1 biến danh sách ScheduleManagers để lưu trữ
List <ScheduleManagersDTO> schedules = new List <ScheduleManagersDTO>();
try
{
conn.Open();
string sql = "select DateFlight, TimeFlight, fromAirport.IATAcode as frmAirIATACode, " +
"toAirport.IATAcode as toAirIATACode, FlightNumber, Aircrafts.AircraftID, " +
"EconomyPrice, Confirmed, Routes.RouteID, AircraftName, SchedulesID from Schedules " +
"join Routes on Schedules.RouteID=Routes.RouteID " +
"join Airports as fromAirport on Routes.ArrivalAirportID=fromAirport.AirportID " +
"join Airports as toAirport on Routes.DepartureAirportID=toAirport.AirportID " +
"join Aircrafts on Schedules.AircraftID=Aircrafts.AircraftID " +
"where Routes.ArrivalAirportID = @arrivalID " +
"OR Routes.DepartureAirportID = @departureID " +
"OR DateFlight = @outbound " +
"OR FlightNumber = @flightNumber " +
"ORDER BY " + order + " DESC";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("arrivalID", route.ArrivalAirportID);
cmd.Parameters.AddWithValue("departureID", route.DepartureAirportID);
cmd.Parameters.AddWithValue("outbound", scheduleManager.Date.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("flightNumber", scheduleManager.FlightNumber);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
float economyPrice = float.Parse(dr["EconomyPrice"].ToString().Trim());
float bussinessPrice = economyPrice * 35 / 100 + economyPrice;
float firstClassPrice = bussinessPrice * 30 / 100 + bussinessPrice;
ScheduleManagersDTO schedule = new ScheduleManagersDTO();
schedule.Date = DateTime.Parse(dr["DateFlight"].ToString().Trim());
schedule.Time = DateTime.Parse(dr["TimeFlight"].ToString().Trim());
schedule.From = dr["frmAirIATACode"].ToString().Trim();
schedule.To = dr["toAirIATACode"].ToString().Trim();
schedule.FlightNumber = dr["FlightNumber"].ToString().Trim();
schedule.AircraftID = dr["AircraftID"].ToString().Trim();
schedule.EconomyPrice = economyPrice;
schedule.BusinessPrice = bussinessPrice;
schedule.FirstClassPrice = firstClassPrice;
schedule.Confirmed = int.Parse(dr["Confirmed"].ToString().Trim());
schedule.RoutesID = dr["RouteID"].ToString().Trim();
schedule.AircraftName = dr["AircraftName"].ToString().Trim();
schedule.SchedulesID = dr["SchedulesID"].ToString().Trim();
schedules.Add(schedule);
}
conn.Close();
}
catch (Exception ex)
{
conn.Close();
MessageBox.Show(ex.Message);
return(null);
}
return(schedules);
}
