public IHttpActionResult PosttblBook(tblBook tblBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblBooks.Add(tblBook);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (tblBookExists(tblBook.ISBN))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = tblBook.ISBN }, tblBook));
}
// Accepts the book return request.
public ActionResult AcceptReturn(int?tranId)
{
/*try
* {*/
if (tranId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblTransaction transaction = transDb.tblTransactions.FirstOrDefault(t => t.TranId == tranId);
if (transaction == null)
{
return(HttpNotFound());
}
tblBook book = bookDb.tblBooks.FirstOrDefault(b => b.BookId == transaction.BookId);
book.BookCopies = book.BookCopies + 1;
bookDb.SaveChanges();
transDb.tblTransactions.Remove(transaction);
transDb.SaveChanges();
return(View("Return"));
/*}
* catch (Exception)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }*/
}
// Cancel book request, redirected to requested
public ActionResult DeleteRequest(int?tranId)
{
/*try
* {*/
if (tranId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblTransaction transaction = transDb.tblTransactions.FirstOrDefault(t => t.TranId == tranId);
if (transaction == null)
{
return(HttpNotFound());
}
tblBook book = bookDb.tblBooks.FirstOrDefault(b => b.BookId == transaction.BookId);
book.BookCopies = book.BookCopies + 1;
bookDb.SaveChanges();
transDb.tblTransactions.Remove(transaction);
transDb.SaveChanges();
return(RedirectToAction("Requested", "UserTransaction", new { userId = userId }));
/* }
* catch (Exception)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }*/
}
// Rerequest book request, redirected to rejected
public ActionResult RerequestRejected(int?tranId)
{
/*try
* {*/
if (tranId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblTransaction transaction = transDb.tblTransactions.FirstOrDefault(t => t.TranId == tranId);
if (transaction == null)
{
return(HttpNotFound());
}
transaction.TranStatus = "Requested";
transaction.TranDate = DateTime.Now.ToShortDateString();
tblBook book = bookDb.tblBooks.FirstOrDefault(b => b.BookId == transaction.BookId);
book.BookCopies = book.BookCopies - 1;
bookDb.SaveChanges();
transDb.SaveChanges();
return(RedirectToAction("Rejected", "UserTransaction", new { userId = userId }));
/*}
* catch (Exception)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }*/
}
public ActionResult Create(tblBook b, HttpPostedFileBase Picture)
{
List <tblCategory> list = db.tblCategories.ToList();
ViewBag.CatList = new SelectList(list, "CatId", "Name");
if (ModelState.IsValid)
{
tblBook book = new tblBook();
book.Author = b.Author;
book.Description = b.Description;
book.Edition = b.Edition;
book.ISBN = b.ISBN;
book.Publisher = b.Publisher;
book.Picture = Picture.FileName.ToString();
book.Title = b.Title;
book.Unit = b.Unit;
//Picture Upload
var folder = Server.MapPath("~/Uploads/");
Picture.SaveAs(Path.Combine(folder, Picture.FileName.ToString()));
db.tblBooks.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
TempData["msg"] = "Book Not Uploaded";
}
return(View());
}
public IHttpActionResult PuttblBook(string id, tblBook tblBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblBook.ISBN)
{
return(BadRequest());
}
db.Entry(tblBook).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblBookExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public String InsertBook(tblBook book)
{
try
{
bdb.tblBooks.Add(book);
bdb.SaveChanges();
return("Data Added Successfully");
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult DeleteConfirmed(int id)
{
tblBook tblBook = bookDb.tblBooks.Find(id);
bookDb.tblBooks.Remove(tblBook);
bookDb.SaveChanges();
return(RedirectToAction("Index"));
}
public String DeleteBookData(int bid)
{
tblBook bdata = bdb.tblBooks.Find(bid);
bdb.tblBooks.Remove(bdata);
bdb.SaveChanges();
return("Data deleted Successfully");
}
public void ChecktblBook()
{
tblBook book = new tblBook();
book.author = "Johnson";
Assert.IsNotNull(book);
Assert.AreEqual("Johnson", book.author);
}
protected void btnDeleteBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text)).First();
db.DeleteObject(tbl);
db.SaveChanges();
populateBooks();
}
public ActionResult Edit([Bind(Include = "BookId,BookTitle,BookCategory,BookAuthor,BookCopies,BookPub,BookPubName,BookISBN,Copyright,DateAdded,Status")] tblBook tblBook)
{
if (ModelState.IsValid)
{
Session["operationMsg"] = "Book updated successfully";
bookDb.Entry(tblBook).State = EntityState.Modified;
bookDb.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblBook));
}
public ActionResult Edit([Bind(Include = "BookId,BookTitle,BookCategory,BookAuthor,BookCopies,Copyright,DateAdded,Statuss,Descrip,Detail,Images1,Images2,Images3,Images")] tblBook tblBook, HttpPostedFileBase Images)
{
if (ModelState.IsValid)
{
if (Images != null)
{
string filename = Path.GetFileName(Images.FileName);
string _filename = DateTime.Now.ToString("yymmssff") + filename;
string extension = Path.GetExtension(Images.FileName);
string path = Path.Combine(Server.MapPath("~/Content/Images/"), _filename);
tblBook.Images = _filename;
if (extension.ToLower() == ".jpg" || extension.ToLower() == ".png" || extension.ToLower() == ".jpeg")
{
if (Images.ContentLength <= 100000000)
{
bookDb.Entry(tblBook).State = EntityState.Modified;
string oldImgPath = Request.MapPath(Session["imgPath"].ToString());
//bookDb.tblBooks.Add(tblBook);
if (bookDb.SaveChanges() > 0)
{
Images.SaveAs(path);
if (System.IO.File.Exists(oldImgPath))
{
System.IO.File.Delete(oldImgPath);
}
Session["operationMsg"] = "Book updated successfully";
}
}
else
{
ViewBag.Mess = "Không đúng định dạng";
return(View());
}
return(RedirectToAction("Index"));
}
}
//Session["operationMsg"] = "Book updated successfully";
//bookDb.Entry(tblBook).State = EntityState.Modified;
//bookDb.SaveChanges();
//return RedirectToAction("Index");
}
else
{
tblBook.Images = Session["imgPath"].ToString();
bookDb.Entry(tblBook).State = EntityState.Modified;
if (bookDb.SaveChanges() > 0)
{
Session["operationMsg"] = "Book updated successfully";
return(RedirectToAction("Index"));
}
}
return(View(tblBook));
}
public ActionResult LCreate([Bind(Include = "BookId,BookTitle,BookCategory,BookAuthor,BookCopies,BookPub,BookPubName,BookISBN,Copyright,DateAdded,Status")] tblBook tblBook)
{
if (ModelState.IsValid)
{
// Session["operationMsg"] = "Book added successfully";
bookDb.tblBooks.Add(tblBook);
bookDb.SaveChanges();
return(RedirectToAction("LIndex"));
}
return(View(tblBook));
}
public tblBook UpdateStudentData(int bid, tblBook b)
{
tblBook bdata = bdb.tblBooks.Find(bid);
bdata.bname = b.bname;
bdata.author = b.author;
bdata.pub = b.pub;
bdata.sub = b.sub;
bdb.SaveChanges();
return(bdata);
}
public IHttpActionResult GettblBook(string id)
{
tblBook tblBook = db.tblBooks.Find(id);
if (tblBook == null)
{
return(NotFound());
}
return(Ok(tblBook));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text.ToString())).First();
txtTitle.Text = tbl.title;
txtAuthor.Text = tbl.author;
txtPublication.Text = tbl.publication;
txtSubject.Text = tbl.subject;
txtBooksQnty.Text = tbl.no_of_copies.ToString();
}
// Borrow the book, redirect to index view.
public ActionResult Borrow(int?bookId)
{
/*try
* {*/
if (transDb.tblTransactions.Where(t => t.UserId == userId).Count() < 6)
{
if (bookId != null)
{
tblBook book = bookDb.tblBooks.FirstOrDefault(b => b.BookId == bookId);
if (book == null)
{
return(HttpNotFound());
}
if (book.BookCopies > 0)
{
book.BookCopies = book.BookCopies - 1;
tblTransaction trans = new tblTransaction()
{
BookId = book.BookId,
BookTitle = book.BookTitle,
BookISBN = book.BookISBN,
TranDate = DateTime.Now.ToShortDateString(),
TranStatus = "Requested",
UserId = userId,
UserName = userName,
};
bookDb.SaveChanges();
transDb.tblTransactions.Add(trans);
transDb.SaveChanges();
Session["requestMsg"] = "Requested successfully";
}
else
{
Session["requestMsg"] = "Sorry you cant take, Book copy is zero";
}
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
else
{
Session["requestMsg"] = "Sorry you cant take more than six books";
}
return(RedirectToAction("Index", "Borrow", new { userId = userId, userName = userName }));
/*}
* catch (Exception)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }*/
}
public void SaveBook(tblBook book)
{
if (book.BookId == 0)
{
db.tblBooks.Add(book);
}
else
{
db.Entry(book).State = EntityState.Modified;
}
db.SaveChanges();
}
public ActionResult Create(tblBook tblBook, HttpPostedFileBase file)
{
if (!isStaff())
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
//check params, check duplicate
if (tblBook.ID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook book = db.tblBooks.Find(tblBook.ID);
if (book != null)
{
ViewBag.CreateMessage = "Book ID is already exist";
return(View());
}
//pass check - create new
//save file
string textPath = "/Images/no_image.jpg"; //default is noimages
if (file != null)
{
string path = Path.Combine(Server.MapPath("~/Images"), tblBook.ID + Path.GetFileName(file.FileName));
file.SaveAs(path);
textPath = "/Images/" + tblBook.ID + file.FileName;
}
book = new tblBook()
{
Name = tblBook.Name,
AddDate = DateTime.Now,
Author = tblBook.Author,
Catagories = tblBook.Catagories,
Description = tblBook.Description,
ID = tblBook.ID,
Place = tblBook.Place,
Status = tblBook.Status,
CoverPicture = textPath
};
db.tblBooks.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblBook));
}
public IHttpActionResult DeletetblBook(string id)
{
tblBook tblBook = db.tblBooks.Find(id);
if (tblBook == null)
{
return(NotFound());
}
db.tblBooks.Remove(tblBook);
db.SaveChanges();
return(Ok(tblBook));
}
public ActionResult ReadBookIII(int?bookId)
{
if (bookId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook book = bookDb.tblBooks.FirstOrDefault(t => t.BookId == bookId);
if (book == null)
{
return(HttpNotFound());
}
return(View(book));
}
// GET: BookManage/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook tblBook = db.tblBooks.Find(id);
if (tblBook == null)
{
return(HttpNotFound());
}
return(View(tblBook));
}
// GET: tblBooks/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook tblBook = bookDb.tblBooks.Find(id);
if (tblBook == null)
{
return(HttpNotFound());
}
return(View(tblBook));
}
protected void btnInsertBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = new tblBook();
tbl.title = txtTitle.Text;
tbl.author = txtAuthor.Text;
tbl.publication = txtPublication.Text;
tbl.subject = txtSubject.Text;
tbl.no_of_copies = int.Parse(txtBooksQnty.Text);
db.AddTotblBooks(tbl);
db.SaveChanges();
populateBooks();
}
// GET: tblBooks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblBook tblBook = bookDb.tblBooks.Find(id);
Session["imgPath"] = tblBook.Images;
if (tblBook == null)
{
return(HttpNotFound());
}
return(View(tblBook));
}
protected void btnUpdateBooks_Click(object sender, EventArgs e)
{
BCC_DOTNET_LMSEntities db = new BCC_DOTNET_LMSEntities();
tblBook tbl = db.tblBooks.ToList().Where(x => x.code == int.Parse(txtCode.Text)).First();
tbl.title = txtTitle.Text;
tbl.author = txtAuthor.Text;
tbl.publication = txtPublication.Text;
tbl.subject = txtSubject.Text;
tbl.no_of_copies = int.Parse(txtBooksQnty.Text);
db.SaveChanges();
populateBooks();
}
public IHttpActionResult GetBookData(int bid)
{
try {
tblBook b = bdb.tblBooks.Find(bid);
if (b != null)
{
return(Content(HttpStatusCode.OK, b));
}
else
{
return(Content(HttpStatusCode.NoContent, "No data found with Book Id " + bid));
}
} catch (Exception) {
return(Content(HttpStatusCode.InternalServerError, "Something went wrong."));
}
}
public IHttpActionResult DeleteStdData(int bid)
{
try {
tblBook bk = bdb.tblBooks.Find(bid);
if (bk != null)
{
bdb.tblBooks.Remove(bk);
return(Content(HttpStatusCode.OK, "Data Deleted Successfully"));
}
else
{
return(Content(HttpStatusCode.NoContent, "No data found with Book Id " + bid));
}
} catch (Exception) {
return(Content(HttpStatusCode.InternalServerError, "Something went wrong."));
}
}
protected void btnAddBook_Click(object sender, EventArgs e)
{
BookFactory BF = new BookFactory();
tblBook book = new tblBook();
book.BookTitle = txtBookTitle.Text;
book.BookCategoryId = ddlCategory.SelectedIndex;
book.Price = double.Parse(txtPrice.Text);
book.Edition = int.Parse(txtEdition.Text);
book.Release_Year = txtYearReleased.Text;
book.Quantity = 1;
book.isAvailable = chkIsAvailable.Checked;
BF.SaveBook(book);
lblMessage.Text = "Book Added Successfully";
cleardata();
}
