public ActionResult DeleteConfirmed(int?PersonalDetailsID, int?DoInFlightID)
{
PersonalDetails_SeatingPosition_YesNOAnswer personalDetails_SeatingPosition_YesNOAnswer = db.PersonalDetails_SeatingPosition_YesNOAnswer.Find(PersonalDetailsID, DoInFlightID);
db.PersonalDetails_SeatingPosition_YesNOAnswer.Remove(personalDetails_SeatingPosition_YesNOAnswer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PersonalDetailsID,SeatingPositionID,YesNoAnswerID")] PersonalDetails_SeatingPosition_YesNOAnswer personalDetails_SeatingPosition_YesNOAnswer)
{
if (ModelState.IsValid)
{
db.Entry(personalDetails_SeatingPosition_YesNOAnswer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonalDetailsID = new SelectList(db.PersonalDetails, "PersonalDetailsID", "AspNetUserId", personalDetails_SeatingPosition_YesNOAnswer.PersonalDetailsID);
ViewBag.SeatingPositionID = new SelectList(db.SeatingPositions, "SeatingPositionID", "Name", personalDetails_SeatingPosition_YesNOAnswer.SeatingPositionID);
ViewBag.YesNoAnswerID = new SelectList(db.YesNoAnswers, "YesNoAnswerID", "Name", personalDetails_SeatingPosition_YesNOAnswer.YesNoAnswerID);
return(View(personalDetails_SeatingPosition_YesNOAnswer));
}
// GET: PersonalDetails_SeatingPosition_YesNOAnswer1/Details/5
public ActionResult Details(int?PersonalDetailsID, int?DoInFlightID)
{
if (PersonalDetailsID == null || DoInFlightID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PersonalDetails_SeatingPosition_YesNOAnswer personalDetails_SeatingPosition_YesNOAnswer = db.PersonalDetails_SeatingPosition_YesNOAnswer.Find(PersonalDetailsID, DoInFlightID);
if (personalDetails_SeatingPosition_YesNOAnswer == null)
{
return(HttpNotFound());
}
return(View(personalDetails_SeatingPosition_YesNOAnswer));
}
public ActionResult Create([Bind(Include = "PersonalDetailsID,SeatingPositionID,YesNoAnswerID")] PersonalDetails_SeatingPosition_YesNOAnswer personalDetails_SeatingPosition_YesNOAnswer)
{
if (ModelState.IsValid)
{
db.PersonalDetails_SeatingPosition_YesNOAnswer.Add(personalDetails_SeatingPosition_YesNOAnswer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonalDetailsID = new SelectList(db.PersonalDetails, "PersonalDetailsID", "FirstName", personalDetails_SeatingPosition_YesNOAnswer.PersonalDetailsID);
ViewBag.SeatingPositionID = new SelectList(db.SeatingPositions, "SeatingPositionID", "Name", personalDetails_SeatingPosition_YesNOAnswer.SeatingPositionID);
ViewBag.YesNoAnswerID = new SelectList(db.YesNoAnswers, "YesNoAnswerID", "Name", personalDetails_SeatingPosition_YesNOAnswer.YesNoAnswerID);
return(View(personalDetails_SeatingPosition_YesNOAnswer));
}
// GET: PersonalDetails_SeatingPosition_YesNOAnswer1/Edit/5
public ActionResult Edit(int?PersonalDetailsID, int?DoInFlightID)
{
if (PersonalDetailsID == null || DoInFlightID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PersonalDetails_SeatingPosition_YesNOAnswer personalDetails_SeatingPosition_YesNOAnswer = db.PersonalDetails_SeatingPosition_YesNOAnswer.Find(PersonalDetailsID, DoInFlightID);
if (personalDetails_SeatingPosition_YesNOAnswer == null)
{
return(HttpNotFound());
}
ViewBag.PersonalDetailsID = new SelectList(db.PersonalDetails, "PersonalDetailsID", "AspNetUserId", personalDetails_SeatingPosition_YesNOAnswer.PersonalDetailsID);
ViewBag.SeatingPositionID = new SelectList(db.SeatingPositions, "SeatingPositionID", "Name", personalDetails_SeatingPosition_YesNOAnswer.SeatingPositionID);
ViewBag.YesNoAnswerID = new SelectList(db.YesNoAnswers, "YesNoAnswerID", "Name", personalDetails_SeatingPosition_YesNOAnswer.YesNoAnswerID);
return(View(personalDetails_SeatingPosition_YesNOAnswer));
}
// GET: PersonalDetails_SeatingPosition_YesNOAnswer
public ActionResult Index()
{
string currentUserId = User.Identity.GetUserId();
ApplicationUser currentUser = db.Users.FirstOrDefault(x => x.Id == currentUserId);
var person = db.PersonalDetails.FirstOrDefault(e => (e.AspNetUserId.Equals(currentUserId)));
if (currentUserId == null)
{
return(Redirect("/Account/Login"));
}
if (person == null)
{
return(RedirectToAction("Create", "PersonalDetails"));
}
var SeatingPositions = db.SeatingPositions.Select(s => s.SeatingPositionID).ToList();
var YesNoAnswer = db.YesNoAnswers.Where(i => i.Name.Equals("No")).Select(i => i.YesNoAnswerID);
if (SeatingPositions.ToList().Count > 0)
{
foreach (var inter in SeatingPositions.ToList())
{
var exist = db.PersonalDetails_SeatingPosition_YesNOAnswer.Where(p => p.SeatingPositionID.Equals(inter) && p.PersonalDetailsID.Equals(person.PersonalDetailsID)).ToList();
if (exist.Count == 0)
{
PersonalDetails_SeatingPosition_YesNOAnswer record = new PersonalDetails_SeatingPosition_YesNOAnswer
{
PersonalDetailsID = person.PersonalDetailsID,
SeatingPositionID = inter,
YesNoAnswerID = YesNoAnswer.First()
};
db.PersonalDetails_SeatingPosition_YesNOAnswer.Add(record);
db.SaveChanges();
}
}
}
ViewBag.SeatingPositions = db.SeatingPositions.ToList();
var personalDetails_SeatingPosition_YesNOAnswer = db.PersonalDetails_SeatingPosition_YesNOAnswer.Include(p => p.PersonalDetails).Include(p => p.SeatingPosition).Include(p => p.YesNoAnswer);
return(View(personalDetails_SeatingPosition_YesNOAnswer.ToList()));
}
