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"));
}
