public FindEmployeesForMaterialsDataSet FindEmployeesForMaterials(string strLastName)
{
try
{
aFindEmployeesForMaterialsDataSet = new FindEmployeesForMaterialsDataSet();
aFindEmployeesForMaterialsTableAdapter = new FindEmployeesForMaterialsDataSetTableAdapters.FindEmployeesForMaterialsTableAdapter();
aFindEmployeesForMaterialsTableAdapter.Fill(aFindEmployeesForMaterialsDataSet.FindEmployeesForMaterials, strLastName);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Class // Find Employees For Materials " + Ex.Message);
}
return(aFindEmployeesForMaterialsDataSet);
}
private void txtEnterLastName_TextChanged(object sender, TextChangedEventArgs e)
{
string strLastName;
int intNumberOfRecords;
int intCounter;
//getting the last name
strLastName = txtEnterLastName.Text;
cboSelectEmployee.Items.Clear();
if (strLastName == "")
{
TheMessagesClass.ErrorMessage("Employee Name Was Not Entered");
return;
}
//loading the combo box
cboSelectEmployee.Items.Add("Select Employee");
//getting the data set
TheFindEmployeesForMaterialsDataSet = TheEmployeeClass.FindEmployeesForMaterials(strLastName);
//getting the records count
intNumberOfRecords = TheFindEmployeesForMaterialsDataSet.FindEmployeesForMaterials.Rows.Count - 1;
if (intNumberOfRecords == -1)
{
TheMessagesClass.InformationMessage("Employee Not Found");
return;
}
//loop
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheFindEmployeesForMaterialsDataSet.FindEmployeesForMaterials[intCounter].FullName);
}
cboSelectEmployee.SelectedIndex = 0;
}
