public async Task <CaseStatusModel> GetCaseStatusAsync(int caseId)
{
var sqlModel = new SqlParamsModel
{
Sql = "pkg_court_cases.p_get_case_status",
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.QueryFirstOrDefaultAsync <CaseStatusModel>(sqlModel));
}
public async Task <AttachmentItemModel> RetrieveAsync(int attachmentId)
{
var sqlModel = new SqlParamsModel
{
Sql = "pkg_attachments.p_get_attachment_details",
Parameters = new OracleDynamicParameters()
};
sqlModel.Parameters.Add("pi_attachment_id", attachmentId, dbType: OracleMappingType.Int32, ParameterDirection.Input);
sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);
return(await _dataAccess.QueryFirstOrDefaultAsync <AttachmentItemModel>(sqlModel));
}
public async Task <PendingDisposedCountModel> GetPendingDisposedCountAsync(int userId)
{
var sqlModel = new SqlParamsModel
{
Sql = "pkg_insights.p_pending_disposed_cases",
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.QueryFirstOrDefaultAsync <PendingDisposedCountModel>(sqlModel));
}
public async Task <CaseProceedingModel> RetrieveAsync(int caseProceedingId)
{
var sqlModel = new SqlParamsModel
{
Sql = "pkg_case_proceedings.p_get_proceeding_details",
Parameters = new OracleDynamicParameters()
};
sqlModel.Parameters.Add("pi_case_proceeding_id", caseProceedingId, dbType: OracleMappingType.Int32, ParameterDirection.Input);
sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);
return(await _dataAccess.QueryFirstOrDefaultAsync <CaseProceedingModel>(sqlModel));
}
