public static void InsertQuestions(List <JeopardyQuestion> questions, List <Category> categories, List <Round> rounds)
{
Console.WriteLine("Entered InsertQuestions!");
var MyJeopardyQuestions = new List <DbJeopardyQuestion>();
foreach (var question in questions)
{
MyJeopardyQuestions.Add(new DbJeopardyQuestion()
{
CategoryId = categories.Where(c => Regex.Unescape(question.Category.ToUpper()) == c.CategoryName).Select(c => c.Id).FirstOrDefault(),
AirDate = question.Air_Date,
Question = question.Question,
DollarValue = question.DollarValue,
Answer = question.Answer,
RoundId = rounds.Where(r => question.Round == r.RoundName).Select(r => r.Id).FirstOrDefault(),
ShowNumber = question.Show_Number,
});
}
Console.WriteLine("Questions Converted!");
var questionswithoutCategory = MyJeopardyQuestions.Where(q => q.CategoryId > 27916 || q.CategoryId < 1).ToList();
using (var context = new JeopardyContext())
{
context.Questions.AddRange(MyJeopardyQuestions);
context.SaveChanges();
Console.WriteLine("Questions inserted!");
}
}
public static void InsertRounds(List <string> Rounds)
{
Console.WriteLine("Entered InsertRounds!");
var MyRounds = new List <Round>();
foreach (var r in Rounds)
{
MyRounds.Add(new Round()
{
RoundName = r
});
}
using (var context = new JeopardyContext())
{
context.Rounds.AddRange(MyRounds);
context.SaveChanges();
}
Console.WriteLine("Rounds inserted!");
}
public static void InsertCategories(List <string> Categories)
{
Console.WriteLine("Entered InsertCategories!");
var MyCategories = new List <Category>();
foreach (var cat in Categories)
{
MyCategories.Add(new Category()
{
CategoryName = cat
});
}
using (var context = new JeopardyContext())
{
context.Categories.AddRange(MyCategories);
context.SaveChanges();
}
Console.WriteLine("Categories inserted!");
}