/// <summary> /// Retrieve all data from Shippers table. Used to fill combo box. /// </summary> /// <returns>List of Shippers</returns> public List <ModelNotifiedForShippers> GetAll_Shippers(out string error) { error = null; ShippersBsn bsn = new ShippersBsn(wpfConfig); List <ShippersInfo> dbItems = bsn.GetAll(); List <ModelNotifiedForShippers> notifiedItems = new List <ModelNotifiedForShippers>(); foreach (ShippersInfo dbItem in dbItems) { ModelNotifiedForShippers itemToAdd = new ModelNotifiedForShippers(); Cloner.CopyAllTo(typeof(ShippersInfo), dbItem, typeof(ModelNotifiedForShippers), itemToAdd); notifiedItems.Add(itemToAdd); } return(notifiedItems); }
private List <ModelNotifiedForOrders> FilterGrid(string filterValue) { filterValue = filterValue.ToLower(); List <ModelNotifiedForOrders> filteredList = new List <ModelNotifiedForOrders>(); foreach (ModelNotifiedForOrders item in OrdersDataContext.modelNotifiedForOrdersMain) { if (item.OrderID.ToString().ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } //Filter string values. if (item.CustomerID != null) { if (item.CustomerID.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.ShipName != null) { if (item.ShipName.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.ShipAddress != null) { if (item.ShipAddress.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.ShipCity != null) { if (item.ShipCity.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.ShipRegion != null) { if (item.ShipRegion.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.ShipPostalCode != null) { if (item.ShipPostalCode.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.ShipCountry != null) { if (item.ShipCountry.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } //Filter FK values. if (item.CustomerID != null) { ModelNotifiedForCustomers comboItem = OrdersDataContext.modelNotifiedForCustomers.Where(x => x.CustomerID == item.CustomerID).FirstOrDefault(); if ((comboItem != null) && (comboItem.ContactName != null) && (comboItem.ContactName.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } if (item.EmployeeID != null) { ModelNotifiedForEmployees comboItem = OrdersDataContext.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.ShipVia != null) { ModelNotifiedForShippers comboItem = OrdersDataContext.modelNotifiedForShippers.Where(x => x.ShipperID == item.ShipVia).FirstOrDefault(); if ((comboItem != null) && (comboItem.CompanyName != null) && (comboItem.CompanyName.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } } return(filteredList); }