//public ActionResult AcftEdit(int id = 0, int pilotid=0)
//{
// var acft = db.vAircraftPilots.Find(id);
// ViewBag.PilotId = pilotid;
// if (acft == null)
// {
// return HttpNotFound();
// }
// return View(acft);
//}
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult AcftEdit(AircraftPilot acft)
//{
// if (Request.IsAuthenticated && ModelState.IsValid)
// {
// int pid = Request["pilotid"] == null ? 0 : Int32.Parse(Request["pilotId"]);
// if (Request["submit"] == "Save Changes")
// {
// db.AircraftPilots.Attach(acft);
// db.Entry(acft).Property(p => p.AcftName).IsModified = true;
// db.Entry(acft).Property(p => p.AcftNumLocal).IsModified = true;
// //db.Entry(acft).Property(p => p.AcftMMS).IsModified = true;
// //db.Entry(acft).Property(p => p.AcftMake).IsModified = true;
// //db.Entry(acft).Property(p => p.AcftModel).IsModified = true;
// //db.Entry(acft).Property(p => p.AcftSeries).IsModified = true;
// db.SaveChanges();
// }
// if (Request["submit"] == "Delete the Aircraft")
// {
// db.AircraftPilots.Attach(acft);
// db.AircraftPilots.Remove(acft);
// db.SaveChanges();
// }
// //return RedirectToAction("Index");
// return RedirectToAction("index_member_menu", new { menuitem = 2, pilotid = pid});
// }
// return View(acft);
//}
public ActionResult IndexLogBook()
{
//ViewBag.FeaturedMessage = "The aircraft tracking system records the GPS locations of your phone while on a flight ";
ViewBag.AppTitle = APP_NAME;
ViewBag.AppTitleModifier = APP_MODIFIER;
//if ( Roles.IsUserInRole("admin")) {
//}
//var password = user.GetPassword();
if (Request.IsAuthenticated)
{
try
{
ViewBag.Message = MSG_LOGGED;
//Trace.WriteLine("Point0");
var pilotUserName = User.Identity.Name;
var result = db.Pilots.Where(p => p.PilotUserName == pilotUserName).FirstOrDefault();
if (result == null)
{
return(View("AuthError"));
}
pilotid = result.PilotID;
//Trace.WriteLine(pilotid);
ViewBag.PilotCode = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().PilotCode;
ViewBag.NameLast = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().NameLast;
ViewBag.NameFirst = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().NameFirst;
string c = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().CertType;
ViewBag.PilotCert = c == null ? c : c.Replace('_', ' ');
//Trace.WriteLine("Point10");
ViewBag.Raiting = "";
ViewBag.BaseAirport = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().BaseAirport;
ViewBag.PilotName = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().PilotName;
ViewBag.PilotID = pilotid;
ViewBag.PilotFlightNum = q_flightsByPilot.Count();
//db.Flights.Where(p => p.PilotID == pilotid).Count();
//var aircraftids = db.Flights.Where(p => p.PilotID == pilotid).Select(p => p.AcftID).Distinct().ToList();
//var aircrafts = db.vAircraftPilots.Where(a => aircraftids.Contains(a.AcftID)).ToList();
var aircrafts = db.vAircraftPilots.Where(p => p.PilotID == pilotid).ToList();
return(View("Index_full", aircrafts));
}
catch (Exception e)
{
ViewBag.eMessage = e.Message;
return(View("Error"));
}
}
else
{
ViewBag.Message = MSG_NOTLOGGED;
var dd = new ListsDD();
ViewBag.AircraftsSelList = dd.getAllAcftList();
ViewBag.PilotSelList = dd.getAllPilotList();
ViewBag.AirportSelList = dd.getAllAirportList();
return(View());
}
}
public ActionResult Index()
{
//ViewBag.FeaturedMessage = "The aircraft tracking system records the GPS locations of your phone while on a flight ";
ViewBag.AppTitle = APP_NAME;
ViewBag.AppTitleModifier = APP_MODIFIER;
//if ( Roles.IsUserInRole("admin")) {
//}
//var password = user.GetPassword();
if (Request.IsAuthenticated)
{
try
{
ViewBag.Message = MSG_LOGGED;
//Trace.WriteLine("Point0");
var pilotUserName = User.Identity.Name;
var result = db.Pilots.Where(p => p.PilotUserName == pilotUserName).FirstOrDefault();
if (result == null)
{
return(View("AuthError"));
}
//pilotid = result.PilotID;
return(RedirectToAction("IndexMember", "Member", new { menuitem = 1 }));
//Trace.WriteLine(pilotid);
ViewBag.PilotCode = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().PilotCode;
ViewBag.NameLast = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().NameLast;
ViewBag.NameFirst = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().NameFirst;
string c = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().CertType;
ViewBag.PilotCert = c == null ? c : c.Replace('_', ' ');
//Trace.WriteLine("Point10");
ViewBag.Raiting = "";
ViewBag.BaseAirport = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().BaseAirport;
ViewBag.PilotName = db.Pilots.Where(p => p.PilotID == pilotid).FirstOrDefault().PilotName;
ViewBag.PilotID = pilotid;
ViewBag.PilotFlightNum = q_flightsByPilot.Count();
//db.Flights.Where(p => p.PilotID == pilotid).Count();
//var aircraftids = db.Flights.Where(p => p.PilotID == pilotid).Select(p => p.AcftID).Distinct().ToList();
//var aircrafts = db.vAircraftPilots.Where(a => aircraftids.Contains(a.AcftID)).ToList();
var aircrafts = db.vAircraftPilots.Where(p => p.PilotID == pilotid).ToList();
q.pilotId = pilotid;
var pt = q.pilotEntity;
var logBookList = q.pilotLogBook.ToList();
var timeLogBook = logBookList.Sum(item => item.FlightDurationMin) / 60;
var timeForward = pt.TimeForward;// q.pilotTimeForwarded;
ViewBag.TimeForward = timeForward;
ViewBag.LogBookTimeHours = timeLogBook;
ViewBag.TotalTimeHours = timeForward + timeLogBook;
var landNumForward = pt.LandingsForward;// q.pilotLandingsForwarded;
var landNumLogBook = logBookList.Sum(item => item.NoLandings);
ViewBag.LandNumForward = landNumForward;
ViewBag.LandNumLogBook = landNumLogBook;
ViewBag.LandNumTotal = landNumForward + landNumLogBook;
var vmPilotLogBookCombined = new vmPilotLogBookCombined(logBookList, aircrafts, pilotid, timeForward, landNumForward);
return(View("Index_member_menu", vmPilotLogBookCombined));
}
catch (Exception e)
{
ViewBag.eMessage = e.Message;
return(View("Error"));
}
}
else
{
ViewBag.Message = MSG_NOTLOGGED;
var dd = new ListsDD();
ViewBag.AircraftsSelList = dd.getAllAcftList();
ViewBag.PilotSelList = dd.getAllPilotList();
ViewBag.AirportSelList = dd.getAllAirportList();
return(View("IndexMobile"));
}
}