// GET: EBOOKs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EBOOK eBOOK = db.EBOOKS.Find(id);
if (eBOOK == null)
{
return(HttpNotFound());
}
if (Request.IsAuthenticated)
{
string time = System.DateTime.Now.ToString();
string membername = User.Identity.GetUserName();
var queryid = from d in db.MEMBERS where d.MEMBERNAME == membername select d.MEMBERID;
string memberid = queryid.ToList().First();
string check = "SELECT * FROM EBOOKHISTORY WHERE EBOOKID =" + id + " AND MEMBERID ='" + memberid + "'";
var checkquery = db.EBOOKCOLLECTINGs.SqlQuery(check);
if (checkquery.ToList().Count > 0)
{
string update = "update EBOOKHISTORY set BROWSETIME = to_date('" + time + "','yyyy-mm-dd hh24:mi:ss') where EBOOKID = " + id + " AND MEMBERID ='" + memberid + "'";
db.Database.ExecuteSqlCommand(update);
}
else
{
string insert = "INSERT INTO EBOOKHISTORY VALUES(" + id + ",'" + memberid + "', to_date('" + time + "','yyyy-mm-dd hh24:mi:ss'))";
db.Database.ExecuteSqlCommand(insert);
}
}
return(View(eBOOK));
}
// GET: EBOOKs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EBOOK eBOOK = db.EBOOKS.Find(id);
if (eBOOK == null)
{
return(HttpNotFound());
}
if (Request.IsAuthenticated)
{
string username = User.Identity.GetUserName();
var queryid = from d in db.MEMBERS where d.MEMBERNAME == username select d.MEMBERID;
string memberid = queryid.ToList().First();
string insert = "insert into EBOOKCOLLECTING values(" + id + ",'" + memberid + "')";
string check = "SELECT * FROM EBOOKCOLLECTING WHERE EBOOKID =" + id + " AND MEMBERID ='" + memberid + "'";
var checkquery = db.EBOOKCOLLECTINGs.SqlQuery(check);
if (checkquery.ToList().Count == 0)
{
db.Database.ExecuteSqlCommand(insert);
}
return(Content("<script>alert('收藏成功');history.go(-1);</script> "));
}
else
{
return(Content("<script>alert('请先登录!');history.go(-1);</script> "));
}
}
public ActionResult Edit([Bind(Include = "EBOOKID,EBOOKTYPE,EBOOKNAME")] EBOOK eBOOK)
{
if (ModelState.IsValid)
{
db.Entry(eBOOK).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(eBOOK));
}
