protected void Grid_Sort(object sender, GridSortCommandEventArgs e) { GridSortExpression sortExpr = new GridSortExpression(); switch (e.OldSortOrder) { case GridSortOrder.None: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Ascending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = RadGrid1.MasterTableView.AllowNaturalSort ? GridSortOrder.None : GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Descending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; } e.Canceled = true; RadGrid1.Rebind(); }
protected void rgdInvoices_SortCommand(object sender, GridSortCommandEventArgs e) { //Apply custom sorting var sortExpr = new GridSortExpression(); switch (e.OldSortOrder) { case GridSortOrder.None: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Ascending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = rgdInvoices.MasterTableView.AllowNaturalSort ? GridSortOrder.None : GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Descending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; } e.Canceled = true; rgdInvoices.Rebind(); }
/// <summary> /// grdFoo_NeedDataSource handler /// </summary> protected void grdFoo_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { try // try to handle grdFoo_OnNeedDataSource { string orderBy = "Name"; string orderDirection = "ASC"; if (grdFoo.MasterTableView != null && grdFoo.MasterTableView.SortExpressions.Count > 0) { GridSortExpression expression = grdFoo.MasterTableView.SortExpressions[0]; orderBy = expression.FieldName; // define order by options { orderDirection = expression.SortOrder == GridSortOrder.Descending ? "DESC" : "ASC"; } } int totalCount = -1, start = grdFoo.CurrentPageIndex * grdFoo.PageSize; grdFoo.DataSource = UnitOfWork.Foos.GetAllView(start, grdFoo.PageSize, orderBy, orderDirection, out totalCount); { grdFoo.VirtualItemCount = totalCount; // bind total count } } catch (Exception ex) // catch exceptions { Exceptions.ProcessModuleLoadException(this, ex); } }
protected void RadGrid1_SortCommand(object sender, Telerik.Web.UI.GridSortCommandEventArgs e) { GridTableView tableView = e.Item.OwnerTableView; e.Canceled = true; GridSortExpression expression = new GridSortExpression(); expression.FieldName = "Customer"; if (tableView.SortExpressions.Count == 0 || tableView.SortExpressions[0].FieldName != "Customer") { expression.SortOrder = GridSortOrder.Descending; } else if (tableView.SortExpressions[0].SortOrder == GridSortOrder.Descending) { expression.SortOrder = GridSortOrder.Ascending; } else if (tableView.SortExpressions[0].SortOrder == GridSortOrder.Ascending) { expression.SortOrder = GridSortOrder.None; } tableView.SortExpressions.AddSortExpression(expression); tableView.Rebind(); LoadDataForRadGrid1(); RadGrid1.DataBind(); }
protected void RGGoodsOrder_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { var pageIndex = RGGoodsOrder.CurrentPageIndex + 1; var pageSize = RGGoodsOrder.PageSize; int totalCount = 0; IList <GoodsOrderInfo> goodsOrderList = new List <GoodsOrderInfo>(); var authWarehouseList = WMSSao.GetWarehouseAuthDic(CurrentSession.Personnel.Get().PersonnelId); if (authWarehouseList != null && authWarehouseList.WarehouseDics != null && authWarehouseList.WarehouseDics.Count > 0) { var authWarehouseIds = authWarehouseList.WarehouseDics.Select(act => act.Key).ToList(); goodsOrderList = _goodsOrder.GetOrderList(authWarehouseIds, StartTime, EndTime, SearchGoods, SearchKey, new List <OrderState> { OrderState.RequirePurchase }, pageIndex, pageSize, out totalCount); } else { RAM.Alert("当前登录人没有授权仓库!"); } TextBoxDate.Text = CountRepeat(goodsOrderList); var expression = new GridSortExpression { FieldName = "OrderTime", SortOrder = GridSortOrder.Ascending }; RGGoodsOrder.MasterTableView.SortExpressions.AddSortExpression(expression); RGGoodsOrder.DataSource = goodsOrderList; RGGoodsOrder.VirtualItemCount = totalCount; if (goodsOrderList.Count > 0) { DicOrderClew = _operationLogManager.GetOperationLogList(goodsOrderList.Select(act => act.OrderId).ToList()); } }
protected void SalesForecastSummariesRadGrid_SortCommand(object source, GridSortCommandEventArgs e) { e.Canceled = true; GridSortExpression expression = new GridSortExpression(); expression.FieldName = e.SortExpression; if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions.Count == 0 || SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].FieldName != e.SortExpression) { expression.SortOrder = GridSortOrder.Descending; } else if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Descending) { expression.SortOrder = GridSortOrder.Ascending; } else if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Ascending) { expression.SortOrder = GridSortOrder.None; } else if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.None) { expression.SortOrder = GridSortOrder.Descending; } SalesForecastSummariesRadGrid.MasterTableView.SortExpressions.AddSortExpression(expression); SalesForecastSummariesRadGrid.MasterTableView.Rebind(); }
protected void QuoteLogRadGrid_SortCommand(object source, GridSortCommandEventArgs e) { e.Canceled = true; GridSortExpression expression = new GridSortExpression(); expression.FieldName = e.SortExpression; if (QuoteLogRadGrid.MasterTableView.SortExpressions.Count == 0 || QuoteLogRadGrid.MasterTableView.SortExpressions[0].FieldName != e.SortExpression) { expression.SortOrder = GridSortOrder.Descending; } else if (QuoteLogRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Descending) { expression.SortOrder = GridSortOrder.Ascending; } else if (QuoteLogRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Ascending) { expression.SortOrder = GridSortOrder.None; } else if (QuoteLogRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.None) { expression.SortOrder = GridSortOrder.Descending; } QuoteLogRadGrid.MasterTableView.SortExpressions.AddSortExpression(expression); string filter = FilterComboBox.SelectedValue; string filterValue; filterValue = (RadioButtonList1.SelectedValue == "0") ? lblSalesTitle.Text : lblVolumesTitle.Text; QuoteLogRadGrid.DataSource = PopulateQuoteLogGrid(filter, filterValue); QuoteLogRadGrid.DataBind(); }
private void AddExpression() { GridSortExpression expression2 = new GridSortExpression(); expression2.FieldName = "U_Nombre"; expression2.SetSortOrder("Ascending"); this.RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression2); }
protected void ContactsRadGrid_SortCommand(object source, GridSortCommandEventArgs e) { RememberSelected(); sortExpression = new GridSortExpression(); sortExpression.FieldName = e.SortExpression; sortExpression.SortOrder = e.NewSortOrder; RaiseBubbleEvent(this, new CommandEventArgs("LoadContacts", null)); }
// method for sorting behaviour; protected void onGridSort(object source, Telerik.Web.UI.GridSortCommandEventArgs e) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); }
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "User.Name"; expression.SortOrder = GridSortOrder.Ascending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } if (RadGrid2.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "Name"; expression.SortOrder = GridSortOrder.Ascending; RadGrid2.MasterTableView.SortExpressions.AddSortExpression(expression); } object personsList = ViewState[PersonList]; if (personsList == null || personsList is string) { var personsAndUsers = new List <PersonWithUser>(); foreach (Person person in PersonManager.GetAllPersons()) { BusiBlocks.Membership.User user = BusiBlocks.Membership.MembershipManager.GetUserByPerson(person); Site defaultSite = PersonManager.GetDefaultSiteByPerson(person); if (defaultSite == null) { defaultSite = new Site(); } personsAndUsers.Add(new PersonWithUser { Person = person, User = user, PrimarySite = defaultSite }); } RadGrid1.DataSource = personsAndUsers; } else if (personsList is IList <string> ) { var personIdList = personsList as IList <string>; var personList = new List <PersonWithUser>(); foreach (string personId in personIdList) { Person person = PersonManager.GetPersonById(personId); BusiBlocks.Membership.User user = BusiBlocks.Membership.MembershipManager.GetUserByPerson(person); Site defaultSite = PersonManager.GetDefaultSiteByPerson(person); if (defaultSite == null) { defaultSite = new Site(); } personList.Add(new PersonWithUser { Person = person, User = user, PrimarySite = defaultSite }); } RadGrid1.DataSource = personList; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "percentage"; expression.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } }
protected void GridView1_SortCommand(object sender, GridSortCommandEventArgs e) { if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); } }
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DataSet dstemp = Peerfx_DB.SPs.ViewPaymentsRequestedbyuser(currentuser.User_key).GetDataSet(); RadGrid1.DataSource = dstemp.Tables[0]; GridSortExpression expression = new GridSortExpression(); expression.FieldName = "date_created"; expression.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); }
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "User.Name"; expression.SortOrder = GridSortOrder.Ascending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } RadGrid1.DataSource = GetDataSource(); }
static void grdOrders_SortCommand(object source, Telerik.Web.UI.GridSortCommandEventArgs e) { if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) { GridSortExpression gridSortExpression = new GridSortExpression(); gridSortExpression.FieldName = e.SortExpression; gridSortExpression.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(gridSortExpression); } }
/// <summary> /// Handles the SortCommand event of the gvTasks control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Telerik.Web.UI.GridSortCommandEventArgs"/> instance containing the event data.</param> protected void gvTasks_SortCommand(object sender, Telerik.Web.UI.GridSortCommandEventArgs e) { if (e.SortExpression.Length > 0) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = e.NewSortOrder; gvTasks.MasterTableView.SortExpressions.AddSortExpression(sortExpr); e.Canceled = true; gvTasks.Rebind(); } }
protected void RadGrid1_SortCommand(object source, Telerik.Web.UI.GridSortCommandEventArgs e) { if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); e.Item.OwnerTableView.Rebind(); } }
public void OnContactsLoaded(List <Contact_V03> contacts, List <string> fieldsToHide) { if (IsListView()) { HideColumns(fieldsToHide); } if (null == contacts || contacts.Count == 0) { totalResults.Value = "0"; Session["MyContacts"] = null; Session["ListDelete"] = null; selectUpDiv.Style.Add("display", "none"); selectDownDiv.Style.Add("display", "none"); } else { Session["MyContacts"] = null; Session["MyContacts"] = contacts; totalResults.Value = contacts.Count.ToString(); selectUpDiv.Style.Add("display", "block"); selectDownDiv.Style.Add("display", "block"); if (sortExpression == null) { if (string.IsNullOrEmpty(SortField)) { sortExpression = new GridSortExpression(); sortExpression.FieldName = "Fullname"; sortExpression.SortOrder = GetSortOrderFromString(SortDirection);// GridSortOrder.Ascending; } else { sortExpression = new GridSortExpression(); sortExpression.FieldName = SortField; sortExpression.SortOrder = GetSortOrderFromString(SortDirection); } } Sort(contacts, sortExpression); } ContactsRadGrid.DataSource = contacts; List <Contact_V03> DeleteList = new List <Contact_V03>(); if (Session["ListDelete"] != null) { DeleteList = (List <Contact_V03>)Session["ListDelete"]; } totalSpan.InnerHtml = totalSpanBot.InnerHtml = totalResults.Value.Replace("-", ""); selectedResult.Value = DeleteList.Count.ToString(); selectedSpan.InnerHtml = selectedSpanBot.InnerHtml = selectedResult.Value.Replace("-", ""); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "FechaProgramada"; expression.SortOrder = GridSortOrder.Ascending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GridSortExpression gse = new GridSortExpression(); gse.SortOrder = GridSortOrder.Descending; gse.FieldName = "Id"; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(gse); } else { LoadData(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { RadGrid1.MasterTableView.SortExpressions.Clear(); GridSortExpression sortExpr1 = new GridSortExpression(); sortExpr1.FieldName = "CreateDate"; sortExpr1.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(sortExpr1); string strUserName = Request.QueryString["usn"]; if (!string.IsNullOrEmpty(strUserName)) ddlSearchUser.SelectedValue = strUserName; } }
protected void gvPricingPlans_SortCommand(object sender, GridSortCommandEventArgs e) { if (e.SortExpression.Length > 0) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = e.NewSortOrder; gvPricingPlans.MasterTableView.SortExpressions.Clear(); gvPricingPlans.MasterTableView.SortExpressions.AddSortExpression(sortExpr); e.Canceled = true; gvPricingPlans.Rebind(); } }
private void BindCurrentPage() { int pageSize = 20; // gvTradeBusinessDate.PageSize; var page = (DateTime.Now.DayOfYear / pageSize); //eg row 50 means page = 3 gvTradeBusinessDate.CurrentPageIndex = page; GridSortExpression expression = new GridSortExpression(); expression.FieldName = "WTBD_DayName"; expression.SortOrder = GridSortOrder.Ascending; gvTradeBusinessDate.MasterTableView.SortExpressions.AddSortExpression(expression); gvTradeBusinessDate.MasterTableView.Rebind(); }
/// <summary> /// Handles the SortCommand event of the rgProjectTeam control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Telerik.Web.UI.GridSortCommandEventArgs"/> instance containing the event data.</param> protected void rgProjectTeam_SortCommand(object sender, Telerik.Web.UI.GridSortCommandEventArgs e) { searchUsers.HideNotifications(); if (e.SortExpression.Length > 0) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = e.NewSortOrder; rgProjectTeam.MasterTableView.SortExpressions.Clear(); rgProjectTeam.MasterTableView.SortExpressions.AddSortExpression(sortExpr); e.Canceled = true; rgProjectTeam.Rebind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { RadGrid1.MasterTableView.SortExpressions.Clear(); GridSortExpression sortExpr1 = new GridSortExpression(); sortExpr1.FieldName = "CreateDate"; sortExpr1.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(sortExpr1); string strUserName = Request.QueryString["usn"]; if (!string.IsNullOrEmpty(strUserName)) { ddlSearchUser.SelectedValue = strUserName; } } }
private void Sort(List <Contact_V03> contacts, GridSortExpression gridSortExpression) { int sortOrder = 0; if (gridSortExpression.SortOrder == GridSortOrder.Ascending) { sortOrder = 1; } if (gridSortExpression.SortOrder == GridSortOrder.Descending) { sortOrder = -1; } if (contacts != null) { contacts.Sort((a, b) => sortOrder * sort(a, b, gridSortExpression.FieldName)); } }
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { BusiBlocksTreeView categories = NewsManager.GetCategoriesItemsTree(Page.User.Identity.Name); object itemList = ViewState[ItemList]; if (itemList != null) { IList <Item> items = new List <Item>(); if (itemList.ToString().Equals("All")) { items = NewsManager.GetItems(); } else { if (!string.IsNullOrEmpty(itemList.ToString())) { string[] arr = itemList.ToString().Split(','); foreach (string itemId in arr) { Item item = NewsManager.GetItem(itemId); if (categories.Contains(item.Category.Id)) { items.Add(NewsManager.GetItem(itemId)); } } } } if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "Item.UpdateDate"; expression.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } var allowedList = (from item in items where SecurityHelper.CanUserView(Page.User.Identity.Name, item.Category.Id) select new RepeaterItem { Item = item, TrafficLightUrl = GetUserStatus(item) }).ToList(); RadGrid1.DataSource = allowedList; } }
/// <summary> /// Handles the SortCommand event of the gvBookingDetails control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Telerik.Web.UI.GridSortCommandEventArgs"/> instance containing the event data.</param> protected void gvBookingDetails_SortCommand(object sender, Telerik.Web.UI.GridSortCommandEventArgs e) { if (e.SortExpression.Length > 0) { GridSortExpression sortExprByCompany = new GridSortExpression(); sortExprByCompany.FieldName = "ItemTypeId"; sortExprByCompany.SortOrder = GridSortOrder.Ascending; GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = e.NewSortOrder; gvBookingDetails.MasterTableView.SortExpressions.Clear(); gvBookingDetails.MasterTableView.SortExpressions.AddSortExpression(sortExprByCompany); gvBookingDetails.MasterTableView.SortExpressions.AddSortExpression(sortExpr); e.Canceled = true; gvBookingDetails.Rebind(); } }
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "UpdateDate"; expression.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } List <Article> articles = new List <Article>(); if (!string.IsNullOrEmpty(FilterExpression)) { BindWithFilter(articles); } else { SearchDefault(articles); } }
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "User.Name"; expression.SortOrder = GridSortOrder.Ascending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } List <PersonWithUser> personsAndUsers = new List <PersonWithUser>(); if (!string.IsNullOrEmpty(FilterExpression)) { BindWithFilter(personsAndUsers); } else { SearchDefault(personsAndUsers); } }
protected void Page_Load(object sender, EventArgs e) { Control feedback = Utilities.FindControlRecursive(Page.Master, "feedback"); RadAjaxManager1.AjaxSettings.AddAjaxSetting(RadGrid1, feedback); NewLinkUrl = Navigation.Admin_ManageSite(string.Empty).GetAbsoluteClientUrl(true); // Display the sites visible to this user. if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "Name"; expression.SortOrder = GridSortOrder.Ascending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } tree1.PopulateTreeView <Region>(SiteManager.GetAllRegions(), true, false, string.Empty); if (!IsPostBack) { FilterExpression = string.Empty; } }
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DataTable dttemp; switch (RadTabStrip1.SelectedIndex) { case 0: dttemp = Peerfx_DB.SPs.ViewPaymentsByStatus(10).GetDataSet().Tables[0]; RadGrid1.DataSource = dttemp; if (!IsPostBack) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "date_created"; expression.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } break; case 1: dttemp = Peerfx_DB.SPs.ViewPaymentsProcessedWithdrawls().GetDataSet().Tables[0]; RadGrid1.DataSource = dttemp; break; } //RadGrid1.MasterTableView.Rebind(); }
/// ----------------------------------------------------------------------------- /// <summary> /// Page_Load runs when the control is loaded /// </summary> /// <remarks> /// </remarks> /// <history> /// </history> /// ----------------------------------------------------------------------------- protected void Page_Load(System.Object sender, System.EventArgs e) { base.Page_Load(sender, e); try { ServiceReference service = new ServiceReference("~/DesktopModules/ATI_Base/resources/services/StreamService.asmx"); service.InlineScript = true; ScriptManager.GetCurrent(Page).Services.Add(service); if (!Page.IsPostBack && !Page.IsCallback) { aqufitEntities entities = new aqufitEntities(); if (Request["a"] != null) { long aId = Convert.ToInt64(Request["a"]); CompetitionAffiliate affiliate = entities.CompetitionAffiliates.FirstOrDefault(a => a.Id == aId); atiRadComboSearchAffiliates.Items.Add(new RadComboBoxItem() { Selected = true, Text = affiliate.Name, Value = "" + affiliate.Id }); // set the sex to all rblSex.Items.FindByValue("A").Selected = true; } baseUrl = ResolveUrl("~/"); Competition comp = null; long compKey = 0; if (Request["c"] != null) { compKey = Convert.ToInt64(Request["c"]); comp = entities.Competitions.FirstOrDefault(c => c.Id == compKey); } if (compKey <= 0) { comp = entities.Competitions.FirstOrDefault(); } workoutTabTitle.Text = "Competition: "+comp.Name; atiWorkoutPanel.Visible = true; var regionList = entities.CompetitionRegions.Select(r => new {Text = r.Name, Id = r.Id }).ToList(); ddlRegion.DataTextField = "Text"; ddlRegion.DataValueField = "Id"; // ddlRegion.DataSource = regionList; // ddlRegion.DataBind(); ddlRegion.Items.Add(new ListItem() { Text = "All Regions", Value = "0", Selected = true }); foreach (var item in regionList) { ddlRegion.Items.Add(new ListItem() { Text = item.Text, Value = "" + item.Id }); } //RadGrid1.MasterTable //var regionList = entities.Com.Select(r => new {Text = r.Name, Id = r.Id }).ToList(); //ddlAffiliate if (RadGrid1.MasterTableView.SortExpressions.Count == 0) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "OverallRank"; expression.SortOrder = GridSortOrder.Ascending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } User angie = entities.UserSettings.OfType<User>().Include("CompetitionAthletes").FirstOrDefault(u => u.Id == 515); atiFeaturedProfile.Settings = angie; litRank.Text = "<span class=\"grad-FFF-EEE\" style=\"float: right; display: inline-block; border: 1px solid #ccc; text-align: center; padding: 7px;\">World Rank<br /><em style=\"font-size: 18px;\">" + angie.CompetitionAthletes.First().OverallRank + "</em></span>"; //grad-FFF-EEE } } catch (Exception exc) //Module failed to load { Exceptions.ProcessModuleLoadException(this, exc); } }
private void Sorting() { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = "ID"; sortExpr.SortOrder = GridSortOrder.Descending; grdQuotesAndTrades.MasterTableView.SortExpressions.AddSortExpression(sortExpr); sortExpr = new GridSortExpression(); sortExpr.FieldName = "CodeName"; sortExpr.SortOrder = GridSortOrder.Ascending; grdLoans.MasterTableView.SortExpressions.AddSortExpression(sortExpr); }
protected void grdQuotesAndTrades_SortCommand(object sender, GridSortCommandEventArgs e) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); }
protected void grdLoans_SortCommand(object sender, GridSortCommandEventArgs e) { // GridTableView tableView = e.Item.OwnerTableView; GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; if (strLoanSort == "ASC") { sortExpr.SortOrder = GridSortOrder.Descending; strLoanSort = "DESC"; } else { sortExpr.SortOrder = GridSortOrder.Ascending; strLoanSort = "ASC"; } // sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); //sortExpr.SortOrder = GridSortOrder.Ascending; }
protected void grdAgency_SortCommand(object sender, GridSortCommandEventArgs e) { if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); } }
protected void ReportGrid_SortCommand(object source, GridSortCommandEventArgs e) { GridSortExpression sortExpr = new GridSortExpression(); DataTable sortTable = new DataTable(); e.Canceled = true; foreach (DataColumn col in _contentData.Columns) { DataColumn newCol = new DataColumn(col.ColumnName); sortTable.Columns.Add(newCol); } DataRow standardsRow = sortTable.NewRow(); DataRow rigorRow = sortTable.NewRow(); foreach (DataColumn col in _contentData.Columns) { standardsRow[col.ColumnName] = _contentData.Rows[0][col]; rigorRow[col.ColumnName] = _contentData.Rows[1][col]; } sortTable.Rows.Add(standardsRow); sortTable.Rows.Add(rigorRow); switch (SessionObject.Reports_GridSortOrder) { case "DESC": _contentData.Select("[1] Like '%studentRow=%' and Len(Score) > 0", e.SortExpression + " DESC").CopyToDataTable<System.Data.DataRow>(sortTable, System.Data.LoadOption.PreserveChanges); _contentData.Select("[1] Not Like '%studentRow=%' and Len(Score) > 0").CopyToDataTable<System.Data.DataRow>(sortTable, System.Data.LoadOption.PreserveChanges); _selectedSortColumn = e.SortExpression; _selectedSortMethod = "DESC"; reportGrid.DataSource = sortTable; reportGrid.DataBind(); SessionObject.Reports_GridSortOrder = "ASC"; break; case "ASC": _contentData.Select("[1] Like '%studentRow=%' and Len(Score) > 0", e.SortExpression + " ASC").CopyToDataTable<System.Data.DataRow>(sortTable, System.Data.LoadOption.PreserveChanges); _contentData.Select("[1] Not Like '%studentRow=%' and Len(Score) > 0").CopyToDataTable<System.Data.DataRow>(sortTable, System.Data.LoadOption.PreserveChanges); _selectedSortColumn = e.SortExpression; _selectedSortMethod = "ASC"; reportGrid.DataSource = sortTable; reportGrid.DataBind(); SessionObject.Reports_GridSortOrder = "DESC"; break; default: _contentData.Select("[1] Like '%studentRow=%' and Len(Score) > 0", e.SortExpression + " DESC").CopyToDataTable<System.Data.DataRow>(sortTable, System.Data.LoadOption.PreserveChanges); _contentData.Select("[1] Not Like '%studentRow=%' and Len(Score) > 0").CopyToDataTable<System.Data.DataRow>(sortTable, System.Data.LoadOption.PreserveChanges); _selectedSortColumn = e.SortExpression; _selectedSortMethod = "DESC"; reportGrid.DataSource = sortTable; reportGrid.DataBind(); SessionObject.Reports_GridSortOrder = "ASC"; break; } }
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { RadGrid1.DataSource = Peerfx_DB.SPs.ViewUsersAllAdminUsers().GetDataSet().Tables[0]; //Peerfx_DB.SPs.ViewUsersAll().GetDataSet().Tables[0]; if (!IsPostBack) { GridSortExpression expression = new GridSortExpression(); expression.FieldName = "last_online"; expression.SortOrder = GridSortOrder.Descending; RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression); } //RadGrid1.MasterTableView.Rebind(); }
private void Sorting() { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = "Name"; sortExpr.SortOrder = GridSortOrder.Ascending; grdAccounts.MasterTableView.SortExpressions.AddSortExpression(sortExpr); sortExpr = new GridSortExpression(); sortExpr.FieldName = "Name"; sortExpr.SortOrder = GridSortOrder.Ascending; grdEmail.MasterTableView.SortExpressions.AddSortExpression(sortExpr); sortExpr = new GridSortExpression(); sortExpr.FieldName = "Name"; sortExpr.SortOrder = GridSortOrder.Ascending; grdUsers.MasterTableView.SortExpressions.AddSortExpression(sortExpr); sortExpr = new GridSortExpression(); sortExpr.FieldName = "Name"; sortExpr.SortOrder = GridSortOrder.Ascending; grdCountry.MasterTableView.SortExpressions.AddSortExpression(sortExpr); sortExpr = new GridSortExpression(); sortExpr.FieldName = "CodeName"; sortExpr.SortOrder = GridSortOrder.Ascending; grdDuplicateLoans.MasterTableView.SortExpressions.AddSortExpression(sortExpr); }