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