protected async void AddAirline_Click(object sender, EventArgs e)
{
// to make sure the fields are not empty
if (!string.IsNullOrWhiteSpace(AirlineCodeTextBox.Text) && !string.IsNullOrWhiteSpace(AirlineNameTextBox.Text))
{
Airline airline = new Airline()
{
Code = AirlineCodeTextBox.Text,
Name = AirlineNameTextBox.Text
};
await dbHelper.AddAirline(airline);
AddAirlineResult.Text = "Added";
AirlineCodeTextBox.Text = string.Empty;
AirlineNameTextBox.Text = string.Empty;
//to update the dropdownlists
ddlAirlines.DataBind();
sdcAirlines.DataBind();
ddlRouteCarrier.DataBind();
RoutesdcAirlines.DataBind();
}
else
{
AddAirlineResult.Text = "Make sure to fill the fields!";
}
}
protected async void AddRoute_Click(object sender, EventArgs e)
{
// Checking fields not empty
if (!string.IsNullOrWhiteSpace(RouteFlightNrTextBox.Text) && !string.IsNullOrWhiteSpace(ddlRouteCarrier.SelectedItem.Text) &&
!string.IsNullOrWhiteSpace(ddlRouteArrCode.SelectedItem.Text) && !string.IsNullOrWhiteSpace(ddlRouteDepCode.SelectedItem.Text))
{
Route route = new Route()
{
FlightNumber = RouteFlightNrTextBox.Text,
Carrier = ddlRouteCarrier.SelectedItem.Text,
Departure = ddlRouteDepCode.SelectedItem.Text,
Arrival = ddlRouteArrCode.SelectedItem.Text
};
await dbHelper.AddRoute(route);
AddRouteResults.Text = "Added";
RouteFlightNrTextBox.Text = string.Empty;
ddlRouteCarrier.SelectedItem.Text = string.Empty;
sdcRoutes.DataBind();
ddlRoutes.DataBind();
ddlRouteDepCode.DataBind();
ddlRouteArrCode.DataBind();
RoutesdcAirports.DataBind();
ddlRouteCarrier.DataBind();
RoutesdcAirlines.DataBind();
}
else
{
AddRouteResults.Text = "Make sure to fill the fields!";
}
}
// to edit the values of the route.
// PK cannot be changed.
//FKs can be changed to different ones from the exiting FKs but you cannot edit it.
protected async void EditRoute_Click(object sender, EventArgs e)
{
// to make sure the fields are not empty and that the arrival and departure are not the same
if (!string.IsNullOrWhiteSpace(ddlRouteCarrier.SelectedItem.Text) &&
!string.IsNullOrWhiteSpace(ddlRouteArrCode.SelectedItem.Text) &&
!string.IsNullOrWhiteSpace(ddlRouteDepCode.SelectedItem.Text) &&
(ddlRouteArrCode.SelectedItem.Text != ddlRouteDepCode.SelectedItem.Text))
{
Route route = new Route()
{
FlightNumber = RouteFlightNrTextBox.Text,
Carrier = ddlRouteCarrier.SelectedItem.Text,
Departure = ddlRouteDepCode.SelectedItem.Text,
Arrival = ddlRouteArrCode.SelectedItem.Text
};
await dbHelper.UpdateRoute(route);
AddRouteResults.Text = "Updated";
RouteFlightNrTextBox.Text = string.Empty;
ddlRouteCarrier.SelectedItem.Text = string.Empty;
RouteFlightNrTextBox.Enabled = true;
EditRouteButton.Enabled = false;
//to update the dropdownlists
ddlRouteDepCode.DataBind();
ddlRouteArrCode.DataBind();
RoutesdcAirports.DataBind();
ddlRouteCarrier.DataBind();
RoutesdcAirlines.DataBind();
}
else
{
AddRouteResults.Text = "Make sure to fill the fields!";
}
}
