public ServerSide()
{
DTResult = new DTResult <T>();
DTParameters = new DTParameters();
DTOrder = new DTOrder();
DTOrderDir = new DTOrderDir();
}
private IEnumerable <EmployeeItem> EmployeeDataOrder(string column, DTOrderDir dir, IEnumerable <EmployeeItem> data)
{
switch (column)
{
case "EmployeeId": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.EMPLOYEE_ID).ToList() : data.OrderByDescending(x => x.EMPLOYEE_ID).ToList());
case "FormalName": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.FORMAL_NAME).ToList() : data.OrderByDescending(x => x.FORMAL_NAME).ToList());
case "PositionTitle": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.POSITION_TITLE).ToList() : data.OrderByDescending(x => x.POSITION_TITLE).ToList());
case "Division": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.DIVISON).ToList() : data.OrderByDescending(x => x.DIVISON).ToList());
case "Directorate": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.DIRECTORATE).ToList() : data.OrderByDescending(x => x.DIRECTORATE).ToList());
case "Address": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.ADDRESS).ToList() : data.OrderByDescending(x => x.ADDRESS).ToList());
case "City": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.CITY).ToList() : data.OrderByDescending(x => x.CITY).ToList());
case "BaseTown": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.BASETOWN).ToList() : data.OrderByDescending(x => x.BASETOWN).ToList());
case "Company": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.COMPANY).ToList() : data.OrderByDescending(x => x.COMPANY).ToList());
case "CostCenter": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.COST_CENTER).ToList() : data.OrderByDescending(x => x.COST_CENTER).ToList());
case "GroupLevel": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.GROUP_LEVEL).ToList() : data.OrderByDescending(x => x.GROUP_LEVEL).ToList());
case "EmailAddress": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.EMAIL_ADDRESS).ToList() : data.OrderByDescending(x => x.EMAIL_ADDRESS).ToList());
case "FlexPoint": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.FLEX_POINT).ToList() : data.OrderByDescending(x => x.FLEX_POINT).ToList());
}
return(null);
}
private IEnumerable <FleetItem> FleetDataOrder(string column, DTOrderDir dir, IEnumerable <FleetItem> data)
{
switch (column)
{
case "VehicleType": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.VehicleType).ToList() : data.OrderByDescending(x => x.VehicleType).ToList());
case "VehicleUsage": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.VehicleUsage).ToList() : data.OrderByDescending(x => x.VehicleUsage).ToList());
case "SupplyMethod": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.SupplyMethod).ToList() : data.OrderByDescending(x => x.SupplyMethod).ToList());
case "BodyType": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.BodyType).ToList() : data.OrderByDescending(x => x.BodyType).ToList());
}
return(null);
}
private IEnumerable <FuelOdometerItem> FuelOdometerDataOrder(string column, DTOrderDir dir, IEnumerable <FuelOdometerItem> data)
{
switch (column)
{
case "VehicleType": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.VehicleType).ToList() : data.OrderByDescending(x => x.VehicleType).ToList());
case "LastKM": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.LastKM).ToList() : data.OrderByDescending(x => x.LastKM).ToList());
case "CostCenter": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.CostCenter).ToList() : data.OrderByDescending(x => x.CostCenter).ToList());
case "EcsRmbTransId": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.EcsRmbTransId).ToList() : data.OrderByDescending(x => x.EcsRmbTransId).ToList());
}
return(null);
}
private IEnumerable <MaterialDetails> MaterialDataOrder(string column, DTOrderDir dir, IEnumerable <MaterialDetails> data)
{
switch (column)
{
case "PlantName": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.PlantName).ToList() : data.OrderByDescending(x => x.PlantName).ToList());
case "MaterialNumber": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.MaterialNumber).ToList() : data.OrderByDescending(x => x.MaterialNumber).ToList());
case "GoodTypeName": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.GoodTypeName).ToList() : data.OrderByDescending(x => x.GoodTypeName).ToList());
case "UomName": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.UomName).ToList() : data.OrderByDescending(x => x.UomName).ToList());
case "PlantDeletion": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.PlantDeletion).ToList() : data.OrderByDescending(x => x.PlantDeletion).ToList());
case "ClientDeletion": return(dir == DTOrderDir.ASC ? data.OrderBy(x => x.ClientDeletion).ToList() : data.OrderByDescending(x => x.ClientDeletion).ToList());
}
return(null);
}
public static IEnumerable <T> OrderBy <T>(this IQueryable <T> query, string name, DTOrderDir direction)
{
var propInfo = GetPropertyInfo(typeof(T), name);
var expr = GetOrderExpression(typeof(T), propInfo);
var sortDir = direction == DTOrderDir.ASC ? "OrderBy" : "OrderByDescending";
var method = typeof(Enumerable).GetMethods().FirstOrDefault(m => m.Name == sortDir && m.GetParameters().Length == 2);
var genericMethod = method.MakeGenericMethod(typeof(T), propInfo.PropertyType);
return((IEnumerable <T>)genericMethod.Invoke(null, new object[] { query, expr.Compile() }));
}
public Order(String column, DTOrderDir dir)
{
Column = column;
Dir = dir;
}
