public void GetDvdByDirector()
{
var repo = new DvdRepositoryADO();
List <Dvd> dvds = repo.GetDvdsbyDirector("Tron");
Assert.AreEqual(3, dvds[0].DvdId);
Assert.AreEqual("The Mad Real World", dvds[0].Title);
Assert.AreEqual(2012, dvds[0].ReleaseYear);
Assert.AreEqual("R", dvds[0].RatingType);
}
public void ADOCanModifyDvd(int dvdId, string title, int releaseYear, int directorId, int ratingId, string note, bool expected)
{
DvdRepositoryADO repo = new DvdRepositoryADO();
Dvd dvd = new Dvd {
DvdId = dvdId, Title = title, ReleaseYear = releaseYear, DirectorId = directorId, RatingId = ratingId, Note = note
};
bool result = repo.UpdateDvd(dvd);
Assert.AreEqual(result, expected);
}
public void CanLoadDvdById()
{
var repo = new DvdRepositoryADO();
Dvd dvd = repo.GetById(5);
Assert.AreEqual("12 Angry Men", dvd.Title);
Assert.AreEqual(1957, dvd.ReleaseYear);
Assert.AreEqual("Sidney Lumet", dvd.Director);
Assert.AreEqual("PG", dvd.Rating);
Assert.AreEqual("A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.", dvd.Notes);
}
public void GetDvdById()
{
var repo = new DvdRepositoryADO();
var dvd = repo.GetDvdById(1);
Assert.AreEqual("True Hollywood Stories", dvd.Title);
Assert.AreEqual(2017, dvd.ReleaseYear);
Assert.AreEqual("Charlie Murphy", dvd.DirectorName);
Assert.AreEqual("R", dvd.RatingType);
}
public void CanLoadDvd()
{
var repo = new DvdRepositoryADO();
var dvds = repo.GetAllDvds();
Assert.AreEqual(2, dvds.Count);
Assert.AreEqual("The Lion King", dvds[0].Title);
Assert.AreEqual(2010, dvds[1].ReleaseYear);
Assert.AreEqual("Ehhhhh", dvds[1].Notes);
Assert.AreNotEqual("Some Guy", dvds[1].Director);
}
public void CanDeleteDvd()
{
Dvd dvd = new Dvd();
var repo = new DvdRepositoryADO();
repo.Delete(4);
var dvds = repo.GetAll();
Assert.AreEqual(13, dvds.Count());
Assert.AreEqual(null, repo.GetById(4));
}
public void CanGetDvdById()
{
var repo = new DvdRepositoryADO();
var dvd = repo.GetDvdByID(1);
Assert.AreEqual(1, dvd.DvdId);
Assert.AreEqual("The Lion King", dvd.Title);
Assert.AreEqual(1992, dvd.ReleaseYear);
Assert.AreNotEqual("Ehhhhh", dvd.Notes);
Assert.AreEqual("Some Guy", dvd.Director);
}
public void CanDeleteDvd()
{
var repo = new DvdRepositoryADO();
var preDelete = repo.GetAll();
repo.DeleteDvd(3);
var postDelete = repo.GetAll();
Assert.AreEqual(preDelete.Count - 1, postDelete.Count());
}
public void CanLoadADODvd()
{
var repo = new DvdRepositoryADO();
var dvd = repo.GetById(1);
Assert.IsNotNull(dvd);
Assert.AreEqual(1, dvd.DvdId);
Assert.AreEqual("Manhattan", dvd.Title);
Assert.AreEqual(1979, dvd.ReleaseYear);
Assert.AreEqual("Allen", dvd.DirectorName);
Assert.AreEqual("PG-13", dvd.RatingName);
Assert.AreEqual("A Woody Allen classic", dvd.Notes);
}
public void ADOCanLoadDvdById()
{
DvdRepositoryADO repo = new DvdRepositoryADO();
var dvd = repo.GetDvd(1);
Assert.IsNotNull(dvd);
Assert.AreEqual(1, dvd.DvdId);
Assert.AreEqual("Office Space", dvd.Title);
Assert.AreEqual("Director A", dvd.Director);
Assert.AreEqual("R", dvd.Rating);
Assert.AreEqual(1999, dvd.ReleaseYear);
Assert.AreEqual("funny movie", dvd.Notes);
}
public void ADOCanLoadDvdsByTitle()
{
DvdRepositoryADO repo = new DvdRepositoryADO();
var dvds = repo.GetDvdsByTitle("Office Space");
Assert.AreEqual(1, dvds.Count);
Assert.AreEqual("Office Space", dvds[0].Title);
Assert.AreEqual("Director A", dvds[0].Director);
Assert.AreEqual("R", dvds[0].Rating);
Assert.AreEqual(1999, dvds[0].ReleaseYear);
Assert.AreEqual("funny movie", dvds[0].Notes);
}
public void CanGetDvdsByRating()
{
var repo = new DvdRepositoryADO();
var dvds = repo.GetDvdByRating("PG");
Assert.IsNotNull(dvds);
Assert.AreEqual(2, dvds.Count());
Assert.AreEqual("The Lion King", dvds[0].Title);
Assert.AreNotEqual("The Lion King", dvds[1].Title);
Assert.AreEqual(1992, dvds[0].ReleaseYear);
Assert.AreEqual("PG", dvds[0].Rating);
Assert.AreEqual("PG", dvds[1].Rating);
}
public void ADOGetDvdById()
{
var repo = new DvdRepositoryADO();
int id = 1;
var dvd = repo.GetById(id);
Assert.AreEqual(1, dvd.DvdId);
Assert.AreEqual("That one movie", dvd.Title);
Assert.AreEqual(1995, dvd.ReleaseYear);
Assert.AreEqual("Jingleheimer", dvd.Director);
Assert.AreEqual("G", dvd.Rating);
Assert.AreEqual("It was ok", dvd.Notes);
}
public void CanLoadDvds()
{
var repo = new DvdRepositoryADO();
var dvds = repo.GetAll().ToList();
Assert.AreEqual(14, dvds.Count());
Assert.AreEqual("12 Angry Men", dvds[4].Title);
Assert.AreEqual(1957, dvds[4].ReleaseYear);
Assert.AreEqual("Sidney Lumet", dvds[4].Director);
Assert.AreEqual("PG", dvds[4].Rating);
Assert.AreEqual("A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.", dvds[4].Notes);
}
public void ADOGetByYear(int year, bool expected)
{
var repo = new DvdRepositoryADO();
List <Dvd> dvds = repo.GetAllByYear(year);
bool actual = false;
if (dvds != null)
{
actual = true;
}
Assert.AreEqual(expected, actual);
}
public void ADOGetTest(int id, bool expected)
{
var repo = new DvdRepositoryADO();
Dvd dvd = repo.Get(id);
bool actual = false;
if (dvd != null)
{
actual = true;
}
Assert.AreEqual(expected, actual);
}
public void ADOGetByTitleTest(string title, bool expected)
{
var repo = new DvdRepositoryADO();
List <Dvd> dvds = repo.GetAllByTitle(title);
bool actual = false;
if (dvds != null)
{
actual = true;
}
Assert.AreEqual(expected, actual);
}
public void ADOGetByRating(string rating, bool expected)
{
var repo = new DvdRepositoryADO();
List <Dvd> dvds = repo.GetAllByRating(rating);
bool actual = false;
if (dvds != null)
{
actual = true;
}
Assert.AreEqual(expected, actual);
}
public void CanDeleteDvd(int id, bool expected)
{
DvdRepositoryADO repo = new DvdRepositoryADO();
bool actual = repo.GetAll().Any(d => d.DvdId == id);
if (actual)
{
repo.DeleteDvd(id);
actual = !(repo.GetAll().Any(d => d.DvdId == id));
}
Assert.AreEqual(expected, actual);
}
public void ADOCanAddDvd()
{
DvdRepositoryADO repo = new DvdRepositoryADO();
Dvd dvdToAdd = new Dvd();
dvdToAdd.Title = "Grand Budapest Hotel";
dvdToAdd.Director = "Director B";
dvdToAdd.Rating = "R";
dvdToAdd.ReleaseYear = 2005;
dvdToAdd.Notes = "funny movie";
repo.AddDvd(dvdToAdd);
Assert.AreEqual(4, dvdToAdd.DvdId);
}
public void ADOGetDvdByDirector()
{
var repo = new DvdRepositoryADO();
string director = "John";
var dvd = repo.GetByDirector(director);
Assert.AreEqual(1, dvd.Count());
Assert.AreEqual(2, dvd[0].DvdId);
Assert.AreEqual("That old movie", dvd[0].Title);
Assert.AreEqual(1444, dvd[0].ReleaseYear);
Assert.AreEqual("John", dvd[0].Director);
Assert.AreEqual("PG-13", dvd[0].Rating);
Assert.AreEqual("Movie did not age well", dvd[0].Notes);
}
public void CanAddADODvd()
{
Dvd DvdToAdd = new Dvd();
var repo = new DvdRepositoryADO();
DvdToAdd.Title = "My test Dvd";
DvdToAdd.ReleaseYear = 2020;
DvdToAdd.DirectorName = "TestDirector";
DvdToAdd.RatingName = "R";
DvdToAdd.Notes = "This is for my test";
repo.Insert(DvdToAdd);
Assert.AreEqual(5, DvdToAdd.DvdId);
}
public void ADOCanAddDvd()
{
Dvd dvdToAdd = new Dvd();
var repo = new DvdRepositoryADO();
string title = "Brand new movie";
int releaseYear = 2017;
string directorName = "NewDirector";
string ratingName = "PG";
string notes = "It's brand new";
repo.SaveNew(title, releaseYear, directorName, ratingName, notes);
Assert.AreEqual(5, repo.GetAllDvd().Count());
}
public void ADOGetDvdByTitle()
{
var repo = new DvdRepositoryADO();
string title = "That other movie";
var dvd = repo.GetByTitle(title);
Assert.AreEqual(1, dvd.Count());
Assert.AreEqual(3, dvd[0].DvdId);
Assert.AreEqual("That other movie", dvd[0].Title);
Assert.AreEqual(2030, dvd[0].ReleaseYear);
Assert.AreEqual("Jacob", dvd[0].Director);
Assert.AreEqual("R", dvd[0].Rating);
Assert.AreEqual("A ways off", dvd[0].Notes);
}
public void CanAddDvd()
{
Dvd dvd = new Dvd();
var repo = new DvdRepositoryADO();
dvd.Title = "The Lord of the Rings: The Two Towers";
dvd.ReleaseYear = 2002;
dvd.Director = "Peter Jackson";
dvd.Rating = "PG-13";
dvd.Notes = "While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron's new ally, Saruman, and his hordes of Isengard.";
repo.Insert(dvd);
Assert.AreEqual(15, dvd.DvdId);
Assert.AreEqual("The Lord of the Rings: The Two Towers", dvd.Title);
}
public void CanEditDvd()
{
var repo = new DvdRepositoryADO();
//Dvd dvd = new Dvd();
var preEdit = repo.GetDvdById(1);
preEdit.Title = "Pimp Chronicles";
preEdit.DirectorName = "Buck Nasty";
repo.EditDvd(preEdit);
var postEdit = repo.GetDvdById(1);
Assert.AreEqual("Pimp Chronicles", postEdit.Title);
Assert.AreEqual("Buck Nasty", postEdit.DirectorName);
}
public void CanGetByRating(string rating, bool expected)
{
DvdRepositoryADO repo = new DvdRepositoryADO();
List <Dvd> result = repo.GetByRating(rating);
bool actual;
if (result.Count == 0)
{
actual = false;
}
else
{
actual = result.All(d => d.Rating == rating);
}
Assert.AreEqual(expected, actual);
}
public void CanGetById(int id, bool expected)
{
DvdRepositoryADO repo = new DvdRepositoryADO();
Dvd result = repo.GetById(id);
bool actual;
if (result == null)
{
actual = false;
}
else
{
actual = (result.DvdId == id);
}
Assert.AreEqual(expected, actual);
}
public void CanGetByTitle(string title, bool expected)
{
DvdRepositoryADO repo = new DvdRepositoryADO();
List <Dvd> result = repo.GetByTitle(title);
bool actual;
if (result.Count == 0)
{
actual = false;
}
else
{
actual = result.All(d => d.Title == title);
}
Assert.AreEqual(expected, actual);
}
public void CanAddDvd()
{
var repo = new DvdRepositoryADO();
Dvd dvdAdd = new Dvd();
dvdAdd.Title = "A Player Hater's Ball";
dvdAdd.ReleaseYear = 1977;
dvdAdd.DirectorName = "Silky Johnson";
dvdAdd.RatingType = "G";
dvdAdd.Notes = "The most diabolical haters this side of the Mississippi!";
repo.AddDvd(dvdAdd);
var newDvd = repo.GetDvdById(4);
Assert.AreEqual("A Player Hater's Ball", newDvd.Title);
Assert.AreEqual(1977, newDvd.ReleaseYear);
Assert.AreEqual("Silky Johnson", newDvd.DirectorName);
Assert.AreEqual("G", newDvd.RatingType);
}