public IEnumerable <LineGraphData> GetAllSubscriptions(UserSubscriptionReportsSearchQuery searchQuery)
{
var query = from user in _session.Query <User>()
where user.CreatedOn >= searchQuery.StartDate && user.CreatedOn <= searchQuery.EndDate
group user by new { user.CreatedOn.Year, user.CreatedOn.Month }
into userGroup
orderby userGroup.Key.Year, userGroup.Key.Month
select new
{
userGroup.Key.Month,
userGroup.Key.Year,
Count = userGroup.Count()
};
return(query.Select(arg => new LineGraphData
{
x = new DateTime(arg.Year, arg.Month, 1).ToString("MMM yyyy"),
y = arg.Count
}).ToList());
}
public JsonResult GraphData(UserSubscriptionReportsSearchQuery searchQuery)
{
var data = _userSubscriptionReportsService.GetAllSubscriptions(searchQuery);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ViewResult Index(UserSubscriptionReportsSearchQuery searchQuery)
{
return(View(searchQuery));
}
