Exemple #1
0
 static void CreateStaff(SchoolContext context)
 {
     context.AddRange(new List <Staff>()
     {
         new Staff()
         {
             Name     = "Nicola",
             Email    = "*****@*****.**",
             JobTitle = "Lecturer"
         },
         new Staff()
         {
             Name     = "Saurabh",
             Email    = "*****@*****.**",
             JobTitle = "Associate Professor"
         },
         new Staff()
         {
             Name     = "Lindsay",
             Email    = "*****@*****.**",
             JobTitle = "Tutor"
         },
         new Staff()
         {
             Name     = "Michael",
             Email    = "*****@*****.**",
             JobTitle = "Tutor"
         }
     });
 }
Exemple #2
0
        private void SetTeacher()
        {
            var s  = SchoolContext.Subjects.ToList();
            var t1 = new Teacher
            {
                Name = "teacher1",
            };

            t1.Subjects.Add(s[0]);

            var t2 = new Teacher
            {
                Name = "teacher2",
            };

            t1.Subjects.Add(s[2]);
            t1.Subjects.Add(s[1]);

            var t3 = new Teacher
            {
                Name = "teacher3",
            };

            t1.Subjects.Add(s[2]);
            SchoolContext.AddRange(t1, t2, t3);
            SchoolContext.SaveChanges();
        }
Exemple #3
0
 static void CreateSubjects(SchoolContext context)
 {
     context.AddRange(new List <Subject>()
     {
         new Subject()
         {
             Code        = "PRG101",
             Name        = "Introduction to Programming",
             Description = "A first look at basic programming techniques.",
         },
         new Subject()
         {
             Code        = "PRG102",
             Name        = "Data Structures and Algorithms",
             Description = "Covers core concepts related to algorithmic problem solving and common data structures.",
         },
         new Subject()
         {
             Code        = "PRG201",
             Name        = ".NET Application Development",
             Description = "Desktop application development using Microsoft's .NET platform.",
         },
         new Subject()
         {
             Code        = "PRG301",
             Name        = "Advanced Algorithms",
             Description = "A more in-dept focus on complex algoriths and related techniques.",
         },
     });
 }
Exemple #4
0
 static void CreateStudents(SchoolContext context)
 {
     context.AddRange(new List <Student>()
     {
         new Student()
         {
             Name   = "Liam",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Science"
         },
         new Student()
         {
             Name   = "Sam",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Arts"
         },
         new Student()
         {
             Name   = "Jess",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Computer Science"
         },
         new Student()
         {
             Name   = "Sylvia",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Engineering"
         },
         new Student()
         {
             Name   = "Darell",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Computer Science"
         },
         new Student()
         {
             Name   = "Lucia",
             Email  = "*****@*****.**",
             Degree = "Bachelor of IT"
         },
         new Student()
         {
             Name   = "Han",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Computer Science"
         },
         new Student()
         {
             Name   = "Alex",
             Email  = "*****@*****.**",
             Degree = "Bachelor of Science"
         },
     });
 }
Exemple #5
0
        static async Task Main(string[] args)
        {
            var context = new SchoolContext();

            // deleted previous
            var deleted = await context.Database.EnsureDeletedAsync().ConfigureAwait(false);

            // creating an empty one
            var created = await context.Database.EnsureCreatedAsync().ConfigureAwait(false);

            if (deleted && created)
            {
                // seed some data
                var firstStudent = new Student {
                    Name = "Usman"
                };
                var secondStudent = new Student {
                    Name = "Haider"
                };

                var firstCourse = new Course {
                    Title = "First", Students = new List <Student> {
                        firstStudent
                    }
                };
                var secondCourse = new Course {
                    Title = "Second", Students = new List <Student> {
                        secondStudent
                    }
                };

                //var firstStudentCourse = new StudentCourse { Student = firstStudent, Course = firstCourse };
                //var secondStudentCourse = new StudentCourse { Student = secondStudent, Course = secondCourse };

                context.AddRange(firstCourse, secondCourse);
                _ = await context.SaveChangesAsync();

                var results = await context.Students.Where(x => x.Cources.Any(sc => sc.Title == "Second")).ToListAsync();

                foreach (var result in results)
                {
                    Console.WriteLine($"{result.Name}");
                }

                var results1 = await context.Students.Where(x => x.StudentCourses.Any(sc => sc.Course.Title == "Second")).ToListAsync();

                foreach (var result in results1)
                {
                    Console.WriteLine($"{result.Name}");
                }
            }

            Console.WriteLine("End of program");
        }
Exemple #6
0
        private void SetCabinetes()
        {
            var c1 = new Cabinete
            {
                Id   = Guid.NewGuid().ToString(),
                Name = "1"
            };
            var c2 = new Cabinete
            {
                Id   = Guid.NewGuid().ToString(),
                Name = "2"
            };
            var c3 = new Cabinete
            {
                Id   = Guid.NewGuid().ToString(),
                Name = "3"
            };

            SchoolContext.AddRange(c1, c2, c3);
            SchoolContext.SaveChanges();
        }
Exemple #7
0
        private void SetClass()
        {
            var c1 = new Class
            {
                Id     = Guid.NewGuid().ToString(),
                Grade  = 1,
                Litera = 'a'
            };
            var c2 = new Class
            {
                Id     = Guid.NewGuid().ToString(),
                Grade  = 2,
                Litera = 'b'
            };
            var c3 = new Class
            {
                Id     = Guid.NewGuid().ToString(),
                Grade  = 3,
                Litera = 'c'
            };

            SchoolContext.AddRange(c1, c2, c3);
            SchoolContext.SaveChanges();
        }
Exemple #8
0
        private void SetSubject()
        {
            var s1 = new Subject
            {
                Id         = Guid.NewGuid().ToString(),
                MaxPerWeek = 10,
                Name       = "Biology"
            };
            var s2 = new Subject
            {
                Id         = Guid.NewGuid().ToString(),
                MaxPerWeek = 20,
                Name       = "Literatura"
            };
            var s3 = new Subject
            {
                Id         = Guid.NewGuid().ToString(),
                MaxPerWeek = 10,
                Name       = "It"
            };

            SchoolContext.AddRange(s1, s2, s3);
            SchoolContext.SaveChanges();
        }
Exemple #9
0
        static void CreateClasses(SchoolContext context)
        {
            var prg101 = context.Subjects.Single(s => s.Code == "prg101");
            var prg102 = context.Subjects.Single(s => s.Code == "prg102");
            var prg201 = context.Subjects.Single(s => s.Code == "prg201");

            var lecturer = context.Staffs.First(s => s.JobTitle == "Lecturer");
            var tutor    = context.Staffs.First(s => s.JobTitle == "Tutor");

            context.AddRange(new List <Lesson>()
            {
                new Lesson()
                {
                    Subject    = prg101,
                    Teacher    = tutor,
                    StartTime  = "TUE 09:00",
                    EndTime    = "TUE 10:00",
                    RoomNumber = "K30",
                    LessonType = LessonType.Tutorial
                },
                new Lesson()
                {
                    Subject    = prg101,
                    Teacher    = lecturer,
                    StartTime  = "THU 10:00",
                    EndTime    = "THU 11:00",
                    RoomNumber = "L35",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg101,
                    Teacher    = lecturer,
                    StartTime  = "THU 12:00",
                    EndTime    = "THU 13:00",
                    RoomNumber = "L35",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg101,
                    Teacher    = lecturer,
                    StartTime  = "FRI 11:00",
                    EndTime    = "FRI 12:00",
                    RoomNumber = "L18",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg102,
                    Teacher    = lecturer,
                    StartTime  = "MON 10:00",
                    EndTime    = "MON 12:00",
                    RoomNumber = "L33",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg102,
                    Teacher    = lecturer,
                    StartTime  = "WED 15:00",
                    EndTime    = "WED 16:00",
                    RoomNumber = "L35",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg102,
                    Teacher    = tutor,
                    StartTime  = "THU 12:00",
                    EndTime    = "THU 13:00",
                    RoomNumber = "M20",
                    LessonType = LessonType.Tutorial
                },

                new Lesson()
                {
                    Subject    = prg201,
                    Teacher    = lecturer,
                    StartTime  = "TUE 11:00",
                    EndTime    = "TUE 12:00",
                    RoomNumber = "L33",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg201,
                    Teacher    = lecturer,
                    StartTime  = "WED 15:00",
                    EndTime    = "WED 16:00",
                    RoomNumber = "L33",
                    LessonType = LessonType.Lecture
                },
                new Lesson()
                {
                    Subject    = prg201,
                    Teacher    = tutor,
                    StartTime  = "THU 12:00",
                    EndTime    = "THU 13:00",
                    RoomNumber = "M22",
                    LessonType = LessonType.Tutorial
                },
                new Lesson()
                {
                    Subject    = prg201,
                    Teacher    = tutor,
                    StartTime  = "FRI 14:00",
                    EndTime    = "FRI 17:00",
                    RoomNumber = "M16",
                    LessonType = LessonType.Lab
                },
            });
        }
 public async Task UpdateDBAsync(IList <School> schools)
 {
     _context.AddRange(schools);
     await _context.SaveChangesAsync();
 }