コード例 #1
0
 public DetailsModel(EFCore.Web.Data.SchoolContext context)
 {
     _context = context;
 }
コード例 #2
0
ファイル: Create.cshtml.cs プロジェクト: iwenli/LearnPro
 public CreateModel(EFCore.Web.Data.SchoolContext context)
 {
     _context = context;
 }
コード例 #3
0
ファイル: Edit.cshtml.cs プロジェクト: iwenli/LearnPro
 public EditModel(EFCore.Web.Data.SchoolContext context)
 {
     _context = context;
 }
コード例 #4
0
ファイル: Index.cshtml.cs プロジェクト: iwenli/LearnPro
 public IndexModel(SchoolContext context, IConfiguration configration)
 {
     _context      = context;
     _configration = configration;
 }
コード例 #5
0
 public DeleteModel(EFCore.Web.Data.SchoolContext context,
                    ILogger <DeleteModel> logger)
 {
     _context = context;
     _logger  = logger;
 }
コード例 #6
0
ファイル: Index.cshtml.cs プロジェクト: iwenli/LearnPro
 public IndexModel(EFCore.Web.Data.SchoolContext context)
 {
     _context = context;
 }
コード例 #7
0
        public static void Initialize(SchoolContext context)
        {
            context.Database.EnsureCreated();

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

            var alexander = new Student
            {
                FirstMidName   = "Carson",
                LastName       = "Alexander",
                EnrollmentDate = DateTime.Parse("2016-09-01")
            };

            var alonso = new Student
            {
                FirstMidName   = "Meredith",
                LastName       = "Alonso",
                EnrollmentDate = DateTime.Parse("2018-09-01")
            };

            var anand = new Student
            {
                FirstMidName   = "Arturo",
                LastName       = "Anand",
                EnrollmentDate = DateTime.Parse("2019-09-01")
            };

            var barzdukas = new Student
            {
                FirstMidName   = "Gytis",
                LastName       = "Barzdukas",
                EnrollmentDate = DateTime.Parse("2018-09-01")
            };

            var li = new Student
            {
                FirstMidName   = "Yan",
                LastName       = "Li",
                EnrollmentDate = DateTime.Parse("2018-09-01")
            };

            var justice = new Student
            {
                FirstMidName   = "Peggy",
                LastName       = "Justice",
                EnrollmentDate = DateTime.Parse("2017-09-01")
            };

            var norman = new Student
            {
                FirstMidName   = "Laura",
                LastName       = "Norman",
                EnrollmentDate = DateTime.Parse("2019-09-01")
            };

            var olivetto = new Student
            {
                FirstMidName   = "Nino",
                LastName       = "Olivetto",
                EnrollmentDate = DateTime.Parse("2011-09-01")
            };

            var abercrombie = new Instructor
            {
                FirstMidName = "Kim",
                LastName     = "Abercrombie",
                HireDate     = DateTime.Parse("1995-03-11")
            };

            var fakhouri = new Instructor
            {
                FirstMidName = "Fadi",
                LastName     = "Fakhouri",
                HireDate     = DateTime.Parse("2002-07-06")
            };

            var harui = new Instructor
            {
                FirstMidName = "Roger",
                LastName     = "Harui",
                HireDate     = DateTime.Parse("1998-07-01")
            };

            var kapoor = new Instructor
            {
                FirstMidName = "Candace",
                LastName     = "Kapoor",
                HireDate     = DateTime.Parse("2001-01-15")
            };

            var zheng = new Instructor
            {
                FirstMidName = "Roger",
                LastName     = "Zheng",
                HireDate     = DateTime.Parse("2004-02-12")
            };

            var officeAssignments = new OfficeAssignment[]
            {
                new OfficeAssignment {
                    Instructor = fakhouri,
                    Location   = "Smith 17"
                },
                new OfficeAssignment {
                    Instructor = harui,
                    Location   = "Gowan 27"
                },
                new OfficeAssignment {
                    Instructor = kapoor,
                    Location   = "Thompson 304"
                },
            };

            context.AddRange(officeAssignments);

            var english = new Department
            {
                Name          = "English",
                Budget        = 350000,
                StartDate     = DateTime.Parse("2007-09-01"),
                Administrator = abercrombie
            };

            var mathematics = new Department
            {
                Name          = "Mathematics",
                Budget        = 100000,
                StartDate     = DateTime.Parse("2007-09-01"),
                Administrator = fakhouri
            };

            var engineering = new Department
            {
                Name          = "Engineering",
                Budget        = 350000,
                StartDate     = DateTime.Parse("2007-09-01"),
                Administrator = harui
            };

            var economics = new Department
            {
                Name          = "Economics",
                Budget        = 100000,
                StartDate     = DateTime.Parse("2007-09-01"),
                Administrator = kapoor
            };

            var chemistry = new Course
            {
                CourseID    = 1050,
                Title       = "Chemistry",
                Credits     = 3,
                Department  = engineering,
                Instructors = new List <Instructor> {
                    kapoor, harui
                }
            };

            var microeconomics = new Course
            {
                CourseID    = 4022,
                Title       = "Microeconomics",
                Credits     = 3,
                Department  = economics,
                Instructors = new List <Instructor> {
                    zheng
                }
            };

            var macroeconmics = new Course
            {
                CourseID    = 4041,
                Title       = "Macroeconomics",
                Credits     = 3,
                Department  = economics,
                Instructors = new List <Instructor> {
                    zheng
                }
            };

            var calculus = new Course
            {
                CourseID    = 1045,
                Title       = "Calculus",
                Credits     = 4,
                Department  = mathematics,
                Instructors = new List <Instructor> {
                    fakhouri
                }
            };

            var trigonometry = new Course
            {
                CourseID    = 3141,
                Title       = "Trigonometry",
                Credits     = 4,
                Department  = mathematics,
                Instructors = new List <Instructor> {
                    harui
                }
            };

            var composition = new Course
            {
                CourseID    = 2021,
                Title       = "Composition",
                Credits     = 3,
                Department  = english,
                Instructors = new List <Instructor> {
                    abercrombie
                }
            };

            var literature = new Course
            {
                CourseID    = 2042,
                Title       = "Literature",
                Credits     = 4,
                Department  = english,
                Instructors = new List <Instructor> {
                    abercrombie
                }
            };

            var enrollments = new Enrollment[]
            {
                new Enrollment {
                    Student = alexander,
                    Course  = chemistry,
                    Grade   = Grade.A
                },
                new Enrollment {
                    Student = alexander,
                    Course  = microeconomics,
                    Grade   = Grade.C
                },
                new Enrollment {
                    Student = alexander,
                    Course  = macroeconmics,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = alonso,
                    Course  = calculus,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = alonso,
                    Course  = trigonometry,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = alonso,
                    Course  = composition,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = anand,
                    Course  = chemistry,
                },
                new Enrollment {
                    Student = anand,
                    Course  = microeconomics,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = barzdukas,
                    Course  = chemistry,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = li,
                    Course  = composition,
                    Grade   = Grade.B
                },
                new Enrollment {
                    Student = justice,
                    Course  = literature,
                    Grade   = Grade.B
                }
            };

            context.AddRange(enrollments);
            context.SaveChanges();
        }