protected void grdScheduleTasks_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (e.SortExpression == "Insert")
     {
         Server.Transfer("ScheduleTask.aspx");
     }
 }

 protected void gv_Sorting(object sender, GridViewSortEventArgs e)
 {
     GridView gv = (GridView)sender;
     IEnumerable<ticket> sortedGroup;
     if (gv.ID.Equals("gvMy")) sortedGroup = myTickets;
     else sortedGroup = groupTickets;
     if (Session[e.SortExpression] == null || Session[e.SortExpression].ToString().Equals("+"))
     {
         Session[e.SortExpression] = "-";
         switch (e.SortExpression)
         {
             case "priority": sortedGroup = sortedGroup.OrderBy(p => p.priority1.level); break;
             case "title": sortedGroup = sortedGroup.OrderBy(p => p.title); break;
             case "submitted": sortedGroup = sortedGroup.OrderBy(p => p.submitted); break;
             case "status": sortedGroup = sortedGroup.OrderBy(p => p.statuse.status_order); break;
             default: break;
         }
     }
     else
     {
         Session[e.SortExpression] = "+";
         switch (e.SortExpression)
         {
             case "priority": sortedGroup = sortedGroup.OrderByDescending(p => p.priority1.level); break;
             case "title": sortedGroup = sortedGroup.OrderByDescending(p => p.title); break;
             case "submitted": sortedGroup = sortedGroup.OrderByDescending(p => p.submitted); break;
             case "status": sortedGroup = sortedGroup.OrderByDescending(p => p.statuse.status_order); break;
             default: break;
         }
     }
     
     gv.DataSource = sortedGroup;
     gv.DataBind();
 }

 protected void grdCustomers_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (e.SortExpression == "Insert")
     {
         Response.Redirect("Customer.aspx");
     }
 }

 protected void GridViewQuotation_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (!string.IsNullOrEmpty(txtCountry.Text))
     {
       SqlDataSourceQuot.SelectCommand = "SELECT vw_Quotation.Quotation_Version_Id, vw_Quotation.Quotation_No, vw_Quotation.Vername,vw_Quotation.Quotation_Status_Name, vw_Quotation.code, vw_Quotation.companyname, vw_Quotation.Product_Name, vw_Quotation.Model_No, vw_Quotation.username, vw_Quotation.Quotation_OpenDate, vw_Quotation.Client_Id, vw_Quotation.fname, vw_Quotation.SalesId , quotation_country FROM vw_Quotation LEFT OUTER JOIN m_employee_accesslevel ON vw_Quotation.Access_Level_ID = m_employee_accesslevel.accesslevel_id WHERE ((m_employee_accesslevel.employee_id = @employee_id) OR (vw_Quotation.Access_Level_ID IS NULL)) AND Client_Id like @Client_Id AND SalesId like @SalesId AND ([Product_Name] LIKE '%' + @Product_Name + '%') AND ([Model_No] LIKE '%' + @Model_No + '%') AND vw_Quotation.Quotation_Version_Id in (Select quotation_id from Quotation_Target,Country Where Quotation_Target.country_id = dbo.country.country_id and country_name like '%' + @quotation_country + '%') ORDER BY vw_Quotation.Quotation_No DESC, vw_Quotation.Vername, vw_Quotation.Model_No ";
     }
 }

 protected void gvCatalogo_Sorting(object sender, GridViewSortEventArgs e)
 {
     string sortExpression = "";
     if (ViewState["sortexpression"] != null)
     {
         sortExpression = ViewState["sortexpression"].ToString();
     }
     ViewState["sortexpression"] = e.SortExpression;
     if (sortExpression != ViewState["sortexpression"].ToString())
     {
         ViewState["sortdirection"] = "asc";
     }
     else
     {
         if (ViewState["sortdirection"] == null)
         {
             ViewState["sortdirection"] = "asc";
         }
         else
         {
             if (ViewState["sortdirection"].ToString() == "asc")
             {
                 ViewState["sortdirection"] = "desc";
             }
             else
             {
                 ViewState["sortdirection"] = "asc";
             }
         }
     }
     gvCatalogo.PageIndex = 0;
     CargarGrid();
 }

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        DataTable dataTable = GridView1.DataSource as DataTable;
        string sortExpression = e.SortExpression;
        string direction = string.Empty;

        if (dataTable != null)
        {
            DataView dataView = new DataView(dataTable);

            if (SortDirection == SortDirection.Descending)
            {
                SortDirection = SortDirection.Ascending;
                direction = " ASC";
            }
            else
            {
                SortDirection = SortDirection.Descending;
                direction = " DESC";
            }

            DataTable table = GridView1.DataSource as DataTable;
            table.DefaultView.Sort = sortExpression + direction;

            GridView1.DataSource = table;
            GridView1.DataBind();

        }
    }

 protected void departmentsGrid_Sorting(object sender, GridViewSortEventArgs e)
 {
     // Retrieve the name of the clicked column (sort expression)
     string sortExpression = e.SortExpression;
     // Decide and save the new sort direction
     if (sortExpression == gridSortExpression)
     {
         if(gridSortDirection == SortDirection.Ascending)
         {
             gridSortDirection = SortDirection.Descending;
         }
         else
         {
             gridSortDirection = SortDirection.Ascending;
         }
     }
     else
     {
         gridSortDirection = SortDirection.Ascending;
     }
     // Save the new sort expression
     gridSortExpression = sortExpression;
     // Rebind the grid to its data source
     BindGrid();
 }

    protected void grdContainers_Sorting(object sender, GridViewSortEventArgs e)
    {
        try
        {
            if (sortingColumn != null && sortingColumn.Equals(e.SortExpression))    // if the list is already sorted by this column,
            {                                                                       // toggle ascending/descending
                sortAscending = !sortAscending;
            }
            else                                                                    // else, set new column and set sorting to ascending
            {
                sortingColumn = e.SortExpression;
                sortAscending = true; // set false because default is ascending
            }

            ViewState["sortingColumn"] = sortingColumn;
            ViewState["sortAscending"] = sortAscending;

            updateGridView();
        }
        catch (System.Threading.ThreadAbortException) { }
        catch (Exception ex)
        {
            LogError.logError(ex);
            Response.Redirect("../errorpages/error.aspx");
        }
    }

 public void GridViewSort(object sender, GridViewSortEventArgs e)
 {
     string sortExpression = e.SortExpression;
     if ((this.ViewState["SortOrder"] != null) && (this.ViewState["OrderDire"] != null))
     {
         if (this.ViewState["SortOrder"].ToString() == sortExpression)
         {
             if (this.ViewState["OrderDire"].ToString() == "Desc")
             {
                 this.ViewState["OrderDire"] = "ASC";
             }
             else
             {
                 this.ViewState["OrderDire"] = "Desc";
             }
         }
         else
         {
             this.ViewState["SortOrder"] = e.SortExpression;
             this.ViewState["OrderDire"] = "ASC";
         }
     }
     else
     {
         this.ViewState["SortOrder"] = e.SortExpression;
         this.ViewState["OrderDire"] = "ASC";
     }
 }

 protected void grdCustomerFollowupAction_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (e.SortExpression == "Insert")
     {
         Server.Transfer("CustomerFollowupAction.aspx");
     }
 }

 protected void grdPaymentMethod_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (e.SortExpression == "Insert")
     {
         Server.Transfer("PaymentMethod.aspx");
     }
 }

 protected void gvNominees_Sorting(object sender, GridViewSortEventArgs e)
 {
     SortDirection =
             (SortDirection == SortDirection.Ascending) ? SortDirection.Descending : SortDirection.Ascending;
     SortColumn = e.SortExpression;
     LoadNominees();
 }

 protected void grdRepresentants_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (e.SortExpression == "Insert")
     {
         Server.Transfer("Representant.aspx");
     }
 }

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        //var teste = from Tabela in Contexto.TB_DESENVOLVEDOR
        //            orderby Tabela.ID_DESENVOLVEDOR descending
        //            select Tabela;

        switch (e.SortExpression)
        {
            case "ID_DESENVOLVEDOR":
                {
                    if (((SortDirection)ViewState["TIPO_ORDENACAO"]) == SortDirection.Ascending)
                    {
                        ViewState["TIPO_ORDENACAO"] = SortDirection.Descending;
                        GridView1.DataSource = Contexto.TB_DESENVOLVEDOR.OrderBy(x => x.ID_DESENVOLVEDOR);
                    }
                    else
                    {
                        ViewState["TIPO_ORDENACAO"] = SortDirection.Ascending;
                        GridView1.DataSource = Contexto.TB_DESENVOLVEDOR.OrderByDescending(x => x.ID_DESENVOLVEDOR);
                    }

                    break;
                }

            case "NM_DESENVOLVEDOR":
                {
                    if (((SortDirection)ViewState["TIPO_ORDENACAO"]) == SortDirection.Ascending)
                    {
                        ViewState["TIPO_ORDENACAO"] = SortDirection.Descending;
                        GridView1.DataSource = Contexto.TB_DESENVOLVEDOR.OrderBy(x => x.NM_DESENVOLVEDOR);
                    }
                    else
                    {
                        ViewState["TIPO_ORDENACAO"] = SortDirection.Ascending;
                        GridView1.DataSource = Contexto.TB_DESENVOLVEDOR.OrderByDescending(x => x.NM_DESENVOLVEDOR);
                    }

                    break;
                }

            case "NR_IDADE":
                {
                    if (((SortDirection)ViewState["TIPO_ORDENACAO"]) == SortDirection.Ascending)
                    {
                        ViewState["TIPO_ORDENACAO"] = SortDirection.Descending;
                        GridView1.DataSource = Contexto.TB_DESENVOLVEDOR.OrderBy(x => x.NR_IDADE);
                    }
                    else
                    {
                        ViewState["TIPO_ORDENACAO"] = SortDirection.Ascending;
                        GridView1.DataSource = Contexto.TB_DESENVOLVEDOR.OrderByDescending(x => x.NR_IDADE);
                    }

                    break;
                }
        }

        GridView1.DataBind();
    }

 protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
 {
     DataSet ds = getData();
     DataView dataView = new DataView(ds.Tables[0]);
     dataView.Sort = e.SortExpression;
     GridView1.DataSource = dataView;
     GridView1.DataBind();
 }

 protected void gvReparaciones_Sorting(object sender, GridViewSortEventArgs e)
 {
     //if (e.SortExpression == "vehiculo.dominio") { ViewState["OrdenGvReparaciones"] = "dominio"; }
     //else if (e.SortExpression == "vehiculo.cliente.nombreCompleto") { ViewState["OrdenGvReparaciones"] = "apellido"; }
     //else if (e.SortExpression == "estadoReparacion.nombreEstado") { ViewState["OrdenGvReparaciones"] = "nombreEstado"; }
     //else if (e.SortExpression == "total") { ViewState["OrdenGvReparaciones"] = "totalMO"; }
     ViewState["OrdenGvReparaciones"] = e.SortExpression;
     cargarGrilla();
 }

    protected void sorting(object sender, GridViewSortEventArgs e)
    {
        ISession session = DatabaseEntities.NHibernateHelper.CreateSessionFactory().OpenSession();
        ICriteria criteria = session.CreateCriteria(typeof(DatabaseEntities.User))
                                        .Add(Restrictions.Eq("CurrentCommittee", committee.ID))
                                        .AddOrder(new Order(e.SortExpression.ToString(), true));

        GridViewUsers.DataSource = criteria.List<DatabaseEntities.User>();
        GridViewUsers.DataBind();
    }

 protected void gvFacturas_Sorting(object sender, GridViewSortEventArgs e)
 {
     if (ViewState["dt"] != null)
     {
         DataTable dt = (DataTable)ViewState["dt"];
         dt.DefaultView.Sort = e.SortExpression + " " + cambiarSortDirection();
         gvFacturas.DataSource = dt;
         gvFacturas.DataBind();
     }
 }

    /// <summary>
    /// This event is used to sort the contents of the grid
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    public static void GridSort(HtmlInputHidden txthdnSortOrder, GridViewSortEventArgs e, GridView grdReport, int formName, object objCollection)
    {
        string strSortDir = null;

        try
        {
            //storing the value in hidden variable
            if (txthdnSortOrder.Value.Length == 0)
            {
                txthdnSortOrder.Value = e.SortDirection.ToString();
            }

            //To reverse the sort order
            if (txthdnSortOrder.Value.Length != 0)
            {
                if (txthdnSortOrder.Value == "Ascending")
                {
                    txthdnSortOrder.Value = "Descending";
                }
                else
                {
                    txthdnSortOrder.Value = "Ascending";
                }
            }

            //checking the condition and sorting accordingly
            switch (txthdnSortOrder.Value)
            {
                case "Ascending":
                    strSortDir = "ASC";
                    break;

                case "Descending":
                    strSortDir = "DESC";
                    break;
            }

            //Appending arrow symbol to the grid header according to the sorting.
            GridSorting.AppendSortOrderImageToGridHeader(txthdnSortOrder.Value, e.SortExpression, ref grdReport);
            GridSortingEx(formName, strSortDir, e.SortExpression, ref grdReport, objCollection);

            //Add data to the GridView
            //GridSorting.MakeAccessible(grdReport);
        }
        catch (Exception ex)
        {
            //bool rethrow = ExceptionPolicy.HandleException(ex, ARSConstants.StrPerDatumUIPolicy);

            //if (rethrow)
            //    throw;

            ////Redirecting to error message page
            //HttpContext.Current.Server.Transfer(ARSConstants.StrErrorPageURL);
        }
    }

    protected void adminGrid_Sorting(object sender, GridViewSortEventArgs e)
    {
        SortDirection sortDirection = SortDirection.Ascending;
        string sortField = string.Empty;

        SortGridview((GridView)sender, e, out sortDirection, out sortField);
        string strSortDirection = sortDirection == SortDirection.Ascending ? "ASC" : "DESC";

        adminGrid.DataSource = UserDataAccessLayer.GetAllUsers(e.SortExpression + " " + strSortDirection);
        adminGrid.DataBind();
    }