Example #1
0
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new QOTDContext(
                       serviceProvider.GetRequiredService <DbContextOptions <QOTDContext> >()))
            {
                // Look for any participants.
                if (context.ParticipantQOTD.Any())
                {
                    return;   // DB has been seeded
                }

                context.ParticipantQOTD.AddRange(

                    new ParticipantQOTD
                {
                    GivenName   = "Khalil",
                    FamilyName  = "Jolibois",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Charles",
                    FamilyName  = "Lhermitte",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Enzo",
                    FamilyName  = "Martin",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Manon",
                    FamilyName  = "Grana",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Elisa",
                    FamilyName  = "Martinez",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Andres",
                    FamilyName  = "Saenz",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Jean",
                    FamilyName  = "Hirschfeld",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Lea",
                    FamilyName  = "Powell",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Ericka",
                    FamilyName  = "Bourraine",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Ann Christine Stephie",
                    FamilyName  = "Castera",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Samantha",
                    FamilyName  = "De Groen",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Natalie",
                    FamilyName  = "Tejero",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Emily",
                    FamilyName  = "Amat",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Etienne",
                    FamilyName  = "Decourreges",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Cecile",
                    FamilyName  = "Mclorin-Salvant",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Gabriella",
                    FamilyName  = "Guiol",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Marsha",
                    FamilyName  = "Samson",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Emmanuelle",
                    FamilyName  = "Buteau",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Jess",
                    FamilyName  = "Redal",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Karen",
                    FamilyName  = "Acevedo",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Mariohn",
                    FamilyName  = "Michel",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Marilou",
                    FamilyName  = "Gantier",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Sophia",
                    FamilyName  = "Khawly",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Steph",
                    FamilyName  = "Mathurin",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },

                    new ParticipantQOTD
                {
                    GivenName   = "Stephanie",
                    FamilyName  = "Jean-Pierre",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Alex",
                    FamilyName  = "Larmier",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                },
                    new ParticipantQOTD
                {
                    GivenName   = "Lara",
                    FamilyName  = "Hickox",
                    DateCreated = DateTime.Parse("2018-3-13"),
                    Creator     = "Khalil"
                }

                    );


                context.SaveChanges();
            }
        }
Example #2
0
        public static void InitializeQOTD(IServiceProvider serviceProvider)
        {
            using (var context = new QOTDContext(
                       serviceProvider.GetRequiredService <DbContextOptions <QOTDContext> >()))
            {
                // Look for any Questions
                if (context.QOTD.Any())
                {
                    return;   // DB has been seeded
                }
                context.QOTD.AddRange(

                    new QOTD
                {
                    Question       = "How many Times did Enzo wear a dress in High School?",
                    QuestionAuthor = "Charles",
                    QuestionDate   = DateTime.Parse("2018-3-11"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Hardwood Floors or Carpet?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-13"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Waffles or Pancakes?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-14"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "French Fries or Sweet Potato Fries ",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-15"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Where Does Everyone Live Now",
                    QuestionAuthor = "Charles",
                    QuestionDate   = DateTime.Parse("2018-3-15"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Mr Seignot, Mme Forest or Mme Carrenard",
                    QuestionAuthor = "Etienne",
                    QuestionDate   = DateTime.Parse("2018-3-15"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Cats or Dogs?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-19"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Picasso or Van Gogh?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-20"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Yay Snow? or F**k Snow?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-21"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Best Birth Year: 1988,1989 or 1990",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-22"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Cruise, Beach or Lake House, or Ski Chalet",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-23"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Apples or Oranges?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-26"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Least Favorite Applications: Job, Housing, School",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-27"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Bar Soap or Body Wash?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-28"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "Snap Chat or Instagram Video",
                    QuestionAuthor = "Karen",
                    QuestionDate   = DateTime.Parse("2018-3-29"),
                    Theme          = "",
                },
                    new QOTD
                {
                    Question       = "No limitations , get travel anywhere in the world, where are you going?",
                    QuestionAuthor = "Khalil",
                    QuestionDate   = DateTime.Parse("2018-3-30"),
                    Theme          = "Friday Leisure Edition",
                }



                    );

                context.SaveChanges();
            }
        }
Example #3
0
        public static async System.Threading.Tasks.Task InitializeAsync(IServiceProvider serviceProvider)
        {
            using (var context = new QOTDContext(
                       serviceProvider.GetRequiredService <DbContextOptions <QOTDContext> >()))

            {
                // Look for any answers
                if (context.QOTDAnswer.Any())
                {
                    return;   // DB has been seeded
                }
                var partic = await context.ParticipantQOTD.Select(x => x).ToListAsync();

                Dictionary <string, int> particDic = new Dictionary <string, int>();
                foreach (var participant in partic)
                {
                    string fullname = $"{participant.GivenName} {participant.FamilyName}";
                    Debug.Print(fullname);
                    particDic.Add(fullname, participant.ID);
                }
                List <QOTDAnswer> AllAnswers = new List <QOTDAnswer>()
                {
                    new QOTDAnswer
                    {
                        Question   = "How many Times did Enzo wear a dress in High School?",
                        QuestionID = 1,
                        Author     = "23",
                        AuthorName = "Enzo Martin",
                        Answer     = "2",
                    },

                    new QOTDAnswer
                    {
                        Question   = "How many Times did Enzo wear a dress in High School?",
                        QuestionID = 1,
                        Author     = "1",
                        AuthorName = "Khalil Jolibois",
                        Answer     = "3",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "13",
                        AuthorName = "Emily Amat",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "15",
                        AuthorName = "Samantha De Groen",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "19",
                        AuthorName = "Jean Hirschfeld",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "20",
                        AuthorName = "Andres Saenz",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "6",
                        AuthorName = "Karen Acevedo",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "25",
                        AuthorName = "Alex Larmier",
                        Answer     = "Laminate or Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "27",
                        AuthorName = "Marilou Gantier",
                        Answer     = "Hardwood",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Hardwood Floors or Carpet?",
                        QuestionID = 2,
                        Author     = "1",
                        AuthorName = "Khalil Jolibois",
                        Answer     = "Hardwood",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "15",
                        AuthorName = "Samantha De Groen",
                        Answer     = "Belgian Waffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "Pancakes",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "12",
                        AuthorName = "Etienne Decourreges",
                        Answer     = "Panffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "13",
                        AuthorName = "Emily Amat",
                        Answer     = "Belgian Waffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "19",
                        AuthorName = "Jean Hirschfeld",
                        Answer     = "Waffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "Belgian Waffles with Tienen Suga",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "18",
                        AuthorName = "Lea Powell",
                        Answer     = "Banana Pancakes",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "22",
                        AuthorName = "Manon Grana",
                        Answer     = "Waffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "Waffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "11",
                        AuthorName = "Cecile Mclorin-Salvant",
                        Answer     = "Waffles",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Waffles or Pancakes?",
                        QuestionID = 3,
                        Author     = "1",
                        AuthorName = "Khalil Jolibois",
                        Answer     = "Pancakes",
                    },
                    new QOTDAnswer
                    {
                        Question   = "French Fries or Sweet Potato Fries?",
                        QuestionID = 4,
                        Author     = "22",
                        AuthorName = "Manon Grana",
                        Answer     = "Sweet Potato Fries",
                    },
                    new QOTDAnswer
                    {
                        Question   = "French Fries or Sweet Potato Fries?",
                        QuestionID = 4,
                        Author     = "19",
                        AuthorName = "Jean Hirschfeld",
                        Answer     = "French Fries",
                    },
                    new QOTDAnswer
                    {
                        Question   = "French Fries or Sweet Potato Fries?",
                        QuestionID = 4,
                        Author     = "27",
                        AuthorName = "Marilou Gantier",
                        Answer     = "Paris",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "6",
                        AuthorName = "Karen Acevedo",
                        Answer     = "Miami",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "11", AuthorName = "Cecile Mclorin-Salvant",
                        Answer     = "Brooklyn, China, Australia",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "21", AuthorName = "Elisa Martinez",
                        Answer     = "Miami",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "13", AuthorName = "Emily Amat",
                        Answer     = "Paris",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "12 ",
                        AuthorName = "Etienne Decourreges",

                        Answer = "Paris and Ireland",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "19", AuthorName = "Jean Hirschfeld",
                        Answer     = "Melbourne, Florida",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "7", AuthorName = "Jess Redal",
                        Answer     = "Tahiti",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "15", AuthorName = "Samantha De Groen",
                        Answer     = "Montreal",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "14", AuthorName = "Natalie Tejero",
                        Answer     = "Boston",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "24", AuthorName = "Charles Lhermitte",
                        Answer     = "Lausanne",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Where does everyone live now?",
                        QuestionID = 5,
                        Author     = "10", AuthorName = "Gabriella Guiol",
                        Answer     = "Atlanta",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "21", AuthorName = "Elisa Martinez",
                        Answer     = "Seignot",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "All Three",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "13", AuthorName = "Emily Amat",
                        Answer     = "Carrenard",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "6", AuthorName = "Karen Acevedo",
                        Answer     = "Seignot",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "19", AuthorName = "Jean Hirschfeld",
                        Answer     = "Forrest",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "18", AuthorName = "Lea Powell",
                        Answer     = "Carrenard",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Mr Seignot, MMe Forest or MMe Carrenard?",
                        QuestionID = 6,
                        Author     = "24", AuthorName = "Charles Lhermitte",
                        Answer     = "Seignot",
                    },


                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "24", AuthorName = "Charles Lhermitte",
                        Answer     = "Dogs, cats are assholes",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "21", AuthorName = "Elisa Martinez",
                        Answer     = "All pets except birds",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "Cats",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "18", AuthorName = "Lea Powell",
                        Answer     = "Dogs",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "8", AuthorName = "Emmanuelle Buteau",
                        Answer     = "Dogs",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "12", AuthorName = "Etienne Decourreges",
                        Answer     = "Chiats",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "25", AuthorName = "Alex Larmier",
                        Answer     = "Dogs",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cats or Dogs?",
                        QuestionID = 7,
                        Author     = "5", AuthorName = "Mariohn Michel",
                        Answer     = "Dogs",
                    },


                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "9", AuthorName = "Marsha Samson",
                        Answer     = "Van Gogh",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "18", AuthorName = "Lea Powell",
                        Answer     = "Both",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "17", AuthorName = "Ericka Bourraine",
                        Answer     = "Van Gogh",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "Van Gogh",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "5", AuthorName = "Mariohn Michel",
                        Answer     = "Van Gogh",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "8", AuthorName = "Emmanuelle Buteau",
                        Answer     = "Van Gogh",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Picasso or Van Gogh?",
                        QuestionID = 8,
                        Author     = "11", AuthorName = "Cecile Mclorin-Salvant",
                        Answer     = "Both",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "5", AuthorName = "Mariohn Michel",
                        Answer     = "F**k Snow except first snowfall",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "18",
                        AuthorName = "Lea Powell",
                        Answer     = "Yay Snow",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "F**k Snow",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "13", AuthorName = "Emily Amat",
                        Answer     = "Yay Snow",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "15", AuthorName = "Samantha De Groen",
                        Answer     = "F**k Snow",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "8", AuthorName = "Emmanuelle Buteau",
                        Answer     = "Yay Snow",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "9", AuthorName = "Marsha Samson",
                        Answer     = "F Snow",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Yay Snow or F**k Snow?",
                        QuestionID = 9,
                        Author     = "7", AuthorName = "Jess Redal",
                        Answer     = "No to Snow, also the weather in Tahiti is great",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "4", AuthorName = "Sophia Khawly",
                        Answer     = "88",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "9", AuthorName = "Marsha Samson",
                        Answer     = "89",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "89",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "13", AuthorName = "Emily Amat",
                        Answer     = "89",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "20",
                        AuthorName = "Andres Saenz",
                        Answer     = "89",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "15",
                        AuthorName = "Samantha De Groen",
                        Answer     = "90",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "8",
                        AuthorName = "Emmanuelle Buteau",
                        Answer     = "89",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "21",
                        AuthorName = "Elisa Martinez",
                        Answer     = "89",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "17",
                        AuthorName = "Ericka Bourraine",
                        Answer     = "88",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Best Birth Year: 1988 ,1989 or 1990?",
                        QuestionID = 10,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "88",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "Beach House",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "21", AuthorName = "Elisa Martinez",
                        Answer     = "Beach House or Mountain Cabin",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "22", AuthorName = "Manon Grana",
                        Answer     = " Beach/Lake House",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "18",
                        AuthorName = "Lea Powell",

                        Answer = "Beach or Lake House if it doesn't look like a scary movie serial killer house",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "Beach House on a Mountain",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "Mountain Chalet",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Cruise, Beach/Lake House or Ski Chalet?",
                        QuestionID = 11,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "Beach or Lake House",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "1",
                        AuthorName = "Khalil Jolibois",
                        Answer     = "Can't compare them",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "27",
                        AuthorName = "Marilou Gantier",
                        Answer     = "Apples, hates Oranges",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "21",
                        AuthorName = "Elisa Martinez",
                        Answer     = "Oranges",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "Mandarins and Clementines",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "8",
                        AuthorName = "Emmanuelle Buteau",
                        Answer     = "All of the Above",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "18",
                        AuthorName = "Lea Powell",
                        Answer     = "Oranges and Clementines",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "15",
                        AuthorName = "Samantha De Groen",
                        Answer     = "Apples, Hates Oranges",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "Both",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Apples or Oranges?",
                        QuestionID = 12,
                        Author     = "6",
                        AuthorName = "Karen Acevedo",
                        Answer     = "Both",
                    },

                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "All of the Above",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "8",
                        AuthorName = "Emmanuelle Buteau",
                        Answer     = "All of the Above",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "1",
                        AuthorName = "Khalil Jolibois",
                        Answer     = "Job, especially the portals that make you upload a resume and still fill out all the info",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "Job",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "13",
                        AuthorName = "Emily Amat",
                        Answer     = "Job",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "23",
                        AuthorName = "Enzo Martin",
                        Answer     = "Job",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "27",
                        AuthorName = "Marilou Gantier",
                        Answer     = "Parisian Housing Applications",
                    },
                    new QOTDAnswer
                    {
                        Question   = " least favorite: job applications , housing applications or school applications?",
                        QuestionID = 13,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "Housing",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "1", AuthorName = "Khalil Jolibois",
                        Answer     = "Body Wash",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "27",
                        AuthorName = "Marilou Gantier",
                        Answer     = "Body Wash",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "17",
                        AuthorName = "Ericka Bourraine",
                        Answer     = "Body Wash",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "10",
                        AuthorName = "Gabriella Guiol",
                        Answer     = "Body Wash"
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "13",
                        AuthorName = "Emily Amat",
                        Answer     = "Savon de Marseille: Old Fashioned Bar Soap",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "Bar at home, Body Wash everywhere else",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "8",
                        AuthorName = "Emmanuelle Buteau",
                        Answer     = "Bar Soap",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "Organic Free Range Bar Soap",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "18",
                        AuthorName = "Lea Powell",
                        Answer     = "Bar Soap",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "6",
                        AuthorName = "Karen Acevedo",
                        Answer     = "Bar Soap",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Bar Soap or Body Wash?",
                        QuestionID = 14,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "Both",
                    },

                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "18",
                        AuthorName = "Lea Powell",
                        Answer     = "IG Video",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "20",
                        AuthorName = "Andres Saenz",
                        Answer     = "Whatsapp",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "8",
                        AuthorName = "Emmanuelle Buteau",
                        Answer     = "IG Video",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "11",
                        AuthorName = "Cecile Mclorin-Salvant",
                        Answer     = "IG Video",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "LinkedIn",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "IG Video",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "6",
                        AuthorName = "Karen Acevedo",
                        Answer     = "IG Video",
                    },
                    new QOTDAnswer
                    {
                        Question   = "Snap Chat or Instagram Video?",
                        QuestionID = 15,
                        Author     = "5",
                        AuthorName = "Mariohn Michel",
                        Answer     = "IG Video",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "1 ",
                        AuthorName = "Khalil Jolibois",
                        Answer     = "Galapagos Island",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "24",
                        AuthorName = "Charles Lhermitte",
                        Answer     = "Tibet",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "18",
                        AuthorName = "Lea Powell",
                        Answer     = "All of Europe",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "27",
                        AuthorName = "Marilou Gantier",
                        Answer     = "Japan",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "17",
                        AuthorName = "Ericka Bourraine",
                        Answer     = "Japan",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "17",
                        AuthorName = "Ericka Bourraine",
                        Answer     = "Atlantic Ocean",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "15",
                        AuthorName = "Samantha De Groen",
                        Answer     = "South East Asia",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "22",
                        AuthorName = "Manon Grana",
                        Answer     = "Nothern Lights in Norway",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "9",
                        AuthorName = "Marsha Samson",
                        Answer     = "South Africa, Madagascar, East Africa",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "21",
                        AuthorName = "Elisa Martinez",
                        Answer     = "Pacific Crest Trail in British Columbia",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "20",
                        AuthorName = "Andres Saenz",
                        Answer     = "Japan",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "6",
                        AuthorName = "Karen Acevedo",
                        Answer     = "Japan",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "10",
                        AuthorName = "Gabriella Guiol",
                        Answer     = "South East Asia and Australia",
                    },
                    new QOTDAnswer
                    {
                        Question   = "No Limits: You get to travel anywhere in the word",
                        QuestionID = 16,
                        Author     = "23",
                        AuthorName = "Enzo Martin",
                        Answer     = "Iceland and Antartica",
                    }
                };

                // add try catch and formatting stripping
                foreach (var entry in AllAnswers)
                {
                    Debug.Print("---------------------------");
                    Debug.Print(entry.AuthorName);
                    Debug.Print(particDic[entry.AuthorName].ToString());

                    entry.Author = particDic[entry.AuthorName].ToString();
                }

                context.QOTDAnswer.AddRange(

                    AllAnswers

                    );


                context.SaveChanges();
            }
        }