public ActionResult ShowReview()
        {
            UserReviewDAL     dal       = new UserReviewDAL();
            List <UserReview> objReview = dal.reviews.ToList <UserReview>();

            return(View(objReview));
        }
        public ActionResult AddReview()
        {
            UserReviewDAL     urDAL = new UserReviewDAL();
            List <UserReview> ur    = urDAL.reviews.ToList <UserReview>();

            ViewBag.Reviews = ur;
            return(View());
        }
        public ActionResult AddReviewToDB()
        {
            string      PID     = Request.Form["PID"].ToString();
            string      Review  = Request.Form["Review"].ToString();
            string      DID     = Session["DoctorLoggedIn"].ToString();
            UserDAL     usrDal  = new UserDAL();
            List <User> usrList = (from x in usrDal.Users where x.ID == PID select x).ToList <User>();

            if (usrList.Count >= 1)
            {
                UserReview ur = new UserReview();
                ur.UserId  = PID;
                ur.Message = Review;
                ur.From    = DID;
                UserReviewDAL urDAL = new UserReviewDAL();

                try
                {
                    urDAL.reviews.Add(ur);
                    urDAL.SaveChanges();
                }
                catch (Exception)
                {
                    //Failed insertion,already exist

                    urDAL.reviews.Remove(ur);
                    //ViewBag.DuplicateUser = true;
                    return(RedirectToAction("AddReview", "Doctor"));
                }
            }
            else
            {
                TempData["nonUser"] = "******";
            }

            return(RedirectToAction("AddReview", "Doctor"));
        }