private void Employee_CellOrItsContentContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
if (e.ColumnIndex == EmployeeDGV.Columns.Count - 1)
{
DbWorker.DeleteData("Employees", "employee_id", EmployeeDGV.Rows[e.RowIndex].Cells[0].Value.ToString());
EmployeeDGV.Rows.RemoveAt(e.RowIndex);
return;
}
var stringRow = new string[] //я этим не горжусь :(
{
EmployeeDGV.Rows[e.RowIndex].Cells[0].Value.ToString(),
EmployeeDGV.Rows[e.RowIndex].Cells[1].Value.ToString(),
EmployeeDGV.Rows[e.RowIndex].Cells[2].Value.ToString(),
EmployeeDGV.Rows[e.RowIndex].Cells[3].Value.ToString()
};
ef = new EmployeeForm(new Employee(stringRow));
ef.Owner = this;
ef.ShowDialog();
EmployeeDGV.Rows.Clear();
EmployeeDGV.Update();
DbWorker.GetActualData(AddDGV);
}
private void button1_Click(object sender, EventArgs e)
{
if (DbWorker.Check(conStringTextBox.Text))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public EmployeeForm()
{
InitializeComponent();
Emp = null;
DbWorker.FillDocTypes().ForEach(type => DocTypeCombobox.Items.Add(type));
DbWorker.FillPhoneTypes().ForEach(type => phoneTypeCBox.Items.Add(type));
this.Text = "Создание пользователя";
}
private void AddEmployee_Click(object sender, EventArgs e)
{
ef = new EmployeeForm();
ef.Owner = this;
ef.ShowDialog();
EmployeeDGV.Rows.Clear();
EmployeeDGV.Update();
DbWorker.GetActualData(AddDGV);
}
public EmployeeForm(Employee emp) : this()
{
this.Text = "Просмотр и редактирование пользователя";
PutEmployeeOnForm(emp);
Doc = DbWorker.GetDocument(empId: emp.Id);
PutDocOnForm(Doc);
Emp = emp;
Phone = DbWorker.GetPhone(empId: emp.Id);
PutPhoneOnForm(Phone);
}
public MainForm()
{
InitializeComponent();
if (new ConnectionForm().ShowDialog() == DialogResult.Cancel)
{
Environment.Exit(0);
}
DbWorker.GetActualData(AddDGV);
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (NameTextBox.Text != "" && GenderCombobox.SelectedItem != null && BirthDateTextbox.Text != "" &&
DocTypeCombobox.SelectedItem != null &&
SeriesTextbox.Text != "" && NumberTextbox.Text != "" && DateToTextbox.Text != "" &&
DateFromTextbox.Text != "" && phoneTextBox.Text != "" &&
phoneTypeCBox.SelectedItem != null)
{
var allGood = true;
if (Emp == null)
{
var empId = DbWorker.GetMaxId("Employees", "employee_id") + 1;
allGood = DbWorker.InsertData("Employees",
$"{empId}",
$"'{NameTextBox.Text}'", GenderCombobox.SelectedItem == "М" ? "1" : "0",
$"'{BirthDateTextbox.Text}'");
var docId = DbWorker.GetMaxId("Employee_Documents", "doc_id") + 1;
if (allGood)
{
allGood = DbWorker.InsertData("Employee_Documents", $"{empId}",
$"{docId}",
$"{SeriesTextbox.Text}{NumberTextbox.Text}",
$"{DocTypeCombobox.SelectedIndex}",
$"'{DateFromTextbox.Text}'",
$"'{DateToTextbox.Text}'");
}
var phoneId = DbWorker.GetMaxId("Employee_Phones", "phone_id") + 1;
if (allGood)
{
allGood = DbWorker.InsertData("Employee_Phones", $"{phoneId}",
$"{phoneTextBox.Text}",
$"{empId}",
$"{phoneTypeCBox.SelectedIndex}");
}
else
{
DbWorker.DeleteData("Employees", "employee_id", $"{empId}"); //если плохо добавился док - надо удалить сотрудника
}
if (!allGood)
{
DbWorker.DeleteData("Employees", "employee_id", $"{docId}"); //если плохо добавился телефон - надо удалить и сотрудника
DbWorker.DeleteData("Employee_Documents", "doc_id", $"{docId}"); //и его документ
}
}
else
{
//для обновления это не нужно
allGood = DbWorker.UpdateData("Employees", "employee_id", Emp.Id,
("employee_name", $"'{NameTextBox.Text}'"),
("is_male", GenderCombobox.SelectedItem == "М" ? "1" : "0"),
("birth_date", $"'{BirthDateTextbox.Text}'"));
if (allGood)
{
allGood = DbWorker.UpdateData("Employee_Documents", "doc_id", Doc.DocId,
("series_number", $"{SeriesTextbox.Text}{NumberTextbox.Text}"),
("doc_type", $"{DocTypeCombobox.SelectedIndex}"),
("from_date", $"'{DateFromTextbox.Text}'"),
("by_date", $"'{DateToTextbox.Text}'"));
}
if (allGood)
{
allGood = DbWorker.UpdateData("Employee_Phones", "phone_id", Phone.Id,
("phone_number", $"'{phoneTextBox.Text}'"),
("phone_type", $"{phoneTypeCBox.SelectedIndex}"));
}
}
if (allGood)
{
this.Close();
}
}
else
{
MessageBox.Show("Заполнены не все поля!");
}
}
private void SearchButton_Click(object sender, EventArgs e)
{
EmployeeDGV.Rows.Clear();
EmployeeDGV.Update();
DbWorker.GetFilteredData(AddDGV, SearchTextbox.Text);
}
