public ActionResult DeleteConfirmed(int id) { userbook userbook = db.userbooks.Find(id); db.userbooks.Remove(userbook); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "userid,gbid,isread,reviewbody,urating")] userbook userbook) { if (ModelState.IsValid) { db.Entry(userbook).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.userid = new SelectList(db.users, "userid", "password", userbook.userid); return(View(userbook)); }
// GET: userbooks/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } userbook userbook = db.userbooks.Find(id); if (userbook == null) { return(HttpNotFound()); } return(View(userbook)); }
// GET: userbooks/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } userbook userbook = db.userbooks.Find(id); if (userbook == null) { return(HttpNotFound()); } ViewBag.userid = new SelectList(db.users, "userid", "password", userbook.userid); return(View(userbook)); }
public void addReview(String rev, String gbid, int uid) { userbook ub = db.userbooks.Find(uid, gbid); if (ub != null) { ub.reviewbody = rev; } else { NewUserBook(gbid, uid, true); userbook ub1 = db.userbooks.Find(uid, gbid); ub1.reviewbody = rev; } db.SaveChanges(); }
public void NewUserBook(string id, int uid, bool isRead) { userbook ub = new userbook { gbid = id, userid = uid, isread = isRead }; var amount = (from usb in db.userbooks where (usb.userid == uid) && (usb.gbid == id) select usb).Count(); if (amount == 0) { db.userbooks.Add(ub); db.SaveChanges(); } }