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);
}
