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();
}
}