145
}
public partial class fmDeleteWorker : Form
{
public fmDeleteWorker()
{
InitializeComponent();
}
private void fmDeleteWorker_Load(object sender, EventArgs e)
{
lbFIO.Text += FormDialog.Surname + " " + FormDialog.Name + " " +
FormDialog.SecondName;
}
private void chDocument_Click(object sender, EventArgs e)
{
if (sender is CheckBox)
((CheckBox)sender).Checked = !((CheckBox)sender).Checked;
}
private void txtСause_Click(object sender, EventArgs e)
{
txtСause.SelectAll();
}
private void btDelete_Click(object sender, EventArgs e)
{
if (txtСause.Text != "<Причина увольнения>" && txtСause.Text != "" &&
chDocument.Checked)
{
string File = FormDialog.ID + "_" + dtpDate.Text + "_" +
Path.GetExtension(FormDialog.FileName);
System.IO.File.Copy(FormDialog.Path,
@"ListOfDismissedeEmployees//" + FormDialog.ID + "_" + dtpDate.Text + "_" +
Path.GetExtension(FormDialog.FileName));
DataTable dt =
GetTable.Get("SELECT * FROM ListOfWorker WHERE Код=" + FormDialog.ID);
DateTime BirtdayData = Convert.ToDateTime(dt.Rows[0][5].ToString());
DateTime Start = Convert.ToDateTime(dt.Rows[0][13].ToString());
DateTime Now = dtpDate.Value;
GetTable.Get(
"INSERT INTO ListOfDismissedeEmployees (Код, Фамилия, Имя, Отчество, Пол, [Дата
рождения], Стаж, Категория, Звание, Оклад, Должность, [Дата принятия на
работу],Заявление, [Причина увольнения],[Дата увольнения]) VALUES (" +
dt.Rows[0][0].ToString() + ",'" + dt.Rows[0][1].ToString() + "', '" +
dt.Rows[0][2].ToString() + "', '" + dt.Rows[0][3].ToString() + "', '" +
dt.Rows[0][4].ToString() + "', '" + BirtdayData.Day + "/" + BirtdayData.Month + "/" +
BirtdayData.Year + "','" + dt.Rows[0][7].ToString() + "', '" +
dt.Rows[0][8].ToString() + "', '" + dt.Rows[0][10].ToString() + "','" +
dt.Rows[0][11].ToString() + "', '" + dt.Rows[0][12].ToString() + "', '" + Start.Day +
"/" + Start.Month + "/" + Start.Year + "','" + File + "', '" + txtСause.Text + "','"
+ dtpDate.Text.Replace(".", "/") + "')");
GetTable.Get("DELETE * FROM Education WHERE Код=" + FormDialog.ID);
GetTable.Get("DELETE * FROM PreviousJobs WHERE Код=" + FormDialog.ID);
GetTable.Get("DELETE * FROM QueueForCertification WHERE Код=" + FormDialog.ID);
GetTable.Get("DELETE * FROM TravelledCertification WHERE Код=" + FormDialog.ID);
GetTable.Get("DELETE * FROM TheListOfEmployeesOnLeave WHERE Код=" +
FormDialog.ID);