public ActionResult RenewTransaction(string id) { string bookId = string.Empty; try { BookTranscationTable bookTransactionTable = new BookTranscationTable(db); BookTranscation currentTransaction = bookTransactionTable.GetBookTransactionById(id); if (currentTransaction != null) { currentTransaction.DueDate = currentTransaction.DueDate.AddDays(Convert.ToDouble(WebConfigurationManager.AppSettings[ProjectConstants.BookDueDateDays])); currentTransaction.BookStatus = BookTransactionStatus.Renewed.ToString(); bookTransactionTable.RenewBook(currentTransaction); bookId = Convert.ToString(currentTransaction.BookID); } else { return(RedirectToAction(ProjectConstants.ListBookTranscation)); } } catch (Exception) { throw; } return(RedirectToAction(ProjectConstants.RenewBook, new { @id = bookId })); }
public ActionResult ReturnTransaction(string id) { string bookId = string.Empty; try { BookTranscationTable bookTransactionTable = new BookTranscationTable(db); BookTranscation currentTransaction = bookTransactionTable.GetBookTransactionById(id); if (currentTransaction != null) { currentTransaction.BookStatus = BookTransactionStatus.Returned.ToString(); bookTransactionTable.RenewBook(currentTransaction); bookId = Convert.ToString(currentTransaction.BookID); } else { return(RedirectToAction(ProjectConstants.ListBookTranscation)); } } catch (Exception) { throw; } return(RedirectToAction(ProjectConstants.ReturnBook, new { @id = bookId })); }
public ActionResult ReturnBook(string id) { BookTranscationTable bookTranscationTable = new BookTranscationTable(db); IEnumerable <BookTranscation> edittranscations = bookTranscationTable.GetBookTransactionsByBookId(Convert.ToInt32(id), true); return(View(edittranscations)); }
public ActionResult IssueBook(BookTranscation booktranscation) { if (ModelState.IsValid) { BookTranscationTable bookTranscation = new BookTranscationTable(db); bookTranscation.Insert(booktranscation); } return(View(ProjectConstants.IssueBook)); }
public void GetBookTransactionById_Null() { Mock <IDatabase> mock = new Mock <IDatabase>(); BookTranscationTable booktable = new BookTranscationTable(mock.Object); List <Dictionary <string, string> > result = new List <Dictionary <string, string> >(); mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result); Assert.AreEqual(null, booktable.GetBookTransactionById("1")); }
public void DeleteByTranscationId() { Mock <IDatabase> mock = new Mock <IDatabase>(); mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1); BookTranscationTable booktable = new BookTranscationTable(mock.Object); int result = booktable.DeleteByTranscationId("25"); Assert.AreEqual(1, result); }
public void GetBookTransactionById_ExpectedException() { Mock <IDatabase> mock = new Mock <IDatabase>(); BookTranscationTable booktable = new BookTranscationTable(mock.Object); Dictionary <string, string> parameter = new Dictionary <string, string>(); List <Dictionary <string, string> > result = new List <Dictionary <string, string> >(); parameter.Add("new", "test"); result.Add(parameter); mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result); Assert.IsInstanceOfType(booktable.GetBookTransactionById("1"), typeof(BookTranscation)); }
public void GetBookTransactionCountByBookId() { Mock <IDatabase> mock = new Mock <IDatabase>(); BookTranscationTable booktable = new BookTranscationTable(mock.Object); Dictionary <string, string> parameter = new Dictionary <string, string>(); List <Dictionary <string, string> > result = new List <Dictionary <string, string> >(); parameter.Add("Book_ID", "1"); result.Add(parameter); mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result); Assert.AreEqual(1, booktable.GetBookTransactionCountByBookId(1, true)); }
public void RenewBook() { Mock <IDatabase> mock = new Mock <IDatabase>(); mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1); BookTranscationTable booktable = new BookTranscationTable(mock.Object); BookTranscation book = new BookTranscation(); book.SetTranscationID(1); book.SetBookStatus("Renewed"); book.SetDueDate(DateTime.Now); int result = booktable.Insert(book); Assert.AreEqual(1, result); }
public void GetBookTransactionById_Valid() { Mock <IDatabase> mock = new Mock <IDatabase>(); BookTranscationTable booktable = new BookTranscationTable(mock.Object); Dictionary <string, string> parameter = new Dictionary <string, string>(); List <Dictionary <string, string> > result = new List <Dictionary <string, string> >(); parameter.Add("Transcation_ID", "20"); parameter.Add("Book_ID", "4080"); parameter.Add("BookStatus", "Renewed"); parameter.Add("Member_ID", "10"); parameter.Add("Due_Date", "2018-07-22 17:35:23"); parameter.Add("Date_of_issue", "2018-07-22 17:35:23"); result.Add(parameter); mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result); Assert.IsInstanceOfType(booktable.GetBookTransactionById("20"), typeof(BookTranscation)); }
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)); }
public void GetBooksForIssue() { Mock <IDatabase> mock = new Mock <IDatabase>(); BookTranscationTable booktable = new BookTranscationTable(mock.Object); Dictionary <string, string> parameter = new Dictionary <string, string>(); List <Dictionary <string, string> > result = new List <Dictionary <string, string> >(); parameter.Add("Author", "test"); parameter.Add("Book_id", "9"); parameter.Add("No_of_books", "10"); parameter.Add("Name", "test"); parameter.Add("Rack_No", "11"); parameter.Add("Status", "test"); result.Add(parameter); mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result); Book book = new Book(); Assert.IsInstanceOfType(booktable.GetBooksForIssue(), typeof(List <Book>)); }