//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")); } }