示例#1
0
        public async Task <IActionResult> OnPostAsync(string[] selectedSongs, string[] selectedSpeakers, string[] selectedPrayers)
        {
            if (!ModelState.IsValid)
            {
                return(Page());
            }

            var plan = new Plans();

            if (selectedSongs != null)
            {
                plan.SongToPlan = new List <SongToPlan>();
                foreach (var song in selectedSongs)
                {
                    var songToAdd = new SongToPlan
                    {
                        SongAssignmentID = int.Parse(song)
                    };
                    plan.SongToPlan.Add(songToAdd);
                }
            }

            if (selectedSpeakers != null)
            {
                plan.SpeakToPlan = new List <SpeakToPlan>();
                foreach (var speaker in selectedSpeakers)
                {
                    var speakerToAdd = new SpeakToPlan
                    {
                        SpeakAssignmentID = int.Parse(speaker)
                    };
                    plan.SpeakToPlan.Add(speakerToAdd);
                }
            }

            if (selectedPrayers != null)
            {
                plan.PrayerToPlan = new List <PrayerToPlan>();
                foreach (var pray in selectedPrayers)
                {
                    var prayToAdd = new PrayerToPlan
                    {
                        PrayerToPlanID = int.Parse(pray)
                    };
                    plan.PrayerToPlan.Add(prayToAdd);
                }
            }

            if (await TryUpdateModelAsync <Plans>(
                    plan,
                    "plans",
                    i => i.PlansID,
                    i => i.PlanDate,
                    i => i.RoleID))
            {
                _context.Plans.Add(plan);
                await _context.SaveChangesAsync();

                return(RedirectToPage("./Index"));
            }

            // Conducting Drop Down
            PopulateRoleDropDownList(_context);

            // Song checkboxes
            PopulateSongCheckboxes(_context, plan);

            // Speaker checkboxes
            PopulateSpeakerCheckboxes(_context, plan);

            // Prayer checkboxes
            PopulatePrayerCheckboxes(_context, plan);

            _context.Plans.Add(Plans);
            await _context.SaveChangesAsync();

            return(RedirectToPage("./Index"));
        }
        public static void Initialize(PlannerContext context)
        {
            //context.Database.EnsureCreated();

            // Look for any roles.
            if (context.Role.Any())
            {
                return;   // DB has been seeded
            }

            // ------------------------------------Role----------------------------------
            var roles = new Role[]
            {
                new Role {
                    RoleTypeName = "Bishop"
                },
                new Role {
                    RoleTypeName = "First Counselor"
                },
                new Role {
                    RoleTypeName = "Second Counselor"
                }
            };

            foreach (Role r in roles)
            {
                context.Role.Add(r);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------

            // ------------------------------------Member----------------------------------
            var members = new Member[]
            {
                new Member {
                    MemberName = "Michael Jordan"
                },
                new Member {
                    MemberName = "Gandhi"
                },
                new Member {
                    MemberName = "Donald Trump Jr."
                },
                new Member {
                    MemberName = "Dick Van Dyke"
                },
                new Member {
                    MemberName = "Benjamin Franklin"
                },
                new Member {
                    MemberName = "Winston Churchill"
                },
                new Member {
                    MemberName = "Bill Gates"
                },
                new Member {
                    MemberName = "Steve Jobs"
                },
                new Member {
                    MemberName = "Elvis Presley"
                },
                new Member {
                    MemberName = "Mother Teresa"
                },
                new Member {
                    MemberName = "Martin Luther King"
                },
                new Member {
                    MemberName = "JFK"
                },
                new Member {
                    MemberName = "Abraham Lincoln"
                },
                new Member {
                    MemberName = "Leonardo da Vinci"
                },
                new Member {
                    MemberName = "Tom Cruise"
                }
            };

            foreach (Member m in members)
            {
                context.Member.Add(m);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------

            // ------------------------------------PrayerType----------------------------------
            var prayerTypes = new PrayerType[]
            {
                new PrayerType {
                    PrayerTypeName = "Opening Prayer"
                },
                new PrayerType {
                    PrayerTypeName = "Closing Prayer"
                }
            };

            foreach (PrayerType pt in prayerTypes)
            {
                context.PrayerType.Add(pt);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------

            // ------------------------------------Songs----------------------------------
            var songs = new Song[]
            {
                new Song {
                    SongName   = "I Saw a Mighty Angel Fly",
                    SongNumber = 15
                },
                new Song {
                    SongName   = "We Thank Thee, O God, for a Prophet",
                    SongNumber = 19
                },
                new Song {
                    SongName   = "While of These Emblems We Partake",
                    SongNumber = 173
                },
                new Song {
                    SongName   = "Reverently and Meekly Now",
                    SongNumber = 185
                },
                new Song {
                    SongName   = "I Stand All Amazed",
                    SongNumber = 193
                },
                new Song {
                    SongName   = "He Is Risen!",
                    SongNumber = 199
                },
                new Song {
                    SongName   = "Put Your Shoulder to the Wheel",
                    SongNumber = 252
                },
                new Song {
                    SongName   = "Hope of Israel",
                    SongNumber = 259
                },
                new Song {
                    SongName   = "Arise, O God, and Shine",
                    SongNumber = 265
                },
                new Song {
                    SongName   = "The Iron Rod",
                    SongNumber = 274
                }
            };

            foreach (Song s in songs)
            {
                context.Song.Add(s);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------

            // ------------------------------------SongType----------------------------------
            var songTypes = new SongType[]
            {
                new SongType {
                    SongTypeName = "Opening Song"
                },
                new SongType {
                    SongTypeName = "Sacrament Song"
                },
                new SongType {
                    SongTypeName = "Intermediate Song"
                },
                new SongType {
                    SongTypeName = "Closing Song"
                }
            };

            foreach (SongType st in songTypes)
            {
                context.SongType.Add(st);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------

            // ------------------------------------Subject----------------------------------
            var subjects = new Subject[]
            {
                new Subject {
                    SubjectName = "Hope"
                },
                new Subject {
                    SubjectName = "Repentance"
                },
                new Subject {
                    SubjectName = "Love"
                },
                new Subject {
                    SubjectName = "Ministering"
                },
                new Subject {
                    SubjectName = "Family Home Evening"
                },
                new Subject {
                    SubjectName = "Tithing"
                },
                new Subject {
                    SubjectName = "The Atonement"
                },
                new Subject {
                    SubjectName = "The Relief Society"
                },
                new Subject {
                    SubjectName = "The Priesthood"
                },
                new Subject {
                    SubjectName = "Magnifying Callings"
                }
            };

            foreach (Subject s in subjects)
            {
                context.Subject.Add(s);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------

            // ------------------------------------Bishopric----------------------------------
            var bishopric = new Bishopric[]
            {
                new Bishopric {
                    RoleID   = roles.Single(s => s.RoleTypeName == "Bishop").RoleID,
                    MemberID = members.Single(s => s.MemberName == "Michael Jordan").MemberID
                },
                new Bishopric {
                    RoleID   = roles.Single(s => s.RoleTypeName == "First Counselor").RoleID,
                    MemberID = members.Single(s => s.MemberName == "Gandhi").MemberID
                },
                new Bishopric {
                    RoleID   = roles.Single(s => s.RoleTypeName == "Second Counselor").RoleID,
                    MemberID = members.Single(s => s.MemberName == "Donald Trump Jr.").MemberID
                },
                new Bishopric {
                    RoleID       = roles.Single(s => s.RoleTypeName == "Bishop").RoleID,
                    MemberID     = members.Single(s => s.MemberName == "Dick Van Dyke").MemberID,
                    ReleasedFlag = true
                },
                new Bishopric {
                    RoleID       = roles.Single(s => s.RoleTypeName == "First Counselor").RoleID,
                    MemberID     = members.Single(s => s.MemberName == "Benjamin Franklin").MemberID,
                    ReleasedFlag = true
                }
            };

            foreach (Bishopric b in bishopric)
            {
                context.Bishopric.Add(b);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------Prayer----------------------------------
            var prayers = new Prayer[]
            {
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Michael Jordan").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Gandhi").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Donald Trump Jr.").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Dick Van Dyke").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Benjamin Franklin").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Winston Churchill").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Bill Gates").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Steve Jobs").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Elvis Presley").MemberID
                },
                new Prayer {
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Mother Teresa").MemberID
                }
            };

            foreach (Prayer p in prayers)
            {
                context.Prayer.Add(p);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------SongAssignment----------------------------------

            //Opening Song
            //Sacrament Song
            //Intermediate Song
            //Closing Song

            var songAssignments = new SongAssignment[]
            {
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "I Saw a Mighty Angel Fly").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Opening Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "While of These Emblems We Partake").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Sacrament Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "He Is Risen!").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Intermediate Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "We Thank Thee, O God, for a Prophet").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Closing Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "I Saw a Mighty Angel Fly").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Opening Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "While of These Emblems We Partake").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Sacrament Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "We Thank Thee, O God, for a Prophet").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Closing Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "I Saw a Mighty Angel Fly").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Opening Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "Reverently and Meekly Now").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Sacrament Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "He Is Risen!").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Intermediate Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "Hope of Israel").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Closing Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "I Saw a Mighty Angel Fly").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Opening Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "While of These Emblems We Partake").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Sacrament Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "We Thank Thee, O God, for a Prophet").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Closing Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "Arise, O God, and Shine").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Opening Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "While of These Emblems We Partake").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Sacrament Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "Put Your Shoulder to the Wheel").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Intermediate Song").SongTypeID
                },
                new SongAssignment {
                    SongID     = songs.Single(s => s.SongName == "Hope of Israel").SongID,
                    SongTypeID = songTypes.Single(s => s.SongTypeName == "Closing Song").SongTypeID
                }
            };

            foreach (SongAssignment sa in songAssignments)
            {
                context.SongAssignment.Add(sa);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------SpeakAssignment----------------------------------
            var speakAssignments = new SpeakAssignment[]
            {
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Dick Van Dyke").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Hope").SubjectID,
                    SpeakerPlacement = 1
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Benjamin Franklin").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Repentance").SubjectID,
                    SpeakerPlacement = 2
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Winston Churchill").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Love").SubjectID,
                    SpeakerPlacement = 3
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Bill Gates").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Ministering").SubjectID,
                    SpeakerPlacement = 4
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Steve Jobs").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Family Home Evening").SubjectID,
                    SpeakerPlacement = 1
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Elvis Presley").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Tithing").SubjectID,
                    SpeakerPlacement = 2
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Mother Teresa").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "The Atonement").SubjectID,
                    SpeakerPlacement = 3
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Martin Luther King").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "The Relief Society").SubjectID,
                    SpeakerPlacement = 1
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "JFK").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "The Priesthood").SubjectID,
                    SpeakerPlacement = 2
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Abraham Lincoln").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Magnifying Callings").SubjectID,
                    SpeakerPlacement = 3
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Leonardo da Vinci").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Hope").SubjectID,
                    SpeakerPlacement = 4
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Tom Cruise").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Repentance").SubjectID,
                    SpeakerPlacement = 1
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Dick Van Dyke").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Love").SubjectID,
                    SpeakerPlacement = 2
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Benjamin Franklin").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Ministering").SubjectID,
                    SpeakerPlacement = 3
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Winston Churchill").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Family Home Evening").SubjectID,
                    SpeakerPlacement = 1
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Bill Gates").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "Tithing").SubjectID,
                    SpeakerPlacement = 2
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Steve Jobs").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "The Atonement").SubjectID,
                    SpeakerPlacement = 3
                },
                new SpeakAssignment {
                    MemberID         = members.Single(s => s.MemberName == "Elvis Presley").MemberID,
                    SubjectID        = subjects.Single(s => s.SubjectName == "The Relief Society").SubjectID,
                    SpeakerPlacement = 4
                }
            };

            foreach (SpeakAssignment sa in speakAssignments)
            {
                context.SpeakAssignment.Add(sa);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------Plans----------------------------------
            var plans = new Plans[]
            {
                new Plans {
                    PlanDate = DateTime.Parse("2018-07-22"),
                    RoleID   = roles.Single(s => s.RoleID == 2).RoleID
                },
                new Plans {
                    PlanDate = DateTime.Parse("2018-07-15"),
                    RoleID   = roles.Single(s => s.RoleID == 1).RoleID
                },
                new Plans {
                    PlanDate = DateTime.Parse("2018-07-08"),
                    RoleID   = roles.Single(s => s.RoleID == 3).RoleID
                },
                new Plans {
                    PlanDate = DateTime.Parse("2018-07-01"),
                    RoleID   = roles.Single(s => s.RoleID == 1).RoleID
                },
                new Plans {
                    PlanDate = DateTime.Parse("2018-06-24"),
                    RoleID   = roles.Single(s => s.RoleID == 1).RoleID
                },
            };

            foreach (Plans p in plans)
            {
                context.Plans.Add(p);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------PrayerToPlan----------------------------------
            var prayerToPlans = new PrayerToPlan[]
            {
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 1).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Michael Jordan").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 1).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Gandhi").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 2).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Donald Trump Jr.").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 2).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Dick Van Dyke").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 3).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Benjamin Franklin").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 3).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Winston Churchill").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 4).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Bill Gates").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 4).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Steve Jobs").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 5).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Closing Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Elvis Presley").MemberID
                },
                new PrayerToPlan {
                    PlansID      = plans.Single(s => s.PlansID == 5).PlansID,
                    PrayerTypeID = prayerTypes.Single(s => s.PrayerTypeName == "Opening Prayer").PrayerTypeID,
                    MemberID     = members.Single(s => s.MemberName == "Mother Teresa").MemberID
                }
            };

            foreach (PrayerToPlan ptp in prayerToPlans)
            {
                context.PrayerToPlan.Add(ptp);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------SongToPlan----------------------------------
            var songToPlans = new SongToPlan[]
            {
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 1).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 1).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 1).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 2).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 1).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 3).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 1).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 4).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 2).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 5).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 2).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 6).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 2).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 7).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 3).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 8).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 3).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 9).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 3).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 10).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 3).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 11).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 4).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 12).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 4).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 13).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 4).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 14).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 5).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 15).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 5).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 16).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 5).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 17).SongAssignmentID
                },
                new SongToPlan {
                    PlansID          = plans.Single(s => s.PlansID == 5).PlansID,
                    SongAssignmentID = songAssignments.Single(s => s.SongAssignmentID == 18).SongAssignmentID
                },
            };

            foreach (SongToPlan stp in songToPlans)
            {
                context.SongToPlan.Add(stp);
            }
            context.SaveChanges();

            // ----------------------------------------------------------------------------

            // ------------------------------------SpeakToPlan----------------------------------
            var speakToPlans = new SpeakToPlan[]
            {
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 1).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 1).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 1).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 2).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 1).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 3).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 1).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 4).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 2).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 5).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 2).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 6).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 2).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 7).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 3).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 8).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 3).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 9).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 3).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 10).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 3).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 11).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 4).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 12).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 4).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 13).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 4).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 14).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 5).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 15).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 5).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 16).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 5).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 17).SpeakAssignmentID
                },
                new SpeakToPlan {
                    PlansID           = plans.Single(s => s.PlansID == 5).PlansID,
                    SpeakAssignmentID = speakAssignments.Single(s => s.SpeakAssignmentID == 18).SpeakAssignmentID
                }
            };

            foreach (SpeakToPlan stp in speakToPlans)
            {
                context.SpeakToPlan.Add(stp);
            }
            context.SaveChanges();
            // ----------------------------------------------------------------------------
        }