public IHttpActionResult PutBOOKS(int id, BOOKS bOOKS)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != bOOKS.BOOKID)
{
return(BadRequest());
}
db.Entry(bOOKS).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BOOKSExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Index()
{
if (Session["Password"] != null && Session["userName"] != null)
{
if (ModelState.IsValid)
{
BOOKCONTEXT ncc = new BOOKCONTEXT();
int lastbookId = ncc.allBook.Last().ID;
BOOKS b = ncc.allBook.Single(n => n.ID == lastbookId);
ViewBag.titlezA = b.BOOK_NAME;
ViewBag.messagezA = b.PREVIEW;
ViewBag.datezA = b.PublisherYear.ToShortDateString();
ViewBag.timezA = b.PublisherYear.ToShortTimeString();
ViewBag.idzA = b.ID;
List <BOOKS> LASTFIVE = ncc.allBook.Where(M => M.ID > lastbookId - 2).ToList();
List <BOOKS> F = ncc.allBook.ToList();
return(View(F));
}
}
else
{
return(RedirectToAction("Login"));
}
return(View());
}
public ActionResult GridViewPartialView()
{
// DXCOMMENT: Pass a data model for GridView in the PartialView method's second parameter
BOOKS bk = new BOOKS();
return(PartialView("GridViewPartialView", bk.getBook()));
}
public ActionResult Save(BOOKS sach, HttpPostedFileBase Hinhminhhoa)
{
if (ModelState.IsValid)
{
//sach.Donvitinh = "VND";
if (Hinhminhhoa != null && Hinhminhhoa.ContentLength > 0)
{
var TenAnh = Path.GetFileName(Hinhminhhoa.FileName);
var DuongDan = Path.Combine(Server.MapPath("~/Content/images/books/"), TenAnh);
sach.BOOK_URL = TenAnh;
Hinhminhhoa.SaveAs(DuongDan);
}
else
{
sach.BOOK_URL = "400x400.PNG";
}
//sach.Ngaycapnhat = DateTime.Now;
db.BOOKS.Add(sach);
db.SaveChanges();
return(RedirectToAction("TatCaSach"));
}
else
{
ViewBag.TatCaChuDe = db.GENRE.ToList();
ViewBag.TatCaTacGia = db.AUTHOR.ToList();
ViewBag.TatCaNXB = db.PUBLISHER.ToList();
return(View(sach));
}
}
public ActionResult CreateBook(BOOK bk)
{
BOOKS bks = new BOOKS();
bks.createBook(bk);
return(View());
}
public void AddBook(BOOKS bookadd)
{
string cms = @"insert into ELIBRARYBOOKS(AuthorName,VERSION,BOOK_NAME,BookID,Comment,Copies,CopyRightYear,MadeIn,PREVIEW,PublisherYear,DEPARTMENT,book_img,book_img2,book_img3) VALUES(@AuthorName, @VERSION, @BOOK_NAME, @BookID, @Comment, @Copies, @CopyRightYear, @MadeIn, @PREVIEW, @PublisherYear, @DEPARTMENT, @book_img , @book_img2 , @book_img3 )";
using (OleDbConnection con = new OleDbConnection(cs))
{
OleDbCommand cmd = new OleDbCommand(cms, con);
cmd.Parameters.AddWithValue("AuthorName", "@AuthorName").Value = bookadd.AuthorName;
cmd.Parameters.AddWithValue("VERSION", "@VERSION").Value = bookadd.VERSION;
cmd.Parameters.AddWithValue("BOOK_NAME", "@BOOK_NAME").Value = bookadd.BOOK_NAME;
cmd.Parameters.AddWithValue("BookID", "@BookID").Value = bookadd.BookID;
cmd.Parameters.AddWithValue("Comment", "@Comment").Value = bookadd.Comment;
cmd.Parameters.AddWithValue("Copies", "@Copies").Value = bookadd.Copies;
cmd.Parameters.AddWithValue("CopyRightYear", "@CopyRightYear").Value = bookadd.CopyRightYear;
cmd.Parameters.AddWithValue("MadeIn", "@MadeIn").Value = bookadd.MadeIn;
cmd.Parameters.AddWithValue("PREVIEW", "@PREVIEW").Value = bookadd.PREVIEW;
cmd.Parameters.AddWithValue("PublisherYear", "@PublisherYear").Value = bookadd.PublisherYear;
cmd.Parameters.AddWithValue("DEPARTMENT", "@DEPARTMENT").Value = bookadd.DEPARTMENT;
cmd.Parameters.AddWithValue("book_img", "@book_img").Value = bookadd.book_img;
cmd.Parameters.AddWithValue("book_img2", "@book_img2").Value = bookadd.book_img2;
cmd.Parameters.AddWithValue("book_img3", "@book_img3").Value = bookadd.book_img3;
con.Open();
cmd.ExecuteNonQuery();
}
}
public void Edit_book(BOOKS bookEdit)
{
string cms = @"UPDATE ELIBRARYBOOKS SET DEPARTMENT = @DEPARTMENT ,AuthorName=@AuthorName ,VERSION=@VERSION ,BOOK_NAME=@BOOK_NAME ,BookID=@BookID ,Comment=@Comment ,Copies=@Copies ,CopyRightYear=@CopyRightYear ,MadeIn=@MadeIn ,PREVIEW=@PREVIEW ,PublisherYear=@PublisherYear, book_img = @book_img , book_img2 = @book_img2 , book_img3 = @book_img3 WHERE ID = @ID";
using (OleDbConnection con = new OleDbConnection(cs))
{
OleDbCommand cmd = new OleDbCommand(cms, con);
cmd.Parameters.AddWithValue("DEPARTMENT", "@DEPARTMENT").Value = bookEdit.DEPARTMENT;
cmd.Parameters.AddWithValue("AuthorName", "@AuthorName").Value = bookEdit.AuthorName;
cmd.Parameters.AddWithValue("VERSION", "@VERSION").Value = bookEdit.VERSION;
cmd.Parameters.AddWithValue("BOOK_NAME", "@BOOK_NAME").Value = bookEdit.BOOK_NAME;
cmd.Parameters.AddWithValue("BookID", "@BookID").Value = bookEdit.BookID;
cmd.Parameters.AddWithValue("Comment", "@Comment").Value = bookEdit.Comment;
cmd.Parameters.AddWithValue("Copies", "@Copies").Value = bookEdit.Copies;
cmd.Parameters.AddWithValue("CopyRightYear", "@CopyRightYear").Value = bookEdit.CopyRightYear;
cmd.Parameters.AddWithValue("MadeIn", "@MadeIn").Value = bookEdit.MadeIn;
cmd.Parameters.AddWithValue("PREVIEW", "@PREVIEW").Value = bookEdit.PREVIEW;
cmd.Parameters.AddWithValue("PublisherYear", "@PublisherYear").Value = bookEdit.PublisherYear;
cmd.Parameters.AddWithValue("book_img", "@book_img").Value = bookEdit.book_img;
cmd.Parameters.AddWithValue("book_img3", "@book_img3").Value = bookEdit.book_img2;
cmd.Parameters.AddWithValue("book_img3", "@book_img3").Value = bookEdit.book_img3;
cmd.Parameters.AddWithValue("ID", "@ID").Value = bookEdit.ID;
con.Open();
cmd.ExecuteNonQuery();
}
}
public ActionResult Edit(BOOKS R, int[] selectedAuthors, int[] selectedGenres)
{
BOOKS nr = db.BOOKS.Find(R.BK_ID);
nr.BK_NAME = R.BK_NAME;
nr.BK_INFO = R.BK_INFO;
nr.BK_RATING = R.BK_RATING;
nr.BK_DAC = R.BK_DAC;
try
{
db.Entry(nr).State = EntityState.Modified;
db.SaveChanges();
var BA = from c in db.BOOKS join d in db.BOOKS_AUTHORS on c.BK_ID equals d.BA_BK where d.BA_BK == nr.BK_ID select d;
var BG = from c in db.BOOKS join d in db.BOOKS_GENRES on c.BK_ID equals d.BG_BK where d.BG_BK == nr.BK_ID select d;
db.BOOKS_GENRES.RemoveRange(BG);
db.BOOKS_AUTHORS.RemoveRange(BA);
ViewBag.CmpList = db.DICTIONARY_AGE_CATEGORIES.ToList();
ViewBag.a = (from i in db.AUTHORS where i.BOOKS_AUTHORS.Any(x => x.BA_BK == nr.BK_ID) select i).ToList();
ViewBag.g = (from i in db.GENRES where i.BOOKS_GENRES.Any(x => x.BG_BK == nr.BK_ID) select i).ToList();
ViewBag.Authors = db.AUTHORS.ToList();
ViewBag.Genres = db.GENRES.ToList();
if (selectedAuthors != null)
{
foreach (var c in db.AUTHORS.Where(co => selectedAuthors.Contains(co.AU_ID)))
{
BOOKS_AUTHORS my = new BOOKS_AUTHORS();
my.BA_AU = c.AU_ID;
my.BA_BK = nr.BK_ID;
db.BOOKS_AUTHORS.Add(my);
}
}
if (selectedGenres != null)
{
foreach (var c in db.GENRES.Where(co => selectedGenres.Contains(co.GN_ID)))
{
BOOKS_GENRES my = new BOOKS_GENRES();
my.BG_GN = c.GN_ID;
my.BG_BK = nr.BK_ID;
db.BOOKS_GENRES.Add(my);
}
}
db.SaveChanges();
return(RedirectToAction("BooksRender"));
}
catch { return(View(R)); }
}
public void testBOK()
{
BOOKS bks = new BOOKS();
BOOK bk = new BOOK();
bk.NAME = "ali";
bks.createBook(bk);
}
public ActionResult DeleteConfirmed(int id)
{
BOOKS bOOKS = db.BOOKS.Find(id);
db.BOOKS.Remove(bOOKS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Index()
{
// DXCOMMENT: Pass a data model for GridView
BOOKS bks = new BOOKS();
return(View(bks.getBook()));
}
public ActionResult Create_book_POST(BOOKS bOOk)
{
if (Session["matricn"] != null && Session["passw"] != null)
{
if (ModelState.IsValid)
{
string filename = Path.GetFileNameWithoutExtension(bOOk.imgFile.FileName);
string fileextension = Path.GetExtension(bOOk.imgFile.FileName);
filename += DateTime.Now.ToString("smyff") + fileextension;
bOOk.book_img = "~/imagesUploads/" + filename;
filename = Path.Combine(Server.MapPath("~/imagesUploads/"), filename);
bOOk.imgFile.SaveAs(filename);
string filename3 = Path.GetFileNameWithoutExtension(bOOk.imgFile3.FileName);
string fileextension3 = Path.GetExtension(bOOk.imgFile3.FileName);
filename3 += DateTime.Now.ToString("smyff") + fileextension3;
bOOk.book_img3 = "~/imagesUploads/" + filename3;
filename3 = Path.Combine(Server.MapPath("~/imagesUploads/"), filename3);
bOOk.imgFile3.SaveAs(filename3);
string filename2 = Path.GetFileNameWithoutExtension(bOOk.imgFile2.FileName);
string fileextension2 = Path.GetExtension(bOOk.imgFile2.FileName);
filename2 += DateTime.Now.ToString("smyff") + fileextension2;
bOOk.book_img2 = "~/imagesUploads/" + filename2;
filename2 = Path.Combine(Server.MapPath("~/imagesUploads/"), filename2);
bOOk.imgFile2.SaveAs(filename2);
BOOKCONTEXT bkc = new BOOKCONTEXT();
bkc.AddBook(bOOk);
return(RedirectToAction("index", "admin"));
}
return(View());
}
return(RedirectToAction("Login", "admin"));
}
public ActionResult Edit([Bind(Include = "BOOKID,BOOKNAME,AUTHOR,ISBN")] BOOKS bOOKS)
{
if (ModelState.IsValid)
{
db.Entry(bOOKS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bOOKS));
}
public ActionResult Edit([Bind(Include = "ID,BOOKNAME,AUTHOR,PUBLISH_UTC,VERSION_NUM,VERSION_NUM2,ISOK,LIST_PRICE")] BOOKS bOOKS)
{
if (ModelState.IsValid)
{
db.Entry(bOOKS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bOOKS));
}
public ActionResult Delete_get(int id)
{
if (Session["matricn"] != null && Session["passw"] != null)
{
BOOKCONTEXT bct = new BOOKCONTEXT();
BOOKS bk = bct.allBook.Where(alb => alb.ID == id).Single();
return(View(bk));
}
return(RedirectToAction("Login", "admin"));
}
public ActionResult Create([Bind(Include = "BOOKID,BOOKNAME,AUTHOR,ISBN")] BOOKS bOOKS)
{
if (ModelState.IsValid)
{
db.BOOKS.Add(bOOKS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bOOKS));
}
public ActionResult Create([Bind(Include = "ID,BOOKNAME,AUTHOR,PUBLISH_UTC,VERSION_NUM,VERSION_NUM2,ISOK,LIST_PRICE")] BOOKS bOOKS)
{
if (ModelState.IsValid)
{
db.BOOKS.Add(bOOKS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bOOKS));
}
public IHttpActionResult GetBOOKS(int id)
{
BOOKS bOOKS = db.BOOKS.Find(id);
if (bOOKS == null)
{
return(NotFound());
}
return(Ok(bOOKS));
}
public ActionResult Delete_post(BOOKS bookdel)
{
if (Session["matricn"] != null && Session["passw"] != null)
{
BOOKCONTEXT cldc = new BOOKCONTEXT();
cldc.Delete_book(bookdel);
return(RedirectToAction("Deletelist", "ADMIN"));
}
return(RedirectToAction("Login", "admin"));
}
public IHttpActionResult PostBOOKS(BOOKS bOOKS)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.BOOKS.Add(bOOKS);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = bOOKS.BOOKID }, bOOKS));
}
public ActionResult Create()
{
BOOKS R = new BOOKS();
ViewBag.a = (from i in db.AUTHORS where i.BOOKS_AUTHORS.Any(x => x.BA_BK == R.BK_ID) select i).ToList();
ViewBag.g = (from i in db.GENRES where i.BOOKS_GENRES.Any(x => x.BG_BK == R.BK_ID) select i).ToList();
ViewBag.CmpList = db.DICTIONARY_AGE_CATEGORIES.ToList();
ViewBag.Authors = db.AUTHORS.ToList();
ViewBag.Genres = db.GENRES.ToList();
return(View(R));
}
public ActionResult Edit([Bind(Include = "ID,TITLE,ISBN,CATEGORIES_ID,PUBLISHERS_ID")] BOOKS bOOKS)
{
if (ModelState.IsValid)
{
db.Entry(bOOKS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CATEGORIES_ID = new SelectList(db.CATEGORIES, "ID", "TITLE", bOOKS.CATEGORIES_ID);
ViewBag.PUBLISHERS_ID = new SelectList(db.PUBLISHERS, "ID", "NAME", bOOKS.PUBLISHERS_ID);
return(View(bOOKS));
}
public IHttpActionResult DeleteBOOKS(int id)
{
BOOKS bOOKS = db.BOOKS.Find(id);
if (bOOKS == null)
{
return(NotFound());
}
db.BOOKS.Remove(bOOKS);
db.SaveChanges();
return(Ok(bOOKS));
}
public void Delete_book(BOOKS bookDelete)
{
string cms = @"DELETE FROM ELIBRARYBOOKS WHERE ID = @ID";
using (OleDbConnection con = new OleDbConnection(cs))
{
OleDbCommand cmd = new OleDbCommand(cms, con);
cmd.Parameters.AddWithValue("ID", "@ID").Value = bookDelete.ID;
con.Open();
cmd.ExecuteNonQuery();
}
}
// GET: Home/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BOOKS bOOKS = db.BOOKS.Find(id);
if (bOOKS == null)
{
return(HttpNotFound());
}
return(View(bOOKS));
}
public JsonResult XoaSach(int MaSach)
{
try
{
BOOKS sach = db.BOOKS.Find(MaSach);
var ct = db.ORDERDETAIL.Where(x => x.BOOKS.ID == sach.ID);
db.BOOKS.Remove(sach);
db.SaveChanges();
return(Json(new { status = true }));
}
catch (Exception ex)
{
return(Json(new { status = false }));
}
}
// GET: BOOKS/Edit/5
public ActionResult Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BOOKS bOOKS = db.BOOKS.Find(id);
if (bOOKS == null)
{
return(HttpNotFound());
}
ViewBag.CATEGORIES_ID = new SelectList(db.CATEGORIES, "ID", "TITLE", bOOKS.CATEGORIES_ID);
ViewBag.PUBLISHERS_ID = new SelectList(db.PUBLISHERS, "ID", "NAME", bOOKS.PUBLISHERS_ID);
return(View(bOOKS));
}
public ActionResult SuaSach(int MaSach)
{
var TatCaChuDe = db.GENRE.ToList();
var TatCaTacGia = db.AUTHOR.ToList();
var TatCaNXB = db.PUBLISHER.ToList();
ViewBag.TatCaChuDe = TatCaChuDe;
ViewBag.TatCaTacGia = TatCaTacGia;
ViewBag.TatCaNXB = TatCaNXB;
BOOKS sach = db.BOOKS.Find(MaSach);
sach.PRICE = sach.PRICE != null ? sach.PRICE : 0;
//sach.Giakm = sach.Dongia != null ? sach.Giakm : 0;
sach.DESCRIPTION = sach.DESCRIPTION != null ? sach.DESCRIPTION : "Khong co mo ta";
sach.EXCERPT = sach.EXCERPT != null ? sach.EXCERPT : "khong co mo ta";
return(View(sach));
}
public ActionResult Details(int id)
{
if (Session["Password"] != null && Session["userName"] != null || Session["matricn"] != null && Session["passw"] != null)
{
if (ModelState.IsValid)
{
BOOKCONTEXT bct = new BOOKCONTEXT();
BOOKS bk = bct.allBook.Where(alb => alb.ID == id).Single();
return(View(bk));
}
}
else
{
return(RedirectToAction("Login"));
}
return(View());
}
public ActionResult CreateB(BOOKS R, int[] selectedAuthors, int[] selectedGenres)
{
try
{
ViewBag.CmpList = db.DICTIONARY_AGE_CATEGORIES.ToList();
ViewBag.Authors = db.AUTHORS.ToList();
ViewBag.Genres = db.GENRES.ToList();
ViewBag.a = (from i in db.AUTHORS where i.BOOKS_AUTHORS.Any(x => x.BA_BK == R.BK_ID) select i).ToList();
ViewBag.g = (from i in db.GENRES where i.BOOKS_GENRES.Any(x => x.BG_BK == R.BK_ID) select i).ToList();
if (ModelState.IsValid)
{
db.BOOKS.Add(R);
}
db.SaveChanges();
if (selectedAuthors != null)
{
foreach (var c in db.AUTHORS.Where(co => selectedAuthors.Contains(co.AU_ID)))
{
BOOKS_AUTHORS my = new BOOKS_AUTHORS();
my.BA_AU = c.AU_ID;
my.BA_BK = R.BK_ID;
db.BOOKS_AUTHORS.Add(my);
}
}
if (selectedGenres != null)
{
foreach (var c in db.GENRES.Where(co => selectedGenres.Contains(co.GN_ID)))
{
BOOKS_GENRES my = new BOOKS_GENRES();
my.BG_GN = c.GN_ID;
my.BG_BK = R.BK_ID;
db.BOOKS_GENRES.Add(my);
}
}
db.SaveChanges();
return(RedirectToAction("BooksRender"));
}
catch { return(View(R)); }
}
