コード例 #1
0
 public RozkladUserWrapper(RozkladUser rozkladUser)
     : base(rozkladUser)
 {
     FacultyGroupsTypeIds = FacultyGroups.Select(g => g.TypeId).ToList();
 }
コード例 #2
0
        public async Task InitializeDb()
        {
            await Database.EnsureCreatedAsync();

            if (Students.Any() || Groups.Any() || Faculties.Any())
            {
                return;
            }

            await using var transaction = await Database.BeginTransactionAsync();

            try
            {
                var students = new[]
                {
                    new Student {
                        Email = "*****@*****.**", Name = "StudentName1", Surname = "StudentSurname1"
                    },
                    new Student {
                        Email = "*****@*****.**", Name = "StudentName2", Surname = "StudentSurname2"
                    },
                    new Student {
                        Email = "*****@*****.**", Name = "StudentName3", Surname = "StudentSurname3"
                    },
                    new Student {
                        Email = "*****@*****.**", Name = "StudentName4", Surname = "StudentSurname4"
                    },
                    new Student {
                        Email = "*****@*****.**", Name = "StudentName5", Surname = "StudentSurname5"
                    },
                    new Student {
                        Email = "*****@*****.**", Name = "StudentName6", Surname = "StudentSurname6"
                    }
                };
                await Students.AddRangeAsync(students);
                await SaveChangesAsync();

                var groups = new[]
                {
                    new Group {
                        Name = "PS-12-2"
                    },
                    new Group {
                        Name = "PS-12-1"
                    },
                    new Group {
                        Name = "PE-13-1"
                    },
                    new Group {
                        Name = "PE-13-2"
                    },
                    new Group {
                        Name = "PP-13-1"
                    },
                    new Group {
                        Name = "PP-13-2"
                    }
                };
                await Groups.AddRangeAsync(groups);
                await SaveChangesAsync();

                var faculties = new[]
                {
                    new Faculty {
                        Name = "Applied math"
                    },
                    new Faculty {
                        Name = "Philosophy"
                    },
                    new Faculty {
                        Name = "Ecology"
                    }
                };
                await Faculties.AddRangeAsync(faculties);
                await SaveChangesAsync();

                await FacultyGroups.AddRangeAsync(new[] {
                    new FacultyGroup {
                        GroupId = groups[0].Id, FacultyId = faculties[0].Id
                    },
                    new FacultyGroup {
                        GroupId = groups[1].Id, FacultyId = faculties[0].Id
                    },
                    new FacultyGroup {
                        GroupId = groups[2].Id, FacultyId = faculties[2].Id
                    },
                    new FacultyGroup {
                        GroupId = groups[3].Id, FacultyId = faculties[2].Id
                    },
                    new FacultyGroup {
                        GroupId = groups[4].Id, FacultyId = faculties[1].Id
                    },
                    new FacultyGroup {
                        GroupId = groups[5].Id, FacultyId = faculties[1].Id
                    }
                });
                await SaveChangesAsync();

                await GroupStudents.AddRangeAsync(new[] {
                    new GroupStudent {
                        GroupId = groups[0].Id, StudentId = students[0].Id
                    },
                    new GroupStudent {
                        GroupId = groups[1].Id, StudentId = students[1].Id
                    },
                    new GroupStudent {
                        GroupId = groups[2].Id, StudentId = students[2].Id
                    },
                    new GroupStudent {
                        GroupId = groups[3].Id, StudentId = students[3].Id
                    },
                    new GroupStudent {
                        GroupId = groups[4].Id, StudentId = students[4].Id
                    },
                    new GroupStudent {
                        GroupId = groups[5].Id, StudentId = students[5].Id
                    }
                });

                await transaction.CommitAsync();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
            }
        }