private void btnAdd_Click(object sender, EventArgs e) { if (tabDepartment.TabPages.Count <= 1) { MessageBox.Show("No Departments entered! You cannot add Employee without one Department created", "Cannot add Employee", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { AddEditEmployee addEmp = new AddEditEmployee(true); addEmp.Text = "Add new Employee"; addEmp.ShowDialog(); // refresh LoadEmployees(); } }
private void btnEdit_Click(object sender, EventArgs e) { if (lvEmployees.Items.Count > 0) { // ukoliko se pritisne botun edit, a na listi nije nista selektirano. if (lvEmployees.SelectedItems.Count < 1) { MessageBox.Show("Please select an item", "Cannot edit item", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { AddEditEmployee editEmp = new AddEditEmployee(false); DataRow dr = sqlProcedures.GetEmployee(Convert.ToInt32(lvEmployees.SelectedItems[0].Text)); editEmp.txtEmpId.Text = Validator.ConvertFromDBVal <int>(dr["EmployeeID"]).ToString(); editEmp.txtFirstName.Text = Validator.ConvertFromDBVal <string>(dr["FirstName"]); editEmp.txtLastName.Text = Validator.ConvertFromDBVal <string>(dr["LastName"]); editEmp.txtJobTitle.Text = Validator.ConvertFromDBVal <string>(dr["JobTitle"]); editEmp.txtEmail.Text = Validator.ConvertFromDBVal <string>(dr["EmailAddress"]); editEmp.txtNotes.Text = Validator.ConvertFromDBVal <string>(dr["Notes"]); DateTime?birthDate = Validator.ConvertFromDBVal <DateTime?>(dr["BirthDate"]); if (birthDate != null) { editEmp.txtBirthDate.Text = Convert.ToDateTime(birthDate).ToString("d"); editEmp.dtpBirthDate.Value = Convert.ToDateTime(birthDate); } DateTime?dateHired = Validator.ConvertFromDBVal <DateTime?>(dr["DateHired"]); if (dateHired != null) { editEmp.txtDateHired.Text = Convert.ToDateTime(dateHired).ToString("d"); editEmp.dtpDateHired.Value = Convert.ToDateTime(dateHired); } // department editEmp.cmbDepartment.SelectedValue = Validator.ConvertFromDBVal <int>(dr["DepartmentID"]); // phone numbers editEmp.txtBussPhone.Text = Validator.ConvertFromDBVal <string>(dr["BusinessPhone"]); editEmp.txtHomePhone.Text = Validator.ConvertFromDBVal <string>(dr["HomePhone"]); editEmp.txtMobilePhone.Text = Validator.ConvertFromDBVal <string>(dr["MobilePhone"]); editEmp.txtFaxNumber.Text = Validator.ConvertFromDBVal <string>(dr["FaxNumber"]); // address editEmp.txtAddress.Text = Validator.ConvertFromDBVal <string>(dr["Address"]); editEmp.txtCity.Text = Validator.ConvertFromDBVal <string>(dr["City"]); editEmp.txtStateProvince.Text = Validator.ConvertFromDBVal <string>(dr["StateProvince"]); editEmp.txtPostalCode.Text = Validator.ConvertFromDBVal <string>(dr["PostalCode"]); editEmp.txtCountry.Text = Validator.ConvertFromDBVal <string>(dr["Country"]); editEmp.Text = "Edit Employee"; editEmp.ShowDialog(); // refresh LoadEmployees(); } } else { MessageBox.Show("No Employees found", "Unable to edit", MessageBoxButtons.OK, MessageBoxIcon.Error); } }