private void btnAddDiplom_Click(object sender, EventArgs e)
{
connection DiplomConnection = new connection();
DiplomConnection.insert("Диплом", IDPerson + ",'" + NameOfUniversity.Text + "','" + Scienist.Text + "','"
+ EndYear.Text + "','" + Qualification.Text + "'");
dataGridView0.DataSource = FillDGV("*", "Диплом", "[Код сотрудника] = " + IDPerson);
NameOfUniversity.Text = "";
Scienist.Text = "";
EndYear.Text = "";
Qualification.Text = "";
}
private void btnAddFamily_Click(object sender, EventArgs e)
{
connection FamilyConnection = new connection();
FamilyConnection.insert("[Состав семьи]", IDPerson + ",'" + TreeOfFamily.Text + "','" + FIO.Text + "','" + BirthDayOfFamily.Text+"'");
dataGridView1.DataSource = FillDGV("*", "[Состав семьи]", "[Код сотрудника] = " + IDPerson);
FIO.Text = "";
TreeOfFamily.Text = "";
BirthDayOfFamily.Text = "";
}
private void btnAddIll_Click(object sender, EventArgs e)
{
connection IllConnection = new connection();
IllConnection.insert("Больничные", IDPerson + ",'" + DateOfIle.Text + "','" + DaysOfIle.Text + "','" + checkBox1.ThreeState + "'");
dataGridView3.DataSource = FillDGV("*", "Больничные", "[Код сотрудника] = " + IDPerson);
DateOfIle.Text = "";
DaysOfIle.Text = "";
checkBox1.Checked = false;
}
private void button1_Click(object sender, EventArgs e)
{
connection StaffConnection = new connection();
switch (button1.Text)
{
case "Добавить запись":
StaffConnection.insert("Сотрудники", "'"+LastName.Text + "','" + Name.Text + "','" + MoreName.Text
+ "','" + BirthDay.Text + "','" + NumberContract.Text + "','" + Merry.Text + "','" + WorkDate.Text
+ "','" + Gender.Text + "','" + Adress.Text +"','"+HaveAHome.Text + "','" + SerialPass.Text + "','"
+ NumberPass1.Text + "','" + DatePass.Text + "','" + PlaceOfBirth.Text + "','" + IDPass.Text + "','"
+ WhoGivePass.Text + "','" + Citizen.Text + "','" + INN.Text + "','" + InshuranceNumber.Text + "','"
+ MedicCardNumber.Text + "','" + Departament.Text + "','" + Occupation.Text + "','" + Sector.Text + "','"
+ Sailary.Text + "','" + MaxBonuseMoney.Text + "','" + HomeTel.Text + "','" + workTel.Text + "','"
+ MobTel.Text + "','" + Exp.Text+"'");
break;
case "Изменить":
StaffConnection.update("Сотрудники",
"Фамилия ='" + LastName.Text + "', Имя = '" + Name.Text + "', Отчеcтво ='" + MoreName.Text
+ "', [Дата рождения] ='" + BirthDay.Text + "', [Номер контракта] ='" + NumberContract.Text
+ "', [Семейное положение] ='" + Merry.Text
+ "', [Дата приёма] ='" + WorkDate.Text + "', Пол =" + Gender.Text + "', [Адрес проживания] ='" + Adress.Text
+ "', [Адрес прописки] ='" + HaveAHome.Text + "', [Серия паспорта] ='" + SerialPass.Text + "', [Номер паспорта] ='" + NumberPass1.Text
+ "', [Дата выдачи паспорта] ='" + DatePass.Text + "', [Место рождения] ='" + PlaceOfBirth.Text
+ "', [Код подразделения] ='" + IDPass.Text + "', [Паспорт выдан] ='" + WhoGivePass.Text + "', Гражданство ='" + Citizen.Text
+ "', ИНН ='" + INN.Text + "', [Номер страхового свидетельства] ='" + InshuranceNumber.Text
+ "', [Номер медицинского полиса] ='" + MedicCardNumber.Text + "', Департамент ='" + Departament.Text
+ "', Должность ='" + Occupation.Text + "', Сектор ='" + Sector.Text + "', Оклад ='" + Sailary.Text
+ "', [Максимальная премия] ='" + MaxBonuseMoney.Text + ", Дом.телефон ='" + HomeTel.Text
+ "', Раб.телефон ='" + workTel.Text + "', Моб.телефон ='" + MobTel.Text + "', [Стаж работы] ='" + Exp.Text,
"[Код сотрудника] = "+person.getID());
break;
default:
MessageBox.Show("Нет имени");
break;
}
}
private void btnAddHoly_Click(object sender, EventArgs e)
{
connection HolyConnection = new connection();
HolyConnection.insert("Отпуска", IDPerson + ",'" + DateOfBegining.Text + "','" + DateOfEnd.Text + "','" + NumberOfLaw.Text + "'");
dataGridView2.DataSource = FillDGV("*", "Отпуска", "[Код сотрудника] = " + IDPerson);
DateOfBegining.Text = "";
DateOfEnd.Text = "";
NumberOfLaw.Text = "";
}