public ActionResult AddBook() { var profileData = Session["UserProfile"] as UserSession; if (profileData == null) { return(RedirectToAction("Index", "Home")); } var publicationRepository = new PublicationRepository(); var contentRatingRepository = new ContentRatingRepository(); var authorRepository = new AuthorRepository(); var bookDetail = new BookDetails(); var bookModel = new BookModel(); ModelState.Clear(); bookModel.PublicationList = publicationRepository.GetAllPublication(); bookModel.ContentRatingList = contentRatingRepository.GetAllContentRating(); bookModel.BookTypeList = new List <String>() { "Reference Book", "Loan Book" }; bookDetail.BookModel = bookModel; bookDetail.AuthorList = authorRepository.GetAllAuthor(); return(View(bookDetail)); }
public ActionResult AddContentRating(ContentRatingModel contentRating) { try { if (ModelState.IsValid) { ContentRatingRepository ContentRatingRepo = new ContentRatingRepository(); ContentRatingRepo.AddContentRating(contentRating); var profileData = Session["UserProfile"] as UserSession; var logModel = new LogModel { UserId = profileData.UserID, TableName = "Content Rating", Activity = "Added Content Rating", LogDate = DateTime.Now }; var logRepository = new logRepository(); logRepository.AddLog(logModel); } return(RedirectToAction("GetAllContentRatingDetails")); } catch { return(RedirectToAction("GetAllContentRatingDetails")); } }
//// GET: Delete Book Details //[HttpPost] public ActionResult DeleteContentRating(int id) { var profileData = Session["UserProfile"] as UserSession; if (profileData == null) { return(RedirectToAction("Index", "Home")); } try { ContentRatingRepository ContentRatingRepo = new ContentRatingRepository(); if (ContentRatingRepo.DeleteContentRating(id)) { ViewBag.AlertMsg = "Book details deleted successfully"; } var logModel = new LogModel { UserId = profileData.UserID, TableName = "Author", Activity = "Deleted Author", LogDate = DateTime.Now }; var logRepository = new logRepository(); logRepository.AddLog(logModel); return(RedirectToAction("GetAllContentRatingDetails")); } catch { return(RedirectToAction("GetAllContentRatingDetails")); } }
// GET: Update Book Details public ActionResult EditContentRatingDetails(int id) { var profileData = Session["UserProfile"] as UserSession; if (profileData == null) { return(RedirectToAction("Index", "Home")); } ContentRatingRepository ContentRatingRepo = new ContentRatingRepository(); return(View(ContentRatingRepo.GetAllContentRating().Find(ContentRatings => ContentRatings.ContentRatingId == id))); }
//GET: All Book Details public ActionResult GetAllContentRatingDetails() { var profileData = Session["UserProfile"] as UserSession; if (profileData == null) { return(RedirectToAction("Index", "Home")); } ContentRatingRepository ContentRatingRepo = new ContentRatingRepository(); ModelState.Clear(); return(View(ContentRatingRepo.GetAllContentRating())); }
public ActionResult GetBook(int id) { var profileData = Session["UserProfile"] as UserSession; if (profileData == null) { return(RedirectToAction("Index", "Home")); } BookRepository bookRepository = new BookRepository(); BookAuthorRepository bookAuthorRepository = new BookAuthorRepository(); AuthorRepository authorRepository = new AuthorRepository(); PublicationRepository publicationRepository = new PublicationRepository(); ContentRatingRepository contentRatingRepository = new ContentRatingRepository(); List <BookAuthorModel> bookAuthorList = new List <BookAuthorModel>(); BookDetails bookDetail = new BookDetails(); BookModel book = new BookModel(); book = bookRepository.SearchBookById(id); bookDetail.BookModel = book; bookAuthorList = bookAuthorRepository.GetByBookId(book.BookId); if (bookAuthorList.Count == 1) { bookDetail.AuthorInfo1 = authorRepository.GetByAuthorId(bookAuthorList[0].AuthorId); } else if (bookAuthorList.Count == 2) { bookDetail.AuthorInfo1 = authorRepository.GetByAuthorId(bookAuthorList[0].AuthorId); bookDetail.AuthorInfo2 = authorRepository.GetByAuthorId(bookAuthorList[1].AuthorId); } else { bookDetail.AuthorInfo1 = authorRepository.GetByAuthorId(bookAuthorList[0].AuthorId); bookDetail.AuthorInfo2 = authorRepository.GetByAuthorId(bookAuthorList[1].AuthorId); bookDetail.AuthorInfo3 = authorRepository.GetByAuthorId(bookAuthorList[2].AuthorId); } bookDetail.PublicationModel = publicationRepository.GetByPublicationId(book.PublicationId); bookDetail.ContentRatingModel = contentRatingRepository.GetByContentId(book.ContentRatingId); return(View(bookDetail)); }
public ActionResult EditContentRatingDetails(int id, ContentRatingModel contentRating) { try { ContentRatingRepository ContentRatingRepo = new ContentRatingRepository(); ContentRatingRepo.UpdateContentRating(contentRating); var profileData = Session["UserProfile"] as UserSession; var logModel = new LogModel { UserId = profileData.UserID, TableName = "Content Rating", Activity = "Updated Rating", LogDate = DateTime.Now }; var logRepository = new logRepository(); logRepository.AddLog(logModel); return(RedirectToAction("GetAllContentRatingDetails")); } catch { return(RedirectToAction("GetAllContentRatingDetails")); } }
public ActionResult AddLoan(LoanModel loanModel) { try { LoanRepository loanRepository = new LoanRepository(); copiesRepository copiesRepository = new copiesRepository(); BookRepository bookRepository = new BookRepository(); ContentRatingRepository contentRatingRepository = new ContentRatingRepository(); MemberRepository memberRepository = new MemberRepository(); MembershipRepository membershipRepository = new MembershipRepository(); List <MemberModel> memberList = new List <MemberModel>(); LoanModel newLoanModel = new LoanModel(); newLoanModel.MemberList = memberRepository.GetAllMember(); CopiesModel copiesModel = new CopiesModel(); copiesModel = copiesRepository.SearchCopyById(loanModel.CopiesId); BookModel bookModel = new BookModel(); bookModel = bookRepository.SearchBookById(copiesModel.BookId); if (bookModel.BookType.Equals("Reference Book")) { ViewBag.Message = "Reference Books Can't be Loaned"; return(View(newLoanModel)); } ContentRatingModel contentRatingModel = new ContentRatingModel(); contentRatingModel = contentRatingRepository.GetByContentId(bookModel.ContentRatingId); MemberModel memberModel = new MemberModel(); memberModel = memberRepository.SearchMemberById(loanModel.MembershipId); if (contentRatingModel.ContentRatingName.Equals("18+")) { var today = DateTime.Today; var age = Convert.ToDateTime(memberModel.Dob); var todayAge = today.Year - age.Year; if (todayAge < 18) { ViewBag.Message = "Age Restricted Books Are Not Allowed"; return(View(newLoanModel)); } } MembershipModel membershipModel = new MembershipModel(); membershipModel = membershipRepository.GetMembershipByID(memberModel.MembershipId); BookCopies bookCopiesModel = new BookCopies(); bookCopiesModel = loanRepository.GetAllLoanByMemberID(memberModel.MemberId); if (bookCopiesModel.Quantities >= membershipModel.NoOfBooks) { ViewBag.Message = "No More Books Can be Loaned"; return(View(newLoanModel)); } DateTime returnedDate = Convert.ToDateTime(loanModel.LoanDate); loanModel.ReturnDate = returnedDate.AddDays(14).ToString("yyyy MMMM dd"); loanRepository.AddLoan(loanModel); copiesRepository.UpdateCopiesStatus(loanModel.CopiesId); var profileData = Session["UserProfile"] as UserSession; var logModel = new LogModel { UserId = profileData.UserID, TableName = "Loan", Activity = "Added Loan", LogDate = DateTime.Now }; var logRepository = new logRepository(); logRepository.AddLog(logModel); return(RedirectToAction("Dashboard", "Home")); } catch { return(RedirectToAction("Index", "Home")); } }