Exemplo n.º 1
0
        protected override void Seed(GolfTourDAL.EF.GolfTourEntities context)
        {
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data.
            var golfers = new List <Golfer>
            {
                new Golfer {
                    Name = "Gert", Surname = "Coetzee"
                },
                new Golfer {
                    Name = "Craig", Surname = "Lazar"
                },
                new Golfer {
                    Name = "Hano", Surname = "Pano"
                }
            };

            golfers.ForEach(g => context.Golfers.AddOrUpdate(g));

            var testCourse = new GolfCourse {
                Name = "Durban Country Club"
            };

            context.GolfCourses.AddOrUpdate(testCourse);

            var holes = new List <CourseHole>
            {
                new CourseHole {
                    HoleNumber = 1, Par = 4, Stroke = 1
                },
                new CourseHole {
                    HoleNumber = 2, Par = 4, Stroke = 2
                },
                new CourseHole {
                    HoleNumber = 3, Par = 3, Stroke = 3
                },
                new CourseHole {
                    HoleNumber = 4, Par = 4, Stroke = 4
                },
                new CourseHole {
                    HoleNumber = 5, Par = 3, Stroke = 5
                },
                new CourseHole {
                    HoleNumber = 6, Par = 4, Stroke = 6
                },
                new CourseHole {
                    HoleNumber = 7, Par = 5, Stroke = 7
                },
                new CourseHole {
                    HoleNumber = 8, Par = 4, Stroke = 8
                },
                new CourseHole {
                    HoleNumber = 9, Par = 5, Stroke = 9
                }
            };

            testCourse.Holes = holes;

            var courseRound = new CourseRound
            {
                Date       = DateTime.Now.Subtract(new TimeSpan(0, 1, 0)),
                ScoreType  = ScoreType.MatchPlay,
                GolfCourse = testCourse
            };

            context.CourseRound.AddOrUpdate(courseRound);

            var courseRoundHoles = new List <CourseRoundHole>
            {
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 1),
                    Golfer     = golfers[1],
                    Strokes    = 4
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 1),
                    Golfer     = golfers[2],
                    Strokes    = 5
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 2),
                    Golfer     = golfers[1],
                    Strokes    = 3
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 2),
                    Golfer     = golfers[2],
                    Strokes    = 4
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 3),
                    Golfer     = golfers[2],
                    Strokes    = 6
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 3),
                    Golfer     = golfers[2],
                    Strokes    = 5
                }
            };

            courseRoundHoles.ForEach(r => context.CourseRoundHoles.AddOrUpdate(r));

            context.SaveChanges();
        }
Exemplo n.º 2
0
        protected override void Seed(GolfTourEntities context)
        {
            var golfers = new List <Golfer>
            {
                new Golfer {
                    Name = "Gert", Surname = "Coetzee"
                },
                new Golfer {
                    Name = "Craig", Surname = "Lazar"
                },
                new Golfer {
                    Name = "Hano", Surname = "Pano"
                }
            };

            golfers.ForEach(g => context.Golfers.Add(g));

            var testCourse = new GolfCourse {
                Name = "Durban Country Club"
            };

            context.GolfCourses.Add(testCourse);

            var holes = new List <CourseHole>
            {
                new CourseHole {
                    HoleNumber = 1, Par = 4, Stroke = 1
                },
                new CourseHole {
                    HoleNumber = 2, Par = 4, Stroke = 2
                },
                new CourseHole {
                    HoleNumber = 3, Par = 3, Stroke = 3
                },
                new CourseHole {
                    HoleNumber = 4, Par = 4, Stroke = 4
                },
                new CourseHole {
                    HoleNumber = 5, Par = 3, Stroke = 5
                },
                new CourseHole {
                    HoleNumber = 6, Par = 4, Stroke = 6
                },
                new CourseHole {
                    HoleNumber = 7, Par = 5, Stroke = 7
                },
                new CourseHole {
                    HoleNumber = 8, Par = 4, Stroke = 8
                },
                new CourseHole {
                    HoleNumber = 9, Par = 5, Stroke = 9
                }
            };

            testCourse.Holes = holes;

            var courseRound = new CourseRound
            {
                Date       = DateTime.Now.Subtract(new TimeSpan(0, 1, 0)),
                ScoreType  = ScoreType.MatchPlay,
                GolfCourse = testCourse
            };

            context.CourseRound.Add(courseRound);

            var courseRoundHoles = new List <CourseRoundHole>
            {
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 1),
                    Golfer     = golfers[1],
                    Strokes    = 4
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 1),
                    Golfer     = golfers[2],
                    Strokes    = 5
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 2),
                    Golfer     = golfers[1],
                    Strokes    = 3
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 2),
                    Golfer     = golfers[2],
                    Strokes    = 4
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 3),
                    Golfer     = golfers[2],
                    Strokes    = 6
                },
                new CourseRoundHole
                {
                    CourseRoud = courseRound,
                    CourseHole = courseRound.GolfCourse.Holes.FirstOrDefault(h => h.HoleNumber == 3),
                    Golfer     = golfers[2],
                    Strokes    = 5
                }
            };

            courseRoundHoles.ForEach(r => context.CourseRoundHoles.Add(r));

            context.SaveChanges();
        }