public Employee insertEmployee(EmployeeInsertSdi employeeInsertSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append("insert into Employee values(@employeeid,@ssn,@fname,@mname,@lname,@salary,@dob,@address,@phonenumber,@roletype,@username,@password)");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("employeeid", employeeInsertSdi.EmployeeId1);
command.Parameters.AddWithValue("ssn", employeeInsertSdi.SSN1);
command.Parameters.AddWithValue("fname", employeeInsertSdi.Fname);
command.Parameters.AddWithValue("mname", employeeInsertSdi.Mname);
command.Parameters.AddWithValue("lname", employeeInsertSdi.Lname);
command.Parameters.AddWithValue("dob", DateTime.Parse(employeeInsertSdi.DOB1));
command.Parameters.AddWithValue("phonenumber", employeeInsertSdi.PhoneNumber);
command.Parameters.AddWithValue("address", employeeInsertSdi.Address);
command.Parameters.AddWithValue("username", employeeInsertSdi.Username);
command.Parameters.AddWithValue("password", employeeInsertSdi.Password);
command.Parameters.AddWithValue("salary", employeeInsertSdi.Salary);
command.Parameters.AddWithValue("roletype", employeeInsertSdi.RoleType);
command.ExecuteNonQuery();
con.Close();
return(this.getEmployeeById(employeeInsertSdi.EmployeeId1));
}
private void insertCustom_Click(object sender, EventArgs e)
{
if (!passwordTextBox.Text.Equals(retypePasswordTextBox.Text))
{
MessageBox.Show("retype password does not match", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (employeeService.isExistAccount(usernameTextBox.Text))
{
MessageBox.Show("username already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (employeeService.isExistSSN(ssnTextBox.Text))
{
MessageBox.Show("ssn already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (patronService.isExistAccount(usernameTextBox.Text))
{
MessageBox.Show("username already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
EmployeeInsertSdi employeeInsertSdi = new EmployeeInsertSdi();
employeeInsertSdi.EmployeeId1 = employeeIdTextBox.Text;
employeeInsertSdi.Fname = fnameTextBox.Text;
employeeInsertSdi.Lname = lnameTextBox.Text;
employeeInsertSdi.Mname = mnameTextBox.Text;
employeeInsertSdi.DOB1 = dobTextBox.Value.ToString();
employeeInsertSdi.PhoneNumber = phoneNumberTextBox.Text;
employeeInsertSdi.Username = usernameTextBox.Text;
employeeInsertSdi.Address = addressTextBox.Text;
employeeInsertSdi.Password = passwordTextBox.Text;
employeeInsertSdi.RoleType = roleTypeTextBox.Text;
employeeInsertSdi.SSN1 = ssnTextBox.Text;
employeeInsertSdi.Salary = Convert.ToDouble(salaryTextBox.Text);
Employee employee = employeeService.insertEmployee(employeeInsertSdi);
if (employee != null)
{
this.Close();
employeeForm.addDataToTable(employee);
}
}
}
public Employee insertEmployee(EmployeeInsertSdi employeeInsertSdi)
{
return(employeeRepoService.insertEmployee(employeeInsertSdi));
}