Filtering is not working on Telerik:Radgrid control

Question

Hi i am using telerik radgrid. I am adding DataSource and Rebinding it in code behind in cs file.

Problem is filtering is not working on radgrid.

Any help will be much appreciated.

Thanks

Here is a c# code for this file.

 protected void Page_Load(object sender, EventArgs e)
{
    try
    {
        shopId = new Guid(Session["shopId"].ToString());
    }
    catch (Exception)
    {
        Response.Redirect("~/Shop/Shop_list.aspx");
    }
    // checking while filtering 

    if (StartDate.SelectedDate == null)
    {
        StartDate.SelectedDate = DateTime.Now.Date.AddDays(-14);
    }
    if (FinishDate.SelectedDate == null)
    {
        FinishDate.SelectedDate = DateTime.Now.Date;
    }
    if (!IsPostBack)
    {

        FilterShopOrderData();
    }
}


private void FilterShopOrderData()
{
    IObjectScope scope = ORM.ScopeFactory.GetPerRequestScope(HttpContext.Current);
    DateTime stdate = DateTime.Parse(StartDate.SelectedDate.ToString());
    DateTime endate = DateTime.Parse(FinishDate.SelectedDate.ToString());
    DateTime startOfDay = new DateTime(stdate.Year, stdate.Month, stdate.Day, 00, 00, 00);
    DateTime endOfDay = new DateTime(endate.Year, endate.Month, endate.Day, 23, 59, 59);


    //Rebind RadGrid Of session.
    List shopOrders = null;

    if (CheckBoxShowOrderStatus.Checked == true)
    {
        shopOrders = (from shopOrder in scope.Extent()
                      where shopOrder.ShopId == shopId && shopOrder.ShoporderStatus.IsComplete == !CheckBoxShowOrderStatus.Checked &&
                            shopOrder.CreateDateTime.Date >= startOfDay && shopOrder.CreateDateTime.Date <= endOfDay 
                            && shopOrder.IsDeleted == false 
                            && (shopOrder.IsReceiptSent == true || shopOrder.IsReceiptSkipped == true || shopOrder.IsPDFSent == true)
                      orderby shopOrder.CreateDateTime descending
                      select shopOrder).ToList();

        SubjectHeadingLabel.Text = DAL.DataClasses.Shop.GetShopNameById(shopId) + ": Incomplete Orders";
    }
    else
    {
        shopOrders = (from shopOrder in scope.Extent()
                      where shopOrder.ShopId == shopId &&
                            shopOrder.CreateDateTime.Date >= startOfDay && shopOrder.CreateDateTime.Date <= endOfDay 
                            && shopOrder.IsDeleted == false 
                            && (shopOrder.IsReceiptSent == true || shopOrder.IsReceiptSkipped == true || shopOrder.IsPDFSent == true)
                      orderby shopOrder.CreateDateTime descending
                      select shopOrder).ToList();

        SubjectHeadingLabel.Text = DAL.DataClasses.Shop.GetShopNameById(shopId) + ": All Orders";
    }

    ShopOrderRadGrid.DataSource = shopOrders;
    //ShopOrderRadGrid.DataBind();
    ShopOrderRadGrid.Rebind();
}

protected void ShopOrderRedGridRadGrid_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
    GridDataItem dataItem = e.Item as GridDataItem;

    if (e.CommandName == RadGrid.EditCommandName)
    {
        //Get the PK of the item.
        Guid shopOrderId = new Guid();
        shopOrderId = (Guid)dataItem.GetDataKeyValue("ShopOrderId");
        //store PK in session
        Session["shopOrderId"] = shopOrderId.ToString();
        //redirect to the Order mod page.
        Response.Redirect("~/Shop/Order/Order_mod.aspx");
    }

    if (e.CommandName == RadGrid.InitInsertCommandName)
    {
        //Get the PK of the item.
        //clear the session
        Session["shopOrderId"] = null;
        //redirect to the Order mod page.
        Response.Redirect("~/Shop/Order/Order_mod.aspx");
    }

    //For Delete
    if (e.CommandName == "Delete")
    {
        Guid shopOrderId = Guid.Empty;

        shopOrderId = (Guid)dataItem.GetDataKeyValue("ShopOrderId");
        IObjectScope scope = ORM.ScopeFactory.GetPerRequestScope(HttpContext.Current);

        scope.Transaction.Begin();
        ORM.Shoporder shopOrder = DAL.DataClasses.ShopOrder.GetObjectById(shopOrderId);
        shopOrder.IsDeleted = true;
        scope.Transaction.Commit();
        //ShopOrderRadGrid.Rebind();
        FilterShopOrderData();
    }

    if (e.CommandName == "FilterRadGrid")
    {
        FilterShopOrderData();
    }
}

protected void ShopOrderRedGridRadGrid__onItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem item = e.Item as GridDataItem;
        Guid shopOrderId = new Guid();
        ImageButton button = item["DeleteColumn"].Controls[0] as ImageButton;
        button.Attributes["onclick"] = "return confirm('Are you sure you want to delete this order? Deleted orders can be restored from Recycle Bin.')";
        shopOrderId = new Guid(item.GetDataKeyValue("ShopOrderId").ToString());

        ORM.Shoporder thisShopOrder = DAL.DataClasses.ShopOrder.GetObjectById(shopOrderId);

        Label NameLabel = (Label)e.Item.FindControl("NameLabel");
        NameLabel.Text = thisShopOrder.CustomerFirstname + " " + thisShopOrder.CustomerLastname;

        ORM.Site thisSite = DAL.DataClasses.Company.GetDefaultSite(thisShopOrder.Shop.CompanyId);

        Button PrintButton = (Button)item.FindControl("PrintButton");
        PrintButton.OnClientClick = "openNewWindow('" + DAL.DataClasses.ShopOrder.GetOrderReceiptURL(shopOrderId) + "'); return false;";

        Label OrderTypeLabel = (Label)e.Item.FindControl("OrderTypeLabel");
        OrderTypeLabel.Text = "Physical Products";

        if (thisShopOrder.IsEmailDelivery)
        {
            OrderTypeLabel.Text = "E-Products";
        }
        if (thisShopOrder.Shopdeliverymethod.IsPhysicalDelivery == true && thisShopOrder.IsEmailDelivery)
        {
            OrderTypeLabel.Text = "Physical & E-Products";
        }
    }
}

protected void ShopOrderRadGrid_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
    // ShopOrderRadGrid.Rebind();
    FilterShopOrderData();
}

Filtering is not working on Telerik:Radgrid control

Answers (1)

Apply filter in the code-behind.

note :

Related Questions