public static UserEarningsReport Query(int userID, EarningsFilterValues filter)
{
using (var db = new LcDatabase())
{
return(FromDB(db.QuerySingle(sqlQuery, userID, filter.fromDate, filter.toDate, filter.jobTitleID, filter.userExternalListingID)));
}
}
public static UserEarningsReport CccAdminReport(EarningsFilterValues filter)
{
using (var db = new LcDatabase())
{
return(FromDB(db.QuerySingle(sqlCccAdminReport,
filter.fromDate, filter.toDate,
filter.jobTitleID,
filter.platformID,
filter.institutionID,
filter.fieldOfStudyID)));
}
}
public static IEnumerable <DetailedReport> CccAdminDetailedReport(EarningsFilterValues filter, Locale locale)
{
using (var db = new LcDatabase())
{
return(db.Query(sqlCccAdminDetailedReport,
locale.languageID, locale.countryID,
filter.fromDate, filter.toDate,
filter.jobTitleID,
filter.platformID,
filter.institutionID,
filter.fieldOfStudyID)
.Select(DetailedReport.FromDB));
}
}
