public ActionResult AddSchedule(PilotSchedule ps) { var db = new AllDbContext(); if (ModelState.IsValid) { db.Entry(ps).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PilotID = new SelectList(db.Pilots, "PilotID", "PilotID", ps.PilotID); return(View(ps)); }
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 AddSchedule(int?id) { var db = new AdminDbContext(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var db1 = new AllDbContext(); PilotSchedule ps = db1.Pilot_schedule.Find(id); if (ps == null) { return(HttpNotFound()); } ViewBag.PilotID = new SelectList(db1.Pilots, "PilotID", "PilotID", ps.PilotID); return(View(ps)); }