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