private System.Web.UI.WebControls.SortDirection GetSortDirection(string column) { // By default, set the sort direction to ascending. System.Web.UI.WebControls.SortDirection sortDirection = System.Web.UI.WebControls.SortDirection.Ascending; // Retrieve the last column that was sorted. string sortExpression = ViewState["SortExpression"] as string; if (sortExpression != null) { if (sortExpression == column) { System.Web.UI.WebControls.SortDirection lastDirection = (System.Web.UI.WebControls.SortDirection)ViewState["SortDirection"]; if (lastDirection == System.Web.UI.WebControls.SortDirection.Ascending) { sortDirection = System.Web.UI.WebControls.SortDirection.Descending; } } } // Save new values in ViewState. ViewState["SortDirection"] = sortDirection; ViewState["SortExpression"] = column; return(sortDirection); }
private void CarregarTela(string SortExpression) { if (IsPostBack) { ExtratoComponenteBLL CredReeBLL = new ExtratoComponenteBLL(); int iRepresentante = 0; int.TryParse(ddlRepresentante.SelectedValue, out iRepresentante); //var dadosGrid = CredReeBLL.Listar(int.Parse(txtCodEmpresa.Text), int.Parse(txtCodMatricula.Text), iRepresentante, " ", DateTime.Parse(txtDtIni.Text), DateTime.Parse(txtDtFim.Text)); var dadosGrid = CredReeBLL.Listar(int.Parse(txtCodEmpresa.Text), int.Parse(txtCodMatricula.Text), iRepresentante, "00", short.Parse(ddlSemestre.SelectedValue), int.Parse(ddlNumAno.SelectedValue.ToString())); DataTable dt1 = dadosGrid; DataTable tblOrdered = new DataTable(); DataView view = new DataView(); var vsSort = ViewState["SortDirection"]; if (String.IsNullOrEmpty(SortExpression)) { grdExtratoUtilizacao.DataSource = dt1; grdExtratoUtilizacao.DataBind(); return; } if (dt1.Rows.Count > 0) { if (vsSort == null) { ViewState["SortDirection"] = System.Web.UI.WebControls.SortDirection.Descending; } System.Web.UI.WebControls.SortDirection lastDirection = (System.Web.UI.WebControls.SortDirection)ViewState["SortDirection"]; if (lastDirection != System.Web.UI.WebControls.SortDirection.Ascending) { EnumerableRowCollection <DataRow> query = from row in dt1.AsEnumerable() orderby DateTime.Parse(row.Field <string>(SortExpression)) descending select row; tblOrdered = query.AsDataView().ToTable(); ViewState["SortDirection"] = System.Web.UI.WebControls.SortDirection.Ascending; } else { EnumerableRowCollection <DataRow> query = from row in dt1.AsEnumerable() orderby DateTime.Parse(row.Field <string>(SortExpression)) ascending select row; tblOrdered = query.AsDataView().ToTable(); ViewState["SortDirection"] = System.Web.UI.WebControls.SortDirection.Descending; } grdExtratoUtilizacao.DataSource = tblOrdered; grdExtratoUtilizacao.DataBind(); } } }
protected void gvContact_Sorting(object sender, GridViewSortEventArgs e) { int clientID = Core.SessionHelper.getClientId(); IQueryable <CRM.Data.Entities.Contact> contacts = null; contacts = ContactManager.GetAll(clientID); bool descending = false; if (ViewState[e.SortExpression] == null) { descending = false; } else { descending = !(bool)ViewState[e.SortExpression]; } ViewState[e.SortExpression] = descending; //gvContact.DataSource = contacts.orderByExtension(e.SortExpression, descending); System.Web.UI.WebControls.SortDirection sortDirection = descending ? System.Web.UI.WebControls.SortDirection.Descending : System.Web.UI.WebControls.SortDirection.Ascending; gvContact.DataSource = contacts.orderByNested(e.SortExpression, sortDirection); gvContact.DataBind(); }
protected void GVMRFAgingForOpenPositionReport_Sorting(object sender, GridViewSortEventArgs e) { try { // GridViewRow gvrPager = GVResourcesOnboard.BottomPagerRow; // TextBox txtPages = (TextBox)gvrPager.Cells[0].FindControl("txtPages"); // txtPages.Text = Session[SessionNames.CURRENT_PAGE_INDEX_EMP].ToString(); //On sorting assign new sort expression sortExpression = e.SortExpression; if (Session[SessionNames.PREVIOUS_SORT_EXPRESSION_EMP] == null) { Session[SessionNames.PREVIOUS_SORT_EXPRESSION_EMP] = sortExpression; } if (Session[SessionNames.PREVIOUS_SORT_EXPRESSION_EMP].ToString() == sortExpression) { //Sort to opposite direction based upon previous sort direction if (Session[SessionNames.SORT_DIRECTION_EMP] == null || GridViewSortDirection == System.Web.UI.WebControls.SortDirection.Descending) { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Ascending; SortGridView(sortExpression, ASCENDING); } else { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Descending; SortGridView(sortExpression, DESCENDING); } } else { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Ascending; SortGridView(sortExpression, ASCENDING); } if (Session[SessionNames.EMP_PROJECTID] != null || Session[SessionNames.EMP_DEPARTMENTID] != null || Session[SessionNames.EMP_ROLE] != null || Session[SessionNames.EMP_STATUSID] != null || Session[SessionNames.EMP_NAME] != null) { //Change here 26 March 2015 //btnRemoveFilter.Visible = true; } //Set current sort expression as PreviousSortExpression Session[SessionNames.PREVIOUS_SORT_EXPRESSION_EMP] = sortExpression; } //catches RaveHRException exception catch (RaveHRException ex) { LogErrorMessage(ex); } catch (Exception ex) { RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "gvListOfMrf_RowCreated", EventIDConstants.RAVE_HR_MRF_PRESENTATION_LAYER); LogErrorMessage(objEx); } }
protected void dgvDatos_PageIndexChanging(object sender, GridViewPageEventArgs e) { Site1 oMaster = (Site1)this.Master; System.Web.UI.WebControls.SortDirection oDireccion = (System.Web.UI.WebControls.SortDirection)ViewState["direccionsorting"]; var result = (IQueryable<MedDAL.DAL.tipos>)Session["resultadoquery"]; DataTable dt = MedNeg.Utilidades.DataSetLinqOperators.CopyToDataTable(result); DataView dv = new DataView(dt); dgvDatos.DataSource = oMaster.Paging(e, ViewState["sortexpression"] == null ? "Nombre" : ViewState["sortexpression"].ToString(), dv, ref dgvDatos, ref oDireccion); ViewState["direccionsorting"] = oDireccion; dgvDatos.DataBind(); }
protected void grvInvFsArticulos_PageIndexChanging(object sender, GridViewPageEventArgs e) { Site1 oMaster = (Site1)this.Master; System.Web.UI.WebControls.SortDirection oDireccion = (System.Web.UI.WebControls.SortDirection)ViewState["direccionsorting"]; var result = (IQueryable <MedNeg.Inventarios.Producto>)Session["resultadoquery2"]; DataTable dt = MedNeg.Utilidades.DataSetLinqOperators.CopyToDataTable(result); DataView dv = new DataView(dt); grvInvFsArticulos.DataSource = oMaster.Paging(e, "codigo", dv, ref grvInvFsArticulos, ref oDireccion); ViewState["direccionsorting"] = oDireccion; grvInvFsArticulos.DataBind(); }
private void BindSearchResultsPanel() { Trace.Write(this.GetType().ToString(), "Begin Bind Search Results"); if (_contentNodes.Count > 0) { //SORT THE CATEGORIES ACCORDINGLY string sortExpression = SortResults.SelectedValue; if (!string.IsNullOrEmpty(sortExpression)) { string[] sortTokens = sortExpression.Split(" ".ToCharArray()); System.Web.UI.WebControls.SortDirection dir = (sortTokens[1] == "ASC" ? System.Web.UI.WebControls.SortDirection.Ascending : System.Web.UI.WebControls.SortDirection.Descending); switch (sortTokens[0]) { case "Featured": _contentNodes.Sort(new FeaturedComparer(dir)); break; case "Price": _contentNodes.Sort(new PriceComparer(dir)); break; case "Name": _contentNodes.Sort(new NameComparer(dir)); break; case "Manufacturer": _contentNodes.Sort(new ManufacturerComparer(dir)); break; } } phCategoryContents.Visible = true; //INITIALIZE PAGING VARIABLES InitializePagingVars(false); //BIND THE RESULT PANE BindResultHeader(); //BIND THE PAGING CONTROLS FOOTER BindPagingControls(); } else { ResultIndexMessage.Text = string.Format(ResultIndexMessage.Text, 0, 0, 0); //HIDE THE CONTENTS phCategoryContents.Visible = false; phEmptyCategory.Visible = (_category != null && _category.CatalogNodes.Count == 0); phNoSearchResults.Visible = !phEmptyCategory.Visible; } //UPDATE AJAX PANEL SearchResultsAjaxPanel.Update(); Trace.Write(this.GetType().ToString(), "End Bind Search Results"); }
protected void gdvLista_Sorting(object sender, GridViewSortEventArgs e) { Site1 oMaster = (Site1)this.Master; System.Web.UI.WebControls.SortDirection oDireccion = (System.Web.UI.WebControls.SortDirection)ViewState["direccionsorting"]; var result = (IQueryable <MedDAL.Proveedores.ProveedoresView>)Session["resultadoquery"]; DataTable dt = MedNeg.Utilidades.DataSetLinqOperators.CopyToDataTable(result); DataView dv = new DataView(dt); gdvLista.DataSource = oMaster.Sorting(e, ref oDireccion, dv); ViewState["direccionsorting"] = oDireccion; ViewState["sortexpression"] = e.SortExpression; gdvLista.DataBind(); }
protected void grdSearchResults_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; if (GridViewSortDirection == System.Web.UI.WebControls.SortDirection.Ascending) { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Descending; SortGridView(sortExpression, DESCENDING); } else { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Ascending; SortGridView(sortExpression, ASCENDING); } }
protected void gvSearchResult_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; ViewState["z_sortexpresion"] = e.SortExpression; if (GridViewSortDirection == System.Web.UI.WebControls.SortDirection.Ascending) { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Descending; SortGridView(sortExpression, "DESC"); } else { GridViewSortDirection = System.Web.UI.WebControls.SortDirection.Ascending; SortGridView(sortExpression, "ASC"); } }
private string ConvertSortDirectionToSql(System.Web.UI.WebControls.SortDirection sortDirection) { string newSortDirection = String.Empty; switch (sortDirection) { case System.Web.UI.WebControls.SortDirection.Ascending: newSortDirection = "ASC"; break; case System.Web.UI.WebControls.SortDirection.Descending: newSortDirection = "DESC"; break; } return(newSortDirection); }
protected void SortRecords(object sender, GridViewSortEventArgs e) { var sortExpression = e.SortExpression; string direction; if (SortDirection == SortDirection.Ascending) { SortDirection = SortDirection.Descending; direction = "descending"; } else { SortDirection = SortDirection.Ascending; direction = "ascending"; } var administrators = Administrator.FindAll().Sort(ref sortExpression, ref direction, "ManagerName").ToList(); Administrators.DataSource = administrators; Administrators.DataBind(); }
public DataView Sorting(GridViewSortEventArgs e, ref System.Web.UI.WebControls.SortDirection oDireccion, DataView dv) { string sSortExpression = e.SortExpression; ViewState["sortexpression"] = e.SortExpression; if (oDireccion == System.Web.UI.WebControls.SortDirection.Ascending) { //e.SortDirection = System.Web.UI.WebControls.SortDirection.Descending; dv.Sort = sSortExpression + DESCENDING; oDireccion = System.Web.UI.WebControls.SortDirection.Descending; } else { //e.SortDirection = System.Web.UI.WebControls.SortDirection.Ascending; dv.Sort = sSortExpression + ASCENDING; oDireccion = System.Web.UI.WebControls.SortDirection.Ascending; } return(dv); }
public FeaturedComparer(System.Web.UI.WebControls.SortDirection sortDirection) { _sortDirection = sortDirection; }
public ManufacturerComparer(System.Web.UI.WebControls.SortDirection sortDirection) { _SortDirection = sortDirection; }
public PriceComparer(System.Web.UI.WebControls.SortDirection sortDirection) { _SortDirection = sortDirection; }
/// <summary> /// Gets resources on which user is having read permission. /// </summary> /// <param name="token">Authentication Token</param> /// <param name="fetchedRecords">Records fetched</param> /// <param name="pageSize">Page size</param> /// <param name="totalRecords">Total record count</param> /// <param name="sortExpression">Column to sort on</param> /// <param name="sortDirection">Direction to sort in</param> /// <returns>List of Entities</returns> private IList <Resource> GetEntityList(AuthenticatedToken token, int fetchedRecords, int pageSize, out int totalRecords, string sortExpression, System.Web.UI.WebControls.SortDirection sortDirection) { using (ResourceDataAccess dataAccess = new ResourceDataAccess(base.CreateContext())) { if (sortDirection == System.Web.UI.WebControls.SortDirection.Ascending) { return(dataAccess.SearchForResources(token, SearchCriteria, fetchedRecords, pageSize, out totalRecords, sortExpression, Zentity.Platform.SortDirection.Ascending, IsSecurityAwareControl).ToList()); } else { return(dataAccess.SearchForResources(token, SearchCriteria, fetchedRecords, pageSize, out totalRecords, sortExpression, Zentity.Platform.SortDirection.Descending, IsSecurityAwareControl).ToList()); } } }
public DataView Paging(GridViewPageEventArgs e, string sExpresionSort, DataView dv, ref GridView gdvDatos, ref System.Web.UI.WebControls.SortDirection oDireccion) { int iPagina = e.NewPageIndex; gdvDatos.PageIndex = iPagina; if (oDireccion == System.Web.UI.WebControls.SortDirection.Ascending) { dv.Sort = sExpresionSort + ASCENDING; } else { dv.Sort = sExpresionSort + DESCENDING; } return(dv); }