//private void SetViewBagCertType(EPilotCertificates pilotCertificates)
//{
// IEnumerable<EPilotCertificates> values = Enum.GetValues(typeof(EPilotCertificates)).Cast<EPilotCertificates>();
// IEnumerable<SelectListItem> items =
// from value in values
// select new SelectListItem
// {
// Text = value.ToString().Replace("_"," "),
// Value = value.ToString(),
// Selected = value == pilotCertificates,
// };
// ViewBag.Certif = items;
//}
// GET:
public ActionResult PilotEdit(int id = 0)
{
Pilot pilot = db.Pilots.Find(id);
//EPilotCertificates enumIndexSelected;
//Enum.TryParse(pilot.CertType, out enumIndexSelected);
//List<SelectListItem> items = new List<SelectListItem>();
//items.Add(new SelectListItem { Text = "Student", Value = "0" });
//items.Add(new SelectListItem { Text = "Sport Pilot", Value = "1" });
//items.Add(new SelectListItem { Text = "Recreational Pilot", Value = "2" });
//items.Add(new SelectListItem { Text = "Private Pilot", Value = "3", Selected = true });
//items.Add(new SelectListItem { Text = "Commercial Pilot", Value = "4" });
//items.Add(new SelectListItem { Text = "Flight Instructor", Value = "5", Selected = true });
//items.Add(new SelectListItem { Text = "Airline Transport Pilot", Value = "6" });
//ViewBag.Cert = items;
//SetViewBagCertType(enumIndexSelected);
ViewBag.Certif = ListsDD.getCertificates(pilot.CertType);
if (pilot == null)
{
return(HttpNotFound());
}
ViewBag.Pilotphone = pilot.PilotCode;
ViewBag.PilotNickname = pilot.PilotName;
ViewBag.Certif = ListsDD.getCertificates(pilot.CertType);
return(View(pilot));
}
//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"));
}
}
