public async Task GetStudentTranscriptByPortfolioIdAsync_should_return_expected_value()
{
// Arrange:
var studentNumber = "AP-API-IT";
var studentName = "IntegrationTests, ApplicationPlanner.API";
var dob = "2000/01/01";
var dobParts = dob.Split('/');
var expectedValue = new StudentTranscriptViewModel
{
Id = integrationTestPortfolioId,
UserAccountId = 293945,
AvatarFileName = null,
SchoolCountryType = CC.Common.Enum.CountryType.US,
StudentName = studentName,
StudentId = studentNumber,
ReceivedDateUtc = null
};
// Reset
await _sql.ExecuteAsync("DELETE FROM ApplicationPlanner.Transcript WHERE PortfolioId = @portfolioId", new { portfolioId = integrationTestPortfolioId });
await _sql.ExecuteAsync("DELETE FROM ApplicationPlanner.TranscriptLog WHERE StudentNumber = @studentNumber", new { studentNumber });
// Import a transcript and automatch it to the integration test student
await _qaRepository.ImportTranscriptAsync(integrationTestPortfolioId, integrationTestSchoolId, studentNumber, studentName, dob, "*****@*****.**");
// Act:
var result = await _transcriptRepository.GetStudentTranscriptByPortfolioIdAsync(integrationTestPortfolioId);
// Assert:
Assert.IsTrue(result != null);
Assert.AreEqual(expectedValue.Id, result.Id);
Assert.AreEqual(expectedValue.UserAccountId, result.UserAccountId);
Assert.AreEqual(expectedValue.AvatarFileName, result.AvatarFileName);
Assert.AreEqual(expectedValue.SchoolCountryType, result.SchoolCountryType);
Assert.AreEqual(expectedValue.StudentName, result.StudentName);
Assert.AreEqual(expectedValue.StudentId, result.StudentId);
Assert.IsTrue(result.ReceivedDateUtc != null);
}
