private static async Task PopulateDatabase(QuotableContext context)
{
var dataset1 = new QuoteAuthor()
{
Quote = new Quote("To be or not to be.", "William Shakespeare"), Author = new Author("William", "Shakespeare")
};
var dataset2 = new QuoteAuthor()
{
Quote = new Quote("So many books, so little time.", "Frank Zappa"), Author = new Author("Frank", "Zappa")
};
var dataset3 = new QuoteAuthor()
{
Quote = new Quote("Be the change you wish in the world.", "Mahatma Gandhi"), Author = new Author("Mahatma", "Gandhi")
};
var dataset4 = new QuoteAuthor()
{
Quote = new Quote("If you tell the truth, you don't have to remember anything.", "Mark Twain"), Author = new Author("Mark", "Twain")
};
var dataset5 = new QuoteAuthor()
{
Quote = new Quote("Without music, life would be a mistake.", "Friedrich Nietzsche"), Author = new Author("Friedrich", "Nietzsche")
};
var dataset6 = new QuoteAuthor()
{
Quote = new Quote("We accept the love we think we deserve.", "Stephen Chbosky"), Author = new Author("Stephen", "Chbosky")
};
var dataset7 = new QuoteAuthor()
{
Quote = new Quote("The man who does not read has no advantage over the man who cannot read.", "Mark Twain"), Author = new Author("Mark", "Twain")
};
context.AddRange(dataset1, dataset2, dataset3, dataset4, dataset5, dataset6, dataset7);
await context.SaveChangesAsync();
}
private static async Task PopulateDatabase(QuotableContext context)
{
var author1 = new Author()
{
FirstName = "Dr",
LastName = "Seuss"
};
var author2 = new Author()
{
FirstName = "Mr",
LastName = "Spock"
};
var author3 = new Author()
{
FirstName = "Mr",
LastName = "Tuvok"
};
var quote1 = new Quote();
quote1.Body = "quote one body";
var quote2 = new Quote();
quote2.Body = "quote 2 body";
var quote3 = new Quote();
quote3.Body = "quote 3 body";
var qa1 = new QuoteAuthor()
{
Quote = quote1, Author = author1
};
var qa2 = new QuoteAuthor()
{
Quote = quote2, Author = author2
};
var qa3 = new QuoteAuthor()
{
Quote = quote3, Author = author1
};
var qa4 = new QuoteAuthor()
{
Quote = quote3, Author = author2
};
var qa5 = new QuoteAuthor()
{
Quote = quote3, Author = author3
};
context.AddRange(qa1, qa2, qa3, qa4, qa5);
await context.SaveChangesAsync();
}
private static void PopulateDatabase(QuotableContext context)
{
var author1 = new AuthorObject()
{
FirstName = "Hermione",
LastName = "Granger"
};
var author2 = new AuthorObject()
{
FirstName = "Albus",
LastName = "Dumbledore"
};
var author3 = new AuthorObject()
{
FirstName = "Harry",
LastName = "Potter"
};
var quote1 = new QuoteObject();
quote1.Quote = "Fear of a name only increases fear of the thing itself.";
var quote2 = new QuoteObject();
quote2.Quote = "It is our choices, Harry, that show what we truly are, far more than our abilities.";
var quote3 = new QuoteObject();
quote3.Quote = "I solemnly swear I am up to no good.";
var qa1 = new QuotesAndAuthorsObject()
{
Quote = quote1, Author = author1
};
var qa2 = new QuotesAndAuthorsObject()
{
Quote = quote2, Author = author2
};
var qa3 = new QuotesAndAuthorsObject()
{
Quote = quote3, Author = author3
};
context.AddRange(qa1, qa2, qa3);
context.SaveChanges();
}
private static async Task PopulateDatabase(QuotableContext context)
{
var author1 = new Author()
{
FirstName = "Dr",
LastName = "Seuss"
};
var author2 = new Author()
{
FirstName = "Mahatma",
LastName = "Gandhi"
};
var author3 = new Author()
{
FirstName = "J.K.",
LastName = "Rowling"
};
var quote1 = new Quote();
quote1.QuoteContent = "You’re off to great to places. Today is your day. Your mountain is waiting. So get on your way";
var quote2 = new Quote();
quote2.QuoteContent = "Be the change that you wish to see in the world";
var quote3 = new Quote();
quote3.QuoteContent = "It does not do to dwell on dreams and forget to live";
var da1 = new QuoteAuthor()
{
Quote = quote1, Author = author1
};
var da2 = new QuoteAuthor()
{
Quote = quote2, Author = author2
};
var da5 = new QuoteAuthor()
{
Quote = quote3, Author = author3
};
context.AddRange(da1, da2, da5);
await context.SaveChangesAsync();
}
private static void PopulateDatabase(QuotableContext c)
{
IEnumerable <string> lines = System.IO.File.ReadAllLines(@"..\..\quotes.txt");
DefaultRandomQuoteGenerator d = new DefaultRandomQuoteGenerator(lines);
var count = 0;
foreach (string s in lines)
{
var author = new Author()
{
FirstName = d.FindAuthorFirstName(count),
LastName = d.FindAuthorLastName(count)
};
var quote = new Quote();
quote.quote = d.FindQuoteById(count);
var qa = new QuoteAuthor()
{
quote = quote, Author = author
};
c.AddRange(qa);
count++;
}
c.SaveChanges();
}
/// <summary>
/// takes in a provider and assigns global provider variable to that provider
/// </summary>
/// <param name="provider"></param>
/// <param name="context"></param>
public QuoteController(RandomQuoteProvider provider, QuotableContext context)
{
Provider = provider;
_context = context;
}
private static async Task PopulateDatabase(QuotableContext context)
{
var author1 = new Author()
{
FirstName = "Last Of Us",
LastName = "NaughtyDog"
};
var author2 = new Author()
{
FirstName = "Hunt Showdown",
LastName = "Crytek"
};
var author3 = new Author()
{
FirstName = "Fallout",
LastName = "Bethesda/Obsidean"
};
var author4 = new Author()
{
FirstName = "Oregon Trail",
LastName = "MECC"
};
var quote1 = new Quote();
quote1.Saying = "endure and survive";
var quote2 = new Quote();
quote2.Saying = "You Live to Hunt Another Day";
var quote3 = new Quote();
quote3.Saying = "Rise Up Damned Soul";
var quote4 = new Quote();
quote4.Saying = "War, War Never Changes";
var quote5 = new Quote();
quote5.Saying = "You have died of dysentery";
var qa1 = new QuoteAuthor()
{
Quote = quote1, Author = author1
};
var qa2 = new QuoteAuthor()
{
Quote = quote2, Author = author2
};
var qa3 = new QuoteAuthor()
{
Quote = quote3, Author = author2
};
var qa4 = new QuoteAuthor()
{
Quote = quote4, Author = author3
};
var qa5 = new QuoteAuthor()
{
Quote = quote5, Author = author4
};
context.AddRange(qa1, qa2, qa3, qa4, qa5);
await context.SaveChangesAsync();
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="context">The database context to data access.</param>
public QuotesController(QuotableContext context)
{
Context = context;
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="context">The database context to data access.</param>
public DBQuotesController(QuotableContext context)
{
_context = context;
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="context">The database context to data access.</param>
public QuoteDataController(QuotableContext context)
{
_context = context;
}
