public ActionResult Pilots() { var context = new PilotDbContext(); List <PilotDetails> manager = context.Pilots.ToList(); return(View(manager)); }
public ActionResult PilotEdit(int?id) { var db = new PilotDbContext(); var model = db.Pilots.FirstOrDefault(r => r.ID == id); if (model == null) { return(HttpNotFound()); } return(View(model)); }
public ActionResult PilotEdit(PilotDetails pilot) { var db = new PilotDbContext(); var entry = db.Entry(pilot); if (ModelState.IsValid) { entry.State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Pilots", "Admin")); } return(View(entry)); }
public ActionResult PilotRegister(PilotDetails admin) { var pilot = new PilotDetails { PilotID = admin.PilotID, Password = admin.Password, ConfirmPassword = admin.ConfirmPassword, FirstName = admin.FirstName, LastName = admin.LastName, Age = admin.Age, Gender = admin.Gender, ContactNumber = admin.ContactNumber, RoleID = admin.RoleID, isApproved = admin.isApproved }; if (ModelState.IsValid) { var context = new PilotDbContext(); var isUnique = context.Pilots.Where(n => n.PilotID == admin.PilotID); foreach (var i in isUnique) { if (i.PilotID == admin.PilotID) { ViewData["Error"] = "PilotID Already Exists"; return(View(admin)); } } admin.RoleID = 3; context.Pilots.Add(admin); context.SaveChanges(); var pilot_schedule = new PilotSchedule() { PilotID = admin.PilotID, PilotAvailabilityFrom = null, PilotAvailabilityTo = null, IsActive = false }; var pils = new AdminDbContext(); pils.PilotS.Add(pilot_schedule); pils.SaveChanges(); TempData["saved"] = "Pilot Details Added Successfully!"; return(RedirectToAction("PilotLogin")); } return(View()); }
public ActionResult PilotRejected(int id) { var context = new PilotDbContext(); var user = context.Pilots.Where(n => n.ID == id).ToList(); foreach (var i in user) { i.ConfirmPassword = i.Password; i.isApproved = false; context.SaveChanges(); } return(RedirectToAction("Pilots")); }
public ActionResult PilotLogin(PilotLogin pLogin) { if (ModelState.IsValid) { var context = new PilotDbContext(); var retrive = context.Pilots.Where(n => n.PilotID == pLogin.PilotID); foreach (var i in retrive) { if (i.isApproved == false) { TempData["Message"] = "Admin approval is needed"; return(View(pLogin)); } if (i.PilotID == pLogin.PilotID && i.Password == pLogin.Password && i.isApproved == true) { FormsAuthentication.SetAuthCookie(pLogin.PilotID.ToString(), false); return(RedirectToAction("Index")); } } } ViewData["Error"] = "Invalid Username or password"; return(View(pLogin)); }