public ActionResult DeleteIt(int id)
{
var repo = new Repo();
repo.DeleteDVD(id);
return RedirectToAction("Index", "Home");
}
public void DeleteDVD_Top1_DeletedDVD_DoesNotShowUpInList(int ID_to_mark)
{
Settings set = new Settings(connectionString);
Repo repo = new Repo();
List<int> expectedIDs = new List<int>();
repo.DeleteDVD(ID_to_mark);
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM DVDs WHERE Deleted IS NULL OR Deleted <> 1";
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
expectedIDs.Add((int)dr["dvdID"]);
}
}
}
Assert.IsTrue(!expectedIDs.Contains(ID_to_mark));
repo.RestoreDVD(ID_to_mark);
}