/// <summary> /// Retrieve all data from CustomerDemographics table. Used to fill combo box. /// </summary> /// <returns>List of CustomerDemographics</returns> public List <ModelNotifiedForCustomerDemographics> GetAll_CustomerDemographics(out string error) { error = null; CustomerDemographicsBsn bsn = new CustomerDemographicsBsn(wpfConfig); List <CustomerDemographicsInfo> dbItems = bsn.GetAll(); List <ModelNotifiedForCustomerDemographics> notifiedItems = new List <ModelNotifiedForCustomerDemographics>(); foreach (CustomerDemographicsInfo dbItem in dbItems) { ModelNotifiedForCustomerDemographics itemToAdd = new ModelNotifiedForCustomerDemographics(); Cloner.CopyAllTo(typeof(CustomerDemographicsInfo), dbItem, typeof(ModelNotifiedForCustomerDemographics), 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); }