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