public async Task <IEnumerable <UserListItemModel> > RetrieveAllAsync() { var sqlModel = new SqlParamsModel { Sql = "pkg_app_users.p_get_all_users", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryAsync <UserListItemModel>(sqlModel)); }
public async Task <IEnumerable <PendingProceedingModel> > RetrievePendingProceedingsAsync(int userId) { var sqlModel = new SqlParamsModel { Sql = "pkg_case_proceedings.p_get_pending_proceedings", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_user_id", userId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryAsync <PendingProceedingModel>(sqlModel)); }
public async Task <IEnumerable <ParameterisedReportModel> > GetParameterisedReportAsync(ReportFilterModel filterModel) { var sqlModel = new SqlParamsModel { Sql = "pkg_insights.p_parameterised_report", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_csv_filter_params", filterModel.Csv, dbType: OracleMappingType.Varchar2, ParameterDirection.Input); sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryAsync <ParameterisedReportModel>(sqlModel)); }
public async Task <IEnumerable <CaseActorModel> > RetrieveAsync(int caseId) { var sqlModel = new SqlParamsModel { Sql = "pkg_case_actors.p_get_all_case_actors", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_case_id", caseId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryAsync <CaseActorModel>(sqlModel)); }
public async Task <IEnumerable <ActorTypeModel> > RetrieveAllAsync() { var sqlModel = new SqlParamsModel { Sql = "pkg_actor_types.p_get_all_actor_types", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); var data = await _dataAccess.QueryAsync <ActorTypeModel>(sqlModel); return(data); }