protected async void AddAirport_Click(object sender, EventArgs e)
{
// to make sure the fields are not empty
if (!string.IsNullOrWhiteSpace(AirportCodeTextBox.Text) && !string.IsNullOrWhiteSpace(AirportCityTextBox.Text) &&
!string.IsNullOrWhiteSpace(AirportLatitudeTextBox.Text) && !string.IsNullOrWhiteSpace(AirportLongitudeTextBox.Text))
{
//this will create an airport object
Airport airport = new Airport()
{
Code = AirportCodeTextBox.Text,
City = AirportCityTextBox.Text,
Latitude = double.Parse(AirportLatitudeTextBox.Text),
Longitude = double.Parse(AirportLongitudeTextBox.Text)
};
await dbHelper.AddAirport(airport);
AddAirportResult.Text = "Added";
AirportCodeTextBox.Text = string.Empty;
AirportCityTextBox.Text = string.Empty;
AirportLatitudeTextBox.Text = string.Empty;
AirportLongitudeTextBox.Text = string.Empty;
// to update the dropdownlists
ddlAirports.DataBind();
sdcAirports.DataBind();
ddlRouteDepCode.DataBind();
ddlRouteArrCode.DataBind();
RoutesdcAirports.DataBind();
}
else
{
AddAirportResult.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!";
}
}
