public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
if (bindingContext == null)
{
throw new ArgumentNullException("bindingContext");
}
_request = controllerContext.HttpContext.Request;
var queryString = GetQueryString();
var kendoGridRequest = new KendoGridMvcRequest
{
Take = queryString.GetQueryValue("take", (int?)null),
Page = queryString.GetQueryValue("page", (int?)null),
Skip = queryString.GetQueryValue("skip", (int?)null),
PageSize = queryString.GetQueryValue("pageSize", (int?)null),
FilterObjectWrapper = FilterHelper.Parse(queryString),
GroupObjects = GroupHelper.Parse(queryString),
AggregateObjects = AggregateHelper.Parse(queryString),
SortObjects = SortHelper.Parse(queryString),
};
return(kendoGridRequest);
}
public void FactMethodName()
{
var nvc = HttpUtility.ParseQueryString(queryString);
var result = GroupHelper.Parse(nvc);
result.PrintDump();
}
public Task BindModelAsync([NotNull] ModelBindingContext bindingContext)
{
if (bindingContext == null)
{
throw new ArgumentNullException(nameof(bindingContext));
}
bool isForm = bindingContext.HttpContext.Request.HasFormContentType &&
bindingContext.HttpContext.Request.Method.ToUpper() == "POST";
var collection = isForm ?
bindingContext.HttpContext.Request.Form as IEnumerable <KeyValuePair <string, StringValues> > :
bindingContext.HttpContext.Request.Query as IEnumerable <KeyValuePair <string, StringValues> >;
var queryString = new NameValueCollection();
foreach (KeyValuePair <string, StringValues> entry in collection)
{
string key = entry.Key;
string value = entry.Value.ToArray().FirstOrDefault();
queryString.Add(key, value);
}
var kendoGridRequest = new KendoGridMvcRequest
{
Take = queryString.GetQueryValue("take", (int?)null),
Page = queryString.GetQueryValue("page", (int?)null),
Skip = queryString.GetQueryValue("skip", (int?)null),
PageSize = queryString.GetQueryValue("pageSize", (int?)null),
FilterObjectWrapper = FilterHelper.Parse(queryString),
GroupObjects = GroupHelper.Parse(queryString),
AggregateObjects = AggregateHelper.Parse(queryString),
SortObjects = SortHelper.Parse(queryString),
};
bindingContext.Result = ModelBindingResult.Success(kendoGridRequest);
return(Task.CompletedTask);
}
public object Any(FindOrders req)
{
var grouping = GroupHelper.Parse(Request.QueryString.ToNameValueCollection());
var sorting = SortHelper.Parse(Request.QueryString.ToNameValueCollection());
var result = Request.GetRequestParams();
if (sorting != null)
{
var first = sorting.First();
if (first.Logic == "and")
{
foreach (var aa in first.Filters)
{
if (aa != null && aa.Any())
{
String sql = "";
var logic = aa.First();
// in case field has space
logic.Field = logic.Field.Replace(" ", "");
if (logic.Operator == "eq")
{
result.Add(logic.Field, logic.Value);
}
else if (logic.Operator == "neq")
{
typeof(KendoGridBaseRequest <SalesOrderDetail>)
.GetProperty(logic.Field + "Temp")
.AddAttributes(new QueryFieldAttribute {
Template = "{Field} != {Value}", Field = logic.Field
});
typeof(KendoGridBaseRequest <SalesOrderDetail>)
.GetProperty(logic.Field + "Temp").SetValue(req, logic.Value);
}
else if (logic.Operator == "startswith")
{
result.Add(logic.Field + "StartsWith", logic.Value);
}
else if (logic.Operator == "contains")
{
result.Add(logic.Field + "Contains", logic.Value);
}
else if (logic.Operator == "doesnotcontain")
{
typeof(KendoGridBaseRequest <SalesOrderDetail>)
.GetProperty(logic.Field + "Temp")
.AddAttributes(new QueryFieldAttribute {
Template = "UPPER({Field}) LIKE %UPPER({Value})%", Field = logic.Field
});
typeof(KendoGridBaseRequest <SalesOrderDetail>)
.GetProperty(logic.Field + "Temp").SetValue(req, logic.Value);
}
else if (logic.Operator == "endswith")
{
result.Add(logic.Field + "EndsWith", logic.Value);
}
}
}
}
else if (first.Logic == "or")
{
}
}
req.AllPrameterDictionary = result;
// return sorting;
//var q = AutoQuery.CreateQuery(req, Request.GetRequestParams());
var q = AutoQuery.CreateQuery(req, req.AllPrameterDictionary);
//q.GroupBy(x=>x.SalesOrderID).
var resultA = AutoQuery.Execute(req, q);
var groupBy = resultA.Results.GroupBy(x => x.SalesOrderID).ToList();
var grouped = groupBy.Skip(req.Skip.GetValueOrDefault(0)).Take(req.Take.GetValueOrDefault(10));
resultA.Total = groupBy.Count();
//project into a kendoGroup and calculate the Aggregate
var groupResponse = new List <KendoGroup>();
foreach (var group in grouped)
{
var sum = @group.Sum(salesOrderDetail => Convert.ToDouble(salesOrderDetail.LineTotal));
foreach (var salesOrderDetail in group)
{
salesOrderDetail.Sum = sum;
}
var aggDic = new Dictionary <string, string>();
aggDic.Add("sum", sum.ToString());
var kendoGroup = new KendoGroup
{
Field = "salesOrderId",
HasSubgroups = false,
Items = group,
Aggregates = aggDic,
Value = group.Key
};
groupResponse.Add(kendoGroup);
}
/* Here is the Sorting happening */
// KendoGridResponse<SalesOrderDetail> response = null;
string data = Request.QueryString.Get("sort[0][field]");
List <SalesOrderDetail> SalesList = null;
if (data != null)
{
string direction = Request.QueryString.Get("sort[0][dir]");
if (direction != null)
{
if (direction == "desc")
{
SalesList = resultA.ConvertTo <KendoGridResponse <SalesOrderDetail> >().Results.OrderBy(data).ToList();
SalesList.Reverse();
}
else
{
SalesList = resultA.ConvertTo <KendoGridResponse <SalesOrderDetail> >().Results.OrderBy(data).ToList();
}
}
}
var response = resultA.ConvertTo <KendoGridResponse <SalesOrderDetail> >();
response.Results = SalesList ?? response.Results;
response.Groups = groupResponse;
return(response);
}
