public static IQueryable<vw_item> GetData(DALPortalDataContext portalDc, ItemFilter itemFilter) { var predicate = PredicateExtensions.True<vw_item>(); if (!String.IsNullOrEmpty(itemFilter.size)) predicate = predicate.And(c => c.size.Equals(itemFilter.size)); if (!String.IsNullOrEmpty(itemFilter.companyName)) predicate = predicate.And(c => c.companyName.Equals(itemFilter.companyName)); if (!String.IsNullOrEmpty(itemFilter.description)) predicate = predicate.And(c => c.description.Equals(itemFilter.description)); if (!String.IsNullOrEmpty(itemFilter.itemGroupName)) predicate = predicate.And(c => c.itemGroupName.Equals(itemFilter.itemGroupName)); // if (!String.IsNullOrEmpty(itemFilter.outsideDiameter1)) predicate = predicate.And(c => c.outsideDiameter1.Equals(itemFilter.outsideDiameter1)); if (!String.IsNullOrEmpty(itemFilter.treatmentHeat)) predicate = predicate.And(c => c.treatmentHeat.Equals(itemFilter.treatmentHeat)); if (!String.IsNullOrEmpty(itemFilter.outsideDiameter2)) predicate = predicate.And(c => c.outsideDiameter2.Equals(itemFilter.outsideDiameter2)); if (!String.IsNullOrEmpty(itemFilter.treatmentSurface)) predicate = predicate.And(c => c.treatmentSurface.Equals(itemFilter.treatmentSurface)); if (!String.IsNullOrEmpty(itemFilter.outsideDiameter3)) predicate = predicate.And(c => c.outsideDiameter3.Equals(itemFilter.outsideDiameter3)); if (!String.IsNullOrEmpty(itemFilter.ends)) predicate = predicate.And(c => c.ends.Equals(itemFilter.ends)); if (!String.IsNullOrEmpty(itemFilter.wallThickness1)) predicate = predicate.And(c => c.wallThickness1.Equals(itemFilter.wallThickness1)); if (!String.IsNullOrEmpty(itemFilter.cdi)) predicate = predicate.And(c => c.cdi.Equals(itemFilter.cdi)); if (!String.IsNullOrEmpty(itemFilter.wallThickness2)) predicate = predicate.And(c => c.wallThickness2.Equals(itemFilter.wallThickness2)); if (!String.IsNullOrEmpty(itemFilter.supplier)) predicate = predicate.And(c => c.supplier.Equals(itemFilter.supplier)); if (!String.IsNullOrEmpty(itemFilter.type)) predicate = predicate.And(c => c.type.Equals(itemFilter.type)); if (!String.IsNullOrEmpty(itemFilter.other)) predicate = predicate.And(c => c.other.Equals(itemFilter.other)); if (!String.IsNullOrEmpty(itemFilter.specification)) predicate = predicate.And(c => c.specification.Equals(itemFilter.specification)); if (!String.IsNullOrEmpty(itemFilter.certificates)) predicate = predicate.And(c => c.certificates.Equals(itemFilter.certificates)); if (!String.IsNullOrEmpty(itemFilter.length)) predicate = predicate.And(c => c.length.Equals(itemFilter.length)); return portalDc.vw_items.Where(predicate); }
public static IQueryable <vw_item> GetData(DALPortalDataContext portalDc, ItemFilter itemFilter) { var predicate = PredicateExtensions.True <vw_item>(); if (!String.IsNullOrEmpty(itemFilter.size)) { predicate = predicate.And(c => c.size.Equals(itemFilter.size)); } if (!String.IsNullOrEmpty(itemFilter.companyName)) { predicate = predicate.And(c => c.companyName.Equals(itemFilter.companyName)); } if (!String.IsNullOrEmpty(itemFilter.description)) { predicate = predicate.And(c => c.description.Equals(itemFilter.description)); } if (!String.IsNullOrEmpty(itemFilter.itemGroupName)) { predicate = predicate.And(c => c.itemGroupName.Equals(itemFilter.itemGroupName)); } // if (!String.IsNullOrEmpty(itemFilter.outsideDiameter1)) { predicate = predicate.And(c => c.outsideDiameter1.Equals(itemFilter.outsideDiameter1)); } if (!String.IsNullOrEmpty(itemFilter.treatmentHeat)) { predicate = predicate.And(c => c.treatmentHeat.Equals(itemFilter.treatmentHeat)); } if (!String.IsNullOrEmpty(itemFilter.outsideDiameter2)) { predicate = predicate.And(c => c.outsideDiameter2.Equals(itemFilter.outsideDiameter2)); } if (!String.IsNullOrEmpty(itemFilter.treatmentSurface)) { predicate = predicate.And(c => c.treatmentSurface.Equals(itemFilter.treatmentSurface)); } if (!String.IsNullOrEmpty(itemFilter.outsideDiameter3)) { predicate = predicate.And(c => c.outsideDiameter3.Equals(itemFilter.outsideDiameter3)); } if (!String.IsNullOrEmpty(itemFilter.ends)) { predicate = predicate.And(c => c.ends.Equals(itemFilter.ends)); } if (!String.IsNullOrEmpty(itemFilter.wallThickness1)) { predicate = predicate.And(c => c.wallThickness1.Equals(itemFilter.wallThickness1)); } if (!String.IsNullOrEmpty(itemFilter.cdi)) { predicate = predicate.And(c => c.cdi.Equals(itemFilter.cdi)); } if (!String.IsNullOrEmpty(itemFilter.wallThickness2)) { predicate = predicate.And(c => c.wallThickness2.Equals(itemFilter.wallThickness2)); } if (!String.IsNullOrEmpty(itemFilter.supplier)) { predicate = predicate.And(c => c.supplier.Equals(itemFilter.supplier)); } if (!String.IsNullOrEmpty(itemFilter.type)) { predicate = predicate.And(c => c.type.Equals(itemFilter.type)); } if (!String.IsNullOrEmpty(itemFilter.other)) { predicate = predicate.And(c => c.other.Equals(itemFilter.other)); } if (!String.IsNullOrEmpty(itemFilter.specification)) { predicate = predicate.And(c => c.specification.Equals(itemFilter.specification)); } if (!String.IsNullOrEmpty(itemFilter.certificates)) { predicate = predicate.And(c => c.certificates.Equals(itemFilter.certificates)); } if (!String.IsNullOrEmpty(itemFilter.length)) { predicate = predicate.And(c => c.length.Equals(itemFilter.length)); } return(portalDc.vw_items.Where(predicate)); }