private void bindGrid() { Collection <ProductCL> products = productBLL.getAllProducts(); Collection <newProductCL> prod = ConvertProductToGrid(products); if (prod.Count() > 0) { GvProductMangmt.DataSource = prod; GvProductMangmt.DataBind(); } else { DataTable dt = new DataTable(); ShowNoResultFound(prod, GvProductMangmt); } }
protected void btnSearch_Click(object sender, EventArgs e) { Collection <ProductCL> grd = productBLL.getAllProducts(); Collection <newProductCL> newProdgrd = ConvertProductToGrid(grd); var xyz = newProdgrd.Where(x => x.id >= 0); if (txtFeature1.Text == string.Empty && txtStkQty.Text == string.Empty && txtPrice.Text == string.Empty && txtName.Text == string.Empty && txtFeature2.Text == string.Empty && txtFeature3.Text == string.Empty && txtFeature4.Text == string.Empty && txtWeight.Text == string.Empty && txtKeywords.Text == string.Empty && ddlCodApplicable.SelectedValue == "0" && txtDispatchTime.Text == string.Empty && txtWarranty.Text == string.Empty && txtShippingCharge.Text == string.Empty) { if (newProdgrd.Count > 0) { GvProductMangmt.DataSource = newProdgrd; GvProductMangmt.DataBind(); } else { DataTable dt = new DataTable(); ShowNoResultFound(newProdgrd, GvProductMangmt); } } else { if (txtName.Text != string.Empty) { xyz = xyz.Where(x => x.productName.ToLower().Contains(txtName.Text.ToLower())); } if (txtPrice.Text != string.Empty) { xyz = from x in xyz where x.productPrice.Contains(txtPrice.Text) select x; } if (txtStkQty.Text != string.Empty) { xyz = from x in xyz where x.stockQuantity.Contains(txtStkQty.Text) select x; } if (txtFeature1.Text != string.Empty) { xyz = from x in xyz where x.feature1.ToLower().Contains(txtFeature1.Text.ToLower()) select x; } if (txtFeature2.Text != string.Empty) { xyz = from x in xyz where x.feature2.ToLower().Contains(txtFeature2.Text.ToLower()) select x; } if (txtFeature3.Text != string.Empty) { xyz = from x in xyz where x.feature3.ToLower().Contains(txtFeature3.Text.ToLower()) select x; } if (txtFeature4.Text != string.Empty) { xyz = from x in xyz where x.feature4.ToLower().Contains(txtFeature4.Text.ToLower()) select x; } if (txtKeywords.Text != string.Empty) { xyz = from x in xyz where x.keywords.ToLower().Contains(txtKeywords.Text.ToLower()) select x; } if (txtWeight.Text != string.Empty) { xyz = from x in xyz where x.weight.Contains(txtWeight.Text) select x; } if (ddlCodApplicable.SelectedValue != "0") { xyz = from x in xyz where x.codApplicable == ddlCodApplicable.Text select x; } if (txtDispatchTime.Text != string.Empty) { xyz = from x in xyz where x.dispatchTime == txtDispatchTime.Text select x; } if (txtShippingCharge.Text != string.Empty) { xyz = from x in xyz where x.shippingCharge.Contains(txtShippingCharge.Text) select x; } if (txtWarranty.Text != string.Empty) { xyz = from x in xyz where x.warranty.Contains(txtWarranty.Text) select x; } Collection <newProductCL> xyzUpdate = new Collection <newProductCL>(); foreach (newProductCL item in xyz) { xyzUpdate.Add(new newProductCL { codApplicable = item.codApplicable, dateCreated = item.dateCreated, dateModified = item.dateModified, description = item.description, dispatchTime = item.dispatchTime, feature1 = item.feature1, feature2 = item.feature2, feature3 = item.feature3, feature4 = item.feature4, id = item.id, imageUrl = item.imageUrl, isDeleted = item.isDeleted, isHot = item.isHot, keywords = item.keywords, productName = item.productName, productPrice = item.productPrice, shippingCharge = item.shippingCharge, stockQuantity = item.stockQuantity, warranty = item.warranty, weight = item.weight, }); } if (xyzUpdate.Count() > 0) { GvProductMangmt.DataSource = xyzUpdate; GvProductMangmt.DataBind(); } else { DataTable dt = new DataTable(); ShowNoResultFound(xyzUpdate, GvProductMangmt); } } }