public Flight(int id) //creates flight using a reservation ID
{
try
{
this.resId = id;
this.planeName = DBPlanes.getName(DBReservations.getPlane(resId));
this.capacity = DBPlanes.getCapacity(DBReservations.getPlane(resId));
this.departureTime = DBReservations.getDate(resId);
this.destination = DBDestinations.getLocation(DBReservations.getDestination(resId));
this.travelDistance = DBDestinations.getDistanceFromLR(this.destination);
this.flightSpeed = DBPlanes.getSpeed(DBPlanes.getID(this.planeName));
this.passengerCount = 0;
this.travelTime = ((this.travelDistance * 2) / this.flightSpeed) + 1; //Travel time to and from destination with 1 extra hour for refuling and acceleration/deceleration;
List <string> flightResList = DBReservations.getReservationsByPlane(DBPlanes.getID(this.planeName));
foreach (String s in flightResList) // "Out of all the reservations made for the plane that this Flight belongs to..." -ksm
{
int resNum = Convert.ToInt32(s);
if (this.departureTime == DBReservations.getDate(resNum) && this.destination == DBDestinations.getLocation(DBReservations.getDestination(resNum)))
{
this.passengerCount++; //"... Add 1 passenger for each reservation that matches this flight." -ksm
}
}
this.seatsAvailable = this.capacity - this.passengerCount;
this.returnTime = this.departureTime;
TimeSpan time = TimeSpan.FromHours(travelTime);
this.returnTime = this.returnTime + time;
}
catch (Exception ex)
{
throw ex;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String jet = jetsDropDownList.SelectedValue;
String dest = destinationDropDownList.SelectedValue;
DateTime date = Calendar1.SelectedDate;
if (ampmDropDownList.SelectedValue == "PM")
{
int hours;
if (hourBox.Text == "12")
{
hours = Convert.ToInt32(hourBox.Text);
}
else
{
hours = Convert.ToInt32(hourBox.Text) + 12;
}
TimeSpan time = new TimeSpan(hours, Convert.ToInt32(minuteBox.Text), 0);
date = date.Date + time;
}
else
{
int hours;
if (hourBox.Text == "12")
{
hours = Convert.ToInt32(hourBox.Text) - 12;
}
else
{
hours = Convert.ToInt32(hourBox.Text);
}
TimeSpan time = new TimeSpan(hours, Convert.ToInt32(minuteBox.Text), 0);
date = date.Date + time;
}
DBReservations.RegisterReservation(DBPlanes.getID(jet), CookieHandler.getID(), DBDestinations.getID(dest), date);
//sets cookies for use in results page
CookieHandler.setCookie("jet", DBPlanes.getName(DBPlanes.getID(jet)));
CookieHandler.setCookie("dest", destinationDropDownList.SelectedValue);
CookieHandler.setCookie("date", date.ToString());
//change page to results
HttpContext.Current.Response.Redirect("Results.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
CookieHandler.checkLogin();
DBHandler.populateDataSet();
if (!IsPostBack)
{
// This is a login check that redirects to login page if there is no valid login cookie.
Dictionary <int, Plane> planes = new Dictionary <int, Plane>();
int count = 0;
foreach (string plane in DBPlanes.PlanesList())
{
Plane p = new Plane(DBPlanes.getID(plane)); //Create Plane object for each plane
planes[count] = p; //Populate planes Dictionary with Plane
planes[count].updatePlaneLocation(); //Updates planes location based on Plane Flight plan
count++;
}
Session["planes"] = planes;
}
}