public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblAeroplane_HMS03_Team7 tblAeroplane_HMS03_Team7 = db.tblAeroplane_HMS03_Team7.Find(id);
if (tblAeroplane_HMS03_Team7 == null)
{
return(HttpNotFound());
}
var user = db.tblAeroplane_HMS03_Team7.Where(x => x.PlaneRegistrationID == tblAeroplane_HMS03_Team7.PlaneRegistrationID).FirstOrDefault();
if (user != null)
{
if (tblAeroplane_HMS03_Team7.ScheduleStatus == "scheduled" || tblAeroplane_HMS03_Team7.ScheduleStatus == "Scheduled")
{
MessageBox.Show("Flight already scheduled!");
return(RedirectToAction("Index"));
}
}
return(View(tblAeroplane_HMS03_Team7));
}
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)
{
tblAeroplane_HMS03_Team7 tblAeroplane_HMS03_Team7 = db.tblAeroplane_HMS03_Team7.Find(id);
db.tblAeroplane_HMS03_Team7.Remove(tblAeroplane_HMS03_Team7);
db.SaveChanges();
MessageBox.Show("Flight deleted successfully!" + tblAeroplane_HMS03_Team7.AirplaneSeries);
return(RedirectToAction("Index"));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblAeroplane_HMS03_Team7 tblAeroplane_HMS03_Team7 = db.tblAeroplane_HMS03_Team7.Find(id);
//tblAeroplane_HMS03_Team7.ScheduleStatus = (string)Session["status"];
if (tblAeroplane_HMS03_Team7 == null)
{
return(HttpNotFound());
}
//if(tblAeroplane_HMS03_Team7.PlaneRegistrationID=)
return(View(tblAeroplane_HMS03_Team7));
}
public ActionResult Create([Bind(Include = "PlaneRegistrationID,DateOfCommencement,DateOdMAnufacturing,AirplaneSeries,Airline,Capacity_Premium,Capacity_FirstClass,Capacity_Economy,TakeOffWeight,MaximumDistance,LocationOfPlane,SchedulerID,RecentUpdate,ScheduleStatus")] tblAeroplane_HMS03_Team7 tblAeroplane_HMS03_Team7)
{
if (ModelState.IsValid)
{
if (tblAeroplane_HMS03_Team7.DateOdMAnufacturing > DateTime.Now && tblAeroplane_HMS03_Team7.DateOfCommencement > DateTime.Now)
{
MessageBox.Show("manufacturing and commencement cannot be in future");
return(RedirectToAction("Create"));
}
else if (tblAeroplane_HMS03_Team7.DateOdMAnufacturing > DateTime.Now)
{
MessageBox.Show("date of manufacturing cannot be in future");
return(RedirectToAction("Create"));
}
else if (tblAeroplane_HMS03_Team7.DateOfCommencement > DateTime.Now)
{
MessageBox.Show("date of commencement cannot be in future");
return(RedirectToAction("Create"));
}
if (db.tblAeroplane_HMS03_Team7.Any(x => x.AirplaneSeries == tblAeroplane_HMS03_Team7.AirplaneSeries))
{
//ModelState.AddModelError("CustomError", "name already exists");
MessageBox.Show("name already exists:" + tblAeroplane_HMS03_Team7.AirplaneSeries);
return(RedirectToAction("Create"));
}
if (tblAeroplane_HMS03_Team7.DateOfCommencement < tblAeroplane_HMS03_Team7.DateOdMAnufacturing)
{
MessageBox.Show("can't be same or Date of Commencement should be greater than date of manufacturing");
return(RedirectToAction("Create"));
}
tblAeroplane_HMS03_Team7.SchedulerID = int.Parse(Session["FMID"].ToString());
tblAeroplane_HMS03_Team7.ScheduleStatus = "Not Scheduled";
tblAeroplane_HMS03_Team7.RecentUpdate = DateTime.Now;
db.tblAeroplane_HMS03_Team7.Add(tblAeroplane_HMS03_Team7);
db.SaveChanges();
MessageBox.Show("Created successfully with ID:" + tblAeroplane_HMS03_Team7.PlaneRegistrationID);
return(RedirectToAction("Index"));
}
ViewBag.SchedulerID = new SelectList(db.tblEmployee_HMS03_Team7, "EmployeeID", "Employee_Name", tblAeroplane_HMS03_Team7.SchedulerID);
return(View(tblAeroplane_HMS03_Team7));
}
public ActionResult Search([Bind(Include = "PlaneRegistrationID,DateOfCommencement,DateOdMAnufacturing,AirplaneSeries,Airline,Capacity_Premium,Capacity_FirstClass,Capacity_Economy,TakeOffWeight,MaximumDistance,LocationOfPlane,SchedulerID,RecentUpdate,ScheduleStatus")] tblAeroplane_HMS03_Team7 flight)
{
Session["planeid"] = flight.PlaneRegistrationID;
Session["flightname"] = flight.AirplaneSeries;
Session["airlines"] = flight.Airline;
var result = db.tblAeroplane_HMS03_Team7.Where(x => x.PlaneRegistrationID == flight.PlaneRegistrationID && x.AirplaneSeries == flight.AirplaneSeries && x.Airline == flight.Airline).FirstOrDefault();
if (result != null)
{
return(RedirectToAction("Searchflights"));
}
else
{
MessageBox.Show("there are no flights existed for entered details");
return(RedirectToAction("Search"));
}
}
public ActionResult Edit([Bind(Include = "PlaneRegistrationID,DateOfCommencement,DateOdMAnufacturing,AirplaneSeries,Airline,Capacity_Premium,Capacity_FirstClass,Capacity_Economy,TakeOffWeight,MaximumDistance,LocationOfPlane,SchedulerID,RecentUpdate,ScheduleStatus")] tblAeroplane_HMS03_Team7 tblAeroplane_HMS03_Team7)
{
if (ModelState.IsValid)
{
if (tblAeroplane_HMS03_Team7.DateOdMAnufacturing > DateTime.Now && tblAeroplane_HMS03_Team7.DateOfCommencement > DateTime.Now)
{
MessageBox.Show("Manufacturing and commencement cannot be in future");
return(RedirectToAction("Edit"));
}
if (tblAeroplane_HMS03_Team7.DateOfCommencement < tblAeroplane_HMS03_Team7.DateOdMAnufacturing)
{
MessageBox.Show("Can't be same or Date of Commencement should be greater than date of manufacturing");
return(RedirectToAction("Edit"));
}
db.Entry(tblAeroplane_HMS03_Team7).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Updated successfully");
return(RedirectToAction("Index"));
}
ViewBag.SchedulerID = new SelectList(db.tblEmployee_HMS03_Team7, "EmployeeID", "Employee_Name", tblAeroplane_HMS03_Team7.SchedulerID);
return(View(tblAeroplane_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));
}
