//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);
}
