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);
}
