private List <ModelNotifiedForEmployeeTerritories> FilterGrid(string filterValue)
{
filterValue = filterValue.ToLower();
List <ModelNotifiedForEmployeeTerritories> filteredList = new List <ModelNotifiedForEmployeeTerritories>();
foreach (ModelNotifiedForEmployeeTerritories item in EmployeeTerritoriesDataContext.modelNotifiedForEmployeeTerritoriesMain)
{
if (item.EmployeeID.ToString().ToLower().Contains(filterValue))
{
filteredList.Add(item);
continue;
}
if (item.TerritoryID.ToString().ToLower().Contains(filterValue))
{
filteredList.Add(item);
continue;
}
//Filter string values.
if (item.TerritoryID != null)
{
if (item.TerritoryID.ToLower().Contains(filterValue))
{
filteredList.Add(item);
continue;
}
}
//Filter FK values.
if (item.EmployeeID != null)
{
ModelNotifiedForEmployees comboItem = EmployeeTerritoriesDataContext.modelNotifiedForEmployees.Where(x => x.EmployeeID == item.EmployeeID).FirstOrDefault();
if ((comboItem != null) && (comboItem.LastName != null) && (comboItem.LastName.ToLower().Contains(filterValue)))
{
filteredList.Add(item);
continue;
}
}
if (item.TerritoryID != null)
{
ModelNotifiedForTerritories comboItem = EmployeeTerritoriesDataContext.modelNotifiedForTerritories.Where(x => x.TerritoryID == item.TerritoryID).FirstOrDefault();
if ((comboItem != null) && (comboItem.TerritoryDescription != null) && (comboItem.TerritoryDescription.ToLower().Contains(filterValue)))
{
filteredList.Add(item);
continue;
}
}
}
return(filteredList);
}
/// <summary>
/// Retrieve all data from Territories table. Used to fill combo box.
/// </summary>
/// <returns>List of Territories</returns>
public List <ModelNotifiedForTerritories> GetAll_Territories(out string error)
{
error = null;
TerritoriesBsn bsn = new TerritoriesBsn(wpfConfig);
List <TerritoriesInfo> dbItems = bsn.GetAll();
List <ModelNotifiedForTerritories> notifiedItems = new List <ModelNotifiedForTerritories>();
foreach (TerritoriesInfo dbItem in dbItems)
{
ModelNotifiedForTerritories itemToAdd = new ModelNotifiedForTerritories();
Cloner.CopyAllTo(typeof(TerritoriesInfo), dbItem, typeof(ModelNotifiedForTerritories), itemToAdd);
notifiedItems.Add(itemToAdd);
}
return(notifiedItems);
}