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 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("Заполнены не все поля!"); } }