/// <summary>
/// Reset filters.
/// </summary>
private void Button6_Click(object sender, EventArgs e)
{
EmployeesPanel.ClearAllData();
EmployeesLV.ClearAllData();
EmployeesLV.SetNameColumns();
EmployeesLV.GetAllData(!checkBox1.Checked);
}
private void Search()
{
int cur = EmployeesLV.IsSelected() ? EmployeesLV.GetSelectedIndex() + 1 : 0;
int count = EmployeesLV.GetCountItems();
for (int i = cur; i < cur + count; i++)
{
int index = i % count;
if (HEquals.E(textBox11, index, EmployeesLV.I_FNAME) &&
HEquals.E(textBox7, index, EmployeesLV.I_LNAME) &&
HEquals.E(textBox4, index, EmployeesLV.I_MNAME) &&
HEquals.E(textBox5, index, EmployeesLV.I_JOB_ID) &&
HEquals.E(textBox10, index, EmployeesLV.I_TEL_WORK) &&
HEquals.E(textBox8, index, EmployeesLV.I_EMAIL) &&
HEquals.E(comboBox1, checkBox6, index, EmployeesLV.I_IS_ACTIVITY) &&
HEquals.E(comboBox2, checkBox1, index, EmployeesLV.I_SEX) &&
HEquals.E(dateTimePicker1, checkBox2, index, EmployeesLV.I_EMPLOYMENT_DATE) &&
HEquals.E(dateTimePicker2, checkBox3, index, EmployeesLV.I_UPDATE_AT)
)
{
EmployeesLV.SetSelected(index, true);
return;
}
}
}
/// <summary>
/// Project selection. Setting up a new environment.
/// </summary>
private bool SelectProject()
{
using (FormChoose f = new FormChoose())
{
f.ShowDialog();
if (f.IsOpen())
{
try
{
Database.SetConnection(Config.currentFolder + "\\" + Database.FILE_NAME);
EmployeesLV.SetListBox(listView1);
EmployeesLV.SetNameColumns();
EmployeesLV.GetAllData(!checkBox1.Checked);
EmployeesPanel.SetPanel(panelEmployee);
EmployeesPanel.Enabled();
Text = Config.PROJECT_NAME + " - " + f.GetNameFolder();
}
catch
{
MessageBox.Show("Файл пошкоджений");
return(false);
}
return(true);
}
}
return(false);
}
public static bool E(CheckBox c, CheckBox isActive, int iRow, int iCell)
{
if (isActive.Checked)
{
return(c.Checked == EmployeesLV.GetValueItem(iRow, iCell).Equals("Так"));
}
return(true);
}
public static bool E(ComboBox cb, CheckBox isActive, int iRow, int iCell)
{
if (isActive.Checked)
{
return(string.Equals(cb.Text,
EmployeesLV.GetValueItem(iRow, iCell).ToString()));
}
return(true);
}
/// <summary>
/// Quick search button.
/// </summary>
private void Button4_Click(object sender, EventArgs e)
{
// If empty or the string is constant TEXT_SEARCH => return.
if (string.IsNullOrEmpty(findField.Text) || findField.Text.Equals(TEXT_SEARCH))
{
return;
}
EmployeesLV.FindCellAndSetFocus(findField.Text, EmployeesLV.I_LNAME, true);
}
public static bool E(TextBox t, int iRow, int iCell)
{
if (string.IsNullOrWhiteSpace(t.Text))
{
return(true);
}
return(string.Equals(t.Text.Trim(),
EmployeesLV.GetValueItem(iRow, iCell).ToString(),
StringComparison.OrdinalIgnoreCase));
}
public static bool E(DateTimePicker dtp, CheckBox isActive, int iRow, int iCell)
{
if (isActive.Checked)
{
if (!dtp.Value.Date.ToShortDateString().Equals(
EmployeesLV.GetValueItem(iRow, iCell).ToString()))
{
return(false);
}
}
return(true);
}
/// <summary>
/// Event when the selected employee is changed.
/// </summary>
private void ListView1_SelectedIndexChanged(object sender, EventArgs e)
{
// If the focus is lost, delete the panel.
if (!EmployeesLV.IsSelected())
{
EmployeesPanel.ClearAllData();
button7.Enabled = false;
button7.Text = "Оберіть працівника";
return;
}
FillPanelEmployee();
}
private void OpenOtherFormWithImage(bool isOpen = true)
{
if (isOpen)
{
pictureBox1.Image = null;
Employees.CloseImage();
Employees.isOpen = true;
return;
}
Employees.isOpen = false;
EmployeesLV.UpdateSelected();
}
private void EmployeeToolStripMenuItem_Click(object sender, EventArgs e)
{
if (!EmployeesLV.IsSelected())
{
MessageBox.Show("Оберіть працівника");
return;
}
OpenOtherFormWithImage();
using (FormEmployee f = new FormEmployee(EmployeesLV.GetSelectedID()))
{
f.ShowDialog();
}
OpenOtherFormWithImage(false);
}
/// <summary>
/// Fill the panel with data from dataGridView.
/// </summary>
private void FillPanelEmployee()
{
if (!Employees.isOpen)
{
EmployeesPanel.AddInfo(pictureBox1, Employees.GetImage(EmployeesLV.GetSelectedID()));
}
EmployeesPanel.AddInfo(fieldFName, EmployeesLV.GetSelectedCell(EmployeesLV.I_FNAME));
EmployeesPanel.AddInfo(fieldLName, EmployeesLV.GetSelectedCell(EmployeesLV.I_LNAME));
EmployeesPanel.AddInfo(fieldMName, EmployeesLV.GetSelectedCell(EmployeesLV.I_MNAME));
EmployeesPanel.AddInfo(fieldJob, EmployeesLV.GetSelectedCell(EmployeesLV.I_JOB_ID));
EmployeesPanel.AddInfo(fieldTelWork, EmployeesLV.GetSelectedCell(EmployeesLV.I_TEL_WORK));
EmployeesPanel.AddInfo(fieldEmail, EmployeesLV.GetSelectedCell(EmployeesLV.I_EMAIL));
EmployeesPanel.AddInfo(fieldEmployment, EmployeesLV.GetSelectedCell(EmployeesLV.I_EMPLOYMENT_DATE));
EmployeesPanel.AddInfo(fieldUpdateAt, EmployeesLV.GetSelectedCell(EmployeesLV.I_UPDATE_AT));
button7.Enabled = true;
button7.Text = "Відкрити картку #" + EmployeesLV.GetSelectedID();
}
private void Filter()
{
for (int i = 0; i < EmployeesLV.GetCountItems(); i++)
{
if (!HEquals.E(textBox11, i, EmployeesLV.I_FNAME) ||
!HEquals.E(textBox7, i, EmployeesLV.I_LNAME) ||
!HEquals.E(textBox4, i, EmployeesLV.I_MNAME) ||
!HEquals.E(textBox5, i, EmployeesLV.I_JOB_ID) ||
!HEquals.E(textBox10, i, EmployeesLV.I_TEL_WORK) ||
!HEquals.E(textBox8, i, EmployeesLV.I_EMAIL) ||
!HEquals.E(comboBox1, checkBox6, i, EmployeesLV.I_IS_ACTIVITY) ||
!HEquals.E(comboBox2, checkBox1, i, EmployeesLV.I_SEX) ||
!HEquals.E(dateTimePicker1, checkBox2, i, EmployeesLV.I_EMPLOYMENT_DATE) ||
!HEquals.E(dateTimePicker2, checkBox3, i, EmployeesLV.I_UPDATE_AT)
)
{
EmployeesLV.Delete(i--);
}
}
}
private void FormChooseToolStripMenuItem_Click(object sender, EventArgs e)
{
Hide();
// Close and clear all data.
EmployeesLV.ClearAllData();
EmployeesPanel.ClearAllData();
EmployeesLV.Close();
EmployeesPanel.Close();
Database.CloseConnection();
button7.Enabled = false;
button7.Text = "Оберіть працівника";
if (!SelectProject())
{
Application.ExitThread();
}
Show();
}
private void Button1_Click(object sender, EventArgs e)
{
if (isNew)
{
id = MainModel.GetCountRecords() + 1;
}
int jobID = string.IsNullOrWhiteSpace(comboBox1.Text)
? 0
: JobsModel.GetOneJobs(comboBox1.Text).First().Id;
bool isCorrectSalary = Double.TryParse(textBox10.Text, out double salary);
if (!isCorrectSalary)
{
MessageBox.Show("Зарплата не вірна");
return;
}
var main = new MainTable
{
Id = id,
FName = textBox2.Text, // Top
MName = textBox3.Text,
LName = textBox1.Text,
JobId = jobID,
TimeTableNum = textBox9.Text, // Middle Main
IndividualTaxNum = textBox8.Text,
Sex = comboBox3.Text.Equals("Чоловік"),
EmploymentDate = dateTimePicker2.Value.Date,
DateDismissal = dateTimePicker3.Value.Date,
UpdateAt = DateTime.Today,
Email = textBox5.Text,
TelWork = textBox6.Text,
TelHome = textBox7.Text,
About = textBox4.Text,
Salary = salary,
IsActivity = comboBox2.Text.Equals("Працює") // Bottom
};
int isUpdated = isNew ? MainModel.Insert(main) : MainModel.Update(main);
if (isUpdated == 1)
{
if (isNew)
{
EmployeesLV.AddOneData(id);
}
else
{
EmployeesLV.UpdateOneData(id);
}
EmployeesLV.UpdateSelected();
label19.BackColor = Color.DarkSlateGray;
label19.Text = "Збережено";
}
else
{
label19.BackColor = Color.FromArgb(185, 46, 59);
label19.Text = "Не збережено";
}
label19.Visible = true;
timer1.Enabled = true;
}
