private void Add_Click(object sender, RoutedEventArgs e) { if (Check()) { student.LastName = Text1.Text; student.FirstName = Text2.Text; student.Address = Text3.Text; student.IndexNumber = Text4.Text; student.IdStudies = NewStudyId(); //listbox new DB().DeleteStudent_Subject(StudentId); var list = ListBox.Items; int i = 1; foreach (CheckBox o in list) { var r = o.Content; var student_subject = new Student_Subject { IdStudent = StudentId, IdSubject = i }; if (o.IsChecked == true) { new DB().AddStudent_Subject(student_subject); } i++; } Close(); } }
protected override void Seed(FeriContext context) { User user0 = new User("userName0", "pass123", "student1", "surname1", "student"); User user1 = new User("userName1", "pass1234", "student2", "surname1", "student"); User user2 = new User("userName2", "pass1235", "student3", "surname1", "student"); User user3 = new User("userName3", "pass1", "student4", "surname1", "student"); User user4 = new User("userName4", "pass123", "name1", "surname1", "student"); User user5 = new User("userName5", "pass123", "name1", "surname1", "student"); User user6 = new User("userName6", "pass123", "name1", "surname1", "student"); User user7 = new User("userName7", "pass123", "name1", "surname1", "profesor"); User user8 = new User("userName8", "pass123", "name1", "surname1", "profesor"); User user9 = new User("userName9", "pass123", "name1", "surname1", "referent"); context.Users.Add(user0); context.Users.Add(user1); context.Users.Add(user2); context.Users.Add(user3); context.Users.Add(user4); context.Users.Add(user5); context.Users.Add(user6); context.Users.Add(user7); context.Users.Add(user8); context.Users.Add(user9); Student student1 = new Student("E0000000", user0); Student student2 = new Student("E0000001", user1); Student student3 = new Student("E0000002", user2); Student student4 = new Student("E0000003", user3); context.Students.Add(student1); context.Students.Add(student2); context.Students.Add(student3); context.Students.Add(student4); Subject programiranje1 = new Subject("Programiranje1", user7); Subject programiranje2 = new Subject("Programiranje2", user8); context.Subjects.Add(programiranje1); context.Subjects.Add(programiranje2); Student_Subject student_subject1 = new Student_Subject(student1, programiranje1); Student_Subject student_subject2 = new Student_Subject(student1, programiranje2); Student_Subject student_subject4 = new Student_Subject(student2, programiranje2); context.SaveChanges(); //List<User> users = new List<User>() { user0, user1, user2, user3, user4, user5, user6, user7, user8, user9 }; //List<Student> students = new List<Student>() { student1, student2, student3, student4 }; //List<Subject> subjects = new List<Subject>() { programiranje1, programiranje2 }; //List<Student_Subject> razred_ucenec = new List<Student_Subject>() { student_subject1, student_subject2, student_subject4 }; User loggedInUser = null; base.Seed(context); }
public void DeleteStudent_Subject(int StudentId) { var listSS = new DB().GetStudentSubjects(StudentId); var idList = (from ss in listSS select ss.IdSubject).ToList(); foreach (int id in idList) { Student_Subject student_subject = new Student_Subject { IdStudent = StudentId, IdSubject = id }; new DB().DeleteStudent_Subject(student_subject); } }
public void DeleteStudent_Subject(Student_Subject ss) { pjatkDb.Student_Subject.Remove(pjatkDb.Student_Subject.Single(s => s.IdStudent == ss.IdStudent && s.IdSubject == ss.IdSubject)); pjatkDb.SaveChanges(); }
public void AddStudent_Subject(Student_Subject s) { pjatkDb.Student_Subject.Add(s); pjatkDb.SaveChanges(); }