public async Task SavedSchoolsByPortfolioIdAsync_should_return_all_saved_schools() { // Arrange: var expectedValue = new TranscriptInstitutionModel { InunId = "5000", Name = "Abilene Christian University", ImageName = "school-406.jpg", City = "Abilene", StateProvCode = "TX", StateProvName = "Texas" }; // 1. Delete All Saved Schools await _sql.ExecuteAsync("DELETE FROM Student.EducationSchool WHERE PortfolioId = @portfolioId", new { portfolioId = integrationTestPortfolioId }); // 2. Add a saved School await _sql.ExecuteAsync("INSERT INTO Student.EducationSchool (EducationSchoolId, PortfolioId) VALUES (406, @portfolioId)", new { portfolioId = integrationTestPortfolioId }); // Act: var result = (await _institutionRepository.SavedSchoolsByPortfolioIdAsync(integrationTestPortfolioId, 2)).ToList(); // Assert: Assert.IsTrue(result.Count == 1); Assert.IsTrue(expectedValue.InunId == result[0].InunId); Assert.IsTrue(expectedValue.Name == result[0].Name); Assert.IsTrue(expectedValue.ImageName == result[0].ImageName); Assert.IsTrue(expectedValue.City == result[0].City); Assert.IsTrue(expectedValue.StateProvCode == result[0].StateProvCode); Assert.IsTrue(expectedValue.StateProvName == result[0].StateProvName); }
public SavedSchool() { Institution = new TranscriptInstitutionModel(); }