private async void EmpNameSearch(string name)
{
try
{
string columns = "a_employee_number,a_name_last,a_name_first,a_org_primary,a_object_primary,a_location_primary,a_location_p_desc,a_location_p_short";
string query = "SELECT TOP " + maxResults + " " + columns + " FROM pr_employee_master";
var searchParams = new QueryParamCollection();
searchParams.Add("a_name_last", name.ToUpper(), false, "OR");
searchParams.Add("a_name_first", name.ToUpper(), false, "OR");
SetWorking(true);
var comms = new MunisComms();
using (var cmd = comms.GetSqlCommandFromParams(query, searchParams.Parameters))
using (var results = await comms.ReturnSqlTableFromCmdAsync(cmd))
{
if (results.Rows.Count > 0)
{
MunisResults.DataSource = null;
MunisResults.DataSource = results;
MunisResults.ClearSelection();
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
SetWorking(false);
}
}
/// <summary>
/// Pull a complete list of employees from the database.
/// </summary>
/// <returns></returns>
private async Task <List <Employee> > GetEmployeeList()
{
MunisComms comms = new MunisComms();
string query = "SELECT a_employee_number,a_name_last,a_name_first,e_supervisor FROM pr_employee_master";
var tmpList = new List <Employee>();
using (var results = await comms.ReturnSqlTableAsync(query))
{
foreach (DataRow row in results.Rows)
{
var firstName = row["a_name_first"].ToString().Trim();
var lastName = row["a_name_last"].ToString().Trim();
var empNumber = row["a_employee_number"].ToString().Trim();
var supId = row["e_supervisor"].ToString().Trim();
tmpList.Add(new Employee(firstName + " " + lastName, empNumber, supId));
}
}
return(tmpList);
}
