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 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 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 AspirantSelectLists(Aspirant aspirant, AspiranturaContext context)
{
Statuses = Helper.GetStatuses();
Studyforms = Helper.GetStudyForms();
Specialities = Helper.GetSpecialities(context);
Departments = Helper.GetDepartments(context);
Prepods = Helper.GetPrepods(context);
if (aspirant != null)
{
selectedStatus = Statuses.FirstOrDefault(k => k.Value == (int)aspirant.StatusType);
selectedStudyform = Studyforms.FirstOrDefault(k => k.Value == (int)aspirant.StudyForm);
selectedSpeciality = Specialities.FirstOrDefault(k => k.Value == aspirant.SpecialityId); // возможно нужна проверка на null
selectedDepartment = Departments.FirstOrDefault(k => k.Value == aspirant.DepartmentId);
selectedPrepod = Prepods.FirstOrDefault(k => k.Value == aspirant.PrepodId);
}
}
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 BtnPrepod_Click(object sender, RoutedEventArgs e)
{
Prepods prepods = new Prepods();
prepods.Show();
}
public string FindPrepodsInAb(int a, int b)
{
var prepodsInAb = Prepods.Where(prepod => a < prepod.Salary && prepod.Salary < b).ToList();
return(prepodsInAb.Count > 0 ? string.Join(", ", prepodsInAb) : "Таких преподавателей нет");
}
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;
}
}
