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