public ActionResult Decide(ReviewViewModel rvm) { var grabReviews = from a in db.Reviewer where (a.ApplicationID == rvm.Application.ID) && (User.Identity.Name == a.User) select a; if (grabReviews.Count() > 0) { int rmExists = (from a in db.Reviewer where a.User.Equals(User.Identity.Name) && a.ApplicationID == rvm.Application.ID select a.ID).ToList()[0]; //rmExists = new ReviewerModel() { Comment = rvm.ReviewerModel.Comment, Date = DateTime.Now, User = User.Identity.Name, ApplicationID = rvm.Application.ID }; ReviewerModel rm = db.Reviewer.Find(rmExists); rm.Comment = rvm.ReviewerModel.Comment; rm.DecisionComment = rvm.ReviewerModel.DecisionComment; rm.Date = DateTime.Now; db.Entry(rm).State = EntityState.Modified; db.SaveChanges(); List<TransitionCourses> transitionCourseList = rvm.TransitionCourseList(Int32.Parse(rvm.DepartmentNamesList[0].Value)); List<int> transitionReviewList = (from a in db.TransitionReview where (a.ApplicationID == rvm.Application.ID) && (a.ReviewModelID == rmExists) select a.ID).ToList(); int i = 0; foreach (var a in transitionReviewList) { TransitionReviewModel t = db.TransitionReview.Find(a); if (rvm.Transition[i].Equals("")) { //t.ID = transitionCourseList[i].TransitionCourseModel.ID; t.TransitionOptionModelID = 1; t.answered = false; t.ReviewModelID = rm.ID; t.ApplicationID = rvm.Application.ID; } else { int temp = Int32.Parse(rvm.Transition[i]); //t.ID = transitionCourseList[i].TransitionCourseModel.ID; t.TransitionOptionModelID = (from x in db.TransitionOption where x.ID == temp select x.ID).ToList()[0]; t.answered = true; t.ReviewModelID = rm.ID; t.ApplicationID = rvm.Application.ID; } i++; db.Entry(t).State = EntityState.Modified; db.SaveChanges(); } db.SaveChanges(); return RedirectToAction("Index"); } else { ReviewerModel rm = new ReviewerModel() { Comment = rvm.ReviewerModel.Comment, DecisionComment = rvm.ReviewerModel.Comment, Date = DateTime.Now, User = User.Identity.Name, ApplicationID = rvm.Application.ID }; db.Reviewer.Add(rm); db.SaveChanges(); List<TransitionCourses> transitionCourseList = rvm.TransitionCourseList(Int32.Parse(rvm.DepartmentNamesList[0].Value)); for (int i = 0; i < rvm.Transition.Length; ++i) { if (rvm.Transition[i].Equals("")) { db.TransitionReview.Add(new TransitionReviewModel() { TransitionCourseModelID = transitionCourseList[i].TransitionCourseModel.ID, TransitionOptionModelID = 1, answered = false, ReviewModelID = rm.ID, ApplicationID = rvm.Application.ID }); } else { int temp = Int32.Parse(rvm.Transition[i]); db.TransitionReview.Add(new TransitionReviewModel() { TransitionCourseModelID = transitionCourseList[i].TransitionCourseModel.ID, TransitionOptionModelID = (from a in db.TransitionOption where a.ID == temp select a.ID).ToList()[0], ReviewModelID = rm.ID, ApplicationID = rvm.Application.ID, answered = true }); } } db.SaveChanges(); return RedirectToAction("Index"); } }
public ActionResult Decide(int id) { ReviewViewModel rvm = new ReviewViewModel(); var grabReviews = from a in db.Reviewer where (a.ApplicationID == id) && (User.Identity.Name == a.User) select a; if (grabReviews.Count() > 0) { rvm.exists = true; var grabApplication = from a in db.Application where a.ID == id select a; var profile = Profile.GetProfile(User.Identity.Name); int reviewerDepartmentID = (from a in db.DepartmentModel where a.Name == profile.Department select a.ID).ToList()[0]; foreach (var app in grabApplication) { rvm = new ReviewViewModel() { Application = app, DepartmentList = (from c in db.DepartmentModel join a in db.ApplicationDepartment on app.ID equals a.ApplicationID where c.ID == a.DepartmentID select c).ToList(), Term = (from a in db.Term join b in db.Application on a.ID equals b.ID where a.ID == b.ID select a).ToList()[0], PDFurlList = (from a in db.PDFurlModel join b in db.Application on a.ApplicationID equals b.ID where a.ApplicationID == id select a).ToList(), reviewerDepartmentID = (from a in db.DepartmentModel where a.Name == profile.Department select a.ID).ToList()[0], ReviewerModel = (from a in db.Reviewer where (a.User == User.Identity.Name) && (a.ApplicationID == id) select a).ToList()[0], TransitionCoursesList = rvm.TransitionOptionListExists(rvm.TransitionCourseList(reviewerDepartmentID).Count, grabReviews.ToList()[0].ID, app.ID) }; } } else { rvm = new ReviewViewModel(); var grabApplication = from a in db.Application where a.ID == id select a; var profile = Profile.GetProfile(User.Identity.Name); foreach (var app in grabApplication) { rvm = new ReviewViewModel() { Application = app, DepartmentList = (from c in db.DepartmentModel join a in db.ApplicationDepartment on app.ID equals a.ApplicationID where c.ID == a.DepartmentID select c).ToList(), Term = (from a in db.Term join b in db.Application on a.ID equals b.ID where a.ID == b.ID select a).ToList()[0], PDFurlList = (from a in db.PDFurlModel join b in db.Application on a.ApplicationID equals b.ID where a.ApplicationID == id select a).ToList(), reviewerDepartmentID = (from a in db.DepartmentModel where a.Name == profile.Department select a.ID).ToList()[0], ReviewerModel = new Models.General.ReviewerModel(), TransitionCoursesList = rvm.TransitionCourseList(rvm.reviewerDepartmentID) }; int reviewerDepartmentID = (from a in db.DepartmentModel where a.Name == profile.Department select a.ID).ToList()[0]; rvm.TransitionOptionList(rvm.TransitionCourseList(reviewerDepartmentID).Count); } } return View(rvm); }
public ActionResult Review(ReviewViewModel rvm) { ReviewerModel rm = new ReviewerModel() { Comment = rvm.ReviewerModel.Comment, Date = DateTime.Now, User = User.Identity.Name, ApplicationID = rvm.Application.ID }; db.Reviewer.Add(rm); db.SaveChanges(); List<TransitionCourses> transitionCourseList = rvm.TransitionCourseList(rvm.Application.ID); for(int i=0; i < rvm.Transition.Length; ++i) { if (rvm.Transition[i].Equals("")) { db.TransitionReview.Add(new TransitionReviewModel() { TransitionCourseModelID = transitionCourseList[i].TransitionCourseModel.ID, TransitionOptionModelID = 0, ReviewModelID = rm.ID, ApplicationID = rvm.Application.ID }); } else { int temp = Int32.Parse(rvm.Transition[i]); db.TransitionReview.Add(new TransitionReviewModel() { TransitionCourseModelID = transitionCourseList[i].TransitionCourseModel.ID, TransitionOptionModelID = (from a in db.TransitionOption where a.ID == temp select a.ID).ToList()[0], ReviewModelID = rm.ID, ApplicationID = rvm.Application.ID }); } } db.SaveChanges(); return RedirectToAction("Index"); /* var grabApplication = from a in db.Application where a.ID == rvm.Application.ID select a; var profile = Profile.GetProfile(User.Identity.Name); foreach (var app in grabApplication) { rvm = new ReviewViewModel() { Application = app, DepartmentList = (from c in db.DepartmentModel join a in db.ApplicationDepartment on app.ID equals a.ApplicationID where c.ID == a.DepartmentID select c).ToList(), Term = (from a in db.Term join b in db.Application on a.ID equals b.ID where a.ID == b.ID select a).ToList()[0], PDFurlList = (from a in db.PDFurlModel join b in db.Application on a.ApplicationID equals b.ID where a.ApplicationID == rvm.Application.ID select a).ToList(), reviewerDepartmentID = (from a in db.DepartmentModel where a.Name == profile.Department select a.ID).ToList()[0], ReviewerModel = new Models.General.ReviewerModel(), TransitionCoursesList = rvm.TransitionCourseList(rvm.reviewerDepartmentID) }; int reviewerDepartmentID = (from a in db.DepartmentModel where a.Name == profile.Department select a.ID).ToList()[0]; rvm.TransitionOptionList(rvm.TransitionCourseList(reviewerDepartmentID).Count); } return View(rvm);*/ }