public DisciplinesController(MvcWebContext context) { _context = context; }
public PeopleController(MvcWebContext context) { _context = context; }
public LessonsController(MvcWebContext context) { _context = context; }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MvcWebContext( serviceProvider.GetRequiredService< DbContextOptions<MvcWebContext>>())) { if (context.Lesson.Any()) { return; } var classs = new Classs[]//if (!context.Classs.Any()) { //context.Classs.AddRange( new Classs {NameOfClass = "7a"}, new Classs {NameOfClass = "7b"}, new Classs {NameOfClass = "7c"}, new Classs {NameOfClass = "7d"} //); }; foreach (Classs cl in classs) { context.Classs.Add(cl); } context.SaveChanges(); var mark = new Mark[]//if (!context.Mark.Any()) { // context.Mark.AddRange( new Mark {MarkOfLesson = 2}, new Mark {MarkOfLesson = 3}, new Mark {MarkOfLesson = 4}, new Mark {MarkOfLesson = 5} //); }; foreach (Mark m in mark) { context.Mark.Add(m); } context.SaveChanges(); var discipline = new Discipline[]//if (!context.Discipline.Any()) { // context.Discipline.AddRange( new Discipline {NameOfDiscipline = "Math"}, new Discipline {NameOfDiscipline = "Chemistry"}, new Discipline {NameOfDiscipline = "Languages"}, new Discipline {NameOfDiscipline = "Physics"} //); }; foreach (Discipline disc in discipline) { context.Discipline.Add(disc); } context.SaveChanges(); var users = new Users[]//if (!context.Users.Any()) { //context.Users.AddRange( new Users { Username = "******", Name = "Ivanov", Surname = "Ivan", Lastname = "Ivanovich" }, new Users { Username = "******", Name = "Petrov", Surname = "Petr", Lastname = "Petrovich" }, new Users { Username = "******", Name = "Mihaylov", Surname = "Mihayl", Lastname = "Mihaylovich" }, new Users { Username = "******", Name = "Nikolaev", Surname = "Nikolay", Lastname = "Nikolaevich" } //); }; foreach (Users u in users) { context.Users.Add(u); } context.SaveChanges(); var lesson = new Lesson[]//if (!context.Lesson.Any()) { // context.Lesson.AddRange( new Lesson { Classsesid = classs.Single(c => c.NameOfClass == "7a").id, Disciplinesid = discipline.Single(d => d.NameOfDiscipline == "Languages").id, Marksid = mark.Single(m => m.MarkOfLesson == 5).id, Userssid = users.Single(u => u.Username == "Petrov_1").id }, new Lesson { Classsesid = classs.Single(c => c.NameOfClass == "7b").id, Disciplinesid = discipline.Single(d => d.NameOfDiscipline == "Chemistry").id, Marksid = mark.Single(m => m.MarkOfLesson == 5).id, Userssid = users.Single(u => u.Username == "Mihaylov_1").id }, new Lesson { Classsesid = classs.Single(c => c.NameOfClass == "7c").id, Disciplinesid = discipline.Single(d => d.NameOfDiscipline == "Math").id, Marksid = mark.Single(m => m.MarkOfLesson == 5).id, Userssid = users.Single(u => u.Username == "Nikolaev_1").id }, new Lesson { Classsesid = classs.Single(c => c.NameOfClass == "7d").id, Disciplinesid = discipline.Single(d => d.NameOfDiscipline == "Physics").id, Marksid = mark.Single(m => m.MarkOfLesson == 5).id, Userssid = users.Single(u => u.Username == "Ivanov_1").id } //); }; foreach (Lesson les in lesson) { var lesDb = context.Lesson.Where(l => l.Marks.id == les.Marksid && l.Disciplines.id == les.Disciplinesid && l.Userss.id == les.Userssid && l.Classses.id == les.Classsesid).SingleOrDefault(); if (lesDb == null) { context.Lesson.Add(les); } } context.SaveChanges(); } }
public UsersController(MvcWebContext context) { _context = context; }
public ClasssesController(MvcWebContext context) { _context = context; }
public MarksController(MvcWebContext context) { _context = context; }