public ActionResult Add()
{
var dvd = new DVD();
dvd.CastMembers = new List<Cast>();
dvd.CastMembers.Add(new Cast());
dvd.CastMembers[0].CastRoleName = "actor";
return View(dvd);
}
public ActionResult Add(DVD dvd)
{
if (ModelState.IsValid)
{
var repo = new Repo();
repo.AddDVD(dvd);
return RedirectToAction("Index", "Home");
}
else
{
return View(dvd);
}
}
public void AddDVD_AddSucceeds_Test(string test_title)
{
DVD expected = new DVD()
{
Title = test_title,
CastMembers = new List<Cast>()
{
new Cast() {CastFirstName = "Dolan", CastLastName = "Dcuk", CastRoleName = "actor" },
new Cast() {CastFirstName = "Uncel", CastLastName = "Scroge", CastRoleName = "actor" },
new Cast() {CastFirstName = "Blue", CastLastName = "Meanie", CastRoleName = "actor" }
},
ReleaseDate = new DateTime(2001, 1, 1),
MPAA = "PG",
Studio = "Balooney Pictures",
};
Settings set = new Settings(connectionString);
Repo repo = new Repo();
int newID = repo.AddDVD(expected);
string title = "";
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = $"SELECT TOP 1 * FROM DVDs WHERE Title = '{test_title}' AND dvdID = {newID}";
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
title = dr["Title"].ToString();
}
}
Assert.AreEqual(expected.Title, title);
DynamicParameters p = new DynamicParameters();
p.Add("dvdID", newID);
cn.Query("EraseDVDRecord", p, commandType: CommandType.StoredProcedure);
}
}
public int AddDVD(DVD dvd)
{
List<CastRole> Roles;
using (SqlConnection cn = new SqlConnection(ConnString))
{
Roles = cn.Query<CastRole>("GetAllRoles", commandType: CommandType.StoredProcedure).ToList();
DynamicParameters p = new DynamicParameters();
p.Add("dvdID", DbType.Int32, direction: ParameterDirection.Output);
p.Add("Title", dvd.Title);
p.Add("ReleaseDate", dvd.ReleaseDate?.ToString());
p.Add("MPAA", dvd.MPAA);
p.Add("Studio", dvd.Studio);
cn.Query("AddDVD", p, commandType: CommandType.StoredProcedure);
int dvdID = p.Get<int>("dvdID");
foreach (Cast c in dvd.CastMembers)
{
p = new DynamicParameters();
p.Add("FirstName", c.CastFirstName);
p.Add("LastName", c.CastLastName);
p.Add("CastID", DbType.Int32, direction: ParameterDirection.ReturnValue);
cn.Query("AddCast", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
int castID = p.Get<int>("CastID");
p = new DynamicParameters();
p.Add("dvdID", dvdID);
p.Add("CastID", castID);
p.Add("CastRoleID", Roles.FirstOrDefault(cr => cr.CastRoleName == c.CastRoleName).CastRoleID);
cn.Query("AddCastDetails", p, commandType: CommandType.StoredProcedure);
}
return dvdID;
}
}
public void AddRating_NotBoundToBorrowHistory(int userID, int rating, string note)
{
DVD toRate = new DVD()
{
Title = "RateThis",
CastMembers = new List<Cast>()
};
Settings set = new Settings(connectionString);
Repo repo = new Repo();
int newID = repo.AddDVD(toRate);
repo.AddRating(newID, userID, rating, note);
DVD result = repo.FillInDetails(newID);
Assert.AreEqual(rating, result.History[0].DVDRating);
Assert.AreEqual(note, result.History[0].DVDNote);
using (SqlConnection cn = new SqlConnection(connectionString))
{
DynamicParameters p = new DynamicParameters();
p.Add("dvdID", newID);
cn.Query("EraseDVDRecord", p, commandType: CommandType.StoredProcedure);
}
}
public void SearchByTitle_FullMatch(string fakeTitle)
{
DVD searchMe = new DVD()
{
Title = fakeTitle,
CastMembers = new List<Cast>(),
};
Settings set = new Settings(connectionString);
Repo repo = new Repo();
int newID = repo.AddDVD(searchMe);
int wantedID = 0;
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = $"SELECT TOP 1 * FROM DVDs WHERE Title = '{fakeTitle}' AND dvdID = {newID}";
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
wantedID = (int)dr["dvdID"];
}
}
List<DVD> results = repo.SearchForDVDTitle(fakeTitle);
Assert.AreEqual(wantedID, results.FirstOrDefault().dvdID);
DynamicParameters p = new DynamicParameters();
p.Add("dvdID", newID);
cn.Query("EraseDVDRecord", p, commandType: CommandType.StoredProcedure);
}
}
public void FillInDetails_DetailMatch_Top1_Test()
{
Settings set = new Settings(connectionString);
Repo repo = new Repo();
DVD expectedDetails = new DVD();
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT TOP 1 d.*, ar.AverageRating FROM DVDs d FULL JOIN(SELECT AVG(r.DVDRating) AS AverageRating, r.dvdID FROM Ratings r GROUP BY r.dvdID) AS ar on ar.dvdID = d.dvdID WHERE Deleted IS NULL OR Deleted <> 1";
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
expectedDetails.dvdID = (int)dr["dvdID"];
expectedDetails.Title = dr["Title"].ToString();
expectedDetails.ReleaseDate = DateTime.Parse(dr["ReleaseDate"].ToString());
expectedDetails.MPAA = dr["MPAA"].ToString();
expectedDetails.Studio = dr["Studio"].ToString();
expectedDetails.AverageRating = (int)dr["AverageRating"];
}
}
}
DVD dvd_detailed = repo.FillInDetails(1);
Assert.AreEqual(expectedDetails.dvdID, dvd_detailed.dvdID);
Assert.AreEqual(expectedDetails.AverageRating, dvd_detailed.AverageRating);
Assert.AreEqual(expectedDetails.MPAA, dvd_detailed.MPAA);
Assert.AreEqual(expectedDetails.ReleaseDate, dvd_detailed.ReleaseDate);
Assert.AreEqual(expectedDetails.Studio, dvd_detailed.Studio);
}
public void Borrow_And_Return_DVDs(bool borrow)
{
DVD toBorrow = new DVD()
{
Title = "BorrowThis",
CastMembers = new List<Cast>()
};
Settings set = new Settings(connectionString);
Repo repo = new Repo();
int newID = repo.AddDVD(toBorrow);
repo.DVD_BorrowReturn(1, newID, true);
List<DVD> dvds = repo.GetList();
Assert.IsTrue(!dvds.FirstOrDefault(d => d.Title == "BorrowThis" && d.dvdID == newID).Available);
if (!borrow)
{
repo.DVD_BorrowReturn(1, newID, false);
dvds = repo.GetList();
Assert.IsTrue(dvds.FirstOrDefault(d => d.Title == "BorrowThis" && d.dvdID == newID).Available);
}
using (SqlConnection cn = new SqlConnection(connectionString))
{
DynamicParameters p = new DynamicParameters();
p.Add("dvdID", newID);
cn.Query("EraseDVDRecord", p, commandType: CommandType.StoredProcedure);
}
}
public void Update(DVD updatedDVD)
{
_DVD.RemoveAll(c => c.DvdId == updatedDVD.DvdId);
_DVD.Add(updatedDVD);
}
