public ActionResult AddAReview(AddAWebsiteReview viewModel) { WebUser webUser = new WebUser(); webUser.FirstName = viewModel.WebUser.FirstName; webUser.LastName = viewModel.WebUser.LastName; webUser.City = viewModel.WebUser.City; webUser.State = viewModel.WebUser.State; Website website = new Website(); website.Category = viewModel.Website.Category; website.WebsiteUrl = viewModel.Website.WebsiteUrl; website.WebsiteName = viewModel.Website.WebsiteName; WebsiteReview websiteReview = new WebsiteReview(); websiteReview.Ratings = viewModel.WebsiteReview.Ratings; websiteReview.UserReview = viewModel.WebsiteReview.UserReview; websiteReview.CreatedDate = viewModel.WebsiteReview.CreatedDate; db.WebUsers.Add(webUser); db.Websites.Add(website); db.WebsiteReviews.Add(websiteReview); db.SaveChanges(); TempData["Message"] = "Review was successfully added"; return(RedirectToAction("Index", "WebsiteReviews")); }
public ActionResult DeleteConfirmed(int id) { WebsiteReview websiteReview = db.WebsiteReviews.Find(id); db.WebsiteReviews.Remove(websiteReview); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(WebsiteReview websiteReview) { db.WebsiteReviews.Add(websiteReview); if (ModelState.IsValid) { db.Entry(websiteReview).State = EntityState.Modified; db.SaveChanges(); TempData["Message"] = "Edited Review was successfully Saved"; return(RedirectToAction("Index")); } return(View()); }
public ActionResult Create([Bind(Include = "ID,UserID,WebsiteID,Ratings,UserReview,CreatedDate")] WebsiteReview websiteReview) { if (ModelState.IsValid) { db.WebsiteReviews.Add(websiteReview); db.SaveChanges(); TempData["Message"] = "Review was successfully added"; return(RedirectToAction("Index")); } ViewBag.WebsiteID = new SelectList(db.Websites, "WebsiteID", "WebsiteUrl", websiteReview.WebsiteID); ViewBag.UserID = new SelectList(db.WebUsers, "UserID", "FirstName", websiteReview.UserID); return(View(websiteReview)); }
// GET: WebsiteReviews/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WebsiteReview websiteReview = db.WebsiteReviews.Find(id); if (websiteReview == null) { return(HttpNotFound()); } return(View(websiteReview)); }
// GET: WebsiteReviews/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WebsiteReview websiteReview = db.WebsiteReviews.Find(id); if (websiteReview == null) { return(HttpNotFound()); } ViewBag.WebsiteID = new SelectList(db.Websites, "WebsiteID", "WebsiteID", websiteReview.WebsiteID); ViewBag.UserID = new SelectList(db.WebUsers, "UserID", "UserID", websiteReview.UserID); return(View(websiteReview)); }
public ActionResult Edit(WebsiteReview websiteReview) { if (ModelState.IsValid) { db.Entry(websiteReview).State = EntityState.Modified; //Confirm WebUser table as edited db.Entry(websiteReview.WebUser).State = EntityState.Modified; //Confirm WebUser table as edited db.Entry(websiteReview.Website).State = EntityState.Modified; db.SaveChanges(); //Captures tempdata from server to display operation completed successfully TempData["Message"] = "Edited Review was successfully Saved"; return(RedirectToAction("Index")); } return(View(websiteReview)); }
public ActionResult DeleteConfirmed(int id) { //select the record for the id passed to delete from WebsiteReviews table WebsiteReview websiteReview = db.WebsiteReviews.Find(id); //Get the related primary key of Webuser var userid = websiteReview.WebUser.UserID; //Get the related primary key of Website var websiteid = websiteReview.Website.WebsiteID; //find record for the selected Primary Keys Website website = db.Websites.Find(websiteid); WebUser webuser = db.WebUsers.Find(userid); //Removing records from respective tables db.WebsiteReviews.Remove(websiteReview); db.Websites.Remove(website); db.WebUsers.Remove(webuser); //save the database db.SaveChanges(); //Captures tempdata from server to display operation completed successfully TempData["Message"] = "Review was successfully deleted"; return(RedirectToAction("Index")); }