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)); }