public ActionResult DeleteConfirmed(int id)
        {
            UserReviews1 userReviews1 = db.UserReviews1.Find(id);

            db.UserReviews1.Remove(userReviews1);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Review_ReferenceID,LocalBusiness_ID,LocalExpert_UserID,FairPrice_Rating,Quality_Rating,CompletionTime_Rating,Review_Body,ReviewBody_Date")] UserReviews1 userReviews1)
 {
     if (ModelState.IsValid)
     {
         db.Entry(userReviews1).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.LocalBusiness_ID   = new SelectList(db.LocalBusinessUsers1, "LocalBusiness_ID", "LocalBusiness_UserID", userReviews1.LocalBusiness_ID);
     ViewBag.LocalExpert_UserID = new SelectList(db.LocalExperts1, "LocalExpert_ID", "LocalExpert_UserID", userReviews1.LocalExpert_UserID);
     return(View(userReviews1));
 }
        // GET: UserReviews1/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            UserReviews1 userReviews1 = db.UserReviews1.Find(id);

            if (userReviews1 == null)
            {
                return(HttpNotFound());
            }
            return(View(userReviews1));
        }
        public ActionResult Create([Bind(Include = "Review_ReferenceID,LocalBusiness_ID,LocalExpert_UserID,FairPrice_Rating,Quality_Rating,CompletionTime_Rating,Review_Body,ReviewBody_Date")] UserReviews1 userReviews1)
        {
            if (ModelState.IsValid)
            {
                userReviews1.ReviewBody_Date = DateTime.Now;



                db.UserReviews1.Add(userReviews1);
                db.SaveChanges();
                return(RedirectToAction("Details", "LocalExperts1", new { id = userReviews1.LocalExpert_UserID }));
            }

            return(View(userReviews1));
        }
        // GET: UserReviews1/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            UserReviews1 userReviews1 = db.UserReviews1.Find(id);

            if (userReviews1 == null)
            {
                return(HttpNotFound());
            }
            ViewBag.LocalBusiness_ID   = new SelectList(db.LocalBusinessUsers1, "LocalBusiness_ID", "LocalBusiness_UserID", userReviews1.LocalBusiness_ID);
            ViewBag.LocalExpert_UserID = new SelectList(db.LocalExperts1, "LocalExpert_ID", "LocalExpert_UserID", userReviews1.LocalExpert_UserID);
            return(View(userReviews1));
        }
        public ActionResult Create(int?id)
        {
            var localExpert = db.LocalExperts1.Find(id);

            var userId      = User.Identity.GetUserId();
            var currentUser = db.LocalBusinessUsers1.Single(c => c.LocalBusiness_UserID == userId);

            var userReview = new UserReviews1
            {
                LocalBusiness_ID   = currentUser.LocalBusiness_ID,
                LocalExpert_UserID = id.Value,
                ReviewBody_Date    = DateTime.Now,
            };

            ViewBag.localExpert = localExpert;

            return(View(userReview));
        }