protected void rgPrivGroup_SortCommand(object sender, GridSortCommandEventArgs e)
{
if (OnPrivGroupCommand != null)
{
OnPrivGroupCommand("sort");
}
}
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();
}
/// <summary>
/// Esegue il sort di una colonna nella griglia.
/// Reperisco dalla griglia il nome della colonna da ordinare.
/// Creo l'espressione Lambda corretta e la inserisco nel finder e poi lo persisto nella sessione.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <typeparam name="THeader"></typeparam>
/// <param name="e"></param>
public void FinderSorting <T, THeader>(GridSortCommandEventArgs e)
{
// TODO: verificare gli ordinamenti sui campi dell'entità Header. In questo momento l'ordinamento funziona solo se il campo è settato sull'entità padre
IFinder <T, THeader> finderToExecute = Finder as IFinder <T, THeader>;
finderToExecute.SortExpressionsClear();
SortDirection sortOrder;
if (e.NewSortOrder == GridSortOrder.None && e.OldSortOrder == GridSortOrder.Descending)
{
sortOrder = SortDirection.Descending;
}
else
{
sortOrder = e.NewSortOrder == GridSortOrder.Ascending ? SortDirection.Ascending : SortDirection.Descending;
}
string parameterName = e.SortExpression;
ParameterExpression param = Expression.Parameter(typeof(T), "x");
Expression <Func <T, object> > expr = Expression.Lambda <Func <T, object> >(Expression.Convert(Expression.Property(param, parameterName), typeof(object)), param);
finderToExecute.SortExpressions.Add(new SortExpression <T>()
{
Expression = expr, Direction = sortOrder
});
Finder = finderToExecute;
PersistFinder();
}
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 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();
}
protected void rgTaskList_SortCommand(object sender, GridSortCommandEventArgs e)
{
if (OnTaskListCommand != null)
{
OnTaskListCommand("sort");
}
}
protected void radGridEntry_SortCommand(object Sender, GridSortCommandEventArgs e)
{
//if (e.CommandArgument == "Country") //This Line Made ALL sorting functions of the title/labels are NOT working
{
BindGrid(true, e.CommandArgument.ToString(), e.NewSortOrder, true);
}
}
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();
}
protected void grdProducts_SortCommand(object source, GridSortCommandEventArgs e)
{
// The RadGrid has a bug in it's sorting display on the header
// we'll just do the sorting manually
// if we are in the master products grid
if (e.Item.OwnerTableView.Name.EqualsIgnoreCase("Master"))
{
e.Canceled = true;
this.SortColumn = e.SortExpression;
switch (this.SortColumnDirection)
{
case GridSortOrder.Ascending:
this.SortColumnDirection = GridSortOrder.Descending;
break;
case GridSortOrder.None:
case GridSortOrder.Descending:
this.SortColumnDirection = GridSortOrder.Ascending;
break;
}
BindData(false);
}
else // we're in the variant detail tables
{
}
}
protected void rgNotifyAction_SortCommand(object sender, GridSortCommandEventArgs e)
{
if (OnNotifyActionCommand != null)
{
OnNotifyActionCommand("sort");
}
}
protected void radGridEntry_SortCommand(object Sender, GridSortCommandEventArgs e)
{
if (e.CommandArgument == "Country")
{
BindGrid(true, e.CommandArgument.ToString(), e.NewSortOrder, true);
}
}
protected void RadGridItems_SortCommand(object sender, GridSortCommandEventArgs e)
{
this.ReBindGrid();
ViewState["IsPopulateSubItemModel"] = false;
ViewState["IsPopulateItemModel"] = false;
}
protected void RadGridItemAttribute_SortCommand(object sender, GridSortCommandEventArgs e)
{
this.ReBindGrid();
ViewState["IsSubAttribute"] = (!this.IsPostBack);
ViewState["IsPageValied"] = true;
}
protected void rgRegionalApproverAction_SortCommand(object sender, GridSortCommandEventArgs e)
{
if (OnRegionalApproverActionCommand != null)
{
OnRegionalApproverActionCommand("sort");
}
}
protected void gvUserActivity_SortCommand(object sender, GridSortCommandEventArgs e)
{
if (e.SortExpression.Length > 0)
{
PageIndex = 0;
SortOrder = e.NewSortOrder;
SortField = e.SortExpression;
}
}
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));
}
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 rg3_SortCommand(object source, GridSortCommandEventArgs e)
{
try
{
rg3.Rebind();
}
catch (Exception ex)
{
ErrorManager(ex, new System.Diagnostics.StackTrace().GetFrame(0).GetMethod().Name);
}
}
protected void gvAutoProctorInbox_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 rg1_SortCommand(object source, GridSortCommandEventArgs e)
{
try
{
rg1.Rebind();
}
catch (Exception ex)
{
throw ex;
}
}
protected void AttbtsgrdView_SortCommand(object sender, GridSortCommandEventArgs e)
{
LoadGrid();
LoadGrid2();
LoadGrid3();
LoadGrid4();
LoadGrid5();
LoadGrid6();
LoadGrid7();
LoadGrid8();
}
protected void dgControlPromocion_SortCommand(object source, GridSortCommandEventArgs e)
{
try
{
dgControlPromocion.Rebind();
}
catch (Exception)
{
throw;
}
}
protected void RgvManageUser_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);
* }*/
this.RgvManageUser.MasterTableView.AllowNaturalSort = true;
this.RgvManageUser.MasterTableView.Rebind();
}
protected void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e)
{
DataSet ds = generateArrayIndex();
DataTable dt = new DataTable();
dt = ds.Tables[0];
dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns[0] };
dt.Merge(ds.Tables[1]);
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
updatePanelDashboardGrid.Update();
}
protected void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e)
{
foreach (GridItem item in RadGrid1.MasterTableView.Items)
{
if (item is GridEditableItem)
{
GridEditableItem editableItem = item as GridDataItem;
editableItem.Edit = true;
}
}
RadGrid1.Rebind();
}
protected void RadGrid1_SortCommand(object source, GridSortCommandEventArgs e)
{
ErrorManager();
try
{
this.RadGrid1.Rebind();
}
catch (Exception ex)
{
ErrorManager(ex, "RadGrid1_SortCommand");
}
}
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();
}
}
protected void gridReport_SortCommand(object sender, GridSortCommandEventArgs e)
{
string orderByClause = GetOrderByClause(e.SortExpression, e.NewSortOrder.ToString());
ReportData reportData = new ReportData(UserSession.LoginUser);
reportData.LoadReportData(_reportID, UserSession.LoginUser.UserID);
if (!reportData.IsEmpty)
{
using (SqlConnection connection = new SqlConnection(GetReportConnectionString()))
{
reportData[0].OrderByClause = orderByClause;
reportData[0].Collection.Save();
}
}
}
/// <summary>
/// Sort order action (grid)
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void grdRecentSolution_SortCommand(object source, GridSortCommandEventArgs e)
{
string orderByFormat = string.Empty;
switch (e.NewSortOrder)
{
case GridSortOrder.Ascending:
orderByFormat = "ORDER BY {0} ASC";
break;
case GridSortOrder.Descending:
orderByFormat = "ORDER BY {0} DESC";
break;
}
e.Item.OwnerTableView.Rebind();
}
protected void RGGoodsDemand_SortCommand(object source, GridSortCommandEventArgs e)
{
SortField = e.SortExpression;
if (e.NewSortOrder == GridSortOrder.Ascending)
{
SortStyle = "desc";
SortUser = string.Format("{0} {1} {2}", SortField, "", SortStyle);
RGGoodsDemand.MasterTableView.SortExpressions.AddSortExpression(SortUser);
}
if (e.OldSortOrder == GridSortOrder.Descending)
{
SortStyle = "asc";
SortUser = string.Format("{0} {1} {2}", SortField, "", SortStyle);
RGGoodsDemand.MasterTableView.SortExpressions.AddSortExpression(SortUser);
}
}
/// <summary>
/// Gotta have it for sort to work ??? wierd.
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void grdAssessmentAdmin_SortCommand(object source, GridSortCommandEventArgs e)
{
}
private void GetCompanyGridDataSource(GridSortCommandEventArgs sortEventArgs)
{
int pageNumber = CompanyGrid.CurrentPageIndex + 1;
string sortExpress = string.Empty;
string sortExpressInvert = string.Empty;
foreach (GridSortExpression item in CompanyGrid.MasterTableView.SortExpressions)
{
GridSortOrder newSortOrder = item.SortOrder;
if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression)
{
newSortOrder = sortEventArgs.NewSortOrder;
}
if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (newSortOrder == GridSortOrder.Ascending)
{
sortExpress += item.FieldName + " ASC";
sortExpressInvert += item.FieldName + " DESC";
}
else if (newSortOrder == GridSortOrder.Descending)
{
sortExpress += item.FieldName + " DESC";
sortExpressInvert += item.FieldName + " ASC";
}
}
if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression))
{
if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending)
{
sortExpress += sortEventArgs.SortExpression + " ASC";
sortExpressInvert += sortEventArgs.SortExpression + " DESC";
}
else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending)
{
sortExpress += sortEventArgs.SortExpression + " DESC";
sortExpressInvert += sortEventArgs.SortExpression + " ASC";
}
}
if (!string.IsNullOrEmpty(sortExpress))
{
if (sortExpress.Contains("CompanyName"))
{
sortExpress = sortExpress.Replace("CompanyName", "SocNom");
sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom");
}
if (sortExpress.Contains("City"))
{
sortExpress = sortExpress.Replace("City", "Commune");
sortExpressInvert = sortExpressInvert.Replace("City", "Commune");
}
if (sortExpress.Contains("StatusLabel"))
{
sortExpress = sortExpress.Replace("StatusLabel", "StatusLabel");
sortExpressInvert = sortExpressInvert.Replace("StatusLabel", "StatusLabel");
}
if (sortExpress.Contains("Responsible"))
{
sortExpress = sortExpress.Replace("Responsible", "Responsable");
sortExpressInvert = sortExpressInvert.Replace("Responsible", "Responsable");
}
if (sortExpress.Contains("CreatedDate"))
{
sortExpress = sortExpress.Replace("CreatedDate", "DateCreation");
sortExpressInvert = sortExpressInvert.Replace("CreatedDate", "DateCreation");
}
}
else
{
sortExpress = "SocNom ASC";
sortExpressInvert = "SocNom DESC";
}
CompanyRepository companyRepo = new CompanyRepository();
List<Company> companyList = new List<Company>();
/*if (!string.IsNullOrEmpty(Request.QueryString["type"])) //search by type
{
switch (Request.QueryString["type"])
{
case "all":
CompanyGrid.VirtualItemCount = companyRepo.CountAllCompanies();
companyList = companyRepo.GetAllCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "client":
CompanyGrid.VirtualItemCount = companyRepo.CountCustomerCompanies();
companyList = companyRepo.GetCustomerCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "prospect":
CompanyGrid.VirtualItemCount = companyRepo.CountPropectCompanies();
companyList = companyRepo.GetPropectCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "inactive":
CompanyGrid.VirtualItemCount = companyRepo.CountInactiveCompanies();
companyList = companyRepo.GetInactiveCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
default:
CompanyGrid.VirtualItemCount = companyRepo.CountAllCompanies();
companyList = companyRepo.GetAllCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
}
}
else*/
//if ((!string.IsNullOrEmpty(Request.QueryString["cname"]))) // search by name
//{
if (!string.IsNullOrEmpty(Request.QueryString["ctype"]))
{
switch(Request.QueryString["ctype"])
{
case "all":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByName(Request.QueryString["cname"]);
companyList = companyRepo.FindByName(Request.QueryString["cname"], pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "client":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "1");
companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"],"1", pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "prospect":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "2");
companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"], "2", pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "inactive":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "0");
companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"], "0", pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
}
}
else
{
//CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByName(Request.QueryString["cname"]);
//companyList = companyRepo.FindByName(Request.QueryString["cname"], pageSize, pageNumber, sortExpress, sortExpressInvert);
companyList = companyRepo.GetTopCompany(pageSize);
}
//}
//else //view a number of recent company
//{
// companyList = companyRepo.GetTopCompany(pageSize);
//}
CompanyGrid.DataSource = companyList;
}
protected void OnSortCommandInProduction(object source, GridSortCommandEventArgs e)
{
ApplicationContext.SaveGridSettings("Staff Production", e);
}
protected void OnSort(object sender, GridSortCommandEventArgs args)
{
dgPolicies.Sort = args.SortExpression;
}
protected void radGridResults_SortCommand(object sender, GridSortCommandEventArgs e)
{
string sortDirection = "asc";
if (e.NewSortOrder == GridSortOrder.Descending)
{
sortDirection = "desc";
}
ReferenceSearchCriteria referenceSearchCriteria = this.GetSelectedCriteria(this.Master.CurrentCriteria());
PopulateGridWithCMSData(referenceSearchCriteria, e.SortExpression + " " + sortDirection);
}
protected void OnSortCommand(object sender, GridSortCommandEventArgs e)
{
this.SearchStudents("Grid");
}
protected void OnSortCommand(object sender, GridSortCommandEventArgs e)
{
BindDataToGrid();
}
private void BindCompanyGrid(GridSortCommandEventArgs sortEventArgs)
{
if (!string.IsNullOrEmpty(txtName.Text))
{
int pageSize = 10;
int pageNumber = gridCompany.CurrentPageIndex + 1;
string sortExpress = string.Empty;
string sortExpressInvert = string.Empty;
foreach (GridSortExpression item in gridCompany.MasterTableView.SortExpressions)
{
GridSortOrder newSortOrder = item.SortOrder;
if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression)
{
newSortOrder = sortEventArgs.NewSortOrder;
}
if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (newSortOrder == GridSortOrder.Ascending)
{
sortExpress += item.FieldName + " ASC";
sortExpressInvert += item.FieldName + " DESC";
}
else if (newSortOrder == GridSortOrder.Descending)
{
sortExpress += item.FieldName + " DESC";
sortExpressInvert += item.FieldName + " ASC";
}
}
if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression))
{
if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending)
{
sortExpress += sortEventArgs.SortExpression + " ASC";
sortExpressInvert += sortEventArgs.SortExpression + " DESC";
}
else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending)
{
sortExpress += sortEventArgs.SortExpression + " DESC";
sortExpressInvert += sortEventArgs.SortExpression + " ASC";
}
}
if (!string.IsNullOrEmpty(sortExpress))
{
if (sortExpress.Contains("CompanyName"))
{
sortExpress = sortExpress.Replace("CompanyName", "SocNom");
sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom");
}
if (sortExpress.Contains("City"))
{
sortExpress = sortExpress.Replace("City", "Commune");
sortExpressInvert = sortExpressInvert.Replace("City", "Commune");
}
if (sortExpress.Contains("StatusLabel"))
{
sortExpress = sortExpress.Replace("StatusLabel", "StatusLabel");
sortExpressInvert = sortExpressInvert.Replace("StatusLabel", "StatusLabel");
}
if (sortExpress.Contains("Responsible"))
{
sortExpress = sortExpress.Replace("Responsible", "Responsable");
sortExpressInvert = sortExpressInvert.Replace("Responsible", "Responsable");
}
if (sortExpress.Contains("CreatedDate"))
{
sortExpress = sortExpress.Replace("CreatedDate", "DateCreation");
sortExpressInvert = sortExpressInvert.Replace("CreatedDate", "DateCreation");
}
}
else
{
sortExpress = "SocNom ASC";
sortExpressInvert = "SocNom DESC";
}
CompanyRepository companyRepo = new CompanyRepository();
gridCompany.VirtualItemCount = companyRepo.CountSearchCompaniesByName(txtName.Text);
gridCompany.DataSource = companyRepo.FindByName(txtName.Text,
pageSize, pageNumber, sortExpress, sortExpressInvert);
}
else
{
IList<Company> comList = new List<Company>();
gridCompany.DataSource = comList;
}
}
protected void OnGridCompanySortCommand(object source, GridSortCommandEventArgs e)
{
BindCompanyGrid(e);
}
protected void OnSort(object sender, GridSortCommandEventArgs args)
{
dgDisciplineLevels.Sort = args.SortExpression;
}
protected void OnSort(object sender, GridSortCommandEventArgs args)
{
dgCompetencyAreas.Sort = args.SortExpression;
}
protected void OnGridRoomResultSortCommand(object source, GridSortCommandEventArgs e)
{
GetGridRoomResultDataSource(e);
}
protected void rg_OnSortCommand(object sender, GridSortCommandEventArgs e)
{
RadGrid rg = sender as RadGrid;
if (rg != null)
{
Int32 i;
for (i = 0; i < _grids.Length; i++)
{
if (rg.ID == _grids[i].ID)
{
BindDataToGrid(LevelData.Tables[i + 1], _grids[i]);
break;
}
}
}
}
protected void OnRadActionGridSortCommand(object source, GridSortCommandEventArgs e)
{
BindGridData(e);
}
protected void grdTeklifler_SortCommand(object source, GridSortCommandEventArgs e)
{
}
protected void grdCalculatedDates3_SortCommand(object sender, GridSortCommandEventArgs e)
{
}
protected void grdIstek_SortCommand(object source, GridSortCommandEventArgs e)
{
}
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 OnSortCommand(object sender, GridSortCommandEventArgs e)
{
if (SourceCriteriaExists())
{
radGridResults.DataSource = SearchResourcesWithCriteria(false);
radGridResults.DataBind();
}
}
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);
}
void Grid_SortCommand(object sender, GridSortCommandEventArgs e)
{
this.StoreSelection();
DataTable Dt = null;
string Sort = e.SortExpression + " " + (e.NewSortOrder == GridSortOrder.Ascending ? "" : "Desc");
/*
if (this.mProperties.IsRequery)
{ Dt = this.mBase.List(this.mState.Qc, Sort, this.Grid.PageSize, this.Grid.CurrentPageIndex + 1); }
else
{
Dt = this.mDataSource;
if (this.mState.Qc != null)
{
try { Dt.DefaultView.RowFilter = this.mState.Qc.GetQueryCondition_String(); }
catch { }
}
else
{ Dt.DefaultView.RowFilter = ""; }
}
*/
switch (this.mProperties.SourceType)
{
case eSourceType.Base:
{
Dt = this.mBase.List(this.mState.Qc, Sort, this.Grid.PageSize, this.Grid.CurrentPageIndex + 1);
break;
}
case eSourceType.DataTable:
{
Dt = this.mDataSource;
if (this.mState.Qc != null)
{
try { Dt.DefaultView.RowFilter = this.mState.Qc.GetQueryCondition_String(); }
catch { }
}
else
{ Dt.DefaultView.RowFilter = ""; }
break;
}
case eSourceType.Table:
{
Dt = new Base().pDa.List(this.mTableName, this.mState.Qc, Sort, this.Grid.PageSize, this.Grid.CurrentPageIndex + 1);
break;
}
}
Methods_Web.ClearHTMLTags(Dt);
this.Grid.DataSource = Dt;
this.Grid.Rebind();
List<string> List_Sort = new List<string>();
List_Sort.Add(Sort);
this.SaveGridState(this.Grid.PageSize, this.Grid.CurrentPageIndex, List_Sort);
}
protected void OnSortCommand(object sender, GridSortCommandEventArgs e)
{
BindPerformanceGrid();
}
protected void OnSortCommandRequests(object source, GridSortCommandEventArgs e)
{
ApplicationContext.SaveGridSettings("Staff Requests", e);
}
protected void OnCommentSortCommand(object sender, GridSortCommandEventArgs e)
{
BindCommentGrid();
}
public void SaveGridSettings(string sName, GridSortCommandEventArgs e)
{
// We're only saving the sorting on the master table, not child 'detail' tables
if (e.Item.OwnerTableView.Name != "Detail")
{
var oIAUserSettingsGrid = DataAccess.IAUserSettingsGrids.SingleOrDefault(row => row.MPUserID == MemberProtect.CurrentUser.UserID && row.Name == sName);
if (oIAUserSettingsGrid == null)
{
oIAUserSettingsGrid = new IAUserSettingsGrid();
DataAccess.IAUserSettingsGrids.InsertOnSubmit(oIAUserSettingsGrid);
oIAUserSettingsGrid.MPUserID = MemberProtect.CurrentUser.UserID;
oIAUserSettingsGrid.Name = sName;
oIAUserSettingsGrid.Filters = string.Empty;
}
oIAUserSettingsGrid.SortExpression = e.SortExpression;
if (e.NewSortOrder == GridSortOrder.Ascending)
{
oIAUserSettingsGrid.SortExpression += " ASC";
}
else if (e.NewSortOrder == GridSortOrder.Descending)
{
oIAUserSettingsGrid.SortExpression += " DESC";
}
DataAccess.SubmitChanges();
}
}
private void GetGridRoomResultDataSource(GridSortCommandEventArgs sortEventArgs)
{
int pageNumber = gridRoomResult.CurrentPageIndex + 1;
string sortExpress = string.Empty;
string sortExpressInvert = string.Empty;
foreach (GridSortExpression item in gridRoomResult.MasterTableView.SortExpressions)
{
GridSortOrder newSortOrder = item.SortOrder;
if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression)
{
newSortOrder = sortEventArgs.NewSortOrder;
}
if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (newSortOrder == GridSortOrder.Ascending)
{
sortExpress += item.FieldName + " ASC";
sortExpressInvert += item.FieldName + " DESC";
}
else if (newSortOrder == GridSortOrder.Descending)
{
sortExpress += item.FieldName + " DESC";
sortExpressInvert += item.FieldName + " ASC";
}
}
if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression))
{
if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending)
{
sortExpress += sortEventArgs.SortExpression + " ASC";
sortExpressInvert += sortEventArgs.SortExpression + " DESC";
}
else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending)
{
sortExpress += sortEventArgs.SortExpression + " DESC";
sortExpressInvert += sortEventArgs.SortExpression + " ASC";
}
}
if (string.IsNullOrEmpty(sortExpress))
{
sortExpress = "DateCreated DESC";
sortExpressInvert = "DateCreated ASC";
}
int cityId = Convert.ToInt32(cbbCity.SelectedValue);
int? districtId = Convert.ToInt32(cbbDistrict.SelectedValue);
if (districtId <= 0)
{
districtId = null;
}
int? realestateTypeId = Convert.ToInt32(cbbRealestateType.SelectedValue);
if (realestateTypeId <= 0)
{
realestateTypeId = null;
}
decimal? priceFrom = null;
if (txtPriceFrom.Value.HasValue)
{
priceFrom = Convert.ToDecimal(txtPriceFrom.Value);
}
decimal? priceTo = null;
if (txtPriceTo.Value.HasValue)
{
priceTo = Convert.ToDecimal(txtPriceTo.Value);
}
DateTime? dateFrom = null;
if (datDateFrom.SelectedDate.HasValue)
{
dateFrom = datDateFrom.SelectedDate.Value;
}
DateTime? dateTo = null;
if (datDateTo.SelectedDate.HasValue)
{
dateTo = datDateTo.SelectedDate.Value;
dateTo = dateTo.Value.AddDays(1).AddSeconds(-1);
}
decimal? meterFrom = null;
if (txtMeterSquareFrom.Value.HasValue)
{
meterFrom = Convert.ToDecimal(txtMeterSquareFrom.Value);
}
decimal? meterTo = null;
if (txtMeterSquareTo.Value.HasValue)
{
meterTo = Convert.ToDecimal(txtMeterSquareTo.Value);
}
int gender = radMale.Checked ? 1 : 0;
gridRoomResult.VirtualItemCount = Business.BusinessMethods.CountPost((int)PostTypes.House, null, realestateTypeId, 232, cityId, districtId, null, null, null, gender,
priceFrom, priceTo, dateFrom, dateTo, meterFrom, meterTo, UtilityHelper.FormatKeywords(txtKeywords.Text), false);
List<Post> searchResults = Business.BusinessMethods.SearchPostPaging((int)PostTypes.House, null, realestateTypeId, 232, cityId, districtId, null, null, null, gender,
priceFrom, priceTo, dateFrom, dateTo, meterFrom, meterTo, UtilityHelper.FormatKeywords(txtKeywords.Text), false, gridRoomResult.PageSize, pageNumber, sortExpress, sortExpressInvert);
gridRoomResult.DataSource = searchResults;
//Build Meta Description for Google Search Engine :
StringBuilder builder = new StringBuilder();
foreach (Post post in searchResults)
{
builder.Append(post.Address + " giá : " + post.PriceString + ". \n");
}
this.Page.MetaDescription = builder.ToString();
}
private void dgEquipmentOrdered_SortCommand(object sender, GridSortCommandEventArgs e)
{
dgEquipmentOrdered.Sort = e.SortExpression;
}
protected void RadGrid1_SortCommand(object source, GridSortCommandEventArgs e)
{
fillGrids(2);
}
protected void rdgvFairmadanGelenIstekler_SortCommand(object source, GridSortCommandEventArgs e)
{
int Yil = 0;
int IstekNo = 0;
if (txtFilterYil.Text.Trim() != string.Empty)
{
Yil = int.Parse(txtFilterYil.Text.Trim());
}
else
{
Yil = 0;
}
if (txtFilterIstekNo.Text.Trim() != string.Empty)
{
IstekNo = int.Parse(txtFilterIstekNo.Text.Trim());
}
else
{
IstekNo = 0;
}
GridBagla(int.Parse(Session["IstekleriGosterilecekFirmaId"].ToString()), Yil, IstekNo);
}
private void BindGridData(GridSortCommandEventArgs sortEventArgs)
{
if (SessionManager.CurrentUser == null)
return;
int pageSize = 15;
int pageNumber = gridActions.CurrentPageIndex + 1;
string sortExpress = string.Empty;
string sortExpressInvert = string.Empty;
foreach (GridSortExpression item in gridActions.MasterTableView.SortExpressions)
{
GridSortOrder newSortOrder = item.SortOrder;
if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression)
{
newSortOrder = sortEventArgs.NewSortOrder;
}
if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (newSortOrder == GridSortOrder.Ascending)
{
sortExpress += item.FieldName + " ASC";
sortExpressInvert += item.FieldName + " DESC";
}
else if (newSortOrder == GridSortOrder.Descending)
{
sortExpress += item.FieldName + " DESC";
sortExpressInvert += item.FieldName + " ASC";
}
}
if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression))
{
if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending)
{
sortExpress += sortEventArgs.SortExpression + " ASC";
sortExpressInvert += sortEventArgs.SortExpression + " DESC";
}
else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending)
{
sortExpress += sortEventArgs.SortExpression + " DESC";
sortExpressInvert += sortEventArgs.SortExpression + " ASC";
}
}
if (!string.IsNullOrEmpty(sortExpress))
{
if (sortExpress.Contains("Hour"))
{
sortExpress = sortExpress.Replace("Hour", "Heure");
sortExpressInvert = sortExpressInvert.Replace("Hour", "Heure");
}
if (sortExpress.Contains("CandidateFullName"))
{
sortExpress = sortExpress.Replace("CandidateFullName", "CanLastName");
sortExpressInvert = sortExpressInvert.Replace("CandidateFullName", "CanLastName");
}
if (sortExpress.Contains("CompanyName"))
{
sortExpress = sortExpress.Replace("CompanyName", "SocNom");
sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom");
}
}
else
{
sortExpress = "ActionId DESC";
sortExpressInvert = "ActionId ASC";
}
string type = "MyActiveThisWeek";
if (!string.IsNullOrEmpty(Request.QueryString["type"]))
{
type = Request.QueryString["type"];
}
ActionSearchCriteria criteria = new ActionSearchCriteria();
switch (type)
{
case "MyActiveThisWeek":
DateTime dateFrom = Common.GetBeginDayOfWeek(DateTime.Today);
criteria.DateFrom = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0);
criteria.Active = "Yes";
criteria.Responsible = SessionManager.CurrentUser.UserID;
break;
case "MyActive":
criteria.Active = "Yes";
criteria.Responsible = SessionManager.CurrentUser.UserID;
break;
case "MyInactive":
criteria.Active = "No";
criteria.Responsible = SessionManager.CurrentUser.UserID;
break;
case "MyAllActions":
criteria.Responsible = SessionManager.CurrentUser.UserID;
break;
case "AllActive":
criteria.Active = "Yes";
break;
case "AllInactive":
criteria.Active = "No";
break;
case "AllActions":
break;
case "search":
if (!string.IsNullOrEmpty(Request.QueryString["active"]))
criteria.Active = Request.QueryString["active"];
if (!string.IsNullOrEmpty(Request.QueryString["dateFrom"]))
criteria.DateFrom = DateTime.ParseExact(Request.QueryString["dateFrom"], "dd/MM/yyyy",
System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat);
if (!string.IsNullOrEmpty(Request.QueryString["dateTo"]))
criteria.DateTo = DateTime.ParseExact(Request.QueryString["dateTo"], "dd/MM/yyyy",
System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat);
if (!string.IsNullOrEmpty(Request.QueryString["candidate"]))
criteria.CanName = Request.QueryString["candidate"];
if (!string.IsNullOrEmpty(Request.QueryString["company"]))
criteria.ComName = Request.QueryString["company"];
if (!string.IsNullOrEmpty(Request.QueryString["typeAction"]))
criteria.TypeActionID = int.Parse(Request.QueryString["typeAction"]);
if (!string.IsNullOrEmpty(Request.QueryString["description"]))
criteria.Description = Request.QueryString["description"];
if (!string.IsNullOrEmpty(Request.QueryString["responsible"]))
criteria.Responsible = Request.QueryString["responsible"];
break;
}
ActionRepository repo = new ActionRepository();
gridActions.VirtualItemCount = repo.CountActions(criteria, pageSize, pageNumber, sortExpress, sortExpressInvert);
IList<Neos.Data.Action> list = repo.SearchActions(criteria, pageSize, pageNumber, sortExpress, sortExpressInvert);
gridActions.DataSource = list;
}
