public ContentRatingModel GetByContentId(int id) { Connection(); List <ContentRatingModel> contentList = new List <ContentRatingModel>(); ContentRatingModel contentRatingModel = new ContentRatingModel(); SqlCommand command = new SqlCommand("GetContentRatingByID", _connect); command.Parameters.AddWithValue("@ContentRatingID", id); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter dataAdapter = new SqlDataAdapter(command); DataTable dataTable = new DataTable(); _connect.Open(); dataAdapter.Fill(dataTable); _connect.Close(); //Bind AuthorModel generic list using LINQ contentList = (from DataRow dataRow in dataTable.Rows select new ContentRatingModel() { ContentRatingId = Convert.ToInt32(dataRow["ContentRatingID"]), ContentRatingName = Convert.ToString(dataRow["ContentRating"]), }).ToList(); contentRatingModel = contentList[0]; return(contentRatingModel); }
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")); } }
//To Add ContentRating details public bool AddContentRating(ContentRatingModel obj) { Connection(); SqlCommand command = new SqlCommand("AddNewContentRating", _connect); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ContentRating", obj.ContentRatingName); _connect.Open(); var i = command.ExecuteNonQuery(); _connect.Close(); if (i >= 1) { return(true); } else { return(false); } }
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")); } }