/// <summary> /// Retrieve all data from Orders table. Used to fill combo box. /// </summary> /// <returns>List of Orders</returns> public List <ModelNotifiedForOrders> GetAll_Orders(out string error) { error = null; OrdersBsn bsn = new OrdersBsn(wpfConfig); List <OrdersInfo> dbItems = bsn.GetAll(); List <ModelNotifiedForOrders> notifiedItems = new List <ModelNotifiedForOrders>(); foreach (OrdersInfo dbItem in dbItems) { ModelNotifiedForOrders itemToAdd = new ModelNotifiedForOrders(); Cloner.CopyAllTo(typeof(OrdersInfo), dbItem, typeof(ModelNotifiedForOrders), itemToAdd); notifiedItems.Add(itemToAdd); } return(notifiedItems); }
private List <ModelNotifiedForOrderDetails> FilterGrid(string filterValue) { filterValue = filterValue.ToLower(); List <ModelNotifiedForOrderDetails> filteredList = new List <ModelNotifiedForOrderDetails>(); foreach (ModelNotifiedForOrderDetails item in OrderDetailsDataContext.modelNotifiedForOrderDetailsMain) { if (item.OrderID.ToString().ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } if (item.ProductID.ToString().ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } //Filter FK values. if (item.OrderID != null) { ModelNotifiedForOrders comboItem = OrderDetailsDataContext.modelNotifiedForOrders.Where(x => x.OrderID == item.OrderID).FirstOrDefault(); if ((comboItem != null) && (comboItem.ShipName != null) && (comboItem.ShipName.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } if (item.ProductID != null) { ModelNotifiedForProducts comboItem = OrderDetailsDataContext.modelNotifiedForProducts.Where(x => x.ProductID == item.ProductID).FirstOrDefault(); if ((comboItem != null) && (comboItem.ProductName != null) && (comboItem.ProductName.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } } return(filteredList); }