/// <summary> /// Retrieve all data from Customers table. Used to fill combo box. /// </summary> /// <returns>List of Customers</returns> public List <ModelNotifiedForCustomers> GetAll_Customers(out string error) { error = null; CustomersBsn bsn = new CustomersBsn(wpfConfig); List <CustomersInfo> dbItems = bsn.GetAll(); List <ModelNotifiedForCustomers> notifiedItems = new List <ModelNotifiedForCustomers>(); foreach (CustomersInfo dbItem in dbItems) { ModelNotifiedForCustomers itemToAdd = new ModelNotifiedForCustomers(); Cloner.CopyAllTo(typeof(CustomersInfo), dbItem, typeof(ModelNotifiedForCustomers), itemToAdd); notifiedItems.Add(itemToAdd); } return(notifiedItems); }
private List <ModelNotifiedForCustomerCustomerDemo> FilterGrid(string filterValue) { filterValue = filterValue.ToLower(); List <ModelNotifiedForCustomerCustomerDemo> filteredList = new List <ModelNotifiedForCustomerCustomerDemo>(); foreach (ModelNotifiedForCustomerCustomerDemo item in CustomerCustomerDemoDataContext.modelNotifiedForCustomerCustomerDemoMain) { if (item.CustomerID.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.CustomerTypeID.ToString().ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } if (item.CustomerTypeID != null) { if (item.CustomerTypeID.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } //Filter FK values. if (item.CustomerID != null) { ModelNotifiedForCustomers comboItem = CustomerCustomerDemoDataContext.modelNotifiedForCustomers.Where(x => x.CustomerID == item.CustomerID).FirstOrDefault(); if ((comboItem != null) && (comboItem.CompanyName != null) && (comboItem.CompanyName.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } if (item.CustomerTypeID != null) { ModelNotifiedForCustomerDemographics comboItem = CustomerCustomerDemoDataContext.modelNotifiedForCustomerDemographics.Where(x => x.CustomerTypeID == item.CustomerTypeID).FirstOrDefault(); if ((comboItem != null) && (comboItem.CustomerTypeID != null) && (comboItem.CustomerTypeID.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } } return(filteredList); }