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