public void TestQuotesForMovie()
{
//insert into MediaLib.dbo.MediaSet (Title, OriginalTitle, Genre, Rating, Pending)
//values ('Der Terminator', 'The Terminator', 'Action', 3.44, 'false');
// Produkt(Movie) wird gesucht. Von gefundenen Produkt wird mediaID genommen.
var controllerSearch = new SearchController();
var resultSearch = controllerSearch.ResultMovies("Der Terminator") as ViewResult;
var produktSearch = (List <Movie>)resultSearch.ViewData.Model;
int mediaID = produktSearch.Single <Movie>().Id;
//insert into MediaLib.dbo.QuoteSet (QuoteString, Character, Language, Invocations, UserId, MediaId)
// Mit dem mediID wird alle Zitates gesucht. Diese Movie hat vier Zitates.
var controllerQuote = new QuoteController();
var resultQuote = controllerQuote.ShowQuotesMedia(mediaID) as ViewResult;
var produktQuote = (Movie)resultQuote.ViewData.Model;
// 1 Quote
//values ('I''ll be back', 'The Terminator', 'English', 1, 1, 1);
String gesuchteQuote1 = "I'll be back";
Assert.AreEqual(gesuchteQuote1, produktQuote.Quote.ElementAt <Quote>(0).QuoteString);
Assert.AreEqual("The Terminator", produktQuote.Quote.ElementAt <Quote>(0).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(0).Language);
// 2 Quote
// values ('Not yet. Not for about 40 years.', 'Kyle Reese', 'English', 2, 1, 1);
String gesuchteQuote2 = "Not yet. Not for about 40 years.";
Assert.AreEqual(gesuchteQuote2, produktQuote.Quote.ElementAt <Quote>(1).QuoteString);
Assert.AreEqual("Kyle Reese", produktQuote.Quote.ElementAt <Quote>(1).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(1).Language);
// 3 Quote
// values ('Reese. Why me? Why does it want me?', 'Sarah Connor', 'English', 8, 1, 1);
String gesuchteQuote3 = "Reese. Why me? Why does it want me?";
Assert.AreEqual(gesuchteQuote3, produktQuote.Quote.ElementAt <Quote>(2).QuoteString);
Assert.AreEqual("Sarah Connor", produktQuote.Quote.ElementAt <Quote>(2).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(2).Language);
// 4 Quote
// values ('Your clothes... give them to me, now.', 'The Terminator', 'English', 6, 1, 1);
String gesuchteQuote4 = "Your clothes... give them to me, now.";
Assert.AreEqual(gesuchteQuote4, produktQuote.Quote.ElementAt <Quote>(3).QuoteString);
Assert.AreEqual("The Terminator", produktQuote.Quote.ElementAt <Quote>(3).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(3).Language);
}
public void TestQuotesForTvShow()
{
//insert into MediaLib.dbo.MediaSet (Title, OriginalTitle, Genre, Rating, Pending)
//values ('South Park', 'South Park', 'Comedy', 5, 'false');
// Produkt(TvShow) wird gesucht. Von gefundenen Produkt wird mediaID genommen.
var controllerSearch = new SearchController();
var resultSearch = controllerSearch.ResultTvShows("South Park") as ViewResult;
var produktSearch = (List <TV_Show>)resultSearch.ViewData.Model;
int mediaID = produktSearch.Single <TV_Show>().Id;
//insert into MediaLib.dbo.QuoteSet (QuoteString, Character, Language, Invocations, UserId, MediaId)
// Mit dem mediID wird alle Zitates gesucht. Diese Movie hat drei Zitates.
var controllerQuote = new QuoteController();
var resultQuote = controllerQuote.ShowQuotesMedia(mediaID) as ViewResult;
var produktQuote = (TV_Show)resultQuote.ViewData.Model;
// Quote 1
// values ('TIMAH.', 'Timmy', 'English', 10, 1, 6);
String gesuchteQuote1 = "TIMAH.";
Assert.AreEqual(gesuchteQuote1, produktQuote.Quote.ElementAt <Quote>(0).QuoteString);
Assert.AreEqual("Timmy", produktQuote.Quote.ElementAt <Quote>(0).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(0).Language);
// Quote 2
// values ('Drugs are bad, mkay ...', 'Mr. Mackey', 'English', 4, 1, 6);
String gesuchteQuote2 = "Drugs are bad, mkay ...";
Assert.AreEqual(gesuchteQuote2, produktQuote.Quote.ElementAt <Quote>(1).QuoteString);
Assert.AreEqual("Mr. Mackey", produktQuote.Quote.ElementAt <Quote>(1).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(1).Language);
// Quote 3
// values ('How do you kill, that which has no life? ', 'Blizzard Employee', 'English', 5, 1, 6);
String gesuchteQuote3 = "How do you kill, that which has no life? ";
Assert.AreEqual(gesuchteQuote3, produktQuote.Quote.ElementAt <Quote>(2).QuoteString);
Assert.AreEqual("Blizzard Employee", produktQuote.Quote.ElementAt <Quote>(2).Character);
Assert.AreEqual("English", produktQuote.Quote.ElementAt <Quote>(2).Language);
}
public void TestQuotesForBook()
{
//insert into MediaLib.dbo.MediaSet (Title, OriginalTitle, Genre, Rating, Pending)
//values ('In einer kleinen Stadt', 'Needful Things', 'Horror', 2.41, 'false');
// Produkt(Book) wird gesucht. Von gefundenen Produkt wird mediaID genommen.
var controllerSearch = new SearchController();
var resultSearch = controllerSearch.ResultBooks("In einer kleinen Stadt") as ViewResult;
var produktSearch = (List <Book>)resultSearch.ViewData.Model;
int mediaID = produktSearch.Single <Book>().Id;
// Mit dem mediID wird alle Zitates gesucht. Diese Buch hat nur ein Zitat.
//insert into MediaLib.dbo.QuoteSet (QuoteString, Character, Language, Invocations, UserId, MediaId)
//Quote
//values ('It''s aggravations I mostly want to talk about-- can you sit a spell with me?'
//, 'Old-Timer', 'English', 0, 1, 9);
var controllerQuote = new QuoteController();
var resultQuote = controllerQuote.ShowQuotesMedia(mediaID) as ViewResult;
var produktQuote = (Book)resultQuote.ViewData.Model;
String gesuchteQuote = "It's aggravations I mostly want to talk about-- can you sit a spell with me?";
Assert.AreEqual(gesuchteQuote, produktQuote.Quote.Single().QuoteString);
Assert.AreEqual("Old-Timer", produktQuote.Quote.Single().Character);
Assert.AreEqual("English", produktQuote.Quote.Single().Language);
}