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();
}
}