void fillTeacherKeyCombo()
{
iTeacherTableDB iTeacher = new iTeacherTableDB();
MySqlCommand command = new MySqlCommand("SELECT * FROM `iteacher`");
comboBoxfkT.DataSource = iTeacher.getTeachers(command);
comboBoxfkT.DisplayMember = "id"; comboBoxfkT.ValueMember = "id";
comboBoxfkT.SelectedItem = null;
this.comboBoxfkT.DropDownStyle = ComboBoxStyle.DropDownList;
}
private void statisticTeacherForm_Load(object sender, EventArgs e)
{//показываем кол-во учителей
iTeacherTableDB iTeacher = new iTeacherTableDB();
double totalTeacher = Convert.ToDouble(iTeacher.totalTeacher());
double totalMale = Convert.ToDouble(iTeacher.totalMale());
double totalFemale = Convert.ToDouble(iTeacher.totalFemale());
double malePercentage = totalMale * 100 / totalTeacher;
double femalePercentage = totalFemale * 100 / totalTeacher;
labelTotal.Text = "Общая количество учителей: " + totalTeacher.ToString();
labelMale.Text = "Мужчины: " + malePercentage.ToString("0.00") + "%";
labelFemale.Text = "Женщины: " + femalePercentage.ToString("0.00") + "%";
}
private void buttonAddTeacher_Click(object sender, EventArgs e)
{
iTeacherTableDB iTeacher = new iTeacherTableDB();
string surname = textBoxSname.Text;
string name = textBoxName.Text;
string patronymic = textBoxPname.Text;
string gender = "Мужчина";
if (radioButtonFemale.Checked)
{
gender = "Женщина";
}
DateTime birthdate = dateTimePicker1.Value;
string address = textBoxAddress.Text;
string mail = textBoxMail.Text;
string mobile = textBoxMobile.Text;
string login = textBoxLogin.Text;
string password = textBoxPassword.Text;
MemoryStream teacherPic = new MemoryStream();
int born_year = dateTimePicker1.Value.Year;
int this_year = DateTime.Now.Year;
if ((this_year - born_year) < 22 || (this_year - born_year) > 55)
{
MessageBox.Show("Учитель не может преподовать если ему нет 22 и ему больше 55 лет", "Не правильная дата", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (myVerif())
{
pictureBoxTeacherImage.Image.Save(teacherPic, pictureBoxTeacherImage.Image.RawFormat);
if (iTeacher.insertTeacher(surname, name, patronymic, gender, birthdate, address, mail, mobile, login, password, teacherPic))
{
MessageBox.Show("Учитель добавлен в нашу школу", "Успешно!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Извините что-то не так", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Выполните все услновии", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}