public ActionResult Search(string ipValue)
{
var repo = new Repo();
List<DVD> results = repo.SearchForDVDTitle(ipValue);
return View(results);
}
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);
}
}