private void ButtonDeleteSubjectTeacher_Click(object sender, EventArgs e) { if (TableClasses.SelectedRows.Count != 0) { if (TableSubjects.SelectedRows.Count != 0) { if (TableTeachers.SelectedRows.Count != 0) { if (MessageBox.Show("Вы уверены, что хотите удалить выбранного учителя из предмета в выбранном классе?", "Удаление выбраного учителя из предмета выбранного класса", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { } else { DBControl.Delete(Class_Subject_Teacher.GetObj(Class_Subject.GetObj(Class.Classes[(Guid)TableClasses.SelectedCells[0].Value], Subject.Subjects[(Guid)TableSubjects.SelectedCells[0].Value]), Teacher.Teachers[(Guid)TableTeachers.SelectedCells[0].Value])); TableTeachers.Rows.Remove(TableTeachers.SelectedRows[0]); TableTeachers.ClearSelection(); } } else { MessageBox.Show("Для удаления учителя из предмета, выбирете его из таблицы", "Не выбран учитель для удаления из предмета", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Для удаления учителя у предмета, выбирете предмет из таблицы", "Не выбран предмет для удаления учителя у предмета", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Для удаелния учителя у предмета, выбирете класс из таблицы", "Не выбран класс для удаления учителя у предмета", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void Add(Class_Subject class_subject, Teacher teacher) //Add Class_Subject_Teacher { Class_Subject_Teacher NewClass_Subject_Teacher = new Class_Subject_Teacher() { Class_Subject = class_subject, Teacher = teacher }; Class_Subject_Teacher.Classes_Subjects_Teachers.Add(NewClass_Subject_Teacher.Id, NewClass_Subject_Teacher); command.CommandText = string.Format("INSERT INTO Classes_Subjects_Teachers VALUES ('{0}', '{1}', '{2}')", NewClass_Subject_Teacher.Id, NewClass_Subject_Teacher.Class_Subject.Id, NewClass_Subject_Teacher.Teacher.Id); command.ExecuteNonQuery(); }
public static Class_Subject_Teacher GetObj(Class_Subject clss_sbjct, Teacher tchr) { Class_Subject_Teacher obj = null; foreach (var clss_sbjct_tchr in Classes_Subjects_Teachers.Values) { if (clss_sbjct_tchr.Class_Subject.Id == clss_sbjct.Id && clss_sbjct_tchr.Teacher.Id == tchr.Id) { obj = clss_sbjct_tchr; } } return(obj); }
public static void Load() { //Load Cities command.CommandText = "SELECT * FROM Cities"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { City obj = new City(reader["Name"].ToString(), (Guid)reader["Id"]); City.Cities.Add(obj.Id, obj); } } reader.Close(); //Load Schools command.CommandText = "SELECT * FROM Schools"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { School obj = new School(reader["Name"].ToString(), (Guid)reader["Id"]) { City = City.Cities[(Guid)reader["City_id"]] }; School.Schools.Add(obj.Id, obj); } } reader.Close(); //Load Managers command.CommandText = "SELECT * FROM Managers"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Manager obj = new Manager(reader["FullName"].ToString(), reader["Login"].ToString(), reader["Password"].ToString(), (Guid)reader["Id"]) { School = School.Schools[(Guid)reader["School_id"]] }; Manager.Managers.Add(obj.Id, obj); } } reader.Close(); //Load Classes command.CommandText = "SELECT * FROM Classes"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Class obj = new Class(reader["Name"].ToString(), (Guid)reader["Id"]) { School = School.Schools[(Guid)reader["School_id"]] }; Class.Classes.Add(obj.Id, obj); } } reader.Close(); //Load Students command.CommandText = "SELECT * FROM Students"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Student obj = new Student(reader["FullName"].ToString(), reader["Login"].ToString(), reader["Password"].ToString(), (Guid)reader["Id"]) { Class = Class.Classes[(Guid)reader["Class_id"]] }; Student.Students.Add(obj.Id, obj); } } reader.Close(); //Load Subjects command.CommandText = "SELECT * FROM Subjects"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Subject obj = new Subject(reader["Name"].ToString(), (Guid)reader["Id"]); Subject.Subjects.Add(obj.Id, obj); } } reader.Close(); //Load Marks command.CommandText = "SELECT * FROM Marks"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Mark obj = new Mark(Convert.ToInt32(reader["Value"]), reader["Name"].ToString(), (Guid)reader["Id"]) { Student = Student.Students[(Guid)reader["Student_id"]], Subject = Subject.Subjects[(Guid)reader["Subject_id"]] }; Mark.Marks.Add(obj.Id, obj); } } reader.Close(); //Load Classes_Subjects command.CommandText = "SELECT * FROM Classes_Subjects"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Class_Subject obj = new Class_Subject((Guid)reader["Id"]) { Class = Class.Classes[(Guid)reader["Class_id"]], Subject = Subject.Subjects[(Guid)reader["Subject_id"]] }; Class_Subject.Classes_Subjects.Add(obj.Id, obj); } } reader.Close(); //Load Teachers command.CommandText = "SELECT * FROM Teachers"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Teacher obj = new Teacher(reader["FullName"].ToString(), reader["Login"].ToString(), reader["Password"].ToString(), (Guid)reader["Id"]) { School = School.Schools[(Guid)reader["School_id"]] }; Teacher.Teachers.Add(obj.Id, obj); } } reader.Close(); //Load Classes_Subjects_Teachers command.CommandText = "SELECT * FROM Classes_Subjects_Teachers"; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Class_Subject_Teacher obj = new Class_Subject_Teacher((Guid)reader["Id"]) { Class_Subject = Class_Subject.Classes_Subjects[(Guid)reader["Class_Subject_id"]], Teacher = Teacher.Teachers[(Guid)reader["Teacher_id"]] }; Class_Subject_Teacher.Classes_Subjects_Teachers.Add(obj.Id, obj); } } reader.Close(); }
public static void Delete(Class_Subject_Teacher DeletedClass_Subject_Teacher) //Delete Class_Subject_Teacher { command.CommandText = string.Format("DELETE FROM Classes_Subjects_Teachers WHERE Id = '{0}'", DeletedClass_Subject_Teacher.Id); command.ExecuteNonQuery(); Class_Subject_Teacher.Classes_Subjects_Teachers.Remove(DeletedClass_Subject_Teacher.Id); }