funky gifts

funky.cs

   var completed = RepositoryFactory.GiftRepository.Queryable.Where(x => x.IsCompleted).ToArray();

            var trans = await
                _givingFinancialService.GetKfsAccountDetails(
                    completed.Select(c => new KfsAccountQueryParams {KfsKey = c.KfsKey}).ToArray());

            var grouped = trans.GroupBy(t => t.KfsKey).Select(t => new {t.Key, total = t.Sum(x => x.Amount)});

            var joined = from c in completed
                join g in grouped on c.KfsKey equals g.Key
                where c.Total != g.total
                select new {c.KfsKey, c.Total, c.Id, g.total};
               
            return new JsonNetResult(joined.ToArray());