C# Class Machete.Service.ReportService

Inheritance: IReportService
ファイルを表示 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_oe property

protected IActivitySigninRepository asRepo
return IActivitySigninRepository

eRepo protected_oe property

protected IEmployerRepository eRepo
return IEmployerRepository

lookCache protected_oe property

protected ILookupCache lookCache
return ILookupCache

lookRepo protected_oe property

protected ILookupRepository lookRepo
return ILookupRepository

wRepo protected_oe property

protected IWorkerRepository wRepo
return IWorkerRepository

waRepo protected_oe property

protected IWorkAssignmentRepository waRepo
return IWorkAssignmentRepository

woRepo protected_oe property

protected IWorkOrderRepository woRepo
return IWorkOrderRepository

wrRepo protected_oe property

protected IWorkerRequestRepository wrRepo
return IWorkerRequestRepository

wsiRepo protected_oe property

protected IWorkerSigninRepository wsiRepo
return IWorkerSigninRepository