public ActionResult GetProfits() { EarninisRecordsViewModel model = new EarninisRecordsViewModel(); if (Members.IsLoggedIn()) { IContentType ct = Services.ContentTypeService.GetContentType("EarningsRecordsElement"); IEnumerable <IContent> result = Services.ContentService.GetContentOfContentType(ct.Id).Where(e => e.GetValue <int>("memberId") == Members.GetCurrentMemberId()); if (result != null && result.Count() > 0) { var groupkeys = result.OrderByDescending(e => e.CreateDate) .GroupBy(e => e.CreateDate.ToString("MM/dd")) .Take(7) .Select(e => new { Key = e.Key, Value = e.Sum(a => a.GetValue <decimal>("earning")) }); foreach (var item in groupkeys.OrderBy(e => Convert.ToDateTime(e.Key))) { model.Times.Add(item.Key); model.Datas.Add(item.Value); } } } return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult GetProfitsByProductId(int id) { int memberId = 0; EarninisRecordsViewModel model = new EarninisRecordsViewModel(); if (int.TryParse(SystemSettingsHelper.GetSystemSettingsByKey("show:accountId"), out memberId)) { IContentType ct = Services.ContentTypeService.GetContentType("EarningsRecordsElement"); IEnumerable <IContent> result = Services.ContentService.GetContentOfContentType(ct.Id) .Where(e => e.GetValue <int>("memberId") == memberId) .Where(e => e.GetValue <int>("productid") == id); if (result != null && result.Count() > 0) { var groupkeys = result.OrderByDescending(e => e.CreateDate) .GroupBy(e => e.CreateDate.ToString("MM/dd")) .Select(e => new { Key = e.Key, Value = e.Sum(a => a.GetValue <decimal>("earning")) }); foreach (var item in groupkeys.OrderBy(e => Convert.ToDateTime(e.Key))) { model.Times.Add(item.Key); model.Datas.Add(item.Value); } } } return(Json(model, JsonRequestBehavior.AllowGet)); }