/// <summary>
/// Sort by column with order method.
/// </summary>
/// <param name="order">Order parameter</param>
/// <param name="orderDir">Order direction parameter</param>
/// <param name="data">Data parameter</param>
/// <returns>Returns - Data</returns>
///
//ToDo-add hard coded var
public IQueryable <UnscPerTransactionDTO> SortByColumnWithOrder(IQueryable <UnscPerTransactionDTO> dataQuery, Helpers.SortingPagingInfo sortingPagingInfo)
{
if (sortingPagingInfo != null)
{
// Sorting
string orderDir = sortingPagingInfo.SortDirection;
switch (sortingPagingInfo.SortField)
{
case "Loc":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.Loc)
: dataQuery.OrderBy(p => p.Loc);
break;
case "LocName":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.LocName)
: dataQuery.OrderBy(p => p.LocName);
break;
case "LocQTIDesc":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.LocQTIDesc)
: dataQuery.OrderBy(p => p.LocQTIDesc);
break;
case "PostingDate":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.PostingDate)
: dataQuery.OrderBy(p => p.PostingDate);
break;
case "EffectiveGasDay":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.EffectiveGasDay)
: dataQuery.OrderBy(p => p.EffectiveGasDay);
break;
case "EndingEffectiveDay":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.EndingEffectiveDay)
: dataQuery.OrderBy(p => p.EndingEffectiveDay);
break;
case "MeasBasisDesc":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.MeasBasisDesc)
: dataQuery.OrderBy(p => p.MeasBasisDesc);
break;
case "LocZn":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.LocZn)
: dataQuery.OrderBy(p => p.LocZn);
break;
case "UnsubscribeCapacity":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.UnsubscribeCapacity)
: dataQuery.OrderBy(p => p.UnsubscribeCapacity);
break;
case "ChangePercentage":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.ChangePercentage)
: dataQuery.OrderBy(p => p.ChangePercentage);
break;
default:
dataQuery = dataQuery.OrderByDescending(p => p.CreatedDate);
break;
}
}
else
{
return(dataQuery);
}
return(dataQuery);
}
/// <summary>
/// Sort by column with order method.
/// </summary>
/// <param name="order">Order parameter</param>
/// <param name="orderDir">Order direction parameter</param>
/// <param name="data">Data parameter</param>
/// <returns>Returns - Data</returns>
public IQueryable <OACYPerTransactionDTO> SortByColumnWithOrder(IQueryable <OACYPerTransactionDTO> dataQuery, Helpers.SortingPagingInfo sortingPagingInfo)
{
if (sortingPagingInfo != null)
{
// Sorting
string orderDir = sortingPagingInfo.SortDirection;
switch (sortingPagingInfo.SortField)
{
case "Loc":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.Loc)
: dataQuery.OrderBy(p => p.Loc);
break;
case "LocName":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.LocName)
: dataQuery.OrderBy(p => p.LocName);
break;
case "CycleIndicator":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.CycleIndicator)
: dataQuery.OrderBy(p => p.CycleIndicator);
break;
case "DesignCapacity":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.DesignCapacity)
: dataQuery.OrderBy(p => p.DesignCapacity);
break;
case "OperatingCapacity":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.OperatingCapacity)
: dataQuery.OrderBy(p => p.OperatingCapacity);
break;
case "TotalScheduleQty":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.TotalScheduleQty)
: dataQuery.OrderBy(p => p.TotalScheduleQty);
break;
case "OperationallyAvailableQty":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.OperationallyAvailableQty)
: dataQuery.OrderBy(p => p.OperationallyAvailableQty);
break;
case "AvailablePercentage":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.AvailablePercentage)
: dataQuery.OrderBy(p => p.AvailablePercentage);
break;
case "EffectiveGasDay":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.EffectiveGasDay)
: dataQuery.OrderBy(p => p.EffectiveGasDay);
break;
case "PostingDate":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.PostingDate)
: dataQuery.OrderBy(p => p.PostingDate);
break;
case "FlowIndicator":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.FlowIndicator)
: dataQuery.OrderBy(p => p.FlowIndicator);
break;
case "LocQTIDesc":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.LocQTIDesc)
: dataQuery.OrderBy(p => p.LocQTIDesc);
break;
case "MeasurementBasis":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.MeasurementBasis)
: dataQuery.OrderBy(p => p.MeasurementBasis);
break;
case "ITIndicator":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.ITIndicator)
: dataQuery.OrderBy(p => p.ITIndicator);
break;
case "AllQtyAvailableIndicator":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.AllQtyAvailableIndicator)
: dataQuery.OrderBy(p => p.AllQtyAvailableIndicator);
break;
default:
dataQuery = dataQuery.OrderByDescending(p => p.CreatedDate);
break;
}
}
else
{
return(dataQuery);
}
return(dataQuery);
}
/// <summary>
/// Sort by column with order method.
/// </summary>
/// <param name="order">Order parameter</param>
/// <param name="orderDir">Order direction parameter</param>
/// <param name="data">Data parameter</param>
/// <returns>Returns - Data</returns>
public IQueryable <SwntPerTransaction> SortByColumnWithOrder(IQueryable <SwntPerTransaction> dataQuery, Helpers.SortingPagingInfo sortingPagingInfo)
{
if (sortingPagingInfo != null)
{
// Sorting
string orderDir = sortingPagingInfo.SortDirection;
switch (sortingPagingInfo.SortField)
{
case "NoticeTypeDesc1":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.NoticeTypeDesc1)
: dataQuery.OrderBy(p => p.NoticeTypeDesc1);
break;
case "NoticeId":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.NoticeId)
: dataQuery.OrderBy(p => p.NoticeId);
break;
case "PostingDateTime":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.PostingDateTime)
: dataQuery.OrderBy(p => p.PostingDateTime);
break;
case "NoticeEffectiveDateTime":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.NoticeEffectiveDateTime)
: dataQuery.OrderBy(p => p.NoticeEffectiveDateTime);
break;
case "NoticeEndDateTime":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.NoticeEndDateTime)
: dataQuery.OrderBy(p => p.NoticeEndDateTime);
break;
case "Subject":
dataQuery = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? dataQuery.OrderByDescending(p => p.Subject)
: dataQuery.OrderBy(p => p.Subject);
break;
default:
dataQuery = dataQuery.OrderByDescending(p => p.PostingDateTime);
break;
}
}
else
{
return(dataQuery);
}
return(dataQuery);
}
