public ActionResult DeleteConfirmed(int?personalDetailsID, int?doInFlightID) { PesonalDetail_DoInFlight_YesNoAnswer pesonalDetail_DoInFlight_YesNoAnswer = db.PesonalDetail_DoInFlight_YesNoAnswer.Find(personalDetailsID, doInFlightID); db.PesonalDetail_DoInFlight_YesNoAnswer.Remove(pesonalDetail_DoInFlight_YesNoAnswer); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "PersonalDetailsID,DoInFlightID,YesNoAnswerID")] PesonalDetail_DoInFlight_YesNoAnswer pesonalDetail_DoInFlight_YesNoAnswer) { if (ModelState.IsValid) { db.PesonalDetail_DoInFlight_YesNoAnswer.Add(pesonalDetail_DoInFlight_YesNoAnswer); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DoInFlightID = new SelectList(db.DoInFlights, "DoInFlightID", "Name", pesonalDetail_DoInFlight_YesNoAnswer.DoInFlightID); ViewBag.PersonalDetailsID = new SelectList(db.PersonalDetails, "PersonalDetailsID", "FirstName", pesonalDetail_DoInFlight_YesNoAnswer.PersonalDetailsID); ViewBag.YesNoAnswerID = new SelectList(db.YesNoAnswers, "YesNoAnswerID", "Name", pesonalDetail_DoInFlight_YesNoAnswer.YesNoAnswerID); return(View(pesonalDetail_DoInFlight_YesNoAnswer)); }
// GET: PesonalDetail_DoInFlight_YesNoAnswer/Details/5 public ActionResult Details(int?personDetailsID, int?doInFlightID) { if (personDetailsID == null || doInFlightID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PesonalDetail_DoInFlight_YesNoAnswer pesonalDetail_DoInFlight_YesNoAnswer = db.PesonalDetail_DoInFlight_YesNoAnswer.Find(personDetailsID, doInFlightID); if (pesonalDetail_DoInFlight_YesNoAnswer == null) { return(HttpNotFound()); } return(View(pesonalDetail_DoInFlight_YesNoAnswer)); }
// GET: PesonalDetail_DoInFlight_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 doInFlight = db.DoInFlights.Select(d => d.DoInFlightID).ToList(); var YesNoAnswer = db.YesNoAnswers.Where(y => y.Name.Equals("No")).Select(y => y.YesNoAnswerID); if (doInFlight.ToList().Count > 0) { foreach (var inter in doInFlight.ToList()) { var exist = db.PesonalDetail_DoInFlight_YesNoAnswer.Where(p => p.DoInFlightID.Equals(inter) && p.PersonalDetailsID.Equals(person.PersonalDetailsID)).ToList(); if (exist.Count == 0) { PesonalDetail_DoInFlight_YesNoAnswer record = new PesonalDetail_DoInFlight_YesNoAnswer { PersonalDetailsID = person.PersonalDetailsID, DoInFlightID = inter, YesNoAnswerID = YesNoAnswer.First() }; db.PesonalDetail_DoInFlight_YesNoAnswer.Add(record); db.SaveChanges(); } } } ViewBag.DoInFlight = db.DoInFlights.ToList(); var pesonalDetail_DoInFlight_YesNoAnswer = db.PesonalDetail_DoInFlight_YesNoAnswer.Include(p => p.DoInFlight).Include(p => p.PersonalDetails).Include(p => p.YesNoAnswer); return(View(pesonalDetail_DoInFlight_YesNoAnswer.ToList())); }
// GET: PesonalDetail_DoInFlight_YesNoAnswer/Edit/5 public ActionResult Edit(int?personalDetailsID, int?doInFlightID) { if (personalDetailsID == null || doInFlightID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PesonalDetail_DoInFlight_YesNoAnswer pesonalDetail_DoInFlight_YesNoAnswer = db.PesonalDetail_DoInFlight_YesNoAnswer.Find(personalDetailsID, doInFlightID); if (pesonalDetail_DoInFlight_YesNoAnswer == null) { return(HttpNotFound()); } ViewBag.DoInFlightID = new SelectList(db.DoInFlights, "DoInFlightID", "Name", pesonalDetail_DoInFlight_YesNoAnswer.DoInFlightID); ViewBag.PersonalDetailsID = new SelectList(db.PersonalDetails, "PersonalDetailsID", "FirstName", pesonalDetail_DoInFlight_YesNoAnswer.PersonalDetailsID); ViewBag.YesNoAnswerID = new SelectList(db.YesNoAnswers, "YesNoAnswerID", "Name", pesonalDetail_DoInFlight_YesNoAnswer.YesNoAnswerID); return(View(pesonalDetail_DoInFlight_YesNoAnswer)); }
public ActionResult Edit([Bind(Include = "PersonalDetailsID,DoInFlightID,YesNoAnswerID")] PesonalDetail_DoInFlight_YesNoAnswer pesonalDetail_DoInFlight_YesNoAnswer) { if (ModelState.IsValid) { db.Entry(pesonalDetail_DoInFlight_YesNoAnswer).State = EntityState.Modified; db.SaveChanges(); //check if user is in the dating mood string currentUserId = User.Identity.GetUserId(); PersonalDetails person = db.PersonalDetails.Where(p => p.AspNetUserId.Equals(currentUserId)).First(); var answer = pesonalDetail_DoInFlight_YesNoAnswer.YesNoAnswerID; var mood = pesonalDetail_DoInFlight_YesNoAnswer.DoInFlightID; var datingMood = db.DoInFlights.Where(d => d.Name.Equals("Dating")).Select(d => d.DoInFlightID); var DatingMood = datingMood.First(); var Yes_answer = db.YesNoAnswers.Where(y => y.Name.Equals("Yes")).Select(y => y.YesNoAnswerID); var yes_answer = Yes_answer.First(); var No_answer = db.YesNoAnswers.Where(y => y.Name.Equals("No")).Select(y => y.YesNoAnswerID); var no_answer = No_answer.First(); if (DatingMood.Equals(mood)) { if (yes_answer.Equals(answer)) { var person_dating = db.Datings.Where(d => d.PersonalDetailsID.Equals(person.PersonalDetailsID)); if (person_dating.Count() < 1) { return(RedirectToAction("Create", "Datings")); } else { return(RedirectToAction("Edit", "Datings", new { id = person.PersonalDetailsID })); } } } //check if user is in the silence mood var silence_mood = db.DoInFlights.Where(d => d.Name.Equals("Silence")).First(); var Silence_mood = silence_mood.DoInFlightID; var personal_details = pesonalDetail_DoInFlight_YesNoAnswer.PersonalDetailsID; var this_person_mood_no_silenceMood = db.PesonalDetail_DoInFlight_YesNoAnswer.Where(p => p.DoInFlightID != Silence_mood && p.PersonalDetailsID.Equals(person.PersonalDetailsID)).ToList(); var this_person_mood_silenceMood = db.PesonalDetail_DoInFlight_YesNoAnswer.Where(p => p.DoInFlightID.Equals(Silence_mood) && p.PersonalDetailsID.Equals(person.PersonalDetailsID) && p.YesNoAnswerID.Equals(yes_answer)).ToList(); if (mood.Equals(Silence_mood)) { if (answer.Equals(yes_answer)) { foreach (var p in this_person_mood_no_silenceMood) { p.YesNoAnswerID = no_answer; db.Entry(pesonalDetail_DoInFlight_YesNoAnswer).State = EntityState.Modified; db.SaveChanges(); } } } //if we are in the silence mood and trying to do yes to another mood else { if (answer.Equals(yes_answer)) { if (this_person_mood_silenceMood.Count() > 0) { this_person_mood_silenceMood.First().YesNoAnswerID = no_answer; db.Entry(pesonalDetail_DoInFlight_YesNoAnswer).State = EntityState.Modified; db.SaveChanges();; return(RedirectToAction("Index")); } } } return(RedirectToAction("Index")); } ViewBag.DoInFlightID = new SelectList(db.DoInFlights, "DoInFlightID", "Name", pesonalDetail_DoInFlight_YesNoAnswer.DoInFlightID); ViewBag.PersonalDetailsID = new SelectList(db.PersonalDetails, "PersonalDetailsID", "FirstName", pesonalDetail_DoInFlight_YesNoAnswer.PersonalDetailsID); ViewBag.YesNoAnswerID = new SelectList(db.YesNoAnswers, "YesNoAnswerID", "Name", pesonalDetail_DoInFlight_YesNoAnswer.YesNoAnswerID); return(View(pesonalDetail_DoInFlight_YesNoAnswer)); }