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!"; } }