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)); } }