public IEnumerable <OverViewDataRow> SpData(CC.Data.ccEntities db, CC.Data.Services.IPermissionsBase permissions)
{
var data = db.spFinancialSummarySummary(this.CurId, this.StartDate, this.EndDate
, !this.IncludeNotSubmittedReports
, !this.HideEstimatedAmounts
, this.AgencyId
, this.RegionId
, this.CountryId
, this.StateId
, this.ServiceTypeId
, this.ServiceId
, this.MasterFundId
, this.FundId
, this.AppId
, this.ClientId
, this.sSearch
, this.sSortCol_0
, this.sSortDir_0 == "asc"
, this.iDisplayLength == int.MaxValue ? int.MaxValue : this.iDisplayLength + 1
, this.iDisplayStart
, permissions.User.Id);
return(data.Select(f => new OverViewDataRow
{
ServiceTypeName = f.ServiceType,
ServiceName = f.Service,
FundName = f.Fund,
AppName = f.App,
Quantity = f.Quantity,
Amount = f.Amount,
ClientsCount = f.ClientsCount,
AverageCostPerClient = f.AverageCostPerClient,
AverageCostPerUnit = f.AverageCostPerUnit,
MasterFundName = f.MasterFund,
CcGrant = f.CcGrant,
Cur = this.CurId,
ServiceId = f.ServiceId,
AppId = f.AppId
}).ToList());
}
