public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
CurrentCalling = await _context.CurrentCalling
.Include(c => c.Calling)
.Include(c => c.Member).FirstOrDefaultAsync(m => m.CurrentCallingID == id);
if (CurrentCalling == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
CurrentCalling = await _context.CurrentCalling.FindAsync(id);
if (CurrentCalling != null)
{
_context.CurrentCalling.Remove(CurrentCalling);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
CurrentCalling = await _context.CurrentCalling
.Include(c => c.Calling)
.Include(c => c.Member).FirstOrDefaultAsync(m => m.CurrentCallingID == id);
if (CurrentCalling == null)
{
return(NotFound());
}
ViewData["CallingID"] = new SelectList(_context.Calling, "CallingID", "Display");
ViewData["MemberID"] = new SelectList(_context.Member, "ID", "FullName");
return(Page());
}
public static void Initialize(SacramentMeetingContext context)
{
// context.Database.EnsureCreated();
// Look for any Members
if (context.Member.Any())
{
return; // Db already has data
}
var members = new Member[]
{
new Member {
FirstName = "Joseph", LastName = "Smith", MembersGender = Gender.Male
},
new Member {
FirstName = "Emma", LastName = "Smith", MembersGender = Gender.Female
},
new Member {
FirstName = "Jeffrey", LastName = "Holland", MembersGender = Gender.Male
},
new Member {
FirstName = "Donnie", LastName = "Osmond", MembersGender = Gender.Male
},
new Member {
FirstName = "Marie", LastName = "Osmond", MembersGender = Gender.Female
},
new Member {
FirstName = "David", LastName = "Archuletta", MembersGender = Gender.Male
},
new Member {
FirstName = "Katherine", LastName = "Heigl", MembersGender = Gender.Female
},
new Member {
FirstName = "Glenn", LastName = "Beck", MembersGender = Gender.Male
},
new Member {
FirstName = "Mitt", LastName = "Romney", MembersGender = Gender.Male
},
new Member {
FirstName = "Julianne", LastName = "Hough", MembersGender = Gender.Female
},
new Member {
FirstName = "Brandon", LastName = "Flowers", MembersGender = Gender.Male
},
new Member {
FirstName = "Merlin", LastName = "Olsen", MembersGender = Gender.Male
},
new Member {
FirstName = "Ricky", LastName = "Schroder", MembersGender = Gender.Male
},
new Member {
FirstName = "Gladys", LastName = "Knight", MembersGender = Gender.Female
},
new Member {
FirstName = "Jack", LastName = "Dempsey", MembersGender = Gender.Male
},
new Member {
FirstName = "Danny", LastName = "Ainge", MembersGender = Gender.Male
},
new Member {
FirstName = "Dieter", LastName = "Uchtdorf", MembersGender = Gender.Male
},
};
foreach (Member m in members)
{
context.Member.Add(m);
}
context.SaveChanges();
var callings = new Calling[]
{
new Calling {
Title = "Bishop", Organization = Organizations.Bishopric, CallingGender = GenderCl.Male
},
new Calling {
Title = "1st Counselor", Organization = Organizations.Bishopric, CallingGender = GenderCl.Male
},
new Calling {
Title = "2nd Counselor", Organization = Organizations.Bishopric, CallingGender = GenderCl.Male
},
new Calling {
Title = "Organist", Organization = Organizations.Music, CallingGender = GenderCl.Both
},
new Calling {
Title = "Choirister", Organization = Organizations.Music, CallingGender = GenderCl.Both
},
new Calling {
Title = "2nd Counselor", Organization = Organizations.Young_Men, CallingGender = GenderCl.Male
},
new Calling {
Title = "President", Organization = Organizations.Young_Men, CallingGender = GenderCl.Male
},
new Calling {
Title = "1st Counselor", Organization = Organizations.Young_Men, CallingGender = GenderCl.Male
},
new Calling {
Title = "2nd Counselor", Organization = Organizations.Primary, CallingGender = GenderCl.Female
},
new Calling {
Title = "2nd Counselor", Organization = Organizations.Young_Women, CallingGender = GenderCl.Female
},
new Calling {
Title = "President", Organization = Organizations.Primary, CallingGender = GenderCl.Female
},
new Calling {
Title = "President", Organization = Organizations.Young_Women, CallingGender = GenderCl.Female
},
new Calling {
Title = "1st Counselor", Organization = Organizations.Young_Women, CallingGender = GenderCl.Female
},
new Calling {
Title = "1st Counselor", Organization = Organizations.Primary, CallingGender = GenderCl.Female
},
new Calling {
Title = "Teacher 8yr Olds", Organization = Organizations.Primary, CallingGender = GenderCl.Both
},
new Calling {
Title = "Teacher 7yr Old", Organization = Organizations.Primary, CallingGender = GenderCl.Both
},
};
foreach (Calling c in callings)
{
context.Calling.Add(c);
}
context.SaveChanges();
var currentCallings = new CurrentCalling[]
{
new CurrentCalling {
MemberID = 4, CallingID = 1, DateCalled = DateTime.Parse("2018-3-01")
},
new CurrentCalling {
MemberID = 1, CallingID = 2, DateCalled = DateTime.Parse("2018-3-01")
},
new CurrentCalling {
MemberID = 9, CallingID = 3, DateCalled = DateTime.Parse("2018-3-01")
},
new CurrentCalling {
MemberID = 5, CallingID = 4, DateCalled = DateTime.Parse("2002-9-05")
},
new CurrentCalling {
MemberID = 7, CallingID = 5, DateCalled = DateTime.Parse("2017-4-19")
},
new CurrentCalling {
MemberID = 11, CallingID = 6, DateCalled = DateTime.Parse("2015-8-13")
},
new CurrentCalling {
MemberID = 13, CallingID = 7, DateCalled = DateTime.Parse("2015-8-06")
},
};
foreach (CurrentCalling c in currentCallings)
{
context.CurrentCalling.Add(c);
}
context.SaveChanges();
var songs = new Song[]
{
new Song {
SongID = 2, Title = "The Spirit of God"
},
new Song {
SongID = 8, Title = "Redeemer Of Israel"
},
new Song {
SongID = 19, Title = "We Thank The O God For A Prophet"
},
new Song {
SongID = 26, Title = "Joseph Smith's First Prayer"
},
new Song {
SongID = 35, Title = "For The Strength Of The Hills"
},
new Song {
SongID = 41, Title = "Let Zion In Her Beauty Rise"
},
new Song {
SongID = 58, Title = "Come Ye Children Of The Lord"
},
new Song {
SongID = 66, Title = "Rejoice, The Lord Is King"
},
new Song {
SongID = 85, Title = "How Firm A Foundation"
},
new Song {
SongID = 89, Title = "The Lord Is My Light"
},
new Song {
SongID = 92, Title = "For The Beauty Of The Earth"
},
new Song {
SongID = 96, Title = "Dearest Children God Is Near You"
},
new Song {
SongID = 97, Title = "Lead Kindly Light"
},
new Song {
SongID = 98, Title = "I Need Thee Every Hour"
},
new Song {
SongID = 116, Title = "Come, Follow Me"
},
new Song {
SongID = 169, Title = "As Now We Take The Sacrament"
},
new Song {
SongID = 173, Title = "While Of These Emblems We Partake"
},
new Song {
SongID = 181, Title = "Jesus Of Nazereth, Savior And King"
},
new Song {
SongID = 184, Title = "Upon The Cross of Calvary"
},
new Song {
SongID = 185, Title = "Reverently And Meekly Now"
},
new Song {
SongID = 188, Title = "Thy Will O Lord, Be Done"
},
new Song {
SongID = 193, Title = "I Stand All Amazed"
},
new Song {
SongID = 194, Title = "There Is A Green Hill Far Away"
},
new Song {
SongID = 196, Title = "Jesus, Once Of Humble Birth"
}
};
foreach (Song s in songs)
{
context.Song.Add(s);
}
context.SaveChanges();
var meetings = new Meeting[]
{
new Meeting {
MeetingDate = DateTime.Parse("2019-12-9"), CallingID = 1
},
new Meeting {
MeetingDate = DateTime.Parse("2019-12-16"), CallingID = 1
},
new Meeting {
MeetingDate = DateTime.Parse("2019-12-23"), CallingID = 1
},
new Meeting {
MeetingDate = DateTime.Parse("2019-12-30"), CallingID = 1
},
};
foreach (Meeting m in meetings)
{
context.Meeting.Add(m);
}
context.SaveChanges();
var songSelections = new SongSelection[]
{
new SongSelection {
SongID = 2, MeetingID = 1, Schedule = SongPosition.Opening
},
new SongSelection {
SongID = 173, MeetingID = 1, Schedule = SongPosition.Sacrament
},
new SongSelection {
SongID = 8, MeetingID = 1, Schedule = SongPosition.Closing
},
new SongSelection {
SongID = 19, MeetingID = 2, Schedule = SongPosition.Opening
},
new SongSelection {
SongID = 181, MeetingID = 2, Schedule = SongPosition.Sacrament
},
new SongSelection {
SongID = 26, MeetingID = 2, Schedule = SongPosition.Closing
},
new SongSelection {
SongID = 35, MeetingID = 3, Schedule = SongPosition.Opening
},
new SongSelection {
SongID = 194, MeetingID = 3, Schedule = SongPosition.Sacrament
},
new SongSelection {
SongID = 66, MeetingID = 3, Schedule = SongPosition.Closing
},
new SongSelection {
SongID = 85, MeetingID = 4, Schedule = SongPosition.Opening
},
new SongSelection {
SongID = 196, MeetingID = 4, Schedule = SongPosition.Sacrament
},
new SongSelection {
SongID = 98, MeetingID = 4, Schedule = SongPosition.Closing
},
};
foreach (SongSelection s in songSelections)
{
context.SongSelection.Add(s);
}
context.SaveChanges();
var prayers = new Prayer[]
{
new Prayer {
MeetingID = 1, MemberID = 10, Schedule = PrayerPosition.Opening
},
new Prayer {
MeetingID = 1, MemberID = 11, Schedule = PrayerPosition.Closing
},
new Prayer {
MeetingID = 2, MemberID = 12, Schedule = PrayerPosition.Opening
},
new Prayer {
MeetingID = 2, MemberID = 13, Schedule = PrayerPosition.Closing
},
new Prayer {
MeetingID = 3, MemberID = 14, Schedule = PrayerPosition.Opening
},
new Prayer {
MeetingID = 3, MemberID = 15, Schedule = PrayerPosition.Closing
},
new Prayer {
MeetingID = 4, MemberID = 16, Schedule = PrayerPosition.Opening
},
new Prayer {
MeetingID = 4, MemberID = 1, Schedule = PrayerPosition.Closing
},
};
foreach (Prayer p in prayers)
{
context.Prayer.Add(p);
}
context.SaveChanges();
var talks = new Talk[]
{
new Talk {
MeetingID = 1, MemberID = 1, Topic = "Coming closer to Christ through Christmas traditions"
},
new Talk {
MeetingID = 1, MemberID = 2, Topic = "Jesus in America"
},
new Talk {
MeetingID = 1, MemberID = 3, Topic = "Prophets fortell of Jesus Birth"
},
new Talk {
MeetingID = 2, MemberID = 4, Topic = "Forgiveness"
},
new Talk {
MeetingID = 2, MemberID = 5, Topic = "Giving Service during the Holidays"
},
new Talk {
MeetingID = 3, MemberID = 6, Topic = "Christ-Like Attributes"
},
new Talk {
MeetingID = 3, MemberID = 7, Topic = "'Taking Upon Ourselves the Name of Jesus Christ' by Robert C Gay Oct.2018"
},
};
foreach (Talk t in talks)
{
context.Talk.Add(t);
}
context.SaveChanges();
}
