protected void RadGridFabricCode_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridDataItem)
            {
                var item = e.Item as GridDataItem;

                if (item.ItemIndex > -1 && item.DataItem is FabricCodeDetailsViewBO)
                {
                    FabricCodeDetailsViewBO objFabricCode = (FabricCodeDetailsViewBO)item.DataItem;

                    HtmlAnchor linkEdit = (HtmlAnchor)item.FindControl("linkEdit");
                    linkEdit.Attributes.Add("qid", objFabricCode.Fabric.ToString());

                    HtmlAnchor linkDelete = (HtmlAnchor)item.FindControl("linkDelete");
                    linkDelete.Attributes.Add("qid", objFabricCode.Fabric.ToString());
                    linkDelete.Visible = (objFabricCode.IsCostSheetWherethisFabricCode == true ||
                                          objFabricCode.IsPatternSupportFabricWherethisFabricCode == true ||
                                          objFabricCode.IsPriceWherethisFabricCode == true ||
                                          objFabricCode.IsQuoteWherethisFabricCode == true ||
                                          objFabricCode.IsVisualLayoutWherethisFabricCode == true) ? false : true;

                    HtmlAnchor linkBreakDown = (HtmlAnchor)item.FindControl("linkBreakDown");
                    linkBreakDown.HRef = "AddEditFabricCode.aspx?id=" + objFabricCode.Fabric; //.Add("qid", objFabricCode.Fabric.ToString());

                    linkBreakDown.Visible = !(objFabricCode.IsPure ?? false);                 // int.Parse(this.ddlFilterFabricType.SelectedValue) == 0;
                    linkEdit.Visible      = (objFabricCode.IsPure ?? false);                  // int.Parse(this.ddlFilterFabricType.SelectedValue) == 1;
                }
            }
        }
        private void PopulateDataGrid()
        {
            // Hide Controls
            this.dvEmptyContent.Visible   = false;
            this.dvDataContent.Visible    = false;
            this.dvNoSearchResult.Visible = false;

            // Search text
            string searchText = this.txtSearch.Text.ToLower().Trim();

            // Populate Item Attribute
            FabricCodeDetailsViewBO objFabricCode = new FabricCodeDetailsViewBO();

            if (this.QueryType == 0) // combined
            {
                objFabricCode.IsPure         = false;
                objFabricCode.IsLiningFabric = false;

                btnNewPureFabric.Visible     = false;
                btnNewCombinedFabric.Visible = true;

                this.RadGridFabricCode.MasterTableView.GetColumn("IsLining").Display    = false;
                this.RadGridFabricCode.MasterTableView.GetColumn("Supplier").Display    = false;
                this.RadGridFabricCode.MasterTableView.GetColumn("Country").Display     = false;
                this.RadGridFabricCode.MasterTableView.GetColumn("GSM").Display         = false;
                this.RadGridFabricCode.MasterTableView.GetColumn("FabricPrice").Display = false;
                this.RadGridFabricCode.MasterTableView.GetColumn("FabricWidth").Display = false;
                this.RadGridFabricCode.MasterTableView.GetColumn("Unit").Display        = false;
            }
            else if (this.QueryType == 1) // pure
            {
                objFabricCode.IsPure         = true;
                btnNewPureFabric.Visible     = true;
                btnNewCombinedFabric.Visible = false;

                this.RadGridFabricCode.MasterTableView.GetColumn("IsLining").Display    = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("Supplier").Display    = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("Country").Display     = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("GSM").Display         = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("FabricPrice").Display = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("FabricWidth").Display = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("Unit").Display        = true;
            }
            else // All
            {
                btnNewPureFabric.Visible     = true;
                btnNewCombinedFabric.Visible = true;

                this.RadGridFabricCode.MasterTableView.GetColumn("IsLining").Display    = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("Supplier").Display    = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("Country").Display     = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("GSM").Display         = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("FabricPrice").Display = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("FabricWidth").Display = true;
                this.RadGridFabricCode.MasterTableView.GetColumn("Unit").Display        = true;
            }

            // Sort by condition
            List <FabricCodeDetailsViewBO> lstFabricCode = new List <FabricCodeDetailsViewBO>();

            if ((searchText != string.Empty) && (searchText != "search"))
            {
                lstFabricCode = (from o in objFabricCode.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList()
                                 where (
                                     (o.Code.ToLower().Contains(searchText)) ||
                                     (o.Name.ToLower().Contains(searchText)) ||
                                     (o.Country.Contains(searchText)) ||
                                     (o.Supplier.ToLower().Contains(searchText)) ||
                                     (o.NickName.ToLower().Contains(searchText))
                                     )
                                 select o).ToList();
            }
            else
            {
                lstFabricCode = objFabricCode.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList <FabricCodeDetailsViewBO>();
            }

            if (lstFabricCode.Count > 0)
            {
                this.RadGridFabricCode.AllowPaging = (lstFabricCode.Count > this.RadGridFabricCode.PageSize);
                this.RadGridFabricCode.DataSource  = lstFabricCode;
                this.RadGridFabricCode.DataBind();
                Session["FabricCodeDetails"] = lstFabricCode;

                this.dvDataContent.Visible = true;
            }
            else if ((searchText != string.Empty && searchText != "search"))
            {
                this.lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty);

                this.dvDataContent.Visible    = true;
                this.dvNoSearchResult.Visible = true;
            }
            else
            {
                this.dvEmptyContent.Visible = true;
            }

            this.RadGridFabricCode.Visible = (lstFabricCode.Count > 0);
        }