public void SortReprintGrid(string value)
{
if (SortedColumn != value)
{
GridSortOrder = string.Empty;
}
GridSortOrder = string.IsNullOrEmpty(GridSortOrder) ? SortOrder.ASC : GridSortOrder.Equals(SortOrder.ASC) ? SortOrder.DESC : SortOrder.ASC;
AllControlsEnabled = false;
switch (value)
{
default:
case BatchGridColumnsTagName.BatchId:
BatchList = GridSortOrder.Equals(SortOrder.ASC) ? BatchList.OrderBy(x => x.RequestPrintedBatchID).ToList() : BatchList.OrderByDescending(x => x.RequestPrintedBatchID).ToList();
break;
case BatchGridColumnsTagName.Date:
BatchList = GridSortOrder.Equals(SortOrder.ASC) ? BatchList.OrderBy(x => x.DateRequestPrinted).ToList() : BatchList.OrderByDescending(x => x.DateRequestPrinted).ToList();
break;
case BatchGridColumnsTagName.Records:
BatchList = GridSortOrder.Equals(SortOrder.ASC) ? BatchList.OrderBy(x => x.BatchCount).ToList() : BatchList.OrderByDescending(x => x.BatchCount).ToList();
break;
}
AllControlsEnabled = true;
SortedColumn = value;
}
public void GridColumnSort_SetsFirstOrder()
{
GridSortOrder actual = new GridColumnSort <GridModel, Object?>(sort.Column).FirstOrder;
GridSortOrder expected = GridSortOrder.Asc;
Assert.Equal(expected, actual);
}
private void SortReprintGrid(string value)
{
if (SortedColumn != value)
{
GridSortOrder = string.Empty;
}
GridSortOrder = string.IsNullOrEmpty(GridSortOrder) ? SortOrder.ASC : GridSortOrder.Equals(SortOrder.ASC) ? SortOrder.DESC : SortOrder.ASC;
switch (value)
{
default:
case BatchGridColumnsTagName.BatchId:
BatchList = GridSortOrder.Equals(SortOrder.ASC) ? BatchList.OrderBy(x => x.BatchID).ToList() : BatchList.OrderByDescending(x => x.BatchID).ToList();
break;
case BatchGridColumnsTagName.Date:
BatchList = GridSortOrder.Equals(SortOrder.ASC) ? BatchList.OrderBy(x => x.CreattionDate).ToList() : BatchList.OrderByDescending(x => x.CreattionDate).ToList();
break;
case BatchGridColumnsTagName.Records:
BatchList = GridSortOrder.Equals(SortOrder.ASC) ? BatchList.OrderBy(x => x.RecordsCount).ToList() : BatchList.OrderByDescending(x => x.RecordsCount).ToList();
break;
}
SortedColumn = value;
}
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 gvUserActivity_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
{
string sortBy = gvUserActivity.MasterTableView.SortExpressions[0].FieldName;
GridSortOrder sortOrder = gvUserActivity.MasterTableView.SortExpressions[0].SortOrder;
PageIndex = 0;
SortOrder = sortOrder;
SortField = sortBy;
}
/// <summary>
/// Initializes the sorting settings.
/// </summary>
private void InitializeSortingSettings()
{
if (gvItemList.MasterTableView.SortExpressions.Count != 0)
{
string name = gvItemList.MasterTableView.SortExpressions[0].FieldName;
GridSortOrder order = gvItemList.MasterTableView.SortExpressions[0].SortOrder;
this.SortBy = name;
this.SortOrder = (int)order;
}
}
public void Indexer_SortOrder(String gridName, String query, GridSortOrder order)
{
sumColumn.Name = "sum";
sumColumn.Grid.Name = gridName;
sumColumn.Sort.IsEnabled = true;
sumColumn.Grid.Query = HttpUtility.ParseQueryString(query);
GridSortOrder?actual = sort[sumColumn]?.Order;
GridSortOrder?expected = order;
Assert.Equal(expected, actual);
}
/// <summary>
/// Event that fires when a column header is clicked, indicating that the user would like to order the results
/// by the values in that column. The column can be sorted in ascending or descending order.
/// </summary>
/// <param name="source"></param>
/// <param name="e">GridSortCommandEventArgs</param>
protected void grdCustomers_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
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);
}
public static IGridColumn <T, TValue> FirstSort <T, TValue>(this IGridColumn <T, TValue> column, GridSortOrder order)
{
column.Sort.FirstOrder = order;
return(column);
}
public static IGridColumn <T, TValue> InitialSort <T, TValue>(this IGridColumn <T, TValue> column, GridSortOrder order)
{
column.Sort.InitialOrder = order;
return(column);
}
private void BindGrid(bool isCustomSort, string sortExpression, GridSortOrder order, bool needRebind)
{
EntryList list = GeneralFunction.GetAllEntryCache(false);
// filter only completed
List <Entry> slist = new List <Entry>();
foreach (Entry entry in list)
{
if (entry.Status == StatusEntry.Completed && entry.WithdrawnStatus == "" && ((round == "1") || (round == "2" && entry.IsRound2)))
{
slist.Add(entry);
}
}
// filter
string status = (string)ViewState["TabFilterValue"];
string advanceSearch = (string)ViewState["AdvanceSearch"];
List <Entry> flist = new List <Entry>();
if (advanceSearch == "1")
{
// Advanced search
// basic fields
// user's country
List <Guid> entryIdList = GeneralFunction.GetFilteredEntryListFromRegCountry(ddlCountry.SelectedValue, true);
List <Guid> entryIdList2 = GeneralFunction.GetFilteredEntryListFromRegCompany(txtSearch.Text.Trim(), true);
List <Guid> entryIdList3 = GeneralFunction.GetFilteredEntryListFromClientCC(txtSearch.Text.Trim(), true);
List <Guid> entryIdList4 = GeneralFunction.GetFilteredEntryListFromJuryAssignment(txtSearch.Text.Trim(), round, true);
List <Guid> entryIdList6 = GeneralFunction.GetFilteredEntryListFromAgencyCC(txtSearch.Text.Trim(), true);
// jury panel list
List <Guid> entryIdList5 = GeneralFunction.GetFilteredEntryListFromJuryPanel(ddlPanel.SelectedValue, round, true);
foreach (Entry item in slist)
{
// category strip out the prefix
string category = ddlCategory.SelectedValue;
if (category.Length > 3)
{
category = category.Substring(3, category.Length - 3);
}
if (
(ddlMarket.SelectedValue == "" || (ddlMarket.SelectedValue != "" && item.CategoryMarket == ddlMarket.SelectedValue)) &&
(category == "" || (category != "" && (item.CategoryPSDetailFromRound(round) == category || GeneralFunction.IsCategoryInCategoryGroup(category, item.CategoryPSDetailFromRound(round))))) &&
(ddlCountry.SelectedValue == "" || (ddlCountry.SelectedValue != "" && entryIdList.Contains(item.Id))) &&
(ddlPanel.SelectedValue == "" || (ddlPanel.SelectedValue != "" && entryIdList5.Contains(item.Id))) &&
(
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entryId") && item.Serial.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "title") && item.Campaign.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entrant") && entryIdList2.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "client") && entryIdList3.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "agency") && entryIdList6.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "juryname") && entryIdList4.Contains(item.Id)))
//(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "panel") && entryIdList5.Contains(item.Id)))
)
)
{
flist.Add(item);
}
}
}
else
{
// tab filtering
//if (status == "WDN")
//{
//foreach (Entry item in list)
// if (item.WithdrawnStatus != "") flist.Add(item);
//}
//else
//{
// foreach (Entry item in list)
// if (status == "" || (status != "" && item.Status == status)) flist.Add(item);
//}
flist = slist.ToList();
}
#region CustomSorting
if (isCustomSort)
{
List <Registration> regList = RegistrationList.GetRegistrationList(string.Empty, string.Empty, string.Empty).ToList();
if (sortExpression.Equals("Serial"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Serial select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Serial descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Country"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Country select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Country descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("DateSubmitted"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.DateSubmitted select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.DateSubmitted descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.DateSubmitted select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Campaign"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Client"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("CategoryMarket"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket orderby entry.CategoryPSDetail select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket descending orderby entry.CategoryPSDetail descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Panel"))
{
List <Entry> sortedfList = new List <Entry>();
List <Entry> filteredfList = new List <Entry>();
List <JuryPanelCategory> pnlCategory = new List <JuryPanelCategory>();
switch (order)
{
case GridSortOrder.Ascending:
{
pnlCategory = JuryPanelCategoryList.GetJuryPanelCategoryList(string.Empty, string.Empty).OrderBy(m => m.PanelId).ToList();
foreach (JuryPanelCategory pnl in pnlCategory)
{
List <Entry> pnlEntries = GeneralFunction.GetEntryListFromCategory(pnl.CategoryPSDetail, round).OrderBy(m => m.CategoryPSDetail).ToList();
sortedfList.AddRange((from entry in pnlEntries
join mainentry in flist on entry.Id equals mainentry.Id
select mainentry).ToList());
}
filteredfList.AddRange(sortedfList);
filteredfList.AddRange(flist.Except(sortedfList).OrderBy(m => m.CategoryPSDetail).ToList());
break;
}
case GridSortOrder.Descending:
{
pnlCategory = JuryPanelCategoryList.GetJuryPanelCategoryList(string.Empty, string.Empty).OrderByDescending(m => m.PanelId).ToList();
foreach (JuryPanelCategory pnl in pnlCategory)
{
List <Entry> pnlEntries = GeneralFunction.GetEntryListFromCategory(pnl.CategoryPSDetail, round).OrderByDescending(m => m.CategoryPSDetail).ToList();
sortedfList.AddRange((from entry in pnlEntries
join mainentry in flist on entry.Id equals mainentry.Id
select mainentry).ToList());
}
filteredfList.AddRange(sortedfList);
filteredfList.AddRange(flist.Except(sortedfList).OrderByDescending(m => m.CategoryPSDetail).ToList());
break;
}
case GridSortOrder.None:
{
pnlCategory = JuryPanelCategoryList.GetJuryPanelCategoryList(string.Empty, string.Empty).ToList();
foreach (JuryPanelCategory pnl in pnlCategory)
{
List <Entry> pnlEntries = GeneralFunction.GetEntryListFromCategory(pnl.CategoryPSDetail, round);
sortedfList.AddRange((from entry in pnlEntries
join mainentry in flist on entry.Id equals mainentry.Id
select mainentry).ToList());
}
filteredfList.AddRange(sortedfList);
filteredfList.AddRange(flist.Except(sortedfList).ToList());
break;
}
}
flist = filteredfList;
}
else if (sortExpression.Equals("Entrant"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Company select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Company descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
}
else
{
flist = (from entry in flist orderby entry.Serial select entry).ToList();
//flist = (from entry in flist orderby entry.PanelId, entry.CategoryMarket, entry.CategoryPSDetail, entry.Serial select entry).ToList();
}
#endregion
radGridEntry.DataSource = flist;
if (needRebind)
{
radGridEntry.Rebind();
}
GeneralFunction.SetReportDataCache(flist);
}
public static T InitialSort <T>(this T column, GridSortOrder order) where T : IGridColumn
{
column.InitialSortOrder = order;
return(column);
}
protected void GridView1_SortCommand(object sender, GridSortCommandEventArgs e)
{
this.sortOrder = e.NewSortOrder;
this.sortExpression = e.SortExpression;
DisplayRecords();
}
private void BindGrid(bool needRebind, string sortExpression = "", GridSortOrder order = GridSortOrder.None, bool isCustomSort = false)
{
RegistrationList list = GeneralFunction.GetAllRegistrationCache(needRebind);
EntryList elist = GeneralFunction.GetAllEntryCache(false);
// filter
string status = (string)ViewState["TabFilterValue"];
string advanceSearch = (string)ViewState["AdvanceSearch"];
List <Registration> flist = new List <Registration>();
if (advanceSearch == "1")
{
// Advanced search
//string payStatus = ddlPaymentStatus.SelectedValue;
foreach (Registration item in list)
{
if (
(ddlPaymentStatus.SelectedValue == "All" || (ddlPaymentStatus.SelectedValue != "All" && GeneralFunction.IsRegistrationInList(GeneralFunction.GetRegIdWithEntryPayStatus(ddlPaymentStatus.SelectedValue), item))) &&
(ddlEntryStatus.SelectedValue == "" || (ddlEntryStatus.SelectedValue != "" && GeneralFunction.IsRegistrationInList(GeneralFunction.GetRegIdWithEntryStatus(ddlEntryStatus.SelectedValue), item))) &&
(ddlActive.SelectedValue == "" || (ddlActive.SelectedValue != "" && GeneralFunction.IsRegistrationInList(GeneralFunction.GetRegIdWithSubmittedEntries(ddlActive.SelectedValue), item))) &&
(ddlCountry.SelectedValue == "" || (ddlCountry.SelectedValue != "" && item.Country == ddlCountry.SelectedValue)) &&
(ddlIsVerified.SelectedValue == "" || (ddlIsVerified.SelectedValue != "" && item.IsVerified == bool.Parse(ddlIsVerified.SelectedValue))) &&
(cblMember.SelectedValue == "" || (
(cblMember.SelectedValue != "" && cblMember.Items[0].Selected && item.IsCAAAA) ||
(cblMember.SelectedValue != "" && cblMember.Items[1].Selected && item.IsAPEP) ||
(cblMember.SelectedValue != "" && cblMember.Items[2].Selected && item.IsEProg))
) &&
(
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "company") && item.Company.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "email") && item.Email.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "firstname") && item.Firstname.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "lastname") && item.Lastname.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "contact") && item.Contact.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1))
)
)
{
flist.Add(item);
}
}
}
else
{
// tab filtering
if (status == "" || status == "DIS")
{
foreach (Registration item in list)
{
if (status == "" || (status != "" && item.Status == status))
{
flist.Add(item);
}
}
}
else if (status == "XXX")
{
foreach (Registration item in list)
{
if (status == "" || (status != "" && !item.IsActive))
{
flist.Add(item);
}
}
}
else
{
flist = GeneralFunction.GetRegIdWithSubmittedEntries(status);
}
}
if (isCustomSort)
{
List <Registration> regList = RegistrationList.GetRegistrationList(string.Empty, string.Empty, string.Empty).ToList();
if (sortExpression.Equals("Country"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Country).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Country).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Country).ToList();
break;
}
}
else if (sortExpression.Equals("DateCreated"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.DateCreated).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.DateCreated).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.DateCreated).ToList();
break;
}
}
else if (sortExpression.Equals("Contact"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Contact).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Contact).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Contact).ToList();
break;
}
}
else if (sortExpression.Equals("Job"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Job).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Job).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Job).ToList();
break;
}
}
else if (sortExpression.Equals("DateReminder"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.DateReminder(x.Id, EmailTypeEnum.UserList.ToString())).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.DateReminder(x.Id, EmailTypeEnum.UserList.ToString())).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.DateReminder(x.Id, EmailTypeEnum.UserList.ToString())).ToList();
break;
}
}
else if (sortExpression.Equals("Firstname"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Firstname).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Firstname).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Firstname).ToList();
break;
}
}
else if (sortExpression.Equals("Lastname"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Lastname).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Lastname).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Lastname).ToList();
break;
}
}
else if (sortExpression.Equals("Company"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Company).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Company).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Company).ToList();
break;
}
}
else if (sortExpression.Equals("Email"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Email).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Email).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Email).ToList();
break;
}
}
}
counter = 1;
radGridUser.DataSource = flist;
if (needRebind)
{
radGridUser.DataBind();
}
GeneralFunction.SetReportDataCache(flist);
}
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 BindGrid(bool isCustomSort, string sortExpression, GridSortOrder order, bool needRebind)
{
Effie2017.App.EntryList entryList = Effie2017.App.EntryList.GetEntryList(Guid.Empty, Guid.Empty, "", StatusEntry.UploadPending + "|" + StatusEntry.UploadCompleted + "|" + StatusEntry.Completed + "|");
string advanceSearch = (string)ViewState["AdvanceSearch"];
List <Entry> flist = new List <Entry>();
if (advanceSearch == "1")
{
// Advanced search
// basic fields
// user's country
List <Guid> entryIdList = GeneralFunction.GetFilteredEntryListFromRegCountry(ddlCountry.SelectedValue, true);
List <Guid> entryIdList2 = GeneralFunction.GetFilteredEntryListFromRegCompany(txtSearch.Text.Trim(), true);
// Changes by Shaik for adding new columns on 19 Oct 2015
List <Guid> entryIdList3 = GeneralFunction.GetFilteredEntryListFromRegFirstName(txtSearch.Text.Trim(), true);
List <Guid> entryIdList4 = GeneralFunction.GetFilteredEntryListFromRegLastName(txtSearch.Text.Trim(), true);
foreach (Entry item in entryList)
{
// category strip out the prefix
string category = ddlCategory.SelectedValue;
if (category.Length > 3)
{
category = category.Substring(3, category.Length - 3);
}
if (
(ddlDeadline.SelectedValue == "" || (ddlDeadline.SelectedValue != "" && item.Deadline == ddlDeadline.SelectedValue)) &&
(ddlEntryStatus.SelectedValue == "" || (ddlEntryStatus.SelectedValue != "" && item.Status == ddlEntryStatus.SelectedValue)) &&
(ddlMarket.SelectedValue == "" || (ddlMarket.SelectedValue != "" && item.CategoryMarket == ddlMarket.SelectedValue)) &&
//(ddlCategory.SelectedValue == "" || (ddlCategory.SelectedValue != "" && (item.CategoryPSDetail == ddlCategory.SelectedValue || GeneralFunction.IsCategoryInCategoryGroup(ddlCategory.SelectedValue, item.CategoryPSDetail)))) &&
(category == "" || (category != "" && (item.CategoryPSDetailFromRound("") == category || GeneralFunction.IsCategoryInCategoryGroup(category, item.CategoryPSDetailFromRound(""))))) &&
(ddlCountry.SelectedValue == "" || (ddlCountry.SelectedValue != "" && entryIdList.Contains(item.Id))) &&
(
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entryId") && item.Serial.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "title") && item.Campaign.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "client") && item.Client.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "company") && entryIdList2.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "firstname") && entryIdList3.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "lastname") && entryIdList4.Contains(item.Id)))
)
&&
(File.Exists(System.Configuration.ConfigurationSettings.AppSettings["storagePhysicalPath"] + "EntryUpload\\CreativeVideo\\" + item.Serial + "_CreativeMaterials_Video.mp4"))
)
{
flist.Add(item);
}
}
}
else
{
foreach (Entry item in entryList)
{
if (File.Exists(System.Configuration.ConfigurationSettings.AppSettings["storagePhysicalPath"] + "EntryUpload\\CreativeVideo\\" + item.Serial + "_CreativeMaterials_Video.mp4"))
{
flist.Add(item);
}
}
}
#region CustomSorting
if (isCustomSort)
{
List <Registration> regList = RegistrationList.GetRegistrationList(string.Empty, string.Empty, string.Empty).ToList();
if (sortExpression.Equals("Serial"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Serial select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Serial descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Serial select entry).ToList();
break;
}
}
else if (sortExpression.Equals("DateSubmitted"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.DateSubmitted select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.DateSubmitted descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.DateSubmitted select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Campaign"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Client"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client select entry).ToList();
break;
}
}
else if (sortExpression.Equals("CategoryMarket"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket orderby entry.CategoryPSDetail select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket descending orderby entry.CategoryPSDetail descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket orderby entry.CategoryPSDetail select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Status"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Status select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Status descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Status select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Firstname"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Firstname select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Firstname descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Firstname select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Lastname"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Lastname select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Lastname descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Lastname select entry).ToList();
break;
}
}
else if (sortExpression.Equals("IsVideoDownloaded"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.IsVideoDownloaded select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.IsVideoDownloaded descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.IsVideoDownloaded select entry).ToList();
break;
}
}
}
else
{
flist = (from entry in flist orderby entry.Invoice descending, entry.DateCreated descending select entry).ToList();
}
#endregion
radGridEntry.DataSource = flist;
if (needRebind)
{
radGridEntry.DataBind();
}
}
private void BindGrid(bool isCustomSort, string sortExpression, GridSortOrder order, bool needRebind)
{
ScoreList list = GeneralFunction.GetAllScoreCache(needRebind);
// filter only flagged, not recused, submitted
List <Score> slist = new List <Score>();
foreach (Score score in list)
{
/* Commented because have to show recused entries also */
//if (score.Flag != "" && score.IsSubmitted && !score.IsAdminRecuse && !score.IsRecuse && score.Round == round)
// slist.Add(score);
if (((score.Flag != "" && score.IsSubmitted) || (score.IsRecuse)) && score.Round == round)
{
slist.Add(score);
}
}
// filter
string status = (string)ViewState["TabFilterValue"];
string advanceSearch = (string)ViewState["AdvanceSearch"];
List <Score> flist = new List <Score>();
if (advanceSearch == "1")
{
// Advanced search
// basic fields
// user's country
List <Guid> entryIdList = GeneralFunction.GetFilteredEntryListFromRegCountry(ddlCountry.SelectedValue, true);
List <Guid> entryIdList2 = GeneralFunction.GetFilteredScoreListFromRegCompany(txtSearch.Text.Trim(), true);
// juryname
List <Guid> entryIdList4 = GeneralFunction.GetFilteredScoreListFromJuryAssignment(txtSearch.Text.Trim(), "", "", round, true);
// juryid
List <Guid> entryIdList5 = GeneralFunction.GetFilteredScoreListFromJuryAssignment("", txtSearch.Text.Trim(), "", round, true);
// jurycompany
List <Guid> entryIdList6 = GeneralFunction.GetFilteredScoreListFromJuryAssignment("", "", txtSearch.Text.Trim(), round, true);
foreach (Score item in slist)
{
// category strip out the prefix
string category = ddlCategory.SelectedValue;
if (category.Length > 3)
{
category = category.Substring(3, category.Length - 3);
}
// Jury who scored
EffieJuryManagementApp.Jury jury = GeneralFunction.GetJuryFromIDCache(item.Juryid, round);
// Entry
Entry entry = GeneralFunction.GetEntryFromIDCache(item.EntryId);
if (
(ddlNetwork.SelectedValue == "" || (ddlNetwork.SelectedValue != "" && jury.Network == ddlNetwork.SelectedValue)) &&
(ddlHoldingCompany.SelectedValue == "" || (ddlHoldingCompany.SelectedValue != "" && jury.HoldingCompany == ddlHoldingCompany.SelectedValue)) &&
(ddlMarket.SelectedValue == "" || (ddlMarket.SelectedValue != "" && entry.CategoryMarket == ddlMarket.SelectedValue)) &&
(category == "" || (category != "" && (entry.CategoryPSDetailFromRound(round) == category || GeneralFunction.IsCategoryInCategoryGroup(category, entry.CategoryPSDetailFromRound(round))))) &&
(ddlCountry.SelectedValue == "" || (ddlCountry.SelectedValue != "" && entryIdList.Contains(entry.Id))) &&
(
(ddlJuryFlag.SelectedValue == "" || (ddlJuryFlag.SelectedValue != "" && item.Flag == ddlJuryFlag.SelectedValue)) ||
(ddlJuryFlag.SelectedValue == "JuryRecusal" && item.IsRecuse)
) &&
(ddlRecuse.SelectedValue == "" || (ddlRecuse.SelectedValue != "" && (item.IsAdminRecuse.ToString() == ddlRecuse.SelectedValue || item.IsRecuse.ToString() == ddlRecuse.SelectedValue))) &&
(
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entryId") && entry.Serial.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "title") && entry.Campaign.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entrant") && entryIdList2.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "juryname") && entryIdList4.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "juryId") && entryIdList5.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "jurycompany") && entryIdList6.Contains(item.Id)))
)
)
{
flist.Add(item);
}
}
}
else
{
// tab filtering
//if (status == "WDN")
//{
// foreach (Entry item in list)
// if (item.WithdrawnStatus != "") flist.Add(item);
//}
//else
//{
// foreach (Entry item in list)
// if (status == "" || (status != "" && item.Status == status)) flist.Add(item);
//}
flist = slist;
}
// Sort
List <Entry> sortedEntries = GeneralFunction.GetAllEntryCache(false).ToList();
var result = flist.Join(sortedEntries, score => score.EntryId, entry => entry.Id, (score, entry) => new { Score = score, Entry = entry }).OrderBy(x => x.Entry.Serial).Select(x => x.Score).ToList();
#region CustomSorting
if (isCustomSort)
{
List <Registration> regList = RegistrationList.GetRegistrationList(string.Empty, string.Empty, string.Empty).ToList();
List <EffieJuryManagementApp.Jury> juryList = EffieJuryManagementApp.JuryList.GetJuryList(string.Empty, string.Empty).ToList();
if (sortExpression.Equals("Serial"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Serial select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Serial descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("Country"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Country select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Country descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("Campaign"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Campaign select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Campaign descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("CategoryMarket"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.CategoryMarket select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.CategoryMarket descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("Client"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Client select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Client descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("Panel"))
{
List <Score> sortedfList = new List <Score>();
List <Score> filteredfList = new List <Score>();
List <JuryPanelCategory> pnlCategory = new List <JuryPanelCategory>();
switch (order)
{
case GridSortOrder.Ascending:
{
pnlCategory = JuryPanelCategoryList.GetJuryPanelCategoryList(string.Empty, string.Empty).OrderBy(m => m.PanelId).ToList();
foreach (JuryPanelCategory pnl in pnlCategory)
{
List <Entry> pnlEntries = GeneralFunction.GetEntryListFromCategory(pnl.CategoryPSDetail, round).OrderBy(m => m.CategoryPSDetail).ToList();
sortedfList.AddRange((from entry in pnlEntries
join score in flist on entry.Id equals score.EntryId
select score).ToList());
}
filteredfList.AddRange(sortedfList);
List <Score> preFilteredList = flist.Except(sortedfList).ToList();
preFilteredList = (from score in preFilteredList join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.CategoryPSDetail select score).ToList();
filteredfList.AddRange(preFilteredList);
break;
}
case GridSortOrder.Descending:
{
pnlCategory = JuryPanelCategoryList.GetJuryPanelCategoryList(string.Empty, string.Empty).OrderByDescending(m => m.PanelId).ToList();
foreach (JuryPanelCategory pnl in pnlCategory)
{
List <Entry> pnlEntries = GeneralFunction.GetEntryListFromCategory(pnl.CategoryPSDetail, round).OrderByDescending(m => m.CategoryPSDetail).ToList();
sortedfList.AddRange((from entry in pnlEntries
join mainentry in flist on entry.Id equals mainentry.Id
select mainentry).ToList());
}
filteredfList.AddRange(sortedfList);
List <Score> preFilteredList = flist.Except(sortedfList).ToList();
preFilteredList = (from score in preFilteredList join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.CategoryPSDetail descending select score).ToList();
filteredfList.AddRange(preFilteredList);
break;
}
case GridSortOrder.None:
{
pnlCategory = JuryPanelCategoryList.GetJuryPanelCategoryList(string.Empty, string.Empty).ToList();
foreach (JuryPanelCategory pnl in pnlCategory)
{
List <Entry> pnlEntries = GeneralFunction.GetEntryListFromCategory(pnl.CategoryPSDetail, round);
sortedfList.AddRange((from entry in pnlEntries
join mainentry in flist on entry.Id equals mainentry.Id
select mainentry).ToList());
}
filteredfList.AddRange(sortedfList);
filteredfList.AddRange(flist.Except(sortedfList).ToList());
break;
}
}
flist = filteredfList;
}
else if (sortExpression.Equals("Entrant"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Company select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Company descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("Brand"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Brand select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join entry in sortedEntries on score.EntryId equals entry.Id orderby entry.Brand descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("JuryID"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.SerialNo select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.SerialNo descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("JuryName"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.FirstName, jury.LastName select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.FirstName, jury.LastName descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("JuryTitle"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.Designation select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.Designation descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("JuryCompany"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.Company select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.Company descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("JuryCountry"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.Country select score).ToList();
break;
case GridSortOrder.Descending:
flist = (from score in flist join jury in juryList on score.Juryid equals jury.Id orderby jury.Country descending select score).ToList();
break;
case GridSortOrder.None:
flist = (from score in flist select score).ToList();
break;
}
}
else if (sortExpression.Equals("JuryFlag"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = flist.OrderBy(x => x.Flags).ToList();
break;
case GridSortOrder.Descending:
flist = flist.OrderByDescending(x => x.Flags).ToList();
break;
case GridSortOrder.None:
flist = flist.OrderBy(x => x.Flags).ToList();
break;
}
}
}
else
{
flist = (from score in flist select score).ToList();
}
#endregion
radGridEntry.DataSource = flist;
if (needRebind)
{
radGridEntry.Rebind();
}
GeneralFunction.SetReportDataCache(result);
// hide show checkboxes for certain status
//if (status == StatusEntry.UploadPending || status == StatusEntry.UploadCompleted)
//{
// foreach (GridDataItem item in radGridEntry.Items)
// {
// CheckBox chkbox = (CheckBox)item.FindControl("chkbox");
// if (chkbox != null) chkbox.Visible = true;
// Security.SecureControlByHiding(chkbox);
// }
//}
}
public static IGridColumn <T, TValue> Sortable <T, TValue>(this IGridColumn <T, TValue> column, GridSortOrder firstOrder)
{
column.Sort.FirstOrder = firstOrder;
column.Sort.IsEnabled ??= true;
return(column);
}
private void BindGrid(bool isCustomSort, string sortExpression, GridSortOrder order, bool needRebind)
{
List <Entry> list = GeneralFunction.GetEntryListFromJuryPanel(jury, round);
// filter only completed
List <Entry> slist = new List <Entry>();
foreach (Entry entry in list)
{
if (entry.Status == StatusEntry.Completed)
{
slist.Add(entry);
}
}
// filter
string status = (string)ViewState["TabFilterValue"];
string advanceSearch = (string)ViewState["AdvanceSearch"];
List <Entry> flist = new List <Entry>();
if (advanceSearch == "1")
{
// Advanced search
// basic fields
// user's country
List <Guid> entryIdList = GeneralFunction.GetFilteredEntryListFromRegCountry(ddlCountry.SelectedValue, true);
List <Guid> entryIdList2 = GeneralFunction.GetFilteredEntryListFromRegCompany(txtSearch.Text.Trim(), true);
List <Guid> entryIdList5 = GeneralFunction.GetFilteredEntryListFromJuryPanel(ddlPanel.SelectedValue, round, true);
foreach (Entry item in slist)
{
Score score = GeneralFunction.GetScoreFromMatchingEntryCache(item, jury.Id, round);
// category strip out the prefix
string category = ddlCategory.SelectedValue;
if (category.Length > 3)
{
category = category.Substring(3, category.Length - 3);
}
if (
(ddlScoreStatus.SelectedValue == "" || (ddlScoreStatus.SelectedValue == "1" && score != null && score.IsSubmitted) || (ddlScoreStatus.SelectedValue == "0" && ((score == null) || (score != null && !score.IsSubmitted)))) &&
(ddlRecuse.SelectedValue == "" || (ddlRecuse.SelectedValue == "1" && score != null && (score.IsAdminRecuse || score.IsRecuse)) || (ddlRecuse.SelectedValue == "0" && ((score == null) || (score != null && !score.IsAdminRecuse && !score.IsRecuse)))) &&
//(ddlRecuse.SelectedValue == "" || (ddlRecuse.SelectedValue == "1" && score != null && score.IsAdminRecuse) || (ddlRecuse.SelectedValue == "0" && ((score == null) || (score != null && !score.IsAdminRecuse)))) &&
(category == "" || (category != "" && (item.CategoryPSDetailFromRound(round) == category || GeneralFunction.IsCategoryInCategoryGroup(category, item.CategoryPSDetailFromRound(round))))) &&
(ddlCountry.SelectedValue == "" || (ddlCountry.SelectedValue != "" && entryIdList.Contains(item.Id))) &&
(ddlPanel.SelectedValue == "" || (ddlPanel.SelectedValue != "" && entryIdList5.Contains(item.Id))) &&
(
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entryId") && item.Serial.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "title") && item.Campaign.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1)) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "entrant") && entryIdList2.Contains(item.Id))) ||
(txtSearch.Text.Trim() == "" || (txtSearch.Text.Trim() != "" && (ddlSearch.SelectedValue == "" || ddlSearch.SelectedValue == "client") && item.Client.ToUpper().IndexOf(txtSearch.Text.Trim().ToUpper()) != -1))
)
)
{
flist.Add(item);
}
}
}
else
{
// tab filtering
//if (status == "WDN")
//{
// foreach (Entry item in list)
// if (item.WithdrawnStatus != "") flist.Add(item);
//}
//else
//{
// foreach (Entry item in list)
// if (status == "" || (status != "" && item.Status == status)) flist.Add(item);
//}
flist = slist;
}
// Sort
flist = flist.OrderBy(p => p.Serial).ToList();
#region CustomSorting
if (isCustomSort)
{
List <Registration> regList = RegistrationList.GetRegistrationList(string.Empty, string.Empty, string.Empty).ToList();
if (sortExpression.Equals("Serial"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist orderby entry.Serial select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist orderby entry.Serial descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Country"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Country select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Country descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Campaign"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Campaign descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Client"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.Client descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("CategoryMarket"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket orderby entry.CategoryPSDetail select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby entry.CategoryMarket descending orderby entry.CategoryPSDetail descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Entrant"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Company select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id orderby reg.Company descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist join reg in regList on entry.RegistrationId equals reg.Id select entry).ToList();
break;
}
}
else if (sortExpression.Equals("Brand"))
{
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist orderby entry.Brand select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist orderby entry.Brand descending select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist select entry).ToList();
break;
}
}
else if (sortExpression.Equals("ScoreStatus"))
{
List <Score> scoreList = GeneralFunction.GetAllScoreCache(false).Where(j => j.Juryid.Equals(jury.Id)).ToList();
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist
from score in scoreList
where entry.Id == score.EntryId
orderby score.IsSubmitted, score.IsAdminRecuse, score.IsRecuse
select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist
from score in scoreList
where entry.Id == score.EntryId
orderby score.IsSubmitted, score.IsAdminRecuse, score.IsRecuse descending
select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist select entry).ToList();
break;
}
}
else if (sortExpression.Equals("JuryFlag"))
{
List <Score> scoreList = GeneralFunction.GetAllScoreCache(false).Where(j => j.Juryid.Equals(jury.Id)).ToList();
switch (order)
{
case GridSortOrder.Ascending:
flist = (from entry in flist
from score in scoreList
where entry.Id == score.EntryId
orderby score.Flag
select entry).ToList();
break;
case GridSortOrder.Descending:
flist = (from entry in flist
from score in scoreList
where entry.Id == score.EntryId
orderby score.Flag descending
select entry).ToList();
break;
case GridSortOrder.None:
flist = (from entry in flist select entry).ToList();
break;
}
}
}
else
{
//flist = (from entry in flist orderby entry.Invoice descending, entry.DateCreated descending select entry).ToList();
flist = (from entry in flist orderby entry.GetPanelId(round), entry.CategoryMarket, entry.CategoryPSDetail, entry.Serial select entry).ToList();
}
#endregion
radGridEntry.DataSource = flist;
if (needRebind)
{
radGridEntry.Rebind();
}
GeneralFunction.SetReportDataCache(flist);
// hide show checkboxes for certain status
//if (status == StatusEntry.UploadPending || status == StatusEntry.UploadCompleted)
//{
// foreach (GridDataItem item in radGridEntry.Items)
// {
// CheckBox chkbox = (CheckBox)item.FindControl("chkbox");
// if (chkbox != null) chkbox.Visible = true;
// Security.SecureControlByHiding(chkbox);
// }
//}
}
public virtual IGridColumn <T> InitialSort(GridSortOrder order)
{
InitialSortOrder = order;
return(this);
}
/// <summary>
/// Grid를 정렬합니다.
/// </summary>
protected void DoGridSortCommand(string sortExpression, GridSortOrder gridSortOrder)
{
DoGridSortCommand(sortExpression, gridSortOrder != GridSortOrder.Descending);
}
public static T FirstSort <T>(this T column, GridSortOrder order) where T : IGridColumn
{
column.FirstSortOrder = order;
return(column);
}
public virtual IGridColumn <T> FirstSort(GridSortOrder order)
{
FirstSortOrder = order;
return(this);
}
/// <summary>
/// If set to asc or desc, the column will be sorted in that direction on first
/// sort.Subsequent sorts of the column will toggle as usual (default: null)
/// </summary>
/// <param name="builder">Column Builder</param>
/// <param name="firstSortOrder">First sort order</param>
public static ColumnBuilder FirstSortOrder(this ColumnBuilder builder, GridSortOrder firstSortOrder)
{
builder.CurrentColumn.FirstSortOrder = firstSortOrder;
return builder;
}
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";
}
if (!string.IsNullOrEmpty(txtEmail.Text) || !string.IsNullOrEmpty(txtPhoneNumber.Text))
{
string email = txtEmail.Text.ToLower();
string phoneNumber = txtPhoneNumber.Text.ToLower();
int postTypeId = GetPostTypeId();
gridRoomResult.VirtualItemCount = Business.BusinessMethods.CountPost(postTypeId, null, null, null, null, null, null, phoneNumber, email, null,
null, null, null, null, null, null, null, true);
List <Post> searchResults = Business.BusinessMethods.SearchPostPaging(postTypeId, null, null, null, null, null, null, phoneNumber, email, null,
null, null, null, null, null, null, null, true, gridRoomResult.PageSize, pageNumber, sortExpress, sortExpressInvert);
gridRoomResult.DataSource = searchResults;
}
}
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";
}
gridRoomResult.VirtualItemCount = Business.BusinessMethods.CountNoPricePost();
List <Post> searchResults = Business.BusinessMethods.SearchNoPricePostPaging(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();
}
