private void RefreshSpecialtyProperty() { Specialties.Clear(); try { DbContext.Specialties.OrderBy(x => x.Name).ToList().ForEach(x => Specialties.Add(x)); OnPropertyChanged(nameof(Specialties)); } catch (EntityException e) { OnEntityException(e); } catch (DbEntityValidationException e) { OnDbEntityValidationException(e); } }
public static void Init() { Specialties.Add(new Speciality { FacultyId = 123, Id = 2, LectorId = 321, Name = "Telecommunications", ShortName = "TIS" }); Users.Add(new User { Id = 1, FacultylID = 123, Name = "Boris", Email = "*****@*****.**", TeamID = 12 }); Users.Add(new User { Id = 2, FacultylID = 456, Name = "Stefan", Email = "*****@*****.**", TeamID = 12 }); //Initi Story Stories.Add(new Story { Id = 55, Name = "Controlers Story", Description = "Create all required controlers", EndDate = new DateTime(2020, 12, 23), ProjectId = 2, StartDate = DateTime.Now }); //Inti faculties Faculties.Add(new Faculty() { Id = 1, Name = "Physico-technological faculty", Description = "We are the best", ShortName = "PTF" }); //Init Teams Teams.Add(new Team { Id = 43, Name = "Team A", FacultyID = 1, DateCreated = new DateTime(2019, 10, 01) }); Teams.Add(new Team { Id = 44, Name = "Team B", FacultyID = 1, DateCreated = new DateTime(2019, 10, 01) }); //Init User Taks UserTasks.Add(new UserTask { Id = 23, AssignedToUserID = 2, Description = "Task Description", EndDate = new DateTime(2020, 11, 23), Name = "Create Controlers", OwnerId = 1, StartDate = DateTime.Now, StoryId = 55 }); Sprints.Add(new Sprint { Description = "Description", EndDate = DateTime.Now.AddDays(5), Id = 133, Name = "Sprint name", StartDate = DateTime.Now, TeamID = 1 }); Lectors.Add(new Lector { Id = 24, FirstName = "Vladimir", LastName = "Sovniov", DateStarted = new DateTime(2018, 10, 12) }); Projects.Add(new Project { Description = "Project description", Id = 4322, Name = "Some project name", OwnerId = 2 }); //User positions UserPositions.Add(new UserPosition { Id = 1, PositionName = "Junior Developer", Description = "Begginer C# developer" }); UserPositions.Add(new UserPosition { Id = 2, PositionName = "Middle Developer", Description = "Experienced C# developer" }); UserPositions.Add(new UserPosition { Id = 3, PositionName = "Senior Developer", Description = "Very experienced C# developer" }); }
public void SeedDb(int a) { if (a == 0) { var dep = Departments.Add(new Department { Name = "КТ", Code = 1 }); var sepc = Specialties.Add(new Specialty { Name = "ПОИТ", Code = 1, Department = dep }); var gr = Groups.Add(new Group { Number = 42491, Specialty = sepc }); FileInfo newFile = new FileInfo(Directory.GetCurrentDirectory() + "\\st.xlsx"); ExcelPackage pck = new ExcelPackage(newFile); ExcelWorksheet sheet = pck.Workbook.Worksheets[1]; for (int i = 1; sheet.Cells[i, 1].Value != null; i++) { var ln = sheet.Cells[i, 1].Value.ToString().Split(' ')[0]; var fn = sheet.Cells[i, 1].Value.ToString().Split(' ')[1]; var mn = sheet.Cells[i, 1].Value.ToString().Split(' ')[2]; Students.Add(new Student { Group = gr, FirstName = fn, MiddleName = mn, LastName = ln }); } } else { var cp1 = ControlPoints.Add(new ControlPoint { Date = DateTime.ParseExact("30.09 2017", "dd.MM yyyy", null) }); var cp2 = ControlPoints.Add(new ControlPoint { Date = DateTime.ParseExact("30.10 2017", "dd.MM yyyy", null) }); var cp3 = ControlPoints.Add(new ControlPoint { Date = DateTime.ParseExact("30.11 2017", "dd.MM yyyy", null) }); var sub1 = Subjects.Add(new Subject { Name = "КПиЯП" }); var teacher1 = Teachers.Add(new Teacher { FirstName = "Марина", MiddleName = "Анатольевна", LastName = "Бельчик" }); var sub2 = Subjects.Add(new Subject { Name = "БДиСУБД" }); var teacher2 = Teachers.Add(new Teacher { FirstName = "Ольга", MiddleName = "Николаевна", LastName = "Виничук" }); var sub3 = Subjects.Add(new Subject { Name = "ПСИП" }); foreach (var student in Students.ToList()) { student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp1, Student = student, Subject = sub1, Teacher = teacher1 }); student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp2, Student = student, Subject = sub1, Teacher = teacher1 }); student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp3, Student = student, Subject = sub1, Teacher = teacher1 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp1, Student = student, Subject = sub1, Teacher = teacher1 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp2, Student = student, Subject = sub1, Teacher = teacher1 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp3, Student = student, Subject = sub1, Teacher = teacher1 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp1, Student = student, Subject = sub1, Teacher = teacher1 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp2, Student = student, Subject = sub1, Teacher = teacher1 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp3, Student = student, Subject = sub1, Teacher = teacher1 }); } foreach (var student in Students.ToList()) { student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp1, Student = student, Subject = sub2, Teacher = teacher2 }); student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp2, Student = student, Subject = sub2, Teacher = teacher2 }); student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp3, Student = student, Subject = sub2, Teacher = teacher2 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp1, Student = student, Subject = sub2, Teacher = teacher2 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp2, Student = student, Subject = sub2, Teacher = teacher2 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp3, Student = student, Subject = sub2, Teacher = teacher2 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp1, Student = student, Subject = sub2, Teacher = teacher2 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp2, Student = student, Subject = sub2, Teacher = teacher2 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp3, Student = student, Subject = sub2, Teacher = teacher2 }); } foreach (var student in Students.ToList()) { student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp1, Student = student, Subject = sub3, Teacher = teacher2 }); student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp2, Student = student, Subject = sub3, Teacher = teacher2 }); student.Marks.Add(new Mark { Value = new Random().Next(3, 10), ControlPoint = cp3, Student = student, Subject = sub3, Teacher = teacher2 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp1, Student = student, Subject = sub3, Teacher = teacher2 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp2, Student = student, Subject = sub3, Teacher = teacher2 }); student.Absences.Add(new Absence { Count = 0, ControlPoint = cp3, Student = student, Subject = sub3, Teacher = teacher2 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp1, Student = student, Subject = sub3, Teacher = teacher2 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp2, Student = student, Subject = sub3, Teacher = teacher2 }); student.LabWorks.Add(new LabWork { NotPassed = 0, ControlPoint = cp3, Student = student, Subject = sub3, Teacher = teacher2 }); } } SaveChanges(); }