//Rent DVD from DVDs Statuses Page with drop down user public ActionResult RentDVD(ViewMovieDVDsVM vM) { //Library method to rent DVD based on DVDID and BorrowerID var rentalTicket = new RentalTicket(); rentalTicket.BorrowerId = vM.Borrower.BorrowerId; rentalTicket.DVDId = vM.DVDIdToRent; rentalTicket.DateBorrowed = DateTime.Now.Date; rentalTicket.MovieId = vM.MovieId; var newRentalTicket = _oops.RentDVD(rentalTicket); return RedirectToAction("ViewDVDsStatus", "Home", new {id = newRentalTicket.MovieId}); }
//Rent DVD (send to DB) public RentalTicket RentDVDSendToDb(RentalTicket rentalTicket) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); p.Add("BorrowerID", rentalTicket.BorrowerId); p.Add("DVDID", rentalTicket.DVDId); p.Add("DateBorrowed", rentalTicket.DateBorrowed); p.Add("BorrowerStatusID", DbType.Int32, direction: ParameterDirection.Output); cn.Execute("RentDVDToBorrowerStatuses", p, commandType: CommandType.StoredProcedure); rentalTicket.BorrowerStatusId = p.Get<int>("BorrowerStatusID"); } return rentalTicket; }
public void TestRentDVDSendToDb() { RentalTicket newRental = new RentalTicket() { DVDId = 2, BorrowerId = 1, DateBorrowed = DateTime.Now.Date }; var result = repo.RentDVDSendToDb(newRental).BorrowerStatusId; Assert.AreEqual(result, 30); }