public ActionResult GetTutorsToReview() { var payments = _paymentService.GetTableQuery().Where(p => p.StudentId == SessionDataHelper.UserId).Distinct().ToList(); var Class = new List<Class>(); var Reviews = new List<ReviewTutorViewModel>(); foreach(var p in payments) { var temp = new ReviewTutorViewModel(); var tempTutorReview = _reviewTutorService.GetTableQuery().Where(r => r.StudentId == SessionDataHelper.UserId).Where(r => r.TeacherId == p.TeacherId).SingleOrDefault(); var tempTutor = _teacherUserService.GetById(p.TeacherId); temp.Date = DateTime.Today; temp.StudentID = SessionDataHelper.UserId; temp.TeacherID = p.TeacherId; temp.TutorName = tempTutor.User.FirstName + " " + tempTutor.User.LastName; if(tempTutorReview!=null) { temp.Comment=tempTutorReview.Comment; temp.Rating = tempTutorReview.Rating; } else { temp.Comment = "Review This Tutor!"; temp.Rating=0; } Reviews.Add(temp); } var records=Reviews; return Json(new { Result = "OK", Records = records }); }
public ActionResult AddUpdateTutorsToReview(ReviewTutorViewModel review) { var reviewTutor = _reviewTutorService.GetTableQuery().Where(r => r.StudentId == review.StudentID).Where(r=> r.TeacherId==review.TeacherID).ToList(); var record = new ReviewTutorViewModel(); if(reviewTutor.Count()>0) { var update = new ReviewTeacher { Id = reviewTutor.Single().Id, Comment = review.Comment, Date = DateTime.Today, Rating = review.Rating, StudentId = review.StudentID, TeacherId = review.TeacherID }; _reviewTutorService.Update(update); record = new ReviewTutorViewModel { TeacherID=review.TeacherID, TutorName=review.TutorName, Comment = review.Comment, Date = DateTime.Today, StudentID = review.StudentID, Rating = review.Rating, }; } else { var insert = new ReviewTeacher { Comment = review.Comment, Date = DateTime.Today, Rating = review.Rating, StudentId = review.StudentID, TeacherId = review.TeacherID }; _reviewTutorService.Insert(insert); record = new ReviewTutorViewModel { TeacherID = review.TeacherID, TutorName = review.TutorName, Comment = review.Comment, Date = DateTime.Today, StudentID = review.StudentID, Rating = review.Rating, }; } return Json(new { Result = "OK", Records = record }); }