public IEnumerable <StudentWithParentDTO> GetAllByTeacherSchoolSubjectIdAndTeacherId(int id, string teacherId) { TeacherSchoolSubject ts = db.TeacherSchoolSubjectSRepository.GetByID(id); var teacher = db.TeachersRepository.GetByID(teacherId); if (teacher == null) { logger.Warn("No teacher with id {0} found.", teacherId); throw new KeyNotFoundException("Teacher with that id not found."); } if (ts == null) { logger.Error("That teacher + school subject combination is nonexistant, id : {0}. Throwing ArgumentException.", id); throw new ArgumentException("TeacherSchoolSubjectId is not correct.", new ArgumentException()); } var students = db.StudentsRepository .Get(s => s.SchoolClass.SchoolClassTeacherSchoolSubjects.Any(x => x.TeacherSchoolSubject.Id == id && x.TeacherSchoolSubject.Teacher.Id == teacherId)); logger.Info("Getting students taught by {0} {1}, subject: {2}. TeacherSchoolSubjectId : {3}", ts.Teacher.FirstName, ts.Teacher.LastName, ts.SchoolSubject.Name, id); return(students .Select(s => UserToUserDTOConverters.StudentToStudentWithParentDTO(s))); }
public TeacherSchoolSubjectDTO CreateTeacherSchoolSubject(TeacherSchoolSubjectCreateAndEditDTO dto) { Teacher teacher = db.TeachersRepository.GetByID(dto.TeacherId); SchoolSubject subject = db.SchoolSubjectsRepository.GetByID(dto.SchoolSubjectId); if (teacher == null) { logger.Warn("No such teacher found. id {0}", dto.TeacherId); throw new KeyNotFoundException("No teacher with that id"); } if (subject == null) { logger.Warn("No such subject found. id {0}", dto.SchoolSubjectId); throw new KeyNotFoundException("No subject with that id"); } TeacherSchoolSubject tss = TeacherSchoolSubjectToTeacherSchoolSubjectDTOConverters.TeacherSchoolSubjectCreateAndEditDTOToTeacherSchoolSubject(teacher, subject); db.TeacherSchoolSubjectSRepository.Insert(tss); db.Save(); logger.Info("Creating new teacherschoolsubject. teacherId: {0}, subjectId: {1}", dto.TeacherId, dto.SchoolSubjectId); return(TeacherSchoolSubjectToTeacherSchoolSubjectDTOConverters.TeacherSchoolSubjectToTeacherSchoolSubjectDTO(tss)); }
public static TeacherSchoolSubject TeacherSchoolSubjectCreateAndEditDTOToTeacherSchoolSubject(Teacher teacher, SchoolSubject subject) { TeacherSchoolSubject retVal = new TeacherSchoolSubject(); retVal.Teacher = teacher; retVal.SchoolSubject = subject; logger.Info("Converting TeacherSchoolSubjectCreateAndEditDTO to TeacherSchoolSubject."); return(retVal); }
public SchoolClassTeacherSchoolSubjectDTO CreateSchoolClassTeacherSchoolSubject(SchoolClassTeacherSchoolSubjectCreateAndEditDTO dto) { SchoolClass sc = db.SchoolClassesRepository.GetByID(dto.SchoolClassId); TeacherSchoolSubject tss = db.TeacherSchoolSubjectSRepository.GetByID(dto.TeacherSchoolSubjectId); SchoolClassTeacherSchoolSubject sctss = SchoolClassTeacherSchoolSubjectToSchoolClassTeacherSchoolSubjectDTOConverters .SchoolClassTeacherSchoolSubjectCreateAndEditDTOToSchoolClassTeacherSchoolSubject(sc, tss); db.SchoolClassTeacherSchoolSubjectRepository.Insert(sctss); db.Save(); return(SchoolClassTeacherSchoolSubjectToSchoolClassTeacherSchoolSubjectDTOConverters .SchoolClassTeacherSchoolSubjectTo_SchoolClassTeacherSchoolSubjectDTO(sctss)); }
public void DeleteTeacherSchoolSubject(int id) { TeacherSchoolSubject ts = db.TeacherSchoolSubjectSRepository.GetByID(id); foreach (var item in ts.SchoolClassTeacherSchoolSubjects) { logger.Info("Removing dependencies"); item.TeacherSchoolSubject = null; } db.TeacherSchoolSubjectSRepository.Delete(ts); db.Save(); logger.Info("Successfully deleted teacherschoolsubject."); }
public TeacherSchoolSubjectDTO EditTeacherSchoolSubject(int id, TeacherSchoolSubjectCreateAndEditDTO dto) { TeacherSchoolSubject ts = db.TeacherSchoolSubjectSRepository.GetByID(id); if (ts != null) { var schoolSubject = db.SchoolSubjectsRepository.GetByID(dto.SchoolSubjectId); var teacher = db.TeachersRepository.GetByID(dto.TeacherId); ts.SchoolSubject = schoolSubject; ts.Teacher = teacher; db.TeacherSchoolSubjectSRepository.Update(ts); db.Save(); logger.Info("Eddited teacherschoolsubject with id {0}", id); } return(TeacherSchoolSubjectToTeacherSchoolSubjectDTOConverters.TeacherSchoolSubjectToTeacherSchoolSubjectDTO(ts)); }
public IEnumerable <StudentWithParentDTO> GetAllByTeacherSchoolSubjectId(int id) { //TODO 11.10 **DONE** exception if teacherschoolsubject nonexistant TeacherSchoolSubject ts = db.TeacherSchoolSubjectSRepository.GetByID(id); if (ts == null) { logger.Error("That teacher + school subject combination is nonexistant, id : {0}. Throwing ArgumentException.", id); throw new ArgumentException("TeacherSchoolSubjectId is not correct.", new ArgumentException()); } var students = db.StudentsRepository .Get(s => s.SchoolClass.SchoolClassTeacherSchoolSubjects.Any(x => x.TeacherSchoolSubject.Id == id)); logger.Info("Getting students taught by {0} {1}, subject: {2}. TeacherSchoolSubjectId : {3}", ts.Teacher.FirstName, ts.Teacher.LastName, ts.SchoolSubject.Name, id); return(students .Select(s => UserToUserDTOConverters.StudentToStudentWithParentDTO(s))); }
public static TeacherSchoolSubjectDTO TeacherSchoolSubjectToTeacherSchoolSubjectDTO(TeacherSchoolSubject tss) { TeacherSchoolSubjectDTO retVal = new TeacherSchoolSubjectDTO(); retVal.Id = tss.Id; retVal.SubjectId = tss.SchoolSubject.Id; retVal.SubjectName = tss.SchoolSubject.Name; retVal.TeacherId = tss.Teacher.Id; retVal.TeacherFirstName = tss.Teacher.FirstName; retVal.TeacherLastName = tss.Teacher.LastName; logger.Info("Converting TeacherSchoolSubject to TeacherSchoolSubjectDTO."); return(retVal); }
public GradeDTO EditGrade(int id, string teacherId, GradeCreateAndEditDTO dto) { Grade grade = db.GradesRepository.GetByID(id); Teacher teacher = db.TeachersRepository.GetByID(teacherId); Student student = db.StudentsRepository.GetByID(dto.StudentId); SchoolSubject subject = db.SchoolSubjectsRepository.GetByID(dto.SchoolSubjectId); SchoolClass sc = db.SchoolClassesRepository.GetByID(student.SchoolClass.Id); if (teacher == null) { logger.Warn("Teacher with id {0} not found.", teacherId); throw new KeyNotFoundException("teacherId doesn't exist."); } if (student == null) { logger.Warn("Student with id {0} not found.", dto.StudentId); throw new KeyNotFoundException("dto.StudentId doesn't exist."); } if (subject == null) { logger.Warn("Subject with id {0} not found.", dto.SchoolSubjectId); throw new KeyNotFoundException("dto.SchoolSubjectId doesn't exist."); } if (!teacher.TeacherSchoolSubjects.Select(x => x.SchoolSubject).Any(y => y.Id == subject.Id)) { logger.Warn("Teacher {0} {1} (id: {2}) does not teach subject {3} (id: {4}). Cannot grade the student.", teacher.FirstName, teacher.LastName, teacher.Id, subject.Name, subject.Id); throw new Exception("Teacher doesn't teach the given subject."); //TODO 99: fix exceptions! } if (!teacher.TeacherSchoolSubjects.Any(x => x.SchoolClassTeacherSchoolSubjects.Any(y => y.SchoolClass.Id == sc.Id))) { logger.Warn("Teacher {0} {1} (id: {2}) doesn't teach the subject {3} (id: {4}) to student {5} {6} (id: {7}). Cannot grade the student.", teacher.FirstName, teacher.LastName, teacher.Id, subject.Name, subject.Id, student.FirstName, student.LastName, student.Id); throw new Exception("Teacher doesn't teach the subject to the given student"); } TeacherSchoolSubject tss = db.TeacherSchoolSubjectSRepository.Get() .Where(x => x.SchoolSubject.Id == subject.Id && x.Teacher.Id == teacher.Id).FirstOrDefault(); if (tss == null) { logger.Warn("TeacherSchoolSubject combination with teacherId {0} and subject id {1} not found.", teacher.Id, subject.Id); throw new KeyNotFoundException("Given TeacherSchoolSubject combination doesn't exist. Please make one."); } SchoolClassTeacherSchoolSubject sctss = db.SchoolClassTeacherSchoolSubjectRepository.Get() .Where(x => x.TeacherSchoolSubject.Id == tss.Id && x.SchoolClass.Id == sc.Id).FirstOrDefault(); if (sctss == null) { logger.Warn("SchoolClassTeacherSchoolSubject combination with schoolClassId {0} and teacherSchoolSubjectId {1} not found.", sc.Id, tss.Id); throw new KeyNotFoundException("Given SchoolClassTeacherSchoolSubject combination doesn't exist. Please make one."); } grade.Value = dto.Value; grade.DateOfGrading = DateTime.Now; grade.Student = student; grade.SchoolClassTeacherSchoolSubject = sctss; logger.Info("Updating grade"); db.GradesRepository.Update(grade); db.Save(); return(GradeToGradeDTOConverters.GradeToGradeDTO(grade)); }
public GradeDTO CreateGrade(string teacherId, GradeCreateAndEditDTO dto) { Teacher teacher = db.TeachersRepository.GetByID(teacherId); Student student = db.StudentsRepository.GetByID(dto.StudentId); SchoolSubject subject = db.SchoolSubjectsRepository.GetByID(dto.SchoolSubjectId); SchoolClass sc = db.SchoolClassesRepository.GetByID(student.SchoolClass.Id); if (teacher == null) { logger.Warn("Teacher with id {0} not found.", teacherId); throw new KeyNotFoundException("teacherId doesn't exist."); } if (student == null) { logger.Warn("Student with id {0} not found.", dto.StudentId); throw new KeyNotFoundException("dto.StudentId doesn't exist."); } if (subject == null) { logger.Warn("Subject with id {0} not found.", dto.SchoolSubjectId); throw new KeyNotFoundException("dto.SchoolSubjectId doesn't exist."); } if (!teacher.TeacherSchoolSubjects.Select(x => x.SchoolSubject).Any(y => y.Id == subject.Id)) { logger.Warn("Teacher {0} {1} (id: {2}) does not teach subject {3} (id: {4}). Cannot grade the student.", teacher.FirstName, teacher.LastName, teacher.Id, subject.Name, subject.Id); throw new Exception("Teacher doesn't teach the given subject."); //TODO 99: fix exceptions! } if (!teacher.TeacherSchoolSubjects.Any(x => x.SchoolClassTeacherSchoolSubjects.Any(y => y.SchoolClass.Id == sc.Id))) { logger.Warn("Teacher {0} {1} (id: {2}) doesn't teach the subject {3} (id: {4}) to student {5} {6} (id: {7}). Cannot grade the student.", teacher.FirstName, teacher.LastName, teacher.Id, subject.Name, subject.Id, student.FirstName, student.LastName, student.Id); throw new Exception("Teacher doesn't teach the subject to the given student"); } TeacherSchoolSubject tss = db.TeacherSchoolSubjectSRepository.Get() .Where(x => x.SchoolSubject.Id == subject.Id && x.Teacher.Id == teacher.Id).FirstOrDefault(); if (tss == null) { logger.Warn("TeacherSchoolSubject combination with teacherId {0} and subject id {1} not found.", teacher.Id, subject.Id); throw new KeyNotFoundException("Given TeacherSchoolSubject combination doesn't exist. Please make one."); } SchoolClassTeacherSchoolSubject sctss = db.SchoolClassTeacherSchoolSubjectRepository.Get() .Where(x => x.TeacherSchoolSubject.Id == tss.Id && x.SchoolClass.Id == sc.Id).FirstOrDefault(); if (sctss == null) { logger.Warn("SchoolClassTeacherSchoolSubject combination with schoolClassId {0} and teacherSchoolSubjectId {1} not found.", sc.Id, tss.Id); throw new KeyNotFoundException("Given SchoolClassTeacherSchoolSubject combination doesn't exist. Please make one."); } Grade grade = new Grade() { Value = dto.Value, DateOfGrading = DateTime.Now, SchoolClassTeacherSchoolSubject = sctss, Student = student }; logger.Info("Creating grade. teacherId: {0}, studentId: {1}, subjectId: {2}", teacher.Id, student.Id, subject.Id); db.GradesRepository.Insert(grade); db.Save(); string toEmail = student.Parent.Email; string parentName = student.Parent.FirstName + " " + student.Parent.LastName; string studentName = student.FirstName + " " + student.LastName; string date = grade.DateOfGrading.Day + "." + grade.DateOfGrading.Month + "." + grade.DateOfGrading.Year; string subjectName = subject.Name; int gradeValue = grade.Value; EmailSenders.EmailGradingEventToParent(toEmail, parentName, studentName, date, subjectName, gradeValue); return(GradeToGradeDTOConverters.GradeToGradeDTO(grade)); }
SchoolClassTeacherSchoolSubjectCreateAndEditDTOToSchoolClassTeacherSchoolSubject(SchoolClass sc, TeacherSchoolSubject tss) { SchoolClassTeacherSchoolSubject retVal = new SchoolClassTeacherSchoolSubject() { SchoolClass = sc, TeacherSchoolSubject = tss }; logger.Info("Converting SchoolClassTeacherSchoolSubjectCreateAndEditDTO to SchoolClassTeacherSchoolSubject."); return(retVal); }
protected override void Seed(DataAccessContext context) { #region AddingRoles using (var store = new RoleStore <IdentityRole>(context)) { using (var manager = new RoleManager <IdentityRole>(store)) { manager.Create(new IdentityRole("admin")); manager.Create(new IdentityRole("teacher")); manager.Create(new IdentityRole("parent")); manager.Create(new IdentityRole("student")); } } #endregion context.SaveChanges(); #region AddingSchoolSubjects SchoolSubject geography5 = new SchoolSubject() { Id = 1, Name = "Geografija 5", WeeklyClasses = 3 }; context.SchoolSubjects.Add(geography5); SchoolSubject geography6 = new SchoolSubject() { Id = 2, Name = "Geografija 6", WeeklyClasses = 4 }; context.SchoolSubjects.Add(geography6); SchoolSubject biology5 = new SchoolSubject() { Id = 3, Name = "Biologija 5", WeeklyClasses = 2, }; context.SchoolSubjects.Add(biology5); SchoolSubject biology6 = new SchoolSubject() { Id = 4, Name = "Biologija 6", WeeklyClasses = 3 }; context.SchoolSubjects.Add(biology6); SchoolSubject serbian5 = new SchoolSubject() { Id = 5, Name = "Srpski 5", WeeklyClasses = 4 }; context.SchoolSubjects.Add(serbian5); SchoolSubject serbian6 = new SchoolSubject() { Id = 6, Name = "Srpski 6", WeeklyClasses = 4 }; context.SchoolSubjects.Add(serbian6); #endregion context.SaveChanges(); #region AddingSchoolClasses SchoolClass petiA = new SchoolClass() { Id = 1, SchoolGrade = 5, Name = "A" }; context.SchoolClasses.Add(petiA); SchoolClass petiB = new SchoolClass() { Id = 2, SchoolGrade = 5, Name = "B" }; context.SchoolClasses.Add(petiB); SchoolClass sestiA = new SchoolClass() { Id = 3, SchoolGrade = 6, Name = "A" }; context.SchoolClasses.Add(sestiA); SchoolClass sestiB = new SchoolClass() { Id = 4, SchoolGrade = 6, Name = "B" }; context.SchoolClasses.Add(sestiB); #endregion context.SaveChanges(); using (var userStore = new UserStore <ApplicationUser>(context)) { using (var userManager = new UserManager <ApplicationUser>(userStore)) { #region AddingAdmins Admin admin1 = new Admin() { FirstName = "Chuck", LastName = "Norris", UserName = "******", Email = "*****@*****.**", }; userManager.Create(admin1, "qwerty"); userManager.AddToRole(admin1.Id, "admin"); #endregion #region AddingTeachers Teacher peca = new Teacher() { FirstName = "Petar", LastName = "Stojakovic", UserName = "******", Email = "*****@*****.**", }; userManager.Create(peca, "pecaa1"); userManager.AddToRole(peca.Id, "teacher"); Teacher eugen = new Teacher() { FirstName = "Eugen", LastName = "Plancak", UserName = "******", Email = "*****@*****.**", }; userManager.Create(eugen, "eugen1"); userManager.AddToRole(eugen.Id, "teacher"); Teacher kolarov = new Teacher() { FirstName = "Milos", LastName = "Kolarov", UserName = "******", Email = "*****@*****.**", }; userManager.Create(kolarov, "kolarov1"); userManager.AddToRole(kolarov.Id, "teacher"); Teacher obrad = new Teacher() { FirstName = "Obrad", LastName = "Stojkovic", UserName = "******", Email = "*****@*****.**", }; userManager.Create(obrad, "obrad1"); userManager.AddToRole(obrad.Id, "teacher"); #endregion #region AddingParents Parent parent1 = new Parent() { FirstName = "Gordana", LastName = "Alasov", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent1, "gordana1"); userManager.AddToRole(parent1.Id, "parent"); Parent parent2 = new Parent() { FirstName = "Vidosava", LastName = "Maodus", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent2, "vidaa1"); userManager.AddToRole(parent2.Id, "parent"); Parent parent3 = new Parent() { FirstName = "Djordje", LastName = "Atanackovic", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent3, "djole1"); userManager.AddToRole(parent3.Id, "parent"); Parent parent4 = new Parent() { FirstName = "Snezana", LastName = "Stojsic", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent4, "sneza1"); userManager.AddToRole(parent4.Id, "parent"); Parent parent5 = new Parent() { FirstName = "Tatjana", LastName = "Lekic", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent5, "tanja1"); userManager.AddToRole(parent5.Id, "parent"); Parent parent6 = new Parent() { FirstName = "Macone", LastName = "Nedeljkov", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent6, "macaa1"); userManager.AddToRole(parent6.Id, "parent"); Parent parent7 = new Parent() { FirstName = "Mile", LastName = "Etinski", UserName = "******", Email = "*****@*****.**", }; userManager.Create(parent7, "milee1"); userManager.AddToRole(parent7.Id, "parent"); #endregion #region AddingStudents Student goran = new Student() { FirstName = "Goran", LastName = "Alasov", UserName = "******", Email = "*****@*****.**", Parent = parent1, SchoolClass = sestiA, }; userManager.Create(goran, "alasov1"); userManager.AddToRole(goran.Id, "student"); Student mao = new Student() { FirstName = "Milan", LastName = "Maodus", UserName = "******", Email = "*****@*****.**", Parent = parent2, SchoolClass = sestiA }; userManager.Create(mao, "maodus1"); userManager.AddToRole(mao.Id, "student"); Student roki = new Student() { FirstName = "Nenad", LastName = "Maodus", UserName = "******", Email = "*****@*****.**", Parent = parent2, SchoolClass = petiB }; userManager.Create(roki, "rokii1"); userManager.AddToRole(roki.Id, "student"); Student facan = new Student() { FirstName = "Bojan", LastName = "Atanackovic", UserName = "******", Email = "*****@*****.**", Parent = parent3, SchoolClass = sestiA }; userManager.Create(facan, "facan1"); userManager.AddToRole(facan.Id, "student"); Student jebac = new Student() { FirstName = "Aleksandar", LastName = "Atanackovic", UserName = "******", Email = "*****@*****.**", Parent = parent3, SchoolClass = petiA }; userManager.Create(jebac, "jebac1"); userManager.AddToRole(jebac.Id, "student"); Student doca = new Student() { FirstName = "Vladimir", LastName = "Stojsic", UserName = "******", Email = "*****@*****.**", Parent = parent4, SchoolClass = sestiB }; userManager.Create(doca, "doktor1"); userManager.AddToRole(doca.Id, "student"); Student bogdan = new Student() { FirstName = "Bogdan", LastName = "Stojsic", UserName = "******", Email = "*****@*****.**", Parent = parent4, SchoolClass = petiA }; userManager.Create(bogdan, "bogdan1"); userManager.AddToRole(bogdan.Id, "student"); Student sveta = new Student() { FirstName = "Svetozar", LastName = "Lekic", UserName = "******", Email = "*****@*****.**", Parent = parent5, SchoolClass = sestiB }; userManager.Create(sveta, "sveta1"); userManager.AddToRole(sveta.Id, "student"); Student seba = new Student() { FirstName = "Nebojsa", LastName = "Nedeljkov", UserName = "******", Email = "*****@*****.**", Parent = parent6, SchoolClass = sestiB }; userManager.Create(seba, "nebojsa1"); userManager.AddToRole(seba.Id, "student"); Student tanatelo = new Student() { FirstName = "Marko", LastName = "Nedeljkov", UserName = "******", Email = "*****@*****.**", Parent = parent6, SchoolClass = petiB }; userManager.Create(tanatelo, "marko1"); userManager.AddToRole(tanatelo.Id, "student"); Student pista = new Student() { FirstName = "Dragan", LastName = "Etinski", UserName = "******", Email = "*****@*****.**", Parent = parent7, SchoolClass = petiB }; userManager.Create(pista, "pista1"); userManager.AddToRole(pista.Id, "student"); #endregion context.SaveChanges(); #region AddingTeacherSchoolSubjects TeacherSchoolSubject pecaGeo5 = new TeacherSchoolSubject() { Id = 1, Teacher = peca, SchoolSubject = geography5 }; context.TeacherSchoolSubjects.Add(pecaGeo5); TeacherSchoolSubject pecaGeo6 = new TeacherSchoolSubject() { Id = 2, Teacher = peca, SchoolSubject = geography6 }; context.TeacherSchoolSubjects.Add(pecaGeo6); TeacherSchoolSubject eugenBio5 = new TeacherSchoolSubject() { Id = 3, Teacher = eugen, SchoolSubject = biology5 }; context.TeacherSchoolSubjects.Add(eugenBio5); TeacherSchoolSubject eugenBio6 = new TeacherSchoolSubject() { Id = 4, Teacher = eugen, SchoolSubject = biology6 }; context.TeacherSchoolSubjects.Add(eugenBio6); TeacherSchoolSubject kolarovSrp5 = new TeacherSchoolSubject() { Id = 5, Teacher = kolarov, SchoolSubject = serbian5 }; context.TeacherSchoolSubjects.Add(kolarovSrp5); TeacherSchoolSubject obradSrp6 = new TeacherSchoolSubject() { Id = 6, Teacher = obrad, SchoolSubject = serbian6 }; context.TeacherSchoolSubjects.Add(obradSrp6); #endregion context.SaveChanges(); #region AddingSchoolClassTeacherSchoolSubjects SchoolClassTeacherSchoolSubject pecaGeo5PetiA = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = pecaGeo5, SchoolClass = petiA }; context.SchoolClassTeacherSchoolSubjects.Add(pecaGeo5PetiA); SchoolClassTeacherSchoolSubject pecaGeo5PetiB = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = pecaGeo5, SchoolClass = petiB }; context.SchoolClassTeacherSchoolSubjects.Add(pecaGeo5PetiB); SchoolClassTeacherSchoolSubject pecaGeo6SestiA = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = pecaGeo6, SchoolClass = sestiA }; context.SchoolClassTeacherSchoolSubjects.Add(pecaGeo6SestiA); SchoolClassTeacherSchoolSubject pecaGeo6SestiB = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = pecaGeo6, SchoolClass = sestiB }; context.SchoolClassTeacherSchoolSubjects.Add(pecaGeo6SestiB); SchoolClassTeacherSchoolSubject eugenBio5PetiA = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = eugenBio5, SchoolClass = petiA }; context.SchoolClassTeacherSchoolSubjects.Add(eugenBio5PetiA); SchoolClassTeacherSchoolSubject eugenBio5PetiB = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = eugenBio5, SchoolClass = petiB }; context.SchoolClassTeacherSchoolSubjects.Add(eugenBio5PetiB); SchoolClassTeacherSchoolSubject eugenBio6SestiA = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = eugenBio6, SchoolClass = sestiA }; context.SchoolClassTeacherSchoolSubjects.Add(eugenBio6SestiA); SchoolClassTeacherSchoolSubject eugenBio6SestiB = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = eugenBio6, SchoolClass = sestiB }; context.SchoolClassTeacherSchoolSubjects.Add(eugenBio6SestiB); SchoolClassTeacherSchoolSubject kolarovSrp5PetiA = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = kolarovSrp5, SchoolClass = petiA }; context.SchoolClassTeacherSchoolSubjects.Add(kolarovSrp5PetiA); SchoolClassTeacherSchoolSubject kolarovSrp5PetiB = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = kolarovSrp5, SchoolClass = petiB }; context.SchoolClassTeacherSchoolSubjects.Add(kolarovSrp5PetiB); SchoolClassTeacherSchoolSubject obradSrp6SestiA = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = obradSrp6, SchoolClass = sestiA }; context.SchoolClassTeacherSchoolSubjects.Add(obradSrp6SestiA); SchoolClassTeacherSchoolSubject obradSrp6SestiB = new SchoolClassTeacherSchoolSubject() { TeacherSchoolSubject = obradSrp6, SchoolClass = sestiB }; context.SchoolClassTeacherSchoolSubjects.Add(obradSrp6SestiB); #endregion Grade g1 = new Grade() { Id = 1, Value = 4, DateOfGrading = new DateTime(2000, 12, 21), Student = goran, SchoolClassTeacherSchoolSubject = pecaGeo6SestiA }; context.Grades.Add(g1); Grade g2 = new Grade() { Id = 2, Value = 3, DateOfGrading = new DateTime(1998, 5, 8), Student = mao, SchoolClassTeacherSchoolSubject = obradSrp6SestiA }; context.Grades.Add(g2); Grade g3 = new Grade() { Id = 2, Value = 3, DateOfGrading = new DateTime(1997, 1, 27), Student = mao, SchoolClassTeacherSchoolSubject = eugenBio6SestiA }; context.Grades.Add(g3); Grade g4 = new Grade() { Id = 2, Value = 1, DateOfGrading = new DateTime(1997, 9, 11), Student = roki, SchoolClassTeacherSchoolSubject = eugenBio5PetiB }; context.Grades.Add(g4); context.SaveChanges(); } } //context.Roles.Add(new IdentityRole() { Id = Guid.NewGuid().ToString(), Name = "admins" }); //context.Roles.Add(new IdentityRole() { Id = Guid.NewGuid().ToString(), Name = "teachers" }); //context.Roles.Add(new IdentityRole() { Id = Guid.NewGuid().ToString(), Name= "parents" }); //context.Roles.Add(new IdentityRole() { Id = Guid.NewGuid().ToString(), Name = "students" }); //context.SaveChanges(); //List<ApplicationUser> allUsers = new List<ApplicationUser>(); //allUsers.Add(admin1); //allUsers.Add(teacher1); //context.Users.Add(admin1); //context.Users.Add(teacher1); //context.SaveChanges(); //SetAllRoles(allUsers, context); context.SaveChanges(); //Admin admin1 = new Admin() //{ // FirstName = "Goran", // LastName = "Alasov", // UserName = "******", // Email = "*****@*****.**" //}; //Admin admin2 = new Admin() //{ // FirstName = "Goran1", // LastName = "Alasov1", // UserName = "******", // Email = "[email protected]" //}; //admins.Add(admin1); //admins.Add(admin2); //context.SaveChanges(); }