public Family(string ID)
{
connection StaffConnectuon = new connection();
SqlDataReader myReader = StaffConnectuon.select("*", "[Состав семьи]", "[Код семьи] =" + ID);
while (myReader.Read()) {
IDFamily = Convert.ToInt32(myReader[0].ToString());
TreeFamily = myReader[2].ToString();
FIO = myReader[3].ToString();
BirthDayFamily = myReader[4].ToString();
}
}
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 = "";
}
public Diplom(string IDPerson)
{
connection StaffConnectuon = new connection();
SqlDataReader myReader = StaffConnectuon.select("*", "Диплом", "[Код сотрудника] =" + IDPerson);
while (myReader.Read())
{
IDDiplom = Convert.ToInt32(myReader[0].ToString());
NameOfUniversity = myReader[2].ToString();
Scienist = myReader[3].ToString();
EndYear = myReader[4].ToString();
Qualification = myReader[5].ToString();
}
}
/// <summary>
/// Конструктор для описывания сотрудника
/// </summary>
/// <param name="myReader">Данные, получаемые через sql запрос</param>
public Person(string IDPerson)
{
connection StaffConnectuon = new connection();
SqlDataReader myReader = StaffConnectuon.select("*", "Сотрудники", "[Код сотрудника] =" + IDPerson);
while (myReader.Read())
{
ID = Convert.ToInt32(myReader[0].ToString());
LastName = myReader[1].ToString();
Name = myReader[2].ToString();
MoreName = myReader[3].ToString();
BirthDay = myReader[4].ToString();
NumberContract = Convert.ToInt32(myReader[5].ToString());
Merry = myReader[6].ToString();
WorkDate = myReader[7].ToString();
Gender = myReader[8].ToString();
Adress = myReader[9].ToString();
HaveAHome = myReader[10].ToString();
SeriaOfPass = Convert.ToInt32(myReader[11].ToString());
NumberPass1 = Convert.ToInt32(myReader[12].ToString());
DatePass = myReader[13].ToString();
PlaceOfBirth = myReader[14].ToString();
IDPass = Convert.ToInt32(myReader[15].ToString());
WhoGivePass = myReader[16].ToString();
Citizen = myReader[17].ToString();
INN = Convert.ToInt32(myReader[18].ToString());
InshuranceNumber = Convert.ToInt32(myReader[19].ToString());
MedicCardNumber = Convert.ToInt32(myReader[20].ToString());
Department = myReader[21].ToString();
Occupation = myReader[22].ToString();
Sector = myReader[23].ToString();
Sailary = Convert.ToInt32(myReader[24].ToString());
MaxBonuseMoney = Convert.ToInt32(myReader[25].ToString());
HomeTele = Convert.ToInt32(myReader[26].ToString());
workTele = Convert.ToInt32(myReader[27].ToString());
MobTele = Convert.ToInt32(myReader[28].ToString());
Exp = myReader[29].ToString();
}
}
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 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 btnDelIll_Click(object sender, EventArgs e)
{
connection IllConnection = new connection();
IllConnection.delete("Больничные", "[Код больничного]", Convert.ToString(dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[0].Value));
dataGridView3.DataSource = FillDGV("*", "Больничные", "[Код сотрудника] = " + IDPerson);
}
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 btnDelFamily_Click(object sender, EventArgs e)
{
connection FamilyConnection = new connection();
FamilyConnection.delete("[Состав семьи]", "[Код семьи]", Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
dataGridView1.DataSource = FillDGV("*", "[Состав семьи]", "[Код сотрудника] = " + IDPerson);
}
private void btnDelDiplom_Click(object sender, EventArgs e)
{
connection DiplomConnection = new connection();
DiplomConnection.delete("Диплом", "[Код диплома]", Convert.ToString(dataGridView0.Rows[dataGridView0.CurrentRow.Index].Cells[0].Value));
dataGridView0.DataSource = FillDGV("*", "Диплом", "[Код сотрудника] = " + IDPerson);
}
private void btnChIll_Click(object sender, EventArgs e)
{
switch (btnChIll.Text)
{
case "Изменить":
DateOfIle.Text = Convert.ToString(dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[2].Value);
DaysOfIle.Text = Convert.ToString(dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[3].Value);
checkBox1.Checked = (bool)dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[4].Value;
btnChIll.Text = "Сохранить";
btnChIll.BackColor = System.Drawing.Color.GreenYellow;
break;
case "Сохранить":
btnChIll.Text = "Изменить";
btnChIll.BackColor = System.Drawing.Color.Transparent;
connection IllConnection = new connection();
IllConnection.update("Больничные",
" [Дата начала] ='" + DateOfIle.Text + "',[Колличество дней]='" + DaysOfIle.Text + "',[Совмещение с работой] ='" + checkBox1.Checked + "'",
"[Код больничного] = " + Convert.ToString(dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[0].Value));
dataGridView3.DataSource = FillDGV("*", "Больничные", "[Код сотрудника] = " + IDPerson);
DateOfIle.Text = "";
DaysOfIle.Text = "";
checkBox1.Checked = false;
break;
}
}
private void btnChHoly_Click(object sender, EventArgs e)
{
switch (btnChHoly.Text)
{
case "Изменить":
DateOfBegining.Text = Convert.ToString(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[2].Value);
DateOfEnd.Text = Convert.ToString(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[3].Value);
NumberOfLaw.Text = Convert.ToString(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[4].Value);
btnChHoly.Text = "Сохранить";
btnChHoly.BackColor = System.Drawing.Color.GreenYellow;
break;
case "Сохранить":
btnChHoly.Text = "Изменить";
btnChHoly.BackColor = System.Drawing.Color.Transparent;
connection HolyConnection = new connection();
HolyConnection.update("Отпуска",
" [Дата начала] ='" + DateOfBegining.Text + "',[Дата окончания]='" + DateOfEnd.Text + "',[№ приказа] ='" + NumberOfLaw.Text + "'",
"[Код отпуска] = " + Convert.ToString(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value));
dataGridView2.DataSource = FillDGV("*", "Отпуска", "[Код сотрудника] = " + IDPerson);
DateOfBegining.Text = "";
DateOfEnd.Text = "";
NumberOfLaw.Text = "";
break;
}
}
private void btnChFamily_Click(object sender, EventArgs e)
{
switch (btnChFamily.Text) {
case"Изменить":
FIO.Text = Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value);
TreeOfFamily.Text = Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value);
BirthDayOfFamily.Text = Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[4].Value);
btnChFamily.Text = "Сохранить";
btnChFamily.BackColor = System.Drawing.Color.GreenYellow;
break;
case"Сохранить":
btnChFamily.Text = "Изменить";
btnChFamily.BackColor = System.Drawing.Color.Transparent;
connection FamilyConnection = new connection();
FamilyConnection.update("[Состав семьи]",
"ФИО='" + FIO.Text + "',[Степень родства]='" + TreeOfFamily.Text + "',[Дата рождения] ='" + BirthDayOfFamily.Text + "'",
"[Код семьи] = "+ Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
dataGridView1.DataSource = FillDGV("*", "[Состав семьи]", "[Код сотрудника] = " + IDPerson);
FIO.Text = "";
TreeOfFamily.Text = "";
BirthDayOfFamily.Text = "";
break;
}
}
private void btnCHDiplom_Click(object sender, EventArgs e)
{
switch (btnCHDiplom.Text)
{
case "Изменить":
NameOfUniversity.Text = Convert.ToString(dataGridView0.Rows[dataGridView0.CurrentRow.Index].Cells[2].Value);
Scienist.Text = Convert.ToString(dataGridView0.Rows[dataGridView0.CurrentRow.Index].Cells[3].Value);
EndYear.Text = Convert.ToString(dataGridView0.Rows[dataGridView0.CurrentRow.Index].Cells[4].Value);
Qualification.Text = Convert.ToString(dataGridView0.Rows[dataGridView0.CurrentRow.Index].Cells[5].Value);
btnCHDiplom.Text = "Сохранить";
btnCHDiplom.BackColor = System.Drawing.Color.GreenYellow;
break;
case "Сохранить":
btnCHDiplom.Text = "Изменить";
btnCHDiplom.BackColor = System.Drawing.Color.Transparent;
connection DiplomConnection = new connection();
DiplomConnection.update("Диплом",
"[Название ВУЗа]='" + NameOfUniversity.Text + "',[Ученое звание]='" + Scienist.Text + "',[Год окончания] ='" + EndYear.Text + "',Квалификация= '" + Qualification.Text + "'",
"[Код диплома] = " + Convert.ToString(dataGridView0.Rows[dataGridView0.CurrentRow.Index].Cells[0].Value));
dataGridView0.DataSource = FillDGV("*", "Диплом", "[Код сотрудника] = " + IDPerson);
NameOfUniversity.Text = "";
Scienist.Text = "";
EndYear.Text = "";
Qualification.Text = "";
break;
}
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
connection StaffConnectuon = new connection();
//StaffConnectuon.Open();
StaffConnectuon.delete("Сотрудники", "[Код сотрудника]", Convert.ToString(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value));
// StaffConnectuon.Close();
}
private void btnDelHoly_Click(object sender, EventArgs e)
{
connection HolyConnection = new connection();
HolyConnection.delete("Отпуска", "[Код отпуска]", Convert.ToString(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value));
dataGridView2.DataSource = FillDGV("*", "Отпуска", "[Код сотрудника] = " + IDPerson);
}
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 = "";
}
