public List <ProductType> SearchingProductType(ProductTypeSearchCriteria productTypeSearchCriteria)
{
IQueryable <ProductType> query = null;
BaoHienDBDataContext context = BaoHienRepository.GetBaoHienDBDataContext();
if (context != null)
{
query = from pt in context.ProductTypes
where (pt.Status == null)
select pt;
}
if (productTypeSearchCriteria.ProductTypeCode != null)
{
query = query.Where(p => p.TypeCode.ToLower().Contains(productTypeSearchCriteria.ProductTypeCode));
}
if (productTypeSearchCriteria.ProductTypeName != null)
{
query = query.Where(p => p.TypeName.ToLower().Contains(productTypeSearchCriteria.ProductTypeName));
}
if (query != null)
{
return(query.ToList());
}
return(null);
}
private void searchProductType()
{
ProductTypeSearchCriteria producTypeSearchCriteria = new ProductTypeSearchCriteria
{
ProductTypeCode = string.IsNullOrEmpty(txtCode.Text) ? "" : txtCode.Text.ToLower(),
ProductTypeName = string.IsNullOrEmpty(txtName.Text) ? "" : txtName.Text.ToLower()
};
ProductTypeService producTypeService = new ProductTypeService();
List <ProductType> productTypes = producTypeService.SearchingProductType(producTypeSearchCriteria);
if (productTypes != null)
{
dgvProductTypeList.DataSource = productTypes;
lblTotalResult.Text = productTypes.Count.ToString();
}
}
