public JsonResult GetCustomerReports(int Index, SortPurchase sort) { const int RES_In_PAGE = 25; var res = this._prchSrv.GetByCustomerId(User.Identity.GetUserId()); var entities = res.Entities; var totalRes = res.Entities.Count(); switch (sort) { case SortPurchase.OldToNew: entities = res.Entities.OrderBy(p => p.PurchaseDate) .Take(RES_In_PAGE) .Skip((Index - 1) * RES_In_PAGE) .ToArray(); break; case SortPurchase.NewToOld: entities = res.Entities.OrderByDescending(p => p.PurchaseDate) .Take(RES_In_PAGE) .Skip((Index - 1) * RES_In_PAGE) .ToArray(); break; } return(Json(new { TotalPages = totalRes, entities = entities.Select(p => new PurchaseReportVM { ID = p.PurchaseId, DatePurchased = p.PurchaseDate.ToString("HH:mm yyyy/MM/dd"), MusicName = p.Music.HebrewName, ArtistName = p.Music.Artist.User.UserName, PermissionToString = string.Join(",", p.Permision.PropertyValues.Where(pv => !pv.PermissionProperty.IsCostLevel).Select(pv => pv.Name)), Price = p.PurchaseCost, AgreementFileID = p.PurchaseAgreement?.FileId, ArtistID = p.Music.ArtistID, Musicfile = p.Music.WAVFile }) })); }
public JsonResult GetArtistReports(int Index, SortPurchase sort) { var res = this._prchSrv.GetByArtistId(User.Identity.GetUserId()); return(GetReports(res, Index, sort)); }