public async Task FetchUserDetailsAsync_Valid() { // Arrange string userEmail = "*****@*****.**"; SqlParamsModel queryParams = GetParams_FetchUserDetailsAsync(userEmail); _mockDataAccess.ExecuteAsync(default).ReturnsForAnyArgs(1);
public async Task RetrieveAllAsync_Valid() { // Arrange SqlParamsModel queryParams = GetParams_RetrieveAllAsync(); IEnumerable <ProceedingDecisionModel> expected = GetSampleData(); _mockDataAccess.QueryAsync <ProceedingDecisionModel>(default).ReturnsForAnyArgs(expected);
public async Task RetrieveAllAsync_Valid() { // Arrange SqlParamsModel queryParams = GetParams(); IEnumerable <ActorTypeModel> expected = GetSampleData(); _mockDataAccess.QueryAsync <ActorTypeModel>(default).ReturnsForAnyArgs(expected);
public async Task GetPendingDisposedCountAsync_Valid() { // Arrange int userId = 1; SqlParamsModel queryParams = GetParams_GetPendingDisposedCountAsync(userId); PendingDisposedCountModel expected = GetSampleData_GetPendingDisposedCountAsync(); _mockDataAccess.QueryFirstOrDefaultAsync <PendingDisposedCountModel>(default).ReturnsForAnyArgs(expected);
public async Task RetrievePendingProceedingsAsync_Valid() { // Arrange int userId = 1; SqlParamsModel queryParams = GetParams_RetrievePendingProceedingsAsync(userId); IEnumerable <PendingProceedingModel> expected = GetSampleData_RetrievePendingProceedingsAsync(); _mockDataAccess.QueryAsync <PendingProceedingModel>(default).ReturnsForAnyArgs(expected);
public async Task RetrieveAsync_Valid() { // Arrange int caseId = 1; SqlParamsModel queryParams = GetParams_RetrieveAsync(caseId); CaseDatesModel expected = GetSampleData(caseId); _mockDataAccess.QueryFirstOrDefaultAsync <CaseDatesModel>(default).ReturnsForAnyArgs(expected);
public async Task ExistsCaseNumberAsync_Valid() { // Arrange string caseNumber = "CN1"; int appealNumber = 0; SqlParamsModel queryParams = GetParams_ExistsCaseNumberAsync(caseNumber, appealNumber); _mockDataAccess.ExecuteAsync(default).ReturnsForAnyArgs(0);
public async Task RetrieveAsync_Valid() { // Arrange int caseId = 1; SqlParamsModel queryParams = GetParams_RetrieveAsync(caseId); IEnumerable <CaseActorModel> expected = GetSampleData(caseId); _mockDataAccess.QueryAsync <CaseActorModel>(default).ReturnsForAnyArgs(expected);
public async Task CreateAsync_Valid() { // Arrange NewCourtModel courtModel = new() { CourtName = "ABC" }; SqlParamsModel queryParams = GetParams_CreateAsync(courtModel); _mockDataAccess.ExecuteAsync(default).ReturnsForAnyArgs(1);
public async Task IncrementLoginCountAsync(int userId) { var sqlModel = new SqlParamsModel { Sql = "pkg_auth.p_increment_login_count", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_user_id", userId, dbType: OracleMappingType.Int32, ParameterDirection.Input); await _dataAccess.ExecuteAsync(sqlModel); }
private static SqlParamsModel GetParams_CreateAsync(NewCourtModel courtModel) { var sqlModel = new SqlParamsModel { Sql = "pkg_courts.p_create_new_court", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_court_name", courtModel.CourtName, dbType: OracleMappingType.Varchar2, ParameterDirection.Input); sqlModel.Parameters.Add("po_court_id", dbType: OracleMappingType.Int32, direction: ParameterDirection.Output); return(sqlModel); }
private static SqlParamsModel GetParams_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(sqlModel); }
private static SqlParamsModel GetParams_CreateAsync(NewLocationModel locationModel) { var sqlModel = new SqlParamsModel { Sql = "pkg_locations.p_create_new_location", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_location_name", locationModel.LocationName, dbType: OracleMappingType.Varchar2, ParameterDirection.Input); sqlModel.Parameters.Add("po_location_id", dbType: OracleMappingType.Int32, direction: ParameterDirection.Output); return(sqlModel); }
public async Task <IEnumerable <PlatformModel> > RetrieveAllAsync() { var sqlModel = new SqlParamsModel { Sql = "pkg_platforms.p_get_all_platforms", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryAsync <PlatformModel>(sqlModel)); }
private static SqlParamsModel GetParams_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(sqlModel); }
public async Task DeleteAsync(int userId) { var sqlModel = new SqlParamsModel { Sql = "pkg_app_users.p_delete_user", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_user_id", userId, dbType: OracleMappingType.Int32, ParameterDirection.Input); await _dataAccess.ExecuteAsync(sqlModel); }
public async Task LogoutAsync(int userId, int platformId) { var sqlModel = new SqlParamsModel { Sql = "pkg_auth.p_logout", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_user_id", userId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("pi_platform_id", platformId, dbType: OracleMappingType.Int32, direction: ParameterDirection.Input); await _dataAccess.ExecuteAsync(sqlModel); }
private static SqlParamsModel GetParams_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(sqlModel); }
public async Task UpdateAsync(CaseTypeDetailsModel caseTypeModel) { var sqlModel = new SqlParamsModel { Sql = "pkg_case_types.p_update_case_type", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_case_type_id", caseTypeModel.CaseTypeId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("pi_case_type_name", caseTypeModel.CaseTypeName, dbType: OracleMappingType.Varchar2, ParameterDirection.Input); await _dataAccess.ExecuteAsync(sqlModel); }
public async Task ChangePasswordAsync(int userId, string userPassword) { var sqlModel = new SqlParamsModel { Sql = "pkg_app_users.p_change_password", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_user_id", userId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("pi_user_password", userPassword, dbType: OracleMappingType.Varchar2, ParameterDirection.Input); await _dataAccess.ExecuteAsync(sqlModel); }
public async Task <IEnumerable <UserListItemModel> > RetrieveAllWithRolesAsync(int roles) { var sqlModel = new SqlParamsModel { Sql = "pkg_app_users.p_get_users_with_roles", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_roles", roles, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryAsync <UserListItemModel>(sqlModel)); }
public async Task DeleteAsync(int caseId, int currUser) { var sqlModel = new SqlParamsModel { Sql = "pkg_court_cases.p_delete_case", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_case_id", caseId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("pi_update_by", currUser, dbType: OracleMappingType.Int32, ParameterDirection.Input); await _dataAccess.ExecuteAsync(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 <ProceedingDecisionModel> RetrieveAsync(int proceedingDecisionId) { var sqlModel = new SqlParamsModel { Sql = "pkg_proceeding_decisions.p_get_proceeding_decision_details", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_proceeding_decision_id", proceedingDecisionId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("po_cursor", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output); return(await _dataAccess.QueryFirstOrDefaultAsync <ProceedingDecisionModel>(sqlModel)); }
public async Task CreateAsync_Valid() { // Arrange NewLawyerModel lawyerModel = new() { LawyerEmail = "*****@*****.**", LawyerFullname = "ABC", LawyerAddress = "Earth", LawyerPhone = "1234" }; SqlParamsModel queryParams = GetParams_CreateAsync(lawyerModel); _mockDataAccess.ExecuteAsync(default).ReturnsForAnyArgs(1);
public async Task <byte[]> DownloadAsync(int attachmentId) { var sqlModel = new SqlParamsModel { Sql = "pkg_attachments.p_download_attachment", 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 <byte[]>(sqlModel)); }
public async Task <IEnumerable <CaseProceedingModel> > RetrieveAllCaseProceedingsAsync(int caseId) { var sqlModel = new SqlParamsModel { Sql = "pkg_case_proceedings.p_get_all_case_proceedings", 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 <CaseProceedingModel>(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 <CaseDatesModel> RetrieveAsync(int caseId) { var sqlModel = new SqlParamsModel { Sql = "pkg_case_dates.p_get_case_dates", 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 <CaseDatesModel>(sqlModel)); }
public async Task UpdateAsync(LocationDetailsModel locationModel) { var sqlModel = new SqlParamsModel { Sql = "pkg_locations.p_update_location", Parameters = new OracleDynamicParameters() }; sqlModel.Parameters.Add("pi_location_id", locationModel.LocationId, dbType: OracleMappingType.Int32, ParameterDirection.Input); sqlModel.Parameters.Add("pi_location_name", locationModel.LocationName, dbType: OracleMappingType.Varchar2, ParameterDirection.Input); await _dataAccess.ExecuteAsync(sqlModel); }