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