public static void Initialize(IServiceProvider serviceProvider) { using (var context = new SacramentMeetingPlannerContext( serviceProvider.GetRequiredService < DbContextOptions <SacramentMeetingPlannerContext> >())) { // Look for any meetings. if (context.Meeting.Any()) { return; // DB has been seeded } context.Meeting.AddRange( /* * // Meeting Template * new Meeting * { * MeetingDate = DateTime.Parse(""), * DateUpdated = DateTime.Now, * Bishopric = "", * OpeningPrayer = "", * ClosingPrayer = "", * OpeningSong = "", * SacramentSong = "", * IntermediateSong = "", * ClosingSong = "", * Speaker = "", * Subject = "", * } */ new Meeting { MeetingDate = DateTime.Parse("1981-11-15"), DateUpdated = DateTime.Now, Bishopric = "Billy Bob", OpeningPrayer = "Adam Smith", ClosingPrayer = "Old McDude", OpeningSong = "#426 Don't Hit People", SacramentSong = "#865 People Did Nice Things", ClosingSong = "#567 Undying Love ", Speaker = "Thing 1", Subject = "Stuff 1", } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new SacramentMeetingPlannerContext( serviceProvider.GetRequiredService < DbContextOptions <SacramentMeetingPlannerContext> >())) { //Look for any meeting if (context.Meeting.Any()) { return; //DB has been seeded. } context.Meeting.AddRange( new Meeting { Date = DateTime.Parse("2019-12-12"), Presiding = "Marco Bustillos", Leading = "Alexander Calva", Pianist = "Carlos Alonzo", MusicDirector = "Victor Alonzo", StakeAuthority = "Leonel Messi", EssentialAnnouncements = "Confirmation of two members", FirstHymn = "#41 - Let Zion in Her Beauty Rise", FirstPrayer = "Joseph Smith", WardAnnouncements = "Temple travel", SacramentHymn = "#40-Arise, O Glorious Zion", Speakersubjects = "Atonement", FirstMessagePerson = "Raul Rodriguez", Speakersubjects2 = "Fasting", SecondMessagePerson = "Paul McCartney", Speakersubjects3 = "Repentance", ThirdMessagePerson = "John Lennon", LastHymn = "#39-O Saints of Zion", LastPrayer = "Rafael Correa" }, new Meeting { Date = DateTime.Parse("2010-1-11"), Presiding = "John Lennon", Leading = "Paul McCartney", Pianist = "Carlos Alonzo", MusicDirector = "Victor Alonzo", StakeAuthority = "Michelle", EssentialAnnouncements = "Conference next week", FirstHymn = "#41 - Let Zion in Her Beauty Rise", FirstPrayer = "Joseph Smith", WardAnnouncements = "Come Follow Me - new Manual", SacramentHymn = "#40-Arise, O Glorious Zion", Speakersubjects = "Restoration", FirstMessagePerson = "Raul Rodriguez", Speakersubjects2 = "Priesthood", SecondMessagePerson = "Chopin", Speakersubjects3 = "Book of Mormon", ThirdMessagePerson = "Mark Zuckenberg", LastHymn = "#39-O Saints of Zion", LastPrayer = "Lenin Moreno" }, new Meeting { Date = DateTime.Parse("2019-12-12"), Presiding = "Mark Zuckenberg", Leading = "Bill Gates", Pianist = "Donald Trump", MusicDirector = "Hilary", StakeAuthority = "Ferdinand Nkenta", EssentialAnnouncements = "Family History", FirstHymn = "#41 - Let Zion in Her Beauty Rise", FirstPrayer = "John", WardAnnouncements = "Ministering", SacramentHymn = "#40-Arise, O Glorious Zion", Speakersubjects = "Sacrament", FirstMessagePerson = "Raul Rodriguez", Speakersubjects2 = "Church attending", SecondMessagePerson = "Paul McCartney", Speakersubjects3 = "Service", ThirdMessagePerson = "John Lennon", LastHymn = "#39-O Saints of Zion", LastPrayer = "Apple" } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new SacramentMeetingPlannerContext( serviceProvider.GetRequiredService <DbContextOptions <SacramentMeetingPlannerContext> >())) { // Look for any movies. if (context.PlannedMeeting.Any()) { return; // DB has been seeded } //int ID { get; set; } //DateTime MeetingDate { get; set; } //string Conductor { get; set; } //string OpeningSong { get; set; } //string StartPrayer { get; set; } //string SacramentSong { get; set; } //string SpeakerOne { get; set; } //string SpeakerTwo { get; set; } //string SpeakerThree { get; set; } //string SpeakerFour { get; set; } //string SpeakerFive { get; set; } //string OptionalSong { get; set; } //string ClosingSong { get; set; } //string EndPrayer { get; set; } context.PlannedMeeting.AddRange( new PlannedMeeting { MeetingDate = DateTime.Today.Date, Conductor = "Bishop Brown", OpenningSong = "Come thou Fount of Every Blessing", SacramentSong = "God Loved Us, So", ClosingSong = "Abide With Me!", StartPrayer = "Chase Konkle", EndPrayer = "Christine Konkle", SpeakerOne = "Dallan Prince", TopicOne = "Repentance", SpeakerTwo = "Devin Kelm", TopicTwo = "Keep the Sabbath Day Holy", SpeakerThree = "Mason Konkle", TopicThree = "Missionary Work", SpeakerFour = "", TopicFour = "", SpeakerFive = "", TopicFive = "" }, new PlannedMeeting { MeetingDate = DateTime.Today.Date, Conductor = "John Prince", OpenningSong = "Praise to the Man", SacramentSong = "There is a Green Hill", OptionalSong = "God Speed the Right", ClosingSong = "Abide With Me; 'tis Eventide", StartPrayer = "Ammon DeCrescenzo", EndPrayer = "Paula Prince", SpeakerOne = "Emily Kelm", TopicOne = "Temple Attendance", SpeakerTwo = "Michael Kelm", TopicTwo = "Eternal Families", SpeakerThree = "", TopicThree = "", SpeakerFour = "", TopicFour = "", SpeakerFive = "", TopicFive = "" }, new PlannedMeeting { MeetingDate = DateTime.Today.Date, Conductor = "Aaron Burt", OpenningSong = "How Firm a Foundation", SacramentSong = "While of These Enblems We Partake", OptionalSong = "The Spirit of God", ClosingSong = "God Be With You till We Meet Again", StartPrayer = "Gina Russell", EndPrayer = "Levi DeCrescenzo", SpeakerOne = "The Congregation", TopicOne = "Bearing of Testimonies", SpeakerTwo = "", TopicTwo = "", SpeakerThree = "", TopicThree = "", SpeakerFour = "", TopicFour = "", SpeakerFive = "", TopicFive = "" } ); context.SaveChanges(); } }