//[Authorize]
public ActionResult AddJourney()
{
tblSchedule_HMS03_Team7 sch = db.tblSchedule_HMS03_Team7.Find(int.Parse(Session["ScheduleID"].ToString()));
tblJourney_HMS03_Team7 jr = new tblJourney_HMS03_Team7();
jr.ScheduleID = sch.ScheduleID;
jr.NoOfPassengers_Adult = int.Parse(Session["NOofADULT"].ToString());
jr.NoOfPassengers_Child = int.Parse((Session["NOofCHILD"]).ToString());
jr.BonusRequstStatus = Session["Class"].ToString(); //class premium
if (jr.BonusRequstStatus == "Premium")
{
decimal adultfare = Convert.ToDecimal(sch.Fare_Premium_Adult);
decimal childfare = Convert.ToDecimal(sch.Fare_Premium_Child);
jr.TotalBookingFare = (jr.NoOfPassengers_Adult * adultfare) + (jr.NoOfPassengers_Child * childfare);
}
else if (jr.BonusRequstStatus == "FirstClass")
{
decimal adultfare = Convert.ToDecimal(sch.Fare_Firstclass_Adult);
decimal childfare = Convert.ToDecimal(sch.Fare_Firstclass_Child);
jr.TotalBookingFare = (jr.NoOfPassengers_Adult * adultfare) + (jr.NoOfPassengers_Child * childfare);
}
else if (jr.BonusRequstStatus == "Economy")
{
decimal adultfare = Convert.ToDecimal(sch.Fare_Economy_Adult);
decimal childfare = Convert.ToDecimal(sch.Fare_Economy_Child);
jr.TotalBookingFare = (jr.NoOfPassengers_Adult * adultfare) + (jr.NoOfPassengers_Child * childfare);
}
jr.NoOfPassengers_Adult = int.Parse(Session["NOofADULT"].ToString());
jr.NoOfPassengers_Child = int.Parse((Session["NOofCHILD"]).ToString());
jr.PaymentStatus = "Pending";
jr.BookingDate = DateTime.Now;
db.tblJourney_HMS03_Team7.Add(jr);
db.SaveChanges();
Session["count"] = 1;
Session["jour"] = jr.JourneyID;
Session["TotalFare"] = jr.TotalBookingFare;
try
{
jr.CustomerID = int.Parse(Session["cid"].ToString());
db.SaveChanges();
}
catch
{
if (jr.CustomerID == null)
{
MessageBox.Show("You haven't Signed-In");
return(RedirectToAction("Log", "tblLogin_HMS03_Team7"));
}
}
return(RedirectToAction("Details", new { id = jr.JourneyID }));
}
public ActionResult Edit([Bind(Include = "ScheduleID,PlaneRegistrationID,Source,Destination,Departure,Arrival,Fare_Premium_Adult,Fare_Economy_Adult,Fare_Firstclass_Adult,Fare_Premium_Child,Fare_Firstclass_Child,Fare_Economy_Child,Availability_Premium,Availability_Firstclass,Availability_Economy,TravelDistance,StatusofFlight,BonusMiles,BonusMilesPoints")] tblSchedule_HMS03_Team7 tblSchedule_HMS03_Team7)
{
//if (tblSchedule_HMS03_Team7.Departure.Date.Equals(DateTime.Today.Date) && (tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay)).TotalHours < 4)
//{
// MessageBox.Show("you can't update flight!!sorry boss!!");
// return RedirectToAction("Index");
//}
if (ModelState.IsValid)
{
Session["s1"] = tblSchedule_HMS03_Team7.PlaneRegistrationID;
tblSchedule_HMS03_Team7.StatusofFlight = "Scheduled";
tblAeroplane_HMS03_Team7 airplane = db.tblAeroplane_HMS03_Team7.Find(tblSchedule_HMS03_Team7.PlaneRegistrationID);
tblSchedule_HMS03_Team7.Availability_Economy = airplane.Capacity_Economy;
tblSchedule_HMS03_Team7.Availability_Premium = airplane.Capacity_Premium;
tblSchedule_HMS03_Team7.Availability_Firstclass = airplane.Capacity_FirstClass;
db.Entry(tblSchedule_HMS03_Team7).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Flight Schedule edited successfully" + Session["s1"].ToString());
return(RedirectToAction("VeiwScheduleToScheduler"));
}
ViewBag.PlaneRegistrationID = new SelectList(db.tblAeroplane_HMS03_Team7, "PlaneRegistrationID", "AirplaneSeries", tblSchedule_HMS03_Team7.PlaneRegistrationID);
return(View(tblSchedule_HMS03_Team7));
}
public ActionResult DeleteConfirmed(int id)
{
tblSchedule_HMS03_Team7 tblSchedule_HMS03_Team7 = db.tblSchedule_HMS03_Team7.Find(id);
tblSchedule_HMS03_Team7.StatusofFlight = "Cancelled";
db.Entry(tblSchedule_HMS03_Team7).State = EntityState.Modified;
//db.tblSchedule_HMS03_Team7.Remove(tblSchedule_HMS03_Team7);
db.SaveChanges();
return(RedirectToAction("VeiwScheduleToScheduler"));
}
public ActionResult View(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSchedule_HMS03_Team7 tblSchedule_HMS03_Team7 = db.tblSchedule_HMS03_Team7.Find(id);
if (tblSchedule_HMS03_Team7 == null)
{
return(HttpNotFound());
}
return(View(tblSchedule_HMS03_Team7));
}
public ActionResult FareDetails(int?id)
{
Session["ScheduleID"] = id;
tblSchedule_HMS03_Team7 sch = db.tblSchedule_HMS03_Team7.Find(id);
if (sch == null)
{
return(HttpNotFound());
}
decimal?TotalBookingFare;
int ano = int.Parse(Session["NOofADULT"].ToString());
int cno = int.Parse(Session["NOofCHILD"].ToString());
string cl = Session["Class"].ToString();
if (cl == "Premium")
{
decimal?adultfare = sch.Fare_Premium_Adult;
decimal?childfare = sch.Fare_Premium_Child;
TotalBookingFare = (ano * adultfare) + (cno * childfare);
}
else if (cl == "FirstClass")
{
decimal?adultfare = sch.Fare_Firstclass_Adult;
decimal?childfare = sch.Fare_Firstclass_Child;
TotalBookingFare = (ano * adultfare) + (cno * childfare);
}
else if (cl == "Economy")
{
decimal?adultfare = sch.Fare_Economy_Adult;
decimal?childfare = sch.Fare_Economy_Child;
TotalBookingFare = (ano * adultfare) + (cno * childfare);
}
//
/*Session["TotalFare"] = 12345;*///int.Parse(Session["NOofADULT"].ToString()) * adultFare + int.Parse(Session["NOofCHILD"].ToString()) * childFare;
return(View(sch));
//var tblSchedule_HMS03_Team7 = db.tblSchedule_HMS03_Team7.Include(t => t.tblAeroplane_HMS03_Team7);
//return View(tblSchedule_HMS03_Team7.ToList());
}
public ActionResult changeseat()
{
if (ModelState.IsValid)
{
tblSchedule_HMS03_Team7 Sched = db.tblSchedule_HMS03_Team7.Find(int.Parse(Session["ScheduleID"].ToString()));
string CLASS = (string)Session["Class"].ToString();
int NoOfAdult = int.Parse((string)Session["NOofADULT"].ToString());
int NoOfChild = int.Parse((string)Session["NOofCHILD"].ToString());
if (CLASS == "Premium")
{
try {
int avail = Convert.ToInt16(Sched.Availability_Premium);
Sched.Availability_Premium = avail - (NoOfAdult + NoOfChild);
db.SaveChanges();
}
catch
{
}
}
else if (CLASS == "Firstclass")
{
Sched.Availability_Firstclass = Sched.Availability_Firstclass - (NoOfAdult + NoOfChild);
db.SaveChanges();
}
else if (CLASS == "Economy")
{
Sched.Availability_Economy = Sched.Availability_Economy - (NoOfAdult + NoOfChild);
db.SaveChanges();
}
db.Entry(Sched).State = EntityState.Modified;
return(RedirectToAction("ViewTicket", "tblPassenger_HMS03_Team7"));
}
return(View("CheckAvailability"));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSchedule_HMS03_Team7 tblSchedule_HMS03_Team7 = db.tblSchedule_HMS03_Team7.Find(id);
if (tblSchedule_HMS03_Team7 == null)
{
return(HttpNotFound());
}
if (tblSchedule_HMS03_Team7.Departure.Date.Equals(DateTime.Today.Date) && (tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay)).TotalHours < 4)
{
MessageBox.Show("Can't Cancel! Flight to depart in " + tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay).Hours + " : " + tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay).Minutes + " hours");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
return(View(tblSchedule_HMS03_Team7));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSchedule_HMS03_Team7 tblSchedule_HMS03_Team7 = db.tblSchedule_HMS03_Team7.Find(id);
if (tblSchedule_HMS03_Team7 == null)
{
return(HttpNotFound());
}
if (tblSchedule_HMS03_Team7.Departure.Date.Equals(DateTime.Today.Date) && (tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay)).TotalHours < 4.0)
{
MessageBox.Show("Can't Edit! Flight to depart in " + tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay).Hours + " : " + tblSchedule_HMS03_Team7.Departure.TimeOfDay.Subtract(DateTime.Now.TimeOfDay).Minutes + " hours");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
ViewBag.PlaneRegistrationID = new SelectList(db.tblAeroplane_HMS03_Team7, "PlaneRegistrationID", "AirplaneSeries", tblSchedule_HMS03_Team7.PlaneRegistrationID);
return(View(tblSchedule_HMS03_Team7));
}
public ActionResult Edit([Bind(Include = "JourneyID,CustomerID,ScheduleID,TotalBookingFare,NoOfPassengers_Adult,NoOfPassengers_Child,PaymentStatus,BonusRequstStatus,BookingDate,AdditionalBaggageCharge")] tblJourney_HMS03_Team7 tblJourney_HMS03_Team7)
{
if (ModelState.IsValid)
{
tblSchedule_HMS03_Team7 sch = db.tblSchedule_HMS03_Team7.Find(int.Parse(Session["ScheduleID"].ToString()));
if (tblJourney_HMS03_Team7.BonusRequstStatus == "Premium")
{
decimal?adultfare = sch.Fare_Premium_Adult;
decimal?childfare = sch.Fare_Premium_Child;
tblJourney_HMS03_Team7.TotalBookingFare = (tblJourney_HMS03_Team7.NoOfPassengers_Adult * adultfare) + (tblJourney_HMS03_Team7.NoOfPassengers_Child * childfare);
}
else if (tblJourney_HMS03_Team7.BonusRequstStatus == "FirstClass")
{
decimal?adultfare = sch.Fare_Firstclass_Adult;
decimal?childfare = sch.Fare_Firstclass_Child;
tblJourney_HMS03_Team7.TotalBookingFare = (tblJourney_HMS03_Team7.NoOfPassengers_Adult * adultfare) + (tblJourney_HMS03_Team7.NoOfPassengers_Child * childfare);
}
else if (tblJourney_HMS03_Team7.BonusRequstStatus == "Economy")
{
decimal?adultfare = sch.Fare_Economy_Adult;
decimal?childfare = sch.Fare_Economy_Child;
tblJourney_HMS03_Team7.TotalBookingFare = (tblJourney_HMS03_Team7.NoOfPassengers_Adult * adultfare) + (tblJourney_HMS03_Team7.NoOfPassengers_Child * childfare);
}
db.Entry(tblJourney_HMS03_Team7).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.tblCustomer_HMS03_Team7, "CustomerID", "Title", tblJourney_HMS03_Team7.CustomerID);
ViewBag.ScheduleID = new SelectList(db.tblSchedule_HMS03_Team7, "ScheduleID", "Source", tblJourney_HMS03_Team7.ScheduleID);
return(View(tblJourney_HMS03_Team7));
}
public ActionResult Create([Bind(Include = "ScheduleID,PlaneRegistrationID,Source,Destination,Departure,Arrival,Fare_Premium_Adult,Fare_Economy_Adult,Fare_Firstclass_Adult,Fare_Premium_Child,Fare_Firstclass_Child,Fare_Economy_Child,Availability_Premium,Availability_Firstclass,Availability_Economy,TravelDistance,StatusofFlight,BonusMiles,BonusMilesPoints")] tblSchedule_HMS03_Team7 tblSchedule_HMS03_Team7)
{
if (ModelState.IsValid)
{
tblSchedule_HMS03_Team7.StatusofFlight = "Scheduled";
if (tblSchedule_HMS03_Team7.Source.Equals(tblSchedule_HMS03_Team7.Destination))
{
MessageBox.Show("Source and destination can't be same");
// return RedirectToAction("Create");
}
if (tblSchedule_HMS03_Team7.Arrival < tblSchedule_HMS03_Team7.Departure)
{
MessageBox.Show("Arrival should be after departure!");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
if (tblSchedule_HMS03_Team7.Departure < DateTime.Now)
{
MessageBox.Show("Departure should be in future!");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
if (tblSchedule_HMS03_Team7.Departure.Subtract(DateTime.Now).TotalDays < 1)
{
MessageBox.Show("Departure should be after 24 hours!");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
var busy = db.tblSchedule_HMS03_Team7.Where(x => x.PlaneRegistrationID == tblSchedule_HMS03_Team7.PlaneRegistrationID && ((x.Departure <= tblSchedule_HMS03_Team7.Arrival && x.Arrival >= tblSchedule_HMS03_Team7.Arrival) || (x.Departure <= tblSchedule_HMS03_Team7.Departure && x.Arrival >= tblSchedule_HMS03_Team7.Departure))).FirstOrDefault();
if (busy != null)
{
MessageBox.Show("Flight already Scheduled!");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
var duplicate = db.tblSchedule_HMS03_Team7.Where(x => x.Departure == tblSchedule_HMS03_Team7.Departure && x.Arrival == tblSchedule_HMS03_Team7.Arrival && x.Source == tblSchedule_HMS03_Team7.Source && x.Destination == tblSchedule_HMS03_Team7.Destination).FirstOrDefault();
if (duplicate != null)
{
MessageBox.Show("Duplicate Schedule!");
return(RedirectToAction("VeiwScheduleToScheduler"));
}
List <tblAeroplane_HMS03_Team7> alist = db.tblAeroplane_HMS03_Team7.ToList();
foreach (var i in alist)
{
if (i.PlaneRegistrationID == tblSchedule_HMS03_Team7.PlaneRegistrationID)
{
tblSchedule_HMS03_Team7 tr = new tblSchedule_HMS03_Team7();
i.ScheduleStatus = tblSchedule_HMS03_Team7.StatusofFlight;
db.SaveChanges();
}
}
//To increment the schedule count for the scheduled airplane
tblAeroplane_HMS03_Team7 airplane = db.tblAeroplane_HMS03_Team7.Find(tblSchedule_HMS03_Team7.PlaneRegistrationID);
/*airplane.SchedulerID = int.Parse(Session["FSID"].ToString());*/ //Change it to int.Parse(Session["EmployeeID"].ToString());
//airplane.ScheduleStatus = "Scheduled";
tblSchedule_HMS03_Team7.Availability_Economy = airplane.Capacity_Economy;
tblSchedule_HMS03_Team7.Availability_Premium = airplane.Capacity_Premium;
tblSchedule_HMS03_Team7.Availability_Firstclass = airplane.Capacity_FirstClass;
db.tblSchedule_HMS03_Team7.Add(tblSchedule_HMS03_Team7);
db.SaveChanges();
return(RedirectToAction("VeiwScheduleToScheduler"));
}
ViewBag.PlaneRegistrationID = new SelectList(db.tblAeroplane_HMS03_Team7, "PlaneRegistrationID", "AirplaneSeries", tblSchedule_HMS03_Team7.PlaneRegistrationID);
return(View(tblSchedule_HMS03_Team7));
}
