public void CanGetAll(bool expected)
{
DvdRepositoryEF repo = new DvdRepositoryEF();
var allDvds = repo.GetAll();
bool actual = allDvds != null;
while (actual)
{
actual = allDvds[0].DvdId == 1;
actual = allDvds[0].Title == "Mad Max: Fury Road";
actual = allDvds[0].RealeaseYear == 2015;
actual = allDvds[0].Director == "George Miller";
actual = allDvds[0].Rating == "R";
actual = allDvds[0].Notes == "Some critics say \"Thirty-six viewings in a row is the only reasonable way to watch this film.\"";
actual = allDvds[9].DvdId == 10;
actual = allDvds[9].Title == "Boyz N The Hood";
actual = allDvds[9].RealeaseYear == 1992;
actual = allDvds[9].Director == "John Singleton";
actual = allDvds[9].Rating == "R";
actual = allDvds[9].Notes == "";
break;
}
Assert.AreEqual(expected, actual);
}
public void EFCanEditDvd()
{
DvdRepositoryEF repo = new DvdRepositoryEF();
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);
dvdToAdd.Title = "Pulp Fiction";
dvdToAdd.Director = "Quentin Tarantino";
dvdToAdd.ReleaseYear = 1998;
dvdToAdd.Notes = "classic movie";
repo.EditDvd(dvdToAdd);
var updatedDvd = repo.GetDvd(4);
Assert.AreEqual("Pulp Fiction", updatedDvd.Title);
Assert.AreEqual("Quentin Tarantino", updatedDvd.Director);
Assert.AreEqual("R", updatedDvd.Rating);
Assert.AreEqual(1998, updatedDvd.ReleaseYear);
Assert.AreEqual("classic movie", updatedDvd.Notes);
}
public void EFCanUpdate(int id, string title, int releaseYear, string rating, string director, string notes, bool expected)
{
bool actual = false;
Dvd dvd = new Dvd
{
DvdId = id,
Title = title,
ReleaseYear = releaseYear,
Rating = rating,
Director = director,
Notes = notes
};
var repo = new DvdRepositoryEF();
Dvd dvdCheck = repo.Get(id);
if (dvdCheck != null)
{
repo.Update(dvd);
dvdCheck = repo.Get(id);
if (dvdCheck.Title == "Test")
{
actual = true;
}
}
Assert.AreEqual(expected, actual);
}
public void EFCanLoadDirectors()
{
var repo = new DvdRepositoryEF();
var directors = repo.GetDirectors();
Assert.AreEqual(4, directors.Count());
}
public void CanAddDvd()
{
var repo = new DvdRepositoryEF();
Dvd dvdAdd = new Dvd();
var preAdd = repo.GetAll();
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 postAdd = repo.GetAll();
Assert.AreEqual(preAdd.Count + 1, postAdd.Count);
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);
}
public void EFCanLoadRatings()
{
var repo = new DvdRepositoryEF();
var ratings = repo.GetRatings();
Assert.AreEqual(5, ratings.Count());
}
public void EFCanGetByYear()
{
var repo = new DvdRepositoryEF();
var dvds = repo.GetByYear(2030);
Assert.AreEqual(1, dvds.Count());
}
public void EFCanLoadDvds()
{
var repo = new DvdRepositoryEF();
var dvds = repo.GetAllDvd();
Assert.AreEqual(4, dvds.Count());
}
public void CanEditDvd(int id, string title, int year, string director, string rating, string notes, bool expected)
{
DvdRepositoryEF repo = new DvdRepositoryEF();
Dvd edit = new Dvd()
{
Title = title, Director = director, RealeaseYear = year, Rating = rating, Notes = notes
};
repo.EditDvd(edit, id);
Dvd dvd = repo.GetById(id);
bool actual;
if (dvd == null)
{
actual = false;
}
else
{
actual = (dvd.DvdId == id &&
dvd.Title == title &&
dvd.RealeaseYear == year &&
dvd.Director == director &&
dvd.Rating == rating &&
dvd.Notes == notes);
}
Assert.AreEqual(expected, actual);
}
public void CanUpdateDvd()
{
Dvd dvdToCreate = new Dvd();
var repo = new DvdRepositoryEF();
dvdToCreate.DvdId = 4;
dvdToCreate.Title = "BOB";
dvdToCreate.ReleaseYear = 2054;
dvdToCreate.Director = "Smith";
dvdToCreate.Rating = "R";
dvdToCreate.Notes = "Coolio";
repo.CreateDvd(dvdToCreate);
repo.UpdateDvd(dvdToCreate);
var dvdId = 3;
var updatedDvd = repo.GetDvdByID(dvdId);
Assert.AreEqual("A Truly Awesome Tale", updatedDvd.Title);
Assert.AreEqual(2018, updatedDvd.ReleaseYear);
Assert.AreEqual("Johnny Cash", updatedDvd.Director);
Assert.AreEqual("NR", updatedDvd.Rating);
Assert.AreEqual("This is a truly awesome tale!", updatedDvd.Notes);
}
public void EFNotFoundDvdReturnsNull()
{
DvdRepositoryEF repo = new DvdRepositoryEF();
var dvd = repo.GetDvd(1000000000);
Assert.IsNull(dvd);
}
public void EFGetAllTest()
{
var repo = new DvdRepositoryEF();
List <Dvd> dvds = repo.GetAll();
Assert.IsNotNull(dvds);
}
public void EFCanRemoveDvd(int dvdId, bool expected)
{
DvdRepositoryEF repo = new DvdRepositoryEF();
bool result = repo.DeleteDvd(dvdId);
Assert.AreEqual(result, expected);
}
public void EFCanLoadDvdsByRating()
{
DvdRepositoryEF repo = new DvdRepositoryEF();
var dvds = repo.GetDvdsByRating("R");
Assert.AreEqual(2, dvds.Count);
}
public void EFCanLoadDvdsByYear()
{
DvdRepositoryEF repo = new DvdRepositoryEF();
var dvds = repo.GetDvdsByDate(1999);
Assert.AreEqual(2, dvds.Count);
}
public void EFCanListDvdsById(int dvdId, bool expected)
{
DvdRepositoryEF repo = new DvdRepositoryEF();
Dvd dvd = repo.GetDvd(dvdId);
bool result = !(dvd is null);
Assert.AreEqual(result, expected);
}
public void EFCanListDvds(bool expected)
{
DvdRepositoryEF repo = new DvdRepositoryEF();
List <Dvd> list = repo.GetDvdList();
bool result = list.Count > 0;
Assert.AreEqual(result, expected);
}
public void GetDvdByRating()
{
var repo = new DvdRepositoryEF();
List <Dvd> dvds = repo.GetDvdsbyRating("R");
Assert.AreEqual(3, dvds.Count);
}
public void EFCanLoadDvdsByDirector()
{
DvdRepositoryEF repo = new DvdRepositoryEF();
var dvds = repo.GetDvdsByDirector("Director A");
Assert.AreEqual(2, dvds.Count);
}
public void EFCanGetDvdById()
{
var repo = new DvdRepositoryEF();
var dvd = repo.GetById(2);
Assert.AreEqual(2, dvd.DvdId);
Assert.AreEqual("That old movie", dvd.Title);
Assert.AreEqual(1444, dvd.ReleaseYear);
}
public void CanLoadDvds()
{
var repo = new DvdRepositoryEF();
var dvd = repo.GetAll();
Assert.AreEqual(3, dvd.Count);
Assert.AreEqual("True Hollywood Stories", dvd[0].Title);
}
public void EFCanDeleteDvd()
{
var repo = new DvdRepositoryEF();
int dvdId = 4;
repo.Delete(dvdId);
Assert.AreEqual(3, repo.GetAllDvd().Count());
}
public void GetDvdByTitle()
{
var repo = new DvdRepositoryEF();
List <Dvd> dvds = repo.GetDvdsByTitle("East West Bowl");
Assert.AreEqual(2, dvds[0].DvdId);
Assert.AreEqual("Hingle McCringleberry", dvds[0].DirectorName);
}
public void NotFoundDvdReturnsNull()
{
var repo = new DvdRepositoryEF();
var dvdId = 1000;
var dvd = repo.GetDvdByID(dvdId);
Assert.IsNull(dvd);
}
public void EFCanModifyDvd(int dvdId, string title, int releaseYear, int directorId, int ratingId, string note, bool expected)
{
DvdRepositoryEF repo = new DvdRepositoryEF();
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 EFCanGetByDirector()
{
var repo = new DvdRepositoryEF();
var dvds = repo.GetByDirector("John");
Assert.AreEqual(1, dvds.Count());
var dvd = repo.GetByDirector("Jacob");
Assert.AreEqual(1, dvd.Count());
}
public void EFCanGetByRating()
{
var repo = new DvdRepositoryEF();
var dvds = repo.GetByRating("G");
Assert.AreEqual(1, dvds.Count());
var dvd = repo.GetByRating("PG-13");
Assert.AreEqual(1, dvd.Count());
}
public void EFCanGetByTitle()
{
var repo = new DvdRepositoryEF();
var dvds = repo.GetByTitle("A Movie");
Assert.AreEqual(1, dvds.Count());
var nullDvd = repo.GetByTitle("None");
Assert.AreEqual(0, nullDvd.Count());
}
public void GetDvdById()
{
var repo = new DvdRepositoryEF();
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 GetDvdByDirector()
{
var repo = new DvdRepositoryEF();
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);
}