public IActionResult Create([FromBody] USAHomeSale homeinfo) { //post to create home from external source if necessary if (homeinfo == null) { return(BadRequest()); } _realEstateContext.USAHomeSales.Add(homeinfo); _realEstateContext.SaveChanges(); return(CreatedAtRoute("GetHome", new { id = homeinfo.id }, homeinfo)); }
public static void InitializeHomeListings(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any Questions if (context.USAHomeListings.Any()) { return; // DB has been seeded } context.USAHomeListings.AddRange( new USAHomeListing { Address = "2997 Old Town Rd, Bridgeport, CT 06606", //string AskingPrice = 285000, //double Bathrooms = 3, //double? SquareFootage = 2023, //int? Bedrooms = 4, //double? EmailID = null, //string ZipCode = "06606", //string Neighborhood = "North End", //string initialPrice = 309900, //double? placedOnMarketDate = DateTimeOffset.Parse("2018-4-21"), //datetimeoffset?? insertionDate = DateTimeOffset.Now, //datetimeoffset fieldIndicator = "57253987", //string TypeOfSale = null, //string EmailDate = null, //string Active = true, //bool State = "CT", //string City = "Bridgeport" //string } ); context.SaveChanges(); } }
public static void InitializeHomeSales(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any Questions if (context.USAHomeSales.Any()) { return; // DB has been seeded } context.USAHomeSales.AddRange( new USAHomeSale { address = "417 N 59th Ave W Duluth, MN 55807", //string zipcode = "55807", //string city = "Duluth", //string bedrooms = 3, //double? bathrooms = 1, //double? state = "MN", //string walk_score = 71, //int? squareFootage = 2212, //int? salesDate = DateTimeOffset.Parse("2019-7-24"), //datetimeoffset placedOnMarketDate = DateTimeOffset.Parse("2019-6-17"), //datetimeoffset? listingPrice = 159000, //double? transitScore = 37, //int? finalSalesPrice = 167500, //double neighborhood = "Cody", //string initialPrice = 159000, //double? insertionDate = DateTimeOffset.Now, //datetimeoffset } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any participants. if (context.QOTDParticipants.Any()) { return; // DB has been seeded } context.QOTDParticipants.AddRange( new ParticipantQOTD { GivenName = "Khalil", FamilyLetter = "J", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Charles", FamilyLetter = "L", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Enzo", FamilyLetter = "M", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Manon", FamilyLetter = "G", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Elisa", FamilyLetter = "M", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Andres", FamilyLetter = "S", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Jean", FamilyLetter = "H", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Lea", FamilyLetter = "P", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Ericka", FamilyLetter = "B", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Ann Christine Stephie", FamilyLetter = "C", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Samantha", FamilyLetter = "D", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Natalie", FamilyLetter = "T", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Emily", FamilyLetter = "A", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Etienne", FamilyLetter = "D", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Cecile", FamilyLetter = "MS", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Gabriella", FamilyLetter = "G", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Marsha", FamilyLetter = "S", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Emmanuelle", FamilyLetter = "B", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Jess", FamilyLetter = "R", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Karen", FamilyLetter = "A", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Mariohn", FamilyLetter = "M", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Marilou", FamilyLetter = "G", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Sophia", FamilyLetter = "K", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Steph", FamilyLetter = "M", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Stephanie", FamilyLetter = "J", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Alex", FamilyLetter = "L", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" }, new ParticipantQOTD { GivenName = "Lara", FamilyLetter = "H", insertionDate = DateTime.Parse("2018-3-13"), Creator = "Khalil" } ); context.SaveChanges(); } }
public static void InitializeQOTD(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any Questions if (context.QOTDQuestion.Any()) { return; // DB has been seeded } context.QOTDQuestion.AddRange( new Question { QuestionText = "How many Times did Enzo wear a dress in High School?", QuestionAuthor = "Charles", QuestionDate = DateTime.Parse("2018-3-11"), Theme = "", }, new Question { QuestionText = "Hardwood Floors or Carpet?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-13"), Theme = "", }, new Question { QuestionText = "Waffles or Pancakes?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-14"), Theme = "", }, new Question { QuestionText = "French Fries or Sweet Potato Fries ", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-15"), Theme = "", }, new Question { QuestionText = "Where Does Everyone Live Now", QuestionAuthor = "Charles", QuestionDate = DateTime.Parse("2018-3-15"), Theme = "", }, new Question { QuestionText = "Mr Seignot, Mme Forest or Mme Carrenard", QuestionAuthor = "Etienne", QuestionDate = DateTime.Parse("2018-3-15"), Theme = "", }, new Question { QuestionText = "Cats or Dogs?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-19"), Theme = "", }, new Question { QuestionText = "Picasso or Van Gogh?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-20"), Theme = "", }, new Question { QuestionText = "Yay Snow? or F**k Snow?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-21"), Theme = "", }, new Question { QuestionText = "Best Birth Year: 1988,1989 or 1990", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-22"), Theme = "", }, new Question { QuestionText = "Cruise, Beach or Lake House, or Ski Chalet", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-23"), Theme = "", }, new Question { QuestionText = "Apples or Oranges?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-26"), Theme = "", }, new Question { QuestionText = "Least Favorite Applications: Job, Housing, School", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-27"), Theme = "", }, new Question { QuestionText = "Bar Soap or Body Wash?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-28"), Theme = "", }, new Question { QuestionText = "Snap Chat or Instagram Video", QuestionAuthor = "Karen", QuestionDate = DateTime.Parse("2018-3-29"), Theme = "", }, new Question { QuestionText = "No limitations,get travel anywhere in the world, where are you going?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-3-30"), Theme = "Friday Leisure Edition", }, new Question { QuestionText = "million dollar lottery- lump sum or 1000$ payments a week for the rest of your life?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-04-2"), Theme = "Escapism edition", }, new Question { QuestionText = "Skyblog, livejournal or Myspace?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-04-3"), Theme = "Escapism edition", }, new Question { QuestionText = "Would you rather get stuck in a tornado or an earthquake", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-4"), Theme = "", }, new Question { QuestionText = "The actual QOTD is who is a better rapper Kanye or drake", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-5"), Theme = "", }, new Question { QuestionText = "weird sex people in coconut grove locals or UM students?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-8"), Theme = "Weekend Special- Enxo request", }, new Question { QuestionText = "When you die do you want to be buried or cremated?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-9"), Theme = "Morbid Monday edition", }, new Question { QuestionText = "Pastelitos or bagels? ; Bonus points to anyone who remembers the prices", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-10"), Theme = "#tbt", }, new Question { QuestionText = "You get the power to bring a mythical creature to life. Which one are you picking", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-11"), Theme = "Waaaacky Wednesday edition", }, new Question { QuestionText = "Who is your favorite Harry Potter character?", QuestionAuthor = "Charles", QuestionDate = DateTime.Parse("2018-4-12"), Theme = "Waaaacky Wednesday edition", }, new Question { QuestionText = " Would you rather own a yacht or a plane?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-13"), Theme = "Fantasy Friday", }, new Question { QuestionText = "Key lime pie or tres leches ", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-16"), Theme = "Miami Monday ", }, new Question { QuestionText = "Msn messenger or aim; Also you have to respond with one of your usernames", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-17"), Theme = "#tbt ", }, new Question { QuestionText = "Is there an age limit to long hair on men?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-18"), Theme = "", }, new Question { QuestionText = "Best pizza topping combo?;Bonus to whoever can guess what I'm having for lunch", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-19"), Theme = "Tasty thursday edition ", }, new Question { QuestionText = "What's your ideal retirement scenario e.g beach house In Costa rica", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-19"), Theme = "fantasy Friday edition ", }, new Question { QuestionText = "Best Beach?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-20"), Theme = "Miami Monday", }, new Question { QuestionText = "Apple or Android for smartphones and tablet s??", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-20"), Theme = "Technology Tuesday", }, new Question { QuestionText = "You're on death row, What's your last meal?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-26"), Theme = "", }, new Question { QuestionText = "It's the future: Cybernetic implants are proven to be safe. Robo arms, eye implants. Are you getting one?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-27"), Theme = "Fantasy Friday", }, new Question { QuestionText = "Musicals ,yay or nay?,Also what is your favorite musical if you have one", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-4-30"), Theme = "Media Monday", }, new Question { QuestionText = "Also is anyone else getting tired of these Marvel movies", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-1"), Theme = "", }, new Question { QuestionText = "Does anyone else feel like deambulateur sounds like something that prevents people from walking instead of helping them to walk, or is that just me", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-1"), Theme = "", }, new Question { QuestionText = "Brickell or wynwood;Bonus info What's the nightlife spot in your city", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-2"), Theme = "nightlife edition", }, new Question { QuestionText = "Tennis or golf?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-4"), Theme = "", }, new Question { QuestionText = "What is the right birth method for you?https://www.romper.com/p/heres-the-right-birth-method-for-you-according-to-your-zodiac-sign-8930582", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-7"), Theme = "", }, new Question { QuestionText = " You get a chance to learn one language instantaneously. Push a button you're automatically fluent", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-8"), Theme = "", }, new Question { QuestionText = " What's your favorite cheese?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-9"), Theme = "", }, new Question { QuestionText = " Stick or automatic?Bonus question how do you feel about self driving cars?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-10"), Theme = "", }, new Question { QuestionText = " Would you give up eating your favorite food forever if it guaranteed you 5 extra years of life", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-11"), Theme = "", }, new Question { QuestionText = "If someone offers you a meal that is based on a protected or endangered animal and you are guaranteed that it won't get you in any legal trouble.Do you accept the offer?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-14"), Theme = "Super late edition", }, new Question { QuestionText = "Favorite ice cream flavor?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-15"), Theme = "Tasty Tuesday edition", }, new Question { QuestionText = "It looks like sports betting will be legal in the united states,Thoughts? Is this a good thing or a bad thing?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-16"), Theme = "Wager Wednesday", }, new Question { QuestionText = "What is a pet peeve you have with modern society that isn't a big deal but still bothers you", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-17"), Theme = "", }, new Question { QuestionText = "What's your favorite makeup manufacturer/ item", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-18"), Theme = "fashion friday", }, new Question { QuestionText = "Will Miami still be around in 2060, If so how different will it be", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-21"), Theme = "Miami Monday", }, new Question { QuestionText = "Do you eat pie/cake with a fork or a spoon?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-22"), Theme = "", }, new Question { QuestionText = "What's your favorite form of exercise?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-23"), Theme = "", }, new Question { QuestionText = " Who is Julia tuttle?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-24"), Theme = "", }, new Question { QuestionText = " What was the last book that you read?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-25"), Theme = "", }, new Question { QuestionText = " Digital watches , analog watches or phone", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-29"), Theme = "Time keeping Tuesday ", }, new Question { QuestionText = "Grapes with seeds or no seeds", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-30"), Theme = "", }, new Question { QuestionText = "Name your favorite thing about yourself,And if you don't have one message me and I'll get one for you. I have extensive files on all of you", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-5-31"), Theme = "Treacly Thursday", }, new Question { QuestionText = "Who is going to win the nba finals? The warriors? ,the cavaliers? or \"Khalil I, don't care about basketball\"?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-6-1"), Theme = "", }, new Question { QuestionText = "What's your favorite alcoholic beverage", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-6-5"), Theme = "turn up/teetotaler Tuesday", }, new Question { QuestionText = "Are you a morning person or a night owl?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-6-4"), Theme = "morning Monday edition", }, new Question { QuestionText = "Sunset or sunrise?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-06"), Theme = "turn up/teetotaler Tuesday", }, new Question { QuestionText = "<attached: 00002901-PHOTO-2018-06-07-14-33-29.jpg>", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-07"), Theme = "", }, new Question { QuestionText = "What is your favorite mammal?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-08"), Theme = "Fauna Friday", }, new Question { QuestionText = "Would you rather be a YouTuber or an Instagram celebrity?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-08"), Theme = "lose lose Monday ", }, new Question { QuestionText = " who do you think will win the World Cup?", QuestionAuthor = "Marilou", QuestionDate = DateTime.Parse("2018-06-08"), Theme = " ", }, new Question { QuestionText = " When you fly, where do you like to sit on the plane?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-08"), Theme = " Flights not feelings ", }, new Question { QuestionText = "Does product placement in movies and TV shows bother you?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-08"), Theme = " ", }, new Question { QuestionText = "What do you put on your hotdog?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-08"), Theme = " \"foodie\" Friday ", }, new Question { QuestionText = " NSYNC, or backstreet boys?", QuestionAuthor = "Charles", QuestionDate = DateTime.Parse("2018-06-18"), Theme = "Musical Monday ", }, new Question { QuestionText = " Britney or Christina?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-18"), Theme = "Musical Monday ", }, new Question { QuestionText = "Do girls really just want to have fun?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-18"), Theme = "Musical Monday ", }, new Question { QuestionText = "<attached: 00003131-PHOTO-2018-06-20-14-39-13.jpg>", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-18"), Theme = "Musical Monday ", }, new Question { QuestionText = "Does long hair truly = Don't care, or is it more work", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-18"), Theme = "Musical Monday ", }, new Question { QuestionText = "How often do you get a haircut/ new hairstyle", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-18"), Theme = "Musical Monday ", }, new Question { QuestionText = "backpacks or laptop bags?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-26"), Theme = "", }, new Question { QuestionText = "Should all drugs be legalized?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-26"), Theme = "", }, new Question { QuestionText = "what is your ideal thermostat/ac temperature?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-26"), Theme = "", }, new Question { QuestionText = "Some people think society would be more efficient if everyone told the truth all the time?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-06-29"), Theme = "", }, new Question { QuestionText = "Where do you get your clothes?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-02"), Theme = "", }, new Question { QuestionText = "what time do you like to grab lunch at work?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-03"), Theme = "", }, new Question { QuestionText = "For the people who moved or who have spent extended periods of time overseas,What did you miss the most from the good old us of a?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-03"), Theme = "", }, new Question { QuestionText = "How much would someone have to pay you to get a face tattoo?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-09"), Theme = "", }, new Question { QuestionText = "La France vs La Belgique", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "what if we used all the energy put in the World Cup for things that actually matter?", QuestionAuthor = "Etienne", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "<attached: 00003861-PHOTO-2018-07-12-16-40-59.jpg>, left or right?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = " Full omelette or eggwhite omelette?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = " What's the smallest town you could ever see yourself living in?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "Miami time=? Listed time + 30 mins? 45? 1 hour, 2?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "Hot tub or pool?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "If you could be super good at any sport which one would it be??", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "This is the best jayz song , https://youtu.be/Am-HXOuw0EM Are you a sophisticated intellectual who agrees with me?Or an ignorant troglodyte who does not", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", }, new Question { QuestionText = "Do you fit the sterotype of your astrological sign?", QuestionAuthor = "Khalil", QuestionDate = DateTime.Parse("2018-07-10"), Theme = "", } ); context.SaveChanges(); } }
public static void InitializeData(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any answers if (context.HardinessZones.Any()) { return; // DB has been seeded } List <HardinessZone> USAHardinessZones = new List <HardinessZone>() { new HardinessZone { zone = "0a", Country = countrygrow.USA, mintempfahr = null, maxtempfahr = -65, mintempc = null, maxtempc = -53.9, }, new HardinessZone { zone = "0b", Country = countrygrow.USA, mintempfahr = -65, maxtempfahr = -60, mintempc = -53.9, maxtempc = -51.1, }, new HardinessZone { zone = "1a", Country = countrygrow.USA, mintempfahr = -60, maxtempfahr = -55, mintempc = -51.1, maxtempc = -48.3, }, new HardinessZone { zone = "1b", Country = countrygrow.USA, mintempfahr = -55, maxtempfahr = -50, mintempc = -48.3, maxtempc = -45.6, }, new HardinessZone { zone = "2a", Country = countrygrow.USA, mintempfahr = -50, maxtempfahr = -45, mintempc = -45.6, maxtempc = -42.8, }, new HardinessZone { zone = "2b", Country = countrygrow.USA, mintempfahr = -45, maxtempfahr = -40, mintempc = -42.8, maxtempc = -40, }, new HardinessZone { zone = "3a", Country = countrygrow.USA, mintempfahr = -40, maxtempfahr = -35, mintempc = -40, maxtempc = -37.2 }, new HardinessZone { zone = "3b", Country = countrygrow.USA, mintempfahr = -35, maxtempfahr = -30, mintempc = -37.2, maxtempc = -34.4, }, new HardinessZone { zone = "4a", Country = countrygrow.USA, mintempfahr = -30, maxtempfahr = -25, mintempc = -34.4, maxtempc = -31.7, }, new HardinessZone { zone = "4b", Country = countrygrow.USA, mintempfahr = -25, maxtempfahr = -20, mintempc = -31.7, maxtempc = -28.9, }, new HardinessZone { zone = "5a", Country = countrygrow.USA, mintempfahr = -20, maxtempfahr = -15, mintempc = -28.9, maxtempc = -26.1, }, new HardinessZone { zone = "5b", Country = countrygrow.USA, mintempfahr = -15, maxtempfahr = -10, mintempc = -26.1, maxtempc = -23.3, }, new HardinessZone { zone = "6a", Country = countrygrow.USA, mintempfahr = -10, maxtempfahr = -5, mintempc = -23.3, maxtempc = -20.6, }, new HardinessZone { zone = "6b", Country = countrygrow.USA, mintempfahr = -5, maxtempfahr = 0, mintempc = -20.6, maxtempc = -17.8, }, new HardinessZone { zone = "7a", Country = countrygrow.USA, mintempfahr = 0, maxtempfahr = 5, mintempc = -17.8, maxtempc = -15, }, new HardinessZone { zone = "7b", Country = countrygrow.USA, mintempfahr = 5, maxtempfahr = 10, mintempc = -15, maxtempc = -12.2, }, new HardinessZone { zone = "8a", Country = countrygrow.USA, mintempfahr = 10, maxtempfahr = 15, mintempc = -12.2, maxtempc = -9.4, }, new HardinessZone { zone = "8b", Country = countrygrow.USA, mintempfahr = 15, maxtempfahr = 20, mintempc = -9.4, maxtempc = -6.7, }, new HardinessZone { zone = "9a", Country = countrygrow.USA, mintempfahr = 20, maxtempfahr = 25, mintempc = -6.7, maxtempc = -3.9, }, new HardinessZone { zone = "9b", Country = countrygrow.USA, mintempfahr = 25, maxtempfahr = 30, mintempc = -3.9, maxtempc = -1.1, }, new HardinessZone { zone = "10a", Country = countrygrow.USA, mintempfahr = 30, maxtempfahr = 35, mintempc = -1.1, maxtempc = +1.7, }, new HardinessZone { zone = "10b", Country = countrygrow.USA, mintempfahr = 35, maxtempfahr = 40, mintempc = +1.7, maxtempc = +4.4, }, new HardinessZone { zone = "11a", Country = countrygrow.USA, mintempfahr = 40, maxtempfahr = 45, mintempc = +4.4, maxtempc = +7.2, }, new HardinessZone { zone = "11b", Country = countrygrow.USA, mintempfahr = 45, maxtempfahr = 50, mintempc = +7.2, maxtempc = +10, }, new HardinessZone { zone = "12a", Country = countrygrow.USA, mintempfahr = 50, maxtempfahr = 55, mintempc = +10, maxtempc = +12.8, }, new HardinessZone { zone = "12b", Country = countrygrow.USA, mintempfahr = 55, maxtempfahr = null, mintempc = 12.8, maxtempc = null, } }; context.HardinessZones.AddRange( USAHardinessZones ); context.SaveChanges(); } }
public static void InitializeAnswers(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any answers if (context.QOTDAnswers.Any()) { return; // DB has been seeded } var partic = context.QOTDParticipants.Select(x => x).ToList(); Dictionary <string, int> particDic = new Dictionary <string, int>(); foreach (var participant in partic) { string fullname = $"{participant.GivenName} {participant.FamilyLetter}"; 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 M", Answer = "2", }, new QOTDAnswer { Question = "How many Times did Enzo wear a dress in High School?", QuestionID = 1, Author = "1", AuthorName = "Khalil J", Answer = "3", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "13", AuthorName = "Emily A", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "24", AuthorName = "Charles L", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "15", AuthorName = "Samantha D", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "19", AuthorName = "Jean H", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "20", AuthorName = "Andres S", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "6", AuthorName = "Karen A", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "5", AuthorName = "Mariohn M", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "25", AuthorName = "Alex L", Answer = "Laminate or Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "27", AuthorName = "Marilou G", Answer = "Hardwood", }, new QOTDAnswer { Question = "Hardwood Floors or Carpet?", QuestionID = 2, Author = "1", AuthorName = "Khalil J", Answer = "Hardwood", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "15", AuthorName = "Samantha D", Answer = "Belgian Waffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "5", AuthorName = "Mariohn M", Answer = "Pancakes", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "12", AuthorName = "Etienne D", Answer = "Panffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "13", AuthorName = "Emily A", Answer = "Belgian Waffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "19", AuthorName = "Jean H", Answer = "Waffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "9", AuthorName = "Marsha S", Answer = "Belgian Waffles with Tienen Sugar", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "18", AuthorName = "Lea P", Answer = "Banana Pancakes", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "22", AuthorName = "Manon G", Answer = "Waffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "24", AuthorName = "Charles L", Answer = "Waffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "11", AuthorName = "Cecile MS", Answer = "Waffles", }, new QOTDAnswer { Question = "Waffles or Pancakes?", QuestionID = 3, Author = "1", AuthorName = "Khalil J", Answer = "Pancakes", }, new QOTDAnswer { Question = "French Fries or Sweet Potato Fries?", QuestionID = 4, Author = "22", AuthorName = "Manon G", Answer = "Sweet Potato Fries", }, new QOTDAnswer { Question = "French Fries or Sweet Potato Fries?", QuestionID = 4, Author = "19", AuthorName = "Jean H", Answer = "French Fries", }, new QOTDAnswer { Question = "French Fries or Sweet Potato Fries?", QuestionID = 4, Author = "27", AuthorName = "Marilou G", Answer = "Paris", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "6", AuthorName = "Karen A", Answer = "Miami", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "11", AuthorName = "Cecile MS", Answer = "Brooklyn, China, Australia", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "21", AuthorName = "Elisa M", Answer = "Miami", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "13", AuthorName = "Emily A", Answer = "Paris", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "12 ", AuthorName = "Etienne D", Answer = "Paris and Ireland", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "19", AuthorName = "Jean H", Answer = "Melbourne, Florida", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "7", AuthorName = "Jess R", Answer = "Tahiti", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "15", AuthorName = "Samantha D", Answer = "Montreal", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "14", AuthorName = "Natalie T", Answer = "Boston", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "24", AuthorName = "Charles L", Answer = "Lausanne", }, new QOTDAnswer { Question = "Where does everyone live now?", QuestionID = 5, Author = "10", AuthorName = "Gabriella G", Answer = "Atlanta", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "21", AuthorName = "Elisa M", Answer = "Seignot", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "1", AuthorName = "Khalil J", Answer = "All Three", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "13", AuthorName = "Emily A", Answer = "Carrenard", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "6", AuthorName = "Karen A", Answer = "Seignot", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "19", AuthorName = "Jean H", Answer = "Forrest", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "18", AuthorName = "Lea P", Answer = "Carrenard", }, new QOTDAnswer { Question = "Mr Seignot, MMe Forest or MMe Carrenard?", QuestionID = 6, Author = "24", AuthorName = "Charles L", Answer = "Seignot", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "24", AuthorName = "Charles L", Answer = "Dogs, cats are assholes", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "21", AuthorName = "Elisa M", Answer = "All pets except birds", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "1", AuthorName = "Khalil J", Answer = "Cats", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "18", AuthorName = "Lea P", Answer = "Dogs", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "8", AuthorName = "Emmanuelle B", Answer = "Dogs", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "12", AuthorName = "Etienne D", Answer = "Chiats", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "25", AuthorName = "Alex L", Answer = "Dogs", }, new QOTDAnswer { Question = "Cats or Dogs?", QuestionID = 7, Author = "5", AuthorName = "Mariohn M", Answer = "Dogs", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "9", AuthorName = "Marsha S", Answer = "Van Gogh", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "18", AuthorName = "Lea P", Answer = "Both", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "17", AuthorName = "Ericka B", Answer = "Van Gogh", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "1", AuthorName = "Khalil J", Answer = "Van Gogh", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "5", AuthorName = "Mariohn M", Answer = "Van Gogh", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "8", AuthorName = "Emmanuelle B", Answer = "Van Gogh", }, new QOTDAnswer { Question = "Picasso or Van Gogh?", QuestionID = 8, Author = "11", AuthorName = "Cecile MS", Answer = "Both", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "5", AuthorName = "Mariohn M", Answer = "F**k Snow except first snowfall", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "18", AuthorName = "Lea P", Answer = "Yay Snow", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "1", AuthorName = "Khalil J", Answer = "F**k Snow", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "13", AuthorName = "Emily A", Answer = "Yay Snow", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "15", AuthorName = "Samantha D", Answer = "F**k Snow", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "8", AuthorName = "Emmanuelle B", Answer = "Yay Snow", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "9", AuthorName = "Marsha S", Answer = "F Snow", }, new QOTDAnswer { Question = "Yay Snow or F**k Snow?", QuestionID = 9, Author = "7", AuthorName = "Jess R", 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 K", Answer = "88", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "9", AuthorName = "Marsha S", Answer = "89", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "1", AuthorName = "Khalil J", Answer = "89", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "13", AuthorName = "Emily A", Answer = "89", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "20", AuthorName = "Andres S", Answer = "89", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "15", AuthorName = "Samantha D", Answer = "90", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "8", AuthorName = "Emmanuelle B", Answer = "89", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "21", AuthorName = "Elisa M", Answer = "89", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "17", AuthorName = "Ericka B", Answer = "88", }, new QOTDAnswer { Question = "Best Birth Year: 1988 ,1989 or 1990?", QuestionID = 10, Author = "24", AuthorName = "Charles L", Answer = "88", }, new QOTDAnswer { Question = "Cruise, Beach/Lake House or Ski Chalet?", QuestionID = 11, Author = "1", AuthorName = "Khalil J", Answer = "Beach House", }, new QOTDAnswer { Question = "Cruise, Beach/Lake House or Ski Chalet?", QuestionID = 11, Author = "21", AuthorName = "Elisa M", Answer = "Beach House or Mountain Cabin", }, new QOTDAnswer { Question = "Cruise, Beach/Lake House or Ski Chalet?", QuestionID = 11, Author = "22", AuthorName = "Manon G", Answer = " Beach/Lake House", }, new QOTDAnswer { Question = "Cruise, Beach/Lake House or Ski Chalet?", QuestionID = 11, Author = "18", AuthorName = "Lea P", 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 S", Answer = "Beach House on a Mountain", }, new QOTDAnswer { Question = "Cruise, Beach/Lake House or Ski Chalet?", QuestionID = 11, Author = "24", AuthorName = "Charles L", Answer = "Mountain Chalet", }, new QOTDAnswer { Question = "Cruise, Beach/Lake House or Ski Chalet?", QuestionID = 11, Author = "5", AuthorName = "Mariohn M", Answer = "Beach or Lake House", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "1", AuthorName = "Khalil J", Answer = "Can't compare them", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "27", AuthorName = "Marilou G", Answer = "Apples, hates Oranges", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "21", AuthorName = "Elisa M", Answer = "Oranges", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "9", AuthorName = "Marsha S", Answer = "Mandarins and Clementines", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "8", AuthorName = "Emmanuelle B", Answer = "All of the Above", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "18", AuthorName = "Lea P", Answer = "Oranges and Clementines", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "15", AuthorName = "Samantha D", Answer = "Apples, Hates Oranges", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "5", AuthorName = "Mariohn M", Answer = "Both", }, new QOTDAnswer { Question = "Apples or Oranges?", QuestionID = 12, Author = "6", AuthorName = "Karen A", Answer = "Both", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "24", AuthorName = "Charles L", Answer = "All of the Above", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "8", AuthorName = "Emmanuelle B", Answer = "All of the Above", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "1", AuthorName = "Khalil J", 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 S", Answer = "Job", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "13", AuthorName = "Emily A", Answer = "Job", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "23", AuthorName = "Enzo M", Answer = "Job", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "27", AuthorName = "Marilou G", Answer = "Parisian Housing Applications", }, new QOTDAnswer { Question = " least favorite: job applications , housing applications or school applications?", QuestionID = 13, Author = "5", AuthorName = "Mariohn M", Answer = "Housing", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "1", AuthorName = "Khalil J", Answer = "Body Wash", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "27", AuthorName = "Marilou G", Answer = "Body Wash", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "17", AuthorName = "Ericka B", Answer = "Body Wash", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "10", AuthorName = "Gabriella G", Answer = "Body Wash" }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "13", AuthorName = "Emily A", Answer = "Savon de Marseille: Old Fashioned Bar Soap", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "9", AuthorName = "Marsha S", Answer = "Bar at home, Body Wash everywhere else", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "8", AuthorName = "Emmanuelle B", Answer = "Bar Soap", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "24", AuthorName = "Charles L", Answer = "Organic Free Range Bar Soap", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "18", AuthorName = "Lea P", Answer = "Bar Soap", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "6", AuthorName = "Karen A", Answer = "Bar Soap", }, new QOTDAnswer { Question = "Bar Soap or Body Wash?", QuestionID = 14, Author = "5", AuthorName = "Mariohn M", Answer = "Both", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "18", AuthorName = "Lea P", Answer = "IG Video", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "20", AuthorName = "Andres S", Answer = "Whatsapp", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "8", AuthorName = "Emmanuelle B", Answer = "IG Video", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "11", AuthorName = "Cecile MS", Answer = "IG Video", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "9", AuthorName = "Marsha S", Answer = "LinkedIn", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "24", AuthorName = "Charles L", Answer = "IG Video", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "6", AuthorName = "Karen A", Answer = "IG Video", }, new QOTDAnswer { Question = "Snap Chat or Instagram Video?", QuestionID = 15, Author = "5", AuthorName = "Mariohn M", Answer = "IG Video", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "1 ", AuthorName = "Khalil J", Answer = "Galapagos Island", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "24", AuthorName = "Charles L", Answer = "Tibet", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "18", AuthorName = "Lea P", Answer = "All of Europe", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "27", AuthorName = "Marilou G", Answer = "Japan", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "17", AuthorName = "Ericka B", Answer = "Japan", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "17", AuthorName = "Ericka B", Answer = "Atlantic Ocean", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "15", AuthorName = "Samantha D", Answer = "South East Asia", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "22", AuthorName = "Manon G", Answer = "Nothern Lights in Norway", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "9", AuthorName = "Marsha S", 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 M", 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 S", Answer = "Japan", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "6", AuthorName = "Karen A", Answer = "Japan", }, new QOTDAnswer { Question = "No Limits: You get to travel anywhere in the word", QuestionID = 16, Author = "10", AuthorName = "Gabriella G", 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 M", 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.QOTDAnswers.AddRange( AllAnswers ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new AreasContext( serviceProvider.GetRequiredService <DbContextOptions <AreasContext> >())) { // Look for any answers if (context.ChatQuotes.Any()) { return; // DB has been seeded } List <WAQuote> starterQuotes = new List <WAQuote>() { new WAQuote { QuoteText = "\n[7/4/18, 04:38:26] Jean Hirschfeld: Damn, I’m kinda upset England went through...\n\n[7/4/18, 04:51:18] Charles: why\n[7/4/18, 05:38:53] Jean Hirschfeld: Because I’m French, and I don’t like England...", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[3/11/18, 20:04:27] Khalil Jolibois: Thank you thank you, no \"knead\" to pay me so many compliments 😉" + "\n[3/11/18, 20:04:34] Khalil Jolibois: #blaguesdepapa" + "\n[3/11/18, 20:09:26] Enzo Martin: 🤦♂️" + "\n[3/11/18, 20:12:30] Andres Saenz: Got a “rise” outta me" + "\n[3/11/18, 20:12:55] Charles: I guess khalil just had something to “prove”", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[7/6/18, 11:53:26] +lou lou: Americans killing the planet one AC at a time", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[4/19/18, 19:31:50] Zaz: What kinda pizza related message needed to be deleted?" + "\n[4/19/18, 19:32:01] Karen Acevedo: Lmao" + "\n[4/19/18, 19:32:24] Karen Acevedo: Khalil’s secret recipe", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "4/3/18, 17:43:37] Charles: Prometheus YO!" + "\n[4/3/18, 17:43:54] Khalil Jolibois: You better lay low" + "\n[4/3/18, 17:44:45] Samantha De Groen: the big bird's coming, today fosho!" + "\n[4/3/18, 17:45:00] Charles: Zeus don’t like your petty tricks!" + "\n[4/3/18, 17:45:12] Samantha De Groen: so you might end up in the river of stix" + "\n[4/3/18, 19:06:14] Andres Saenz: Im sol glad that it brought such a smile to Bruna Schneider’s face" + "\n[4/3/18, 19:06:17] Andres Saenz: So*", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[7/2/18, 22:19:24] Khalil Jolibois: I was gonna say that all you mixed nationality marriages/relationships need to start negotiating what country your kids will play for" + "\n[7/2/18, 22:20:16] Khalil Jolibois: But the odds of this ragtag bunch of poor eyesight having bookworms producing a word class athlete are not great" + "\n[7/2/18, 22:22:17] Khalil Jolibois: No offense", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[11/19/18, 18:30:21] Lea Powell: Lmfao! bro il y a des gens quand même", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[4/10/18, 15:31:35] Lea Powell: I will always remember carenard telling those kids to knock on the door when they would come in right before the bell to drop them off in class hahahah" + "\n[4/10/18, 15:32:09] Khalil Jolibois: 😁" + "\n[4/10/18, 15:32:53] +lou lou: Omg they're pbby scarred for life and hate the French" + "\n[4/10/18, 15:33:56] Lea Powell: Or finally learned to knock hahahahaha" + "\n[4/10/18, 15:49:40] stephie cast: Both! Lol it’s so hard for me to pick between two things" + "\n[4/10/18, 16:11:13] Marsha Sampson: I have to second that!!! Lmao" + "\n[4/10/18, 16:47:00] Manon Grana: Remember she threw their box out in the hall once" + "\n[4/10/18, 16:50:17] Khalil Jolibois: Haha" + "\n[4/10/18, 16:50:20] Khalil Jolibois: Good times" + "\n[4/10/18, 16:53:30] Manon Grana: “ mais il me font chier avec les bagels”", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[4/11/18, 16:03:07] Andres : Unicorn. Blood keeps me young." + "\n[4/11/18, 16:03:32] Andres : Also feel like it would be cheaper to feed" + "\n[4/11/18, 16:03:58] Andres : Im not just vain, I’m also practical!" + "\n[4/11/18, 16:04:07] Charles: I thought Andres would have resurrected the big bird fo sho" + "\n[4/11/18, 16:04:40] Khalil Jolibois: Hahaha" + "\n[4/11/18, 16:05:49] Lou Lou: Tough decision! Unicorns are so fluffy and cute 🦄But dragons are badass and I want to pretend to be the mother of dragons! 🐉" + "\n[4/11/18, 16:09:33] Manon : 😂" + "\n[4/11/18, 16:24:27] Ericka: 😂😂😂😂😂😂" + "\n[4/11/18, 16:43:24] Enzo : Do you think their horns would be used as aphrodisiacs by certain countries? 🤔" + "\n[4/11/18, 17:20:00] Manon : For sure" + "\n[4/11/18, 17:33:32] Charles: we got a voldemort over here" + "\n[4/11/18, 18:22:33] Andres : It’s just a more productive animal. If i get a stud I can mate it with female horses. I can have a racing empire, or just sell the s***n. I can sell the blood, put t into face creams, start s beauty products line. Petting zoo. Lower liability than dragons." , insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[4/13/18, 16:22:14] Mariohn Michel: Is it sad that in my fantasies, I’m worried about the cost of things lol?" + "\n[4/13/18, 16:28:15] Khalil Jolibois: Yes" + "\n[4/13/18, 16:29:04] Charles: it’s called being a millenial", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[4/17/18, 16:22:29] Khalil Jolibois: My favorite msn moment Is when Amat convinced me she died her hair black after school on Tuesday and died it back to blond by Wednesday morning" + "\n[4/17/18, 16:22:48] Khalil Jolibois: Dyes" + "\n[4/17/18, 16:22:51] Khalil Jolibois: Dyed" + "\n[4/17/18, 16:23:04] +lou lou: 😂", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[8/27/18, 13:09:54] Karen Acevedo: Me too lol" + "\n[8/27/18, 13:10:02] Karen Acevedo: I’d free them" + "\n[8/27/18, 13:10:28] Karen Acevedo: Then hire Dexter to take care of the murderer", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[4/17/18, 19:03:03] Samantha De Groen: Lol check out this little sign I just saw" + "\n[4/17/18, 19:03:08] Samantha De Groen: <attached: 00001935-PHOTO-2018-04-17-19-03-08.jpg>" + "\n[4/17/18, 19:03:08] Samantha De Groen: <attached: 00001935-PHOTO-2018-04-17-19-03-08.jpg>" + "\n[4/17/18, 19:03:25] Samantha De Groen: I guess here in Montreal they leave it as viennoiseries 😜" + "\n[4/17/18, 19:03:34] Lea Powell: Lmao!!!!!" + "\n[4/17/18, 19:04:15] Khalil Jolibois: So many 21st century things in one picture" + "\n[4/17/18, 19:04:24] Khalil Jolibois: Co working spaces" + "\n[4/17/18, 19:04:30] Khalil Jolibois: Pop up restaurants" + "\n[4/17/18, 19:04:41] Khalil Jolibois: @ sign" + "\n[4/17/18, 19:04:47] Samantha De Groen: 😂🤓" + "\n[4/17/18, 19:05:16] Khalil Jolibois: Inconsistent spacing of @ and we work" + "\n[4/17/18, 19:06:04] Khalil Jolibois: Unnecessary and probably unreliable hyping up of the quality of the coffee because we are all divas" + "\n[4/17/18, 19:06:45] Khalil Jolibois: The only thing missing is an exhortation to follow them on social media" + "\n[4/17/18, 19:11:50] Samantha De Groen: There’s a fb and insta logo on the other side but it’s not that prominent 😜" + "\n[4/17/18, 19:15:36] Charles: lol" + "\n[4/18/18, 11:53:54] Enzo Martin: It's missing a \"download our app to order ahead!\"", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[4/24/18, 18:11:08] +etienne Bring back flying pigeons", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[10/11/18, 17:15:07] +lou lou: Speak all foreign languages in a heartbeat. Sorry don't rly care to hear from a mosquito before it bites me haha" + "\n[10/11/18, 17:16:19] Lea Powell: I second that Marilou" + "\n[10/11/18, 17:18:01] Marsha Sampson: Haha me too!!!! Foreign languages for surrreeeee" + "\n[10/11/18, 17:18:01] Khalil Jolibois: 😂😂" + "\n[10/11/18, 17:18:53] +1 bourraine: Lol! Yes yes yes. Foreign languages!!!", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[8/15/18, 18:24:27] Cécile: (Has anyone here tried being poly?)" + "\n[8/15/18, 18:40:39] Khalil Jolibois: If you mean Polynesian sauce at Chick fil a then yes" + "\n[8/15/18, 18:59:23] a larms: Lmao" + "\n[8/15/18, 18:59:49] a larms: I proposed the idea to Nicole (my gf) and it hasnt gotten too far.." + "\n[8/15/18, 19:01:21] Lea Powell: Lmao !!!" + "\n[8/15/18, 19:02:53] Khalil Jolibois: 😂😂😂", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[11/18/18, 22:47:37] Mariohn Michel: How? It’s a swamp. A literal swamp." + "\n[11/18/18, 22:48:40] Khalil Jolibois: Non Floridians looking at a political map" + "\n[11/18/18, 22:58:05] Charles: The alligators decided to vote for MAGA", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[11/19/18, 18:29:06] Zaz: Oooo let me tell you guys all about the weird shit that gets ppl to hospital. So far this year: tiny girl who had butt plug stuck cause bf f****d her with it in it (took a whole fist and mid forearm to get out). If your partner jumps off the dresser onto your dick it will break. Miami guys put \"pearls\" under their dick skin" + "\n[11/19/18, 18:29:37] Lea Powell: Just listen to Ludas song ... back seats windows up lmao" + "\n[11/19/18, 18:29:47] Charles: wait so someone had to fist that thing out of her?" + "\n[11/19/18, 18:29:57] Manon Grana: Hahahahaha from the dresser?! Amazing. Watching too much WWE before bed" + "\n[11/19/18, 18:30:21] Lea Powell: Lmfao! bro il y a des gens quand même" + "\n[11/19/18, 18:30:31] Manon Grana: @13523010628 did you have to fist her yourself to get it out? 🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣" + "\n[11/19/18, 18:30:39] Manon Grana: 🤣🤣", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "\n[11/20/18, 17:44:31] Khalil Jolibois: Their poor families" + "\n[11/20/18, 17:44:57] Manon Grana: Idk what’s worse though.... dying because you had sex w a horse. Or having sex w a horse, not die, and get caught?" + "\n[11/20/18, 17:45:24] Khalil Jolibois: 🚨QOTD🚨", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[11/22/18, 13:58:00] Andres Saenz: Happy thanksgiving dear friends! I’m thankful for the Noble Assemblee! And that my parents were snobby enough to make me learn French like the French, but poor enough that it had to be in public school. I am thankful to have met this amazing gang of life-long friends!" + "\n[11/22/18, 13:58:52] Khalil Jolibois: Lmaaaao" + "\n[11/22/18, 13:59:11] Charles: 😂😂😂" + "\n[11/22/18, 13:59:20] Samantha De Groen: hahahahaha" + "\n[11/22/18, 13:59:48] Charles: also amen to that andres" + "\n[11/22/18, 14:14:31] Karen Acevedo: 😂 yes, ditto", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[12/7/18, 18:10:38] +lou lou: My parents had saved a bottle for years at my sisters birth and it was corked when they opened t years later. So now I say love in the moment. YOLO haha", insertionDate = DateTimeOffset.UtcNow, }, new WAQuote { QuoteText = "+\n[12/28/18, 19:40:53] Khalil Jolibois: SHALOM SHALOM MY BROTHER'S AND SISTERS/FRIENDS/ FAMILY DEVOTION/ MEDITATION WITH YOUR FAMILY Gloire et louange a Dieu tout puissant Amen Que Dieu vous benisse🌹🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🌹❤Dieu Est Bon vrst, JEAN 3:16 💝💖💙🌸🙏🏼🌸 Jesus is the reason for the season lot of love love love love love love love 💜💙💚💛🧡❤💖💗💝 🌺🌸🌷🌻praying/ priye more often/ toutan is coming soon Be ready/Jesussssssss/La vini prepare-w fre-m-se-m Je viens bientot vrst, APOCALYPSE 3:11 🌻🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🌻ENCOURAGEMENT in the Lord/dans Le SEIGNEUR/forced Courage/La joieeeeeeee Smile/sourire for/ pour JESUS RENMEN NOUS🌺💝🌺🌸🙏🏼🌸your lovely sister/friend/family in Christ AVEC AMOUR SHALOM!!!PEACE!!!PAZ!!!PAIX!!!ALHOB 🌹🙏🏼🌹🎀🇭🇹🇺🇸🎀💖💝💗🌻", insertionDate = DateTimeOffset.UtcNow, } }; // add try catch and formatting stripping context.ChatQuotes.AddRange( starterQuotes ); context.SaveChanges(); } }