private void button_Add_Click(object sender, EventArgs e) { People prepod = new People(); prepod.name = textBox_Name.Text; prepod.surname = textBox_Surname.Text; prepod.patronumic = textBox_Patronumic.Text; prepod.login = textBox_Login.Text; prepod.birthday = dateTimePicker_Birthday.Value; prepod.information = richTextBox_Information.Text; try { Prepods prepods = new Prepods(); prepods.OpenConnection(connectionSrting); prepods.InsertPrepod(prepod); prepods.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } MessageBox.Show("Преподаватель был успешно добавлен!"); this.Close(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { Prepods p = new Prepods(); p.OpenConnection(connectionString); People pe = p.GetPrepodByFIO(comboBox1.SelectedItem.ToString()); int idprep = p.GetIdByFIO(pe.name, pe.surname, pe.patronumic); p.CloseConnection(); this.label_Fio.Text = pe.surname + " " + pe.name[0] + '.' + pe.patronumic[0]; this.label_birthday.Text = pe.ConvertDate(); this.richTextBox_Info.Text = pe.information; Predmets pr = new Predmets(); pr.OpenConnection(connectionString); this.richTextBox1.Text = ""; this.richTextBox1.Text = String.Join("\n", pr.GetPredmetsByPrepodId(idprep)); pr.CloseConnection(); this.Text = comboBox1.Text; pictureBox1.Visible = true; label_Fio.Visible = true; label_birthday.Visible = true; label1.Visible = true; richTextBox_Info.Visible = true; richTextBox1.Visible = true; }
private void ViewPrepod_Load(object sender, EventArgs e) { Prepods p = new Prepods(); p.OpenConnection(connectionString); comboBox1.Items.AddRange(p.GetAllPrepods()); p.CloseConnection(); }
private void AddPredmet_Load(object sender, EventArgs e) { Prepods p = new Prepods(); p.OpenConnection(connectionString); this.comboBox_Prepods.Items.AddRange(p.GetAllPrepods()); p.CloseConnection(); }
private void button_Delete_Click(object sender, EventArgs e) { if (comboBox1.Text == "Выберите") { MessageBox.Show("Вы не выбрали!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string[] mas = comboBox1.Text.Split(' '); string name = mas[1]; string surname = mas[0]; string patronumic = mas[2]; if (mode == "prepod") { try { Prepods prepods = new Prepods(); prepods.OpenConnection(connectionString); prepods.DeletePrepodByFIO(name, surname, patronumic); prepods.CloseConnection(); } catch (SqlException ex) { MessageBox.Show("Невозможно удалить преподавателя!\nУдалите сперва предметы, которые он ведет!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MessageBox.Show("Преподователь был успешно удален!"); this.Close(); } else if (mode == "student") { try { Students students = new Students(); students.OpenConnection(connectionString); students.DeleteStudentByFIO(name, surname, patronumic); students.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MessageBox.Show("Студент был успешно удален!"); this.Close(); } }
public PrepodMain(People p) { InitializeComponent(); //звполнение данными поля connectionString = ConfigurationManager.AppSettings["connectionString"]; Prepods prep = new Prepods(); prep.OpenConnection(connectionString); id=prep.GetIdByFIO(p.name,p.surname,p.patronumic); prep.CloseConnection(); this.Text = p.surname + " " + p.name; this.label_Fio.Text = p.surname + " " + p.name[0] + '.' + p.patronumic[0]; this.label_birthday.Text = p.ConvertDate(); this.richTextBox_Info.Text = p.information; }
public DeletePeople(string mode) { InitializeComponent(); this.mode = mode; connectionString = ConfigurationManager.AppSettings["connectionString"]; if (mode == "prepod") { Prepods p = new Prepods(); p.OpenConnection(connectionString); comboBox1.Items.AddRange(p.GetAllPrepods()); p.CloseConnection(); } else if (mode == "student") { Students s = new Students(); s.OpenConnection(connectionString); comboBox1.Items.AddRange(s.GetAllStudents().Split('\n')); s.CloseConnection(); } }
private void button_Enter_Click(object sender, EventArgs e) { if (textBox_Login.Text == String.Empty || textBox_Password.Text == String.Empty) { MessageBox.Show("Вы не ввели логин или пароль\n", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } switch (comboBox_Choice.Text) // выбор типа профиля { case "Администратор": if (textBox_Login.Text == "admin" && textBox_Password.Text == "admin") { administrator.AdminMain admin = new administrator.AdminMain(); this.Opacity = 0; admin.ShowDialog(); } else { MessageBox.Show("Вы ввели неверный логин или пароль\n", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; case "Студент": try { Students s = new Students(); // создание объекта студента s.OpenConnection(connectionString); //открытие соединения People student = s.Autorization(textBox_Login.Text, textBox_Password.Text); // получение инфы о студенте if (textBox_Password.Text == "12345") // если пароль стандартный- то происходит его изменение { NewPasswordDialog newpas = new NewPasswordDialog(this); newpas.ShowDialog(); s.ChangeNewPassword(textBox_Login.Text, label_NewPas.Text); //запись нового пароля в бд } prepod.StudentMain form = new prepod.StudentMain(student); s.CloseConnection(); // закрытие соединения this.Opacity = 0; form.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; case "Преподаватель": try { Prepods p = new Prepods(); p.OpenConnection(connectionString); People prepod = p.Autorization(textBox_Login.Text, textBox_Password.Text); if (textBox_Password.Text == "12345") { NewPasswordDialog newpas = new NewPasswordDialog(this); newpas.ShowDialog(); p.ChangeNewPassword(textBox_Login.Text, label_NewPas.Text); //запись нового пароля в бд } prepod.PrepodMain form = new prepod.PrepodMain(prepod); p.CloseConnection(); this.Opacity = 0; form.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; default: MessageBox.Show("Вы не выбрали тип профиля\n", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } }