protected void btnSave_Click(object sender, EventArgs e) { string fullName = txtName.Text; int age = int.Parse(txtAge.Text); bool gender = bool.Parse(ddlGender.SelectedValue); int tel = int.Parse(txtTel.Text); string email = txtEmail.Text; string street = txtStreet.Text; string city = txtCity.Text; using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var passenger = new Passenger() { FullName = fullName, Gender = gender, Tel = tel, Age = age, Email = email, Location_City = city, Street = street }; db.Passengers.Add(passenger); db.SaveChanges(); Response.Redirect("~/Pages/ListPassenger.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int id = int.Parse(ViewState["Id"].ToString()); string fullName = txtName.Text; int age = int.Parse(txtAge.Text); bool gender = bool.Parse(ddlGender.SelectedValue); int tel = int.Parse(txtTel.Text); string email = txtEmail.Text; string street = txtStreet.Text; string city = txtCity.Text; using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var passenger = db.Passengers.Find(id); if (passenger != null) { passenger.FullName = fullName; passenger.Age = age; passenger.Email = email; passenger.Gender = gender; passenger.Tel = tel; passenger.Street = street; passenger.Location_City = city; db.SaveChanges(); } Response.Redirect("~/Pages/ListPassenger.aspx"); } }
protected void btnContinue_Click(object sender, EventArgs e) { int ticket_id = int.Parse((String)Session["ticket_id"]); Passenger p = (Passenger)Session["passenger"]; using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { User user = db.Users.Find(Session["username"]); Ticket ticket = db.Tickets.Find(ticket_id); if (user.Wallet < ticket.Price) { lblWarn.Visible = true; return; } db.Passengers.Add(p); db.SaveChanges(); var passenger_ID = (from pa in db.Passengers select pa).ToList().LastOrDefault().PassengerID; //var passenger_id = from passenger in db.Passengers orderby passenger.PassengerID descending select passenger.; db.Bookings.Add(new Booking() { Ticket_ID = ticket_id, Passenger_ID = passenger_ID, Booking_Date = System.DateTime.Now }); db.SaveChanges(); var booking_ID = (from pa in db.Bookings select pa).ToList().LastOrDefault().Booking_ID; db.Payments.Add(new Payment() { Booking_ID = booking_ID, Payment_Amount = ticket.Price, Username = Session["username"].ToString(), Payment_Date = System.DateTime.Now }); db.SaveChanges(); Response.Redirect("~/Page/MyBooking.aspx"); } }
protected void btnUpdate_Click(object sender, EventArgs e) { int id = int.Parse(ViewState["Id"].ToString()); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var airplane = db.Airplanes.Find(id); if (airplane != null) { airplane.Producer_ID = drpProducer.SelectedValue; airplane.Seat_Numbers = int.Parse(txtSeatNumbers.Text); db.SaveChanges(); } Response.Redirect("~/Pages/ListAirplane.aspx"); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { string id = e.CommandArgument.ToString(); using (var db = new AirlineTicketBookingDBContext()) { var producer = new Producer() { Producer_ID = id }; db.Producers.Attach(producer); db.Producers.Remove(producer); db.SaveChanges(); Response.Redirect("~/Pages/ListProducer.aspx"); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { int id = int.Parse(e.CommandArgument.ToString()); using (var db = new AirlineTicketBookingDBContext()) { var route = new Route() { Route_ID = id }; db.Routes.Attach(route); db.Routes.Remove(route); db.SaveChanges(); Response.Redirect("~/Pages/ListRoute.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { string id = ViewState["Id"].ToString(); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var user = db.Users.Find(id); if (user != null) { user.Password = txtPassword.Text; user.Wallet = int.Parse(txtWaller.Text); db.SaveChanges(); } Response.Redirect("~/Pages/ListUser.aspx"); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { int id = Int32.Parse(e.CommandArgument.ToString()); using (var db = new AirlineTicketBookingDBContext()) { var ticket = new Ticket() { Ticket_ID = id }; db.Tickets.Attach(ticket); db.Tickets.Remove(ticket); db.SaveChanges(); Response.Redirect("~/Pages/ListTicket.aspx"); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { int id = Int32.Parse(e.CommandArgument.ToString()); using (var db = new AirlineTicketBookingDBContext()) { var passenger = new Passenger() { PassengerID = id }; db.Passengers.Attach(passenger); db.Passengers.Remove(passenger); db.SaveChanges(); Response.Redirect("~/Pages/ListPassenger.aspx"); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { int id = (int)e.CommandArgument; using (var db = new AirlineTicketBookingDBContext()) { var airport = new Airport() { Airport_ID = id }; db.Airports.Attach(airport); db.Airports.Remove(airport); db.SaveChanges(); Response.Redirect("~/Pages/ListAirport.aspx"); } }
protected void btnUpdate_Click(object sender, EventArgs e) { int id = Int32.Parse(ViewState["Id"].ToString()); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var travelclass = db.TravelClasses.Find(id); if (travelclass != null) { travelclass.Name = txtName.Text; travelclass.Description = txtDescription.Text; db.SaveChanges(); } Response.Redirect("~/Pages/ListTravelClass.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int id = int.Parse(ViewState["Id"].ToString()); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var airport = db.Airports.Find(id); if (airport != null) { airport.Airport_Name = txtName.Text; airport.Location_City = ddlLocation.SelectedValue; db.SaveChanges(); } Response.Redirect("~/Pages/ListAirport.aspx"); } }
protected void btnUpdate_Click(object sender, EventArgs e) { string id = ViewState["Id"].ToString(); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var producer = db.Producers.Find(id); if (producer != null) { producer.Producer_Name = txtProducerName.Text; producer.Icon = txtIcon.Text; producer.Description = txtDescription.Text; db.SaveChanges(); } Response.Redirect("~/Pages/ListProducer.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int id = int.Parse(ViewState["Id"].ToString()); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var route = db.Routes.Find(id); if (route != null) { route.Origin_Airport = int.Parse(ddlOriginAirport.SelectedValue); route.Destination_Airport = int.Parse(ddlDestinationAirport.SelectedValue); route.Distance = int.Parse(txtDistance.Text); db.SaveChanges(); } Response.Redirect("~/Pages/ListRoute.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { string name = txtName.Text; string description = txtDescription.Text; using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var travelclass = new TravelClass() { Name = name, Description = description }; db.TravelClasses.Add(travelclass); db.SaveChanges(); Response.Redirect("~/Pages/ListTravelClass.aspx"); } }
protected void btnUpdate_Click(object sender, EventArgs e) { int id = int.Parse(ViewState["Id"].ToString()); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var flight = db.Flights.Find(id); if (flight != null) { flight.Departure_DateTime = DateTime.Parse(txtDeparture_DateTime.Text); flight.Arrival_DateTime = DateTime.Parse(txtArrival_DateTime.Text); flight.Route_ID = int.Parse(drpRoute.SelectedValue); flight.Airplane_ID = int.Parse(drpAirplane.SelectedValue); db.SaveChanges(); } Response.Redirect("~/Pages/ListFlight.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { string producer_ID = drpProducer.SelectedValue; int seat_Numbers = int.Parse(txtSeatNumbers.Text); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { //var producer = db.Producers.Find(producer_ID); var airplane = new Airplane() { Producer_ID = producer_ID, Seat_Numbers = seat_Numbers }; db.Airplanes.Add(airplane); db.SaveChanges(); Response.Redirect("~/Pages/ListAirplane.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { var city = txtCity.Text; var province = txtProvince.Text; var country = txtCountry.Text; using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var location = new Location() { City = city, State_Province = province, Country = country }; db.Locations.Add(location); db.SaveChanges(); } Response.Redirect("~/Pages/ListLocation.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int airplane_ID = int.Parse(drpAirplanes.SelectedValue); int seat_No = int.Parse(txtSeatNo.Text); int travel_Class_ID = int.Parse(drpTravelClasses.SelectedValue); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var airplaneSeat = new AirplaneSeat() { Airplane_ID = airplane_ID, Seat_No = seat_No, Travel_Class_ID = travel_Class_ID }; db.AirplaneSeats.Add(airplaneSeat); db.SaveChanges(); Response.Redirect("~/Pages/ListAirplaneSeats.aspx"); } }
protected void btnUpdate_Click(object sender, EventArgs e) { String id = ViewState["Id"].ToString(); String[] param = id.Split(','); int airplane_ID = int.Parse(param[0]); int seat_No = int.Parse(param[1]); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var airplaneSeat = db.AirplaneSeats.Find(airplane_ID, seat_No); if (airplaneSeat != null) { airplaneSeat.Travel_Class_ID = int.Parse(drpTravelClasses.SelectedValue); db.SaveChanges(); } Response.Redirect("~/Pages/ListAirplaneSeats.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int airport_ID = int.Parse(txtID.Text); string airport_Name = txtName.Text; string location = ddlLocation.SelectedItem.ToString(); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var airport = new Airport() { Airport_ID = airport_ID, Airport_Name = airport_Name, Location_City = location }; db.Airports.Add(airport); db.SaveChanges(); Response.Redirect("~/Pages/ListAirport.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int origin_Airport = int.Parse(ddlOriginAirport.SelectedValue); int destination_Airport = int.Parse(ddlDestinationAirport.SelectedValue); int distance = int.Parse(txtDistance.Text); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var route = new Route() { Origin_Airport = origin_Airport, Destination_Airport = destination_Airport, Distance = distance }; db.Routes.Add(route); db.SaveChanges(); Response.Redirect("~/Pages/ListRoute.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { string username = txtUsername.Text; string password = txtPassword.Text; double wallet = double.Parse(txtWallet.Text); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var user = new User() { Username = username, Password = password, Wallet = wallet }; db.Users.Add(user); db.SaveChanges(); Response.Redirect("~/Pages/ListUser.aspx"); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { String id = e.CommandArgument.ToString(); String[] param = id.Split(','); int airplane_ID = int.Parse(param[0]); int seat_No = int.Parse(param[1]); using (var db = new AirlineTicketBookingDBContext()) { var airplaneSeat = new AirplaneSeat() { Airplane_ID = airplane_ID, Seat_No = seat_No }; db.AirplaneSeats.Attach(airplaneSeat); db.AirplaneSeats.Remove(airplaneSeat); db.SaveChanges(); Response.Redirect("~/Pages/ListAirplaneSeats.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { int flight_No = int.Parse(drpFlightNo.SelectedValue); int seat_No = int.Parse(drpSeatNo.SelectedValue); int airplane_ID = int.Parse(txtAirplaneID.Text); int price = int.Parse(txtPrice.Text); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var ticket = new Ticket() { Flight_No = flight_No, Seat_No = seat_No, Airplane_ID = airplane_ID, Price = price, }; db.Tickets.Add(ticket); db.SaveChanges(); Response.Redirect("~/Pages/ListTicket.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { string producer_ID = txtProducerID.Text; string producer_Name = txtProducerName.Text; string icon = txtIcon.Text; string description = txtDescription.Text; using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var producer = new Producer() { Producer_ID = producer_ID, Producer_Name = producer_Name, Icon = icon, Description = description }; db.Producers.Add(producer); db.SaveChanges(); Response.Redirect("~/Pages/ListProducer.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { DateTime departure_DateTime = DateTime.Parse(txtDeparture_DateTime.Text); DateTime arrival_DateTime = DateTime.Parse(txtArrival_DateTime.Text); int route_ID = int.Parse(drpRoute.SelectedValue); int airplane_ID = int.Parse(drpAirplane.SelectedValue); using (AirlineTicketBookingDBContext db = new AirlineTicketBookingDBContext()) { var flight = new Flight() { Departure_DateTime = departure_DateTime, Arrival_DateTime = arrival_DateTime, Route_ID = route_ID, Airplane_ID = airplane_ID }; db.Flights.Add(flight); db.SaveChanges(); Response.Redirect("~/Pages/ListFlight.aspx"); } }
protected void add_Click(object sender, EventArgs e) { using (var db = new AirlineTicketBookingDBContext()) { var query = from d in db.Cards where d.Code == TextBox1.Text select d; User user = db.Users.Find((String)Session["username"]); List <Card> cards = query.ToList(); if (cards.Count == 1 && cards[0].Status == false) { lblInfo.ForeColor = System.Drawing.Color.Green; user.Wallet += cards[0].Value; Card card = db.Cards.Find(cards[0].ID); card.Status = true; lblInfo.Text = "Your fund has been added, your balance is : " + user.Wallet; } else { lblInfo.ForeColor = System.Drawing.Color.Red; lblInfo.Text = "Card is not exist or has been used by another user"; } db.SaveChanges(); } }