C# Class Machete.Service.ReportService

Inheritance: IReportService

Show file Open project: SavageLearning/Machete

Protected Properties

Property	Type	Description
asRepo	IActivitySigninRepository
eRepo	IEmployerRepository
lookCache	ILookupCache
lookRepo	ILookupRepository
wRepo	IWorkerRepository
waRepo	IWorkAssignmentRepository
woRepo	IWorkOrderRepository
wrRepo	IWorkerRequestRepository
wsiRepo	IWorkerSigninRepository

Public Methods

Method	Description
ActivityReportController ( System.DateTime beginDate, System.DateTime endDate, string reportType ) : IEnumerable
AdultsEnrolledAndAssessedInESL ( ) : IQueryable	Returns dates of completion, minutes completed, and the dwccardnum for all adults attending >12hrs. ESL.
ClientProfileEnglishLevel ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileGender ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileHasDisability ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileHomeless ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileHouseholdComposition ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileIncome ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileRaceEthnicity ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileRefugeeImmigrant ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
ClientProfileWorkerAge ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
CountAssignments ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable	Counts work assignments for a given time period.
CountCancelled ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable	Counts cancelled orders for a given time period.
CountSignins ( DateTime beginDate, DateTime endDate ) : IQueryable	A simple count of worker signins for the given period.
CountTypeofDispatch ( DateTime beginDate, DateTime endDate ) : IQueryable	Counts by type of dispatch (DWC, HHH, Propio/ea.). Very Casa Latina specific, but these numbers can also be used by other centers, especially where they have women's programs.
CountUniqueSignins ( DateTime beginDate, DateTime endDate ) : IQueryable	A simple count of unduplicated worker signins for the given period. Note: Casa's policy is that these should reset on beginDate, but that isn't truly "unduplicated" within the program.
DailySumController ( DateTime date ) : IEnumerable	Controller for daily summary report.
EmployerReportController ( DateTime beginDate, DateTime endDate ) : IEnumerable	Jobs and Zip Codes controller. The jobs and zip codes report was initially requested by Mountain View and centers can see what their orders are and where they're coming from.
FamilyHouseholds ( ) : IQueryable
GetAllActivitySignins ( DateTime beginDate, DateTime endDate ) : IQueryable	Returns all activity signins for a given time period grouped by date, activityType and activityName.
HourlyWageAverage ( DateTime beginDate, DateTime endDate ) : IQueryable	Grabs a sum of hours and wages and averages them for a given time period.
ListJobs ( DateTime beginDate, DateTime endDate ) : IQueryable	Lists jobs in order of occurrence for a given time period.
ListJobsByZip ( DateTime beginDate, DateTime endDate ) : IQueryable
ListOrdersByZipCode ( DateTime beginDate, DateTime endDate ) : IQueryable	Lists most popular zip codes for a given time period.
MemberStatusByDate ( DateTime beginDate, DateTime endDate, string unitOfMeasure, int interval ) : IQueryable	Returns a count of new, expired, and still active members by enumerated dates within the given period. This is a resource intensive query, because it targets specific data with daily granularity; this usage can be offset by reducing the interval and increasing the unit of measure.
MonthlySumController ( DateTime beginDate, DateTime endDate ) : IEnumerable
NewWorkerController ( DateTime beginDate, DateTime endDate, string reportType ) : IEnumerable	NewWorkerController returns an IEnumerable containing the counts of single members, new single members, family members, and new family members. It does not include zip code completeness, which must be called separately.
ReportService ( IWorkOrderRepository woRepo, IWorkAssignmentRepository waRepo, IWorkerRepository wRepo, IWorkerSigninRepository wsiRepo, IWorkerRequestRepository wrRepo, ILookupRepository lookRepo, ILookupCache lookCache, IEmployerRepository eRepo, IActivitySigninRepository asRepo ) : Machete.Data
SingleAdults ( ) : IQueryable
WeeklySumController ( DateTime beginDate, DateTime endDate ) : IEnumerable	Controller for weekly summary report.
WorkersInJobs ( DateTime beginDate, DateTime endDate ) : IQueryable
YearlyActController ( DateTime beginDate, DateTime endDate ) : IEnumerable
YearlySumController ( DateTime beginDate, DateTime endDate ) : IEnumerable

Method Details

ActivityReportController() public method

public ActivityReportController ( System.DateTime beginDate, System.DateTime endDate, string reportType ) : IEnumerable
beginDate	System.DateTime
endDate	System.DateTime
reportType	string
return	IEnumerable

AdultsEnrolledAndAssessedInESL() public method

Returns dates of completion, minutes completed, and the dwccardnum for all adults attending >12hrs. ESL.

public AdultsEnrolledAndAssessedInESL ( ) : IQueryable
return	IQueryable

ClientProfileEnglishLevel() public method

public ClientProfileEnglishLevel ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileGender() public method

public ClientProfileGender ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileHasDisability() public method

public ClientProfileHasDisability ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileHomeless() public method

public ClientProfileHomeless ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileHouseholdComposition() public method

public ClientProfileHouseholdComposition ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileIncome() public method

public ClientProfileIncome ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileRaceEthnicity() public method

public ClientProfileRaceEthnicity ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileRefugeeImmigrant() public method

public ClientProfileRefugeeImmigrant ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

ClientProfileWorkerAge() public method

public ClientProfileWorkerAge ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

CountAssignments() public method

Counts work assignments for a given time period.

public CountAssignments ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

CountCancelled() public method

Counts cancelled orders for a given time period.

public CountCancelled ( System.DateTime beginDate, System.DateTime endDate ) : IQueryable
beginDate	System.DateTime
endDate	System.DateTime
return	IQueryable

CountSignins() public method

A simple count of worker signins for the given period.

public CountSignins ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

CountTypeofDispatch() public method

Counts by type of dispatch (DWC, HHH, Propio/ea.). Very Casa Latina specific, but these numbers can also be used by other centers, especially where they have women's programs.

public CountTypeofDispatch ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

CountUniqueSignins() public method

A simple count of unduplicated worker signins for the given period. Note: Casa's policy is that these should reset on beginDate, but that isn't truly "unduplicated" within the program.

public CountUniqueSignins ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime	DateTime, not null
endDate	DateTime	DateTime, null
return	IQueryable

DailySumController() public method

Controller for daily summary report.

public DailySumController ( DateTime date ) : IEnumerable
date	DateTime
return	IEnumerable

EmployerReportController() public method

Jobs and Zip Codes controller. The jobs and zip codes report was initially requested by Mountain View and centers can see what their orders are and where they're coming from.

public EmployerReportController ( DateTime beginDate, DateTime endDate ) : IEnumerable
beginDate	DateTime
endDate	DateTime
return	IEnumerable

FamilyHouseholds() public method

public FamilyHouseholds ( ) : IQueryable
return	IQueryable

GetAllActivitySignins() public method

Returns all activity signins for a given time period grouped by date, activityType and activityName.

public GetAllActivitySignins ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

HourlyWageAverage() public method

Grabs a sum of hours and wages and averages them for a given time period.

public HourlyWageAverage ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime	Start date for the query.
endDate	DateTime	End date for the query.
return	IQueryable

ListJobs() public method

Lists jobs in order of occurrence for a given time period.

public ListJobs ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

ListJobsByZip() public method

public ListJobsByZip ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

ListOrdersByZipCode() public method

Lists most popular zip codes for a given time period.

public ListOrdersByZipCode ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

MemberStatusByDate() public method

Returns a count of new, expired, and still active members by enumerated dates within the given period. This is a resource intensive query, because it targets specific data with daily granularity; this usage can be offset by reducing the interval and increasing the unit of measure.

public MemberStatusByDate ( DateTime beginDate, DateTime endDate, string unitOfMeasure, int interval ) : IQueryable
beginDate	DateTime
endDate	DateTime
unitOfMeasure	string	The unit of time to measure; "days" or "months".
interval	int	The interval of time (7 days, 3 months) as int
return	IQueryable

MonthlySumController() public method

public MonthlySumController ( DateTime beginDate, DateTime endDate ) : IEnumerable
beginDate	DateTime
endDate	DateTime
return	IEnumerable

NewWorkerController() public method

NewWorkerController returns an IEnumerable containing the counts of single members, new single members, family members, and new family members. It does not include zip code completeness, which must be called separately.

public NewWorkerController ( DateTime beginDate, DateTime endDate, string reportType ) : IEnumerable
beginDate	DateTime
endDate	DateTime
reportType	string
return	IEnumerable

ReportService() public method

public ReportService ( IWorkOrderRepository woRepo, IWorkAssignmentRepository waRepo, IWorkerRepository wRepo, IWorkerSigninRepository wsiRepo, IWorkerRequestRepository wrRepo, ILookupRepository lookRepo, ILookupCache lookCache, IEmployerRepository eRepo, IActivitySigninRepository asRepo ) : Machete.Data
woRepo	IWorkOrderRepository
waRepo	IWorkAssignmentRepository
wRepo	IWorkerRepository
wsiRepo	IWorkerSigninRepository
wrRepo	IWorkerRequestRepository
lookRepo	ILookupRepository
lookCache	ILookupCache
eRepo	IEmployerRepository
asRepo	IActivitySigninRepository
return	Machete.Data

SingleAdults() public method

public SingleAdults ( ) : IQueryable
return	IQueryable

WeeklySumController() public method

Controller for weekly summary report.

public WeeklySumController ( DateTime beginDate, DateTime endDate ) : IEnumerable
beginDate	DateTime
endDate	DateTime
return	IEnumerable

WorkersInJobs() public method

public WorkersInJobs ( DateTime beginDate, DateTime endDate ) : IQueryable
beginDate	DateTime
endDate	DateTime
return	IQueryable

YearlyActController() public method

public YearlyActController ( DateTime beginDate, DateTime endDate ) : IEnumerable
beginDate	DateTime
endDate	DateTime
return	IEnumerable

YearlySumController() public method

public YearlySumController ( DateTime beginDate, DateTime endDate ) : IEnumerable
beginDate	DateTime
endDate	DateTime
return	IEnumerable

Property Details

asRepo protected property

protected IActivitySigninRepository asRepo
return	IActivitySigninRepository

eRepo protected property

protected IEmployerRepository eRepo
return	IEmployerRepository

lookCache protected property

protected ILookupCache lookCache
return	ILookupCache

lookRepo protected property

protected ILookupRepository lookRepo
return	ILookupRepository

wRepo protected property

protected IWorkerRepository wRepo
return	IWorkerRepository

waRepo protected property

protected IWorkAssignmentRepository waRepo
return	IWorkAssignmentRepository

woRepo protected property

protected IWorkOrderRepository woRepo
return	IWorkOrderRepository

wrRepo protected property

protected IWorkerRequestRepository wrRepo
return	IWorkerRequestRepository

wsiRepo protected property

protected IWorkerSigninRepository wsiRepo
return	IWorkerSigninRepository