private void updateCustom_Click(object sender, EventArgs e)
{
if (employeeService.isExistSSN(ssnTextBox.Text))
{
MessageBox.Show("ssn already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
EmployeeUpdateSdi employeeUpdateSdi = new EmployeeUpdateSdi();
employeeUpdateSdi.EmployeeId1 = employeeIdTextBox.Text;
employeeUpdateSdi.SSN1 = ssnTextBox.Text;
employeeUpdateSdi.Fname = fnameTextBox.Text;
employeeUpdateSdi.Mname = mnameTextBox.Text;
employeeUpdateSdi.Lname = lnameTextBox.Text;
employeeUpdateSdi.Salary = Convert.ToDouble(salaryTextBox.Text);
employeeUpdateSdi.DOB1 = dobTextBox.Value.ToString();
employeeUpdateSdi.RoleType = roleTypeTextBox.Text;
employeeUpdateSdi.PhoneNumber = phoneNumberTextBox.Text;
employeeUpdateSdi.Address = addressTextBox.Text;
Employee employee = employeeService.updateEmployee(employeeUpdateSdi);
if (employee != null)
{
this.Close();
employeeForm.updateDataToTable(employee);
}
}
}
public Employee updateEmployee(EmployeeUpdateSdi sdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append(" update Employee set ssn = @ssn," +
"fName = @fname," +
"lName = @lname," +
"mName = @mname," +
"Salary = @salary," +
"DOB = @dob," +
"Address = @address," +
"phoneNumber = @phonenumber," +
"roleType = @roletype ");
sql.Append(" where EmplID = @employeeid");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("ssn", sdi.SSN1);
command.Parameters.AddWithValue("roletype", sdi.RoleType);
command.Parameters.AddWithValue("fname", sdi.Fname);
command.Parameters.AddWithValue("mname", sdi.Mname);
command.Parameters.AddWithValue("lname", sdi.Lname);
command.Parameters.AddWithValue("dob", DateTime.Parse(sdi.DOB1));
command.Parameters.AddWithValue("phonenumber", sdi.PhoneNumber);
command.Parameters.AddWithValue("address", sdi.Address);
command.Parameters.AddWithValue("employeeid", sdi.EmployeeId1);
command.Parameters.AddWithValue("salary", sdi.Salary);
command.ExecuteNonQuery();
con.Close();
return(this.getEmployeeById(sdi.EmployeeId1));
}
public Employee updateEmployee(EmployeeUpdateSdi employeeUpdateSdi)
{
return(employeeRepoService.updateEmployee(employeeUpdateSdi));
}
