public IActionResult CreateReport(string FromDate, string ToDate) { FinancialDto model = new FinancialDto(); model.ViewReportList = new List <FinancialDto>(); try { var obj = _membershipService.GetAll().Where(x => x.CreatedDate >= Convert.ToDateTime(FromDate) && x.CreatedDate <= Convert.ToDateTime(ToDate) && x.IsActive == true && x.IsDelete == false).GroupBy(x => x.MemberShipTypeId).Select(x => new { MemberShipType = _subscriptionTypeService.GetSingle(a => a.Id == x.Key).TypeId, MembershipTypeCount = x.Count(), PriceTotal = x.Sum(y => _subscriptionTypeService.GetSingle(x => x.Id == y.MemberShipTypeId).Price) }).ToList(); model.FromDate = Convert.ToDateTime(FromDate); model.ToDate = Convert.ToDateTime(ToDate); foreach (var item in obj) { var data = new FinancialDto(); data.totalPerson = item.MembershipTypeCount; data.totalAmount = item.PriceTotal; data.MemberShipTypes = item.MemberShipType; model.ViewReportList.Add(data); } return(View("viewReportMembership", model)); } catch (Exception e) { return(null); } }
public IActionResult viewReportMembership(FinancialDto model) { return(View(model)); }