private void search_Click(object sender, EventArgs e)
{
EmployeeSearchSdi employeeSearch = new EmployeeSearchSdi();
if ("".Equals(employeeIdTextBox.Text.Trim()))
{
employeeSearch.EmployeeId1 = null;
}
else
{
employeeSearch.EmployeeId1 = employeeIdTextBox.Text.Trim();
}
if ("".Equals(fnameTextBox.Text.Trim()))
{
employeeSearch.Fname = null;
}
else
{
employeeSearch.Fname = fnameTextBox.Text.Trim();
}
if ("".Equals(mnameTextBox.Text.Trim()))
{
employeeSearch.Mname = null;
}
else
{
employeeSearch.Mname = mnameTextBox.Text.Trim();
}
if ("".Equals(lnameTextBox.Text.Trim()))
{
employeeSearch.Lname = null;
}
else
{
employeeSearch.Lname = lnameTextBox.Text.Trim();
}
if ("".Equals(phoneNumberTextBox.Text.Trim()))
{
employeeSearch.PhoneNumber = null;
}
else
{
employeeSearch.PhoneNumber = phoneNumberTextBox.Text.Trim();
}
if ("".Equals(usernameTextBox.Text.Trim()))
{
employeeSearch.Username = null;
}
else
{
employeeSearch.Username = usernameTextBox.Text.Trim();
}
if ("".Equals(addressTextBox.Text.Trim()))
{
employeeSearch.Address = null;
}
else
{
employeeSearch.Address = addressTextBox.Text.Trim();
}
if ("".Equals(ssnTextBox.Text.Trim()))
{
employeeSearch.SSN1 = null;
}
else
{
employeeSearch.Address = ssnTextBox.Text.Trim();
}
if ("".Equals(roleTypeTextBox.Text.Trim()))
{
employeeSearch.RoleType = null;
}
else
{
employeeSearch.RoleType = roleTypeTextBox.Text.Trim();
}
List <Employee> employees = employeeService.searchEmployees(employeeSearch);
EmployeeSearchResult employeeSearchResult = new EmployeeSearchResult();
employeeSearchResult.Employees = employees;
employeeSearchResult.ShowDialog();
}
public List <Employee> searchEmployees(EmployeeSearchSdi employeeSearchSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
List <Employee> employees = new List <Employee>();
StringBuilder sql = new StringBuilder();
Dictionary <String, Object> param = new Dictionary <String, Object>();
sql.Append("select emplID," +
" ssn," +
" CONCAT(fName,' ',mName,' ',lName) as name," +
" DOB," +
" salary," +
" roletype," +
" phoneNumber," +
" Address from Employee");
sql.Append(" where 1 = 1 ");
if (employeeSearchSdi.EmployeeId1 != null && !"".Equals(employeeSearchSdi.EmployeeId1))
{
sql.Append(" and libraryCardNumber = @librarycardnumber ");
param.Add("librarycardnumber", employeeSearchSdi.EmployeeId1);
}
if (employeeSearchSdi.Fname != null && !"".Equals(employeeSearchSdi.Fname))
{
sql.Append(" and fName = @fname ");
param.Add("fname", employeeSearchSdi.Fname);
}
if (employeeSearchSdi.Lname != null && !"".Equals(employeeSearchSdi.Lname))
{
sql.Append(" and lName = @lname ");
param.Add("lname", employeeSearchSdi.Lname);
}
if (employeeSearchSdi.Mname != null && !"".Equals(employeeSearchSdi.Mname))
{
sql.Append(" and mName = @mname ");
param.Add("mname", employeeSearchSdi.Mname);
}
if (employeeSearchSdi.Address != null && !"".Equals(employeeSearchSdi.Address))
{
sql.Append(" and Address = @address ");
param.Add("address", employeeSearchSdi.Address);
}
if (employeeSearchSdi.PhoneNumber != null && !"".Equals(employeeSearchSdi.PhoneNumber))
{
sql.Append(" and phoneNumber = @phonenumber ");
param.Add("phonenumber", employeeSearchSdi.PhoneNumber);
}
if (employeeSearchSdi.Username != null && !"".Equals(employeeSearchSdi.Username))
{
sql.Append(" and Pusername = @username ");
param.Add("username", employeeSearchSdi.Username);
}
if (employeeSearchSdi.SSN1 != null && !"".Equals(employeeSearchSdi.SSN1))
{
sql.Append(" and ssn = @ssn ");
param.Add("ssn", employeeSearchSdi.SSN1);
}
if (employeeSearchSdi.RoleType != null && !"".Equals(employeeSearchSdi.RoleType))
{
sql.Append(" and roletype = @roletype ");
param.Add("roletype", employeeSearchSdi.RoleType);
}
SqlCommand command = new SqlCommand(sql.ToString(), con);
foreach (KeyValuePair <String, Object> item in param)
{
command.Parameters.AddWithValue(item.Key, item.Value);
}
SqlDataReader data = command.ExecuteReader();
while (data.Read())
{
Employee employee = new Employee();
employee.EmployeeId1 = data.GetString(0);
employee.SSN1 = data.GetString(1);
employee.Name = data.GetString(2);
employee.DOB1 = data.GetDateTime(3);
employee.Salary = data.GetSqlMoney(4).ToDouble();
employee.RoleType = data.GetString(5);
employee.PhoneNumber = data.GetString(6);
employee.Address = data.GetString(7);
employees.Add(employee);
}
data.Close();
con.Close();
return(employees);
}
public List <Employee> searchEmployees(EmployeeSearchSdi employeeSearchSdi)
{
return(employeeRepoService.searchEmployees(employeeSearchSdi));
}
