public ActionResult EditBook(Book book)
{
// Get the Specific Book by Id
BookTable bookTable = new BookTable(db);
bookTable.Update(book);
return(RedirectToActionPermanent(ProjectConstants.ListBook));
}
private void refreshBTN_Click(object sender, EventArgs e)
{
BindingSource bSource = new BindingSource();
bSource.DataSource = BookTable;
BookTable.DataSource = bSource;
BookTable.Update();
BookTable.Refresh();
}
public void Update()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1);
BookTable booktable = new BookTable(mock.Object);
Book book = new Book();
book.SetName("TestBook");
book.SetAuthor("TestSuthor");
book.SetStatus("available");
book.SetPrice(25);
book.SetRackno(5);
book.SetCount(10);
int result = booktable.Update(book);
Assert.AreEqual(1, result);
}
public ActionResult Issue(BookTransactionViewModel transactionViewModel)
{
try
{
if (transactionViewModel == null)
{
throw new ArgumentException(ProjectConstants.InvalidTransactionMsg);
}
MemberTable memberTable = new MemberTable(db);
LibMember member = memberTable.GetMemberById(Convert.ToString(transactionViewModel.MemberID));
if (member == null)
{
ModelState.AddModelError(string.Empty, ProjectConstants.MemberIdNotExistMsg);
return(View(transactionViewModel));
}
BookTable bookTable = new BookTable(db);
Book book = bookTable.GetBookById(Convert.ToString(transactionViewModel.BookID));
BookTranscationTable bookTranscationTable = new BookTranscationTable(db);
BookTranscation bookTranscation = new BookTranscation()
{
BookID = transactionViewModel.BookID, BookStatus = transactionViewModel.BookStatus, MemberID = transactionViewModel.MemberID,
DateofIssue = transactionViewModel.DateofIssue, DueDate = transactionViewModel.DueDate
};
bookTranscationTable.Insert(bookTranscation);
int existingBookTransactionCount = bookTranscationTable.GetBookTransactionCountByBookId(bookTranscation.BookID);
if (existingBookTransactionCount >= book.Count)
{
// update the book status as Not Available
book.Status = BookStatus.NotAvailable.ToString();
bookTable.Update(book);
}
}
catch (Exception)
{
throw;
}
return(RedirectToAction(ProjectConstants.ListBookTranscation));
}
