public async Task GetSubmissionWithEntries_GetsFromDb()
{
// Arrange
ImageEntity imageEntity = EntitiesHelper.GetImage();
var lCreatedEntity = await submissionRepository.Add(new Entities.SubmissionEntity {
Notes = "test", SalonYear = EntitiesHelper.GetSalonYear(), Person = EntitiesHelper.GetPerson(),
Entries = new List <CompetitionEntryEntity>
{
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
IsAccepted = true,
IsAwarded = false,
Score = 50
},
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
}
}
});
// Act
var lResult = await submissionRepository.GetSubmissionWithEntries(lCreatedEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.Id > 0);
Assert.AreEqual("test", lResult.Notes);
Assert.AreEqual(2, lResult.Entries.Count);
}
public async Task GetSectionsBySalonYearSectionTypeIds_GetsFromDb()
{
// Arrange
var salonYear = EntitiesHelper.GetSalonYear();
var sectionType1 = EntitiesHelper.GetSectionType();
var sectionType2 = EntitiesHelper.GetSectionType();
var lCreatedEntity1 = await sectionRepository.Add(new Entities.SectionEntity {
SalonYear = salonYear, SectionType = sectionType1
});
var lCreatedEntity2 = await sectionRepository.Add(new Entities.SectionEntity {
SalonYear = salonYear, SectionType = sectionType2
});
var lCreatedEntity3 = await sectionRepository.Add(new Entities.SectionEntity {
SalonYear = EntitiesHelper.GetSalonYear(), SectionType = sectionType2
});
var lCreatedEntity4 = await sectionRepository.Add(new Entities.SectionEntity {
SalonYear = salonYear, SectionType = EntitiesHelper.GetSectionType()
});
// Act
var lResult = await sectionRepository.GetSectionsBySalonYearSectionTypeIds(salonYear.Id, new List <int> {
sectionType1.Id, sectionType2.Id
});
// Assert
Assert.IsNotNull(lResult);
Assert.AreEqual(2, lResult.Count);
}
public async Task UpdateSubmission_SetsNameAndEntryInDb()
{
// Arrange
ImageEntity imageEntity = EntitiesHelper.GetImage();
var lCreatedEntity = await submissionRepository.Add(new Entities.SubmissionEntity
{
Notes = "test",
SalonYear = EntitiesHelper.GetSalonYear(),
Person = EntitiesHelper.GetPerson(),
Entries = new List <CompetitionEntryEntity>
{
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
IsAccepted = true,
IsAwarded = false,
Score = 50
},
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
}
}
});
lCreatedEntity.Notes = "fred";
lCreatedEntity.Entries[0].IsAwarded = true;
lCreatedEntity.Entries[0].Score = 100;
lCreatedEntity.Entries[1].IsAccepted = false;
lCreatedEntity.Entries[1].IsAwarded = false;
lCreatedEntity.Entries[1].Score = 20;
// Act
await submissionRepository.Update(lCreatedEntity);
// Assert
var lResult = await submissionRepository.GetSubmissionWithEntries(lCreatedEntity.Id);
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.Id > 0);
Assert.AreEqual("fred", lResult.Notes);
Assert.AreEqual(100, lResult.Entries[0].Score);
Assert.AreEqual(true, lResult.Entries[0].IsAccepted);
Assert.AreEqual(true, lResult.Entries[0].IsAwarded);
Assert.AreEqual(20, lResult.Entries[1].Score);
Assert.AreEqual(false, lResult.Entries[1].IsAccepted);
Assert.AreEqual(false, lResult.Entries[1].IsAwarded);
}
public async Task GetSection_GetsFromDb()
{
// Arrange
var lCreatedEntity = await sectionRepository.Add(new Entities.SectionEntity {
SalonYear = EntitiesHelper.GetSalonYear(), SectionType = EntitiesHelper.GetSectionType()
});
// Act
var lResult = await sectionRepository.GetById(lCreatedEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.Id > 0);
}
public async Task GetSubmission_GetsFromDb()
{
// Arrange
var lCreatedEntity = await submissionRepository.Add(new Entities.SubmissionEntity {
Notes = "test", SalonYear = EntitiesHelper.GetSalonYear(), Person = EntitiesHelper.GetPerson()
});
// Act
var lResult = await submissionRepository.GetById(lCreatedEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.Id > 0);
Assert.AreEqual("test", lResult.Notes);
}
public async Task DeleteSubmission_RemovesFromDb()
{
// Arrange
var lCreatedEntity = await submissionRepository.Add(new Entities.SubmissionEntity {
Notes = "test", SalonYear = EntitiesHelper.GetSalonYear(), Person = EntitiesHelper.GetPerson()
});
// Act
await submissionRepository.Delete(lCreatedEntity);
// Assert
var lResult = await submissionRepository.GetById(lCreatedEntity.Id);
Assert.IsNull(lResult);
Assert.IsTrue(lCreatedEntity.Id > 0);
}
public async Task GetAccreditation_GetsFromDb()
{
// Arrange
var lCreatedEntity = await accreditationRepository.Add(new Entities.AccreditationEntity {
SalonNumber = "test", SalonYear = EntitiesHelper.GetSalonYear(), PhotoOrganisation = new PhotoOrganisationEntity {
Name = "org1"
}
});
// Act
var lResult = await accreditationRepository.GetById(lCreatedEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.Id > 0);
Assert.AreEqual("test", lResult.SalonNumber);
}
public async Task DeleteAccreditation_RemovesFromDb()
{
// Arrange
var lCreatedEntity = await accreditationRepository.Add(new Entities.AccreditationEntity {
SalonNumber = "test", SalonYear = EntitiesHelper.GetSalonYear(), PhotoOrganisation = new PhotoOrganisationEntity {
Name = "org1"
}
});
// Act
await accreditationRepository.Delete(lCreatedEntity);
// Assert
var lResult = await accreditationRepository.GetById(lCreatedEntity.Id);
Assert.IsNull(lResult);
Assert.IsTrue(lCreatedEntity.Id > 0);
}
public async Task GetWithSubmissionsSalonsAccreditationSections_GetsFromDb()
{
// Arrange
var lSalonYear = EntitiesHelper.GetSalonYear();
lSalonYear.Accreditations = new List <AccreditationEntity> {
new AccreditationEntity {
SalonNumber = "test", PhotoOrganisation = EntitiesHelper.GetPhotoOrganisation()
}
};
var lSection = EntitiesHelper.GetSection();
lSection.SalonYear = lSalonYear;
var lSubmission = new SubmissionEntity {
SalonYear = lSalonYear, Entries = new List <CompetitionEntryEntity> {
new CompetitionEntryEntity {
Image = EntitiesHelper.GetImage(), Section = lSection
}
}
};
var lCreatedEntity = await personRepository.Add(new PersonEntity { Name = "test1", Submissions = new List <SubmissionEntity> {
lSubmission
} });
// Act
var lResult = await personRepository.GetWithSubmissionsSalonsAccreditationSections(lCreatedEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.IsNotNull(lResult.Submissions);
Assert.IsTrue(lResult.Submissions.Any());
Assert.IsNotNull(lResult.Submissions[0].Entries);
Assert.IsTrue(lResult.Submissions[0].Entries.Any());
Assert.IsNotNull(lResult.Submissions[0].Entries[0].Section);
Assert.IsNotNull(lResult.Submissions[0].Entries[0].Section.SectionType);
Assert.IsNotNull(lResult.Submissions[0].Entries[0].Section.SalonYear);
Assert.IsNotNull(lResult.Submissions[0].Entries[0].Section.SalonYear.Accreditations);
Assert.IsTrue(lResult.Submissions[0].Entries[0].Section.SalonYear.Accreditations.Any());
Assert.IsNotNull(lResult.Submissions[0].Entries[0].Section.SalonYear.Salon);
}
public async Task UpdateSection_SetsNameInDb()
{
// Arrange
var lCreatedEntity = await sectionRepository.Add(new Entities.SectionEntity {
SalonYear = EntitiesHelper.GetSalonYear(), SectionType = EntitiesHelper.GetSectionType()
});
var lNewSalonYear = EntitiesHelper.GetSalonYear();
lNewSalonYear.Name = "new salon year";
lCreatedEntity.SalonYear = lNewSalonYear;
// Act
await sectionRepository.Update(lCreatedEntity);
// Assert
var lResult = await sectionRepository.GetById(lCreatedEntity.Id);
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.Id > 0);
Assert.AreEqual("new salon year", lResult.SalonYear.Name);
}
public async Task GetSubmissionResults_GetsFromDb()
{
// Arrange
ImageEntity imageEntity = EntitiesHelper.GetImage();
var lCreatedEntity = await submissionRepository.Add(new SubmissionEntity { Notes = "test", SalonYear = EntitiesHelper.GetSalonYear(), Person = EntitiesHelper.GetPerson(),
Entries = new List <CompetitionEntryEntity>
{
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
IsAccepted = true,
IsAwarded = false,
AwardDetails = "award 1",
Score = 50
},
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
}
} });
// Act
var lResult = await submissionRepository.GetSubmissionResults(lCreatedEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.IsTrue(lResult.SubmissionId > 0);
Assert.IsTrue(lResult.PersonId > 0);
Assert.IsTrue(!string.IsNullOrWhiteSpace(lResult.DisplayName));
Assert.IsTrue(!string.IsNullOrWhiteSpace(lResult.Entries.ToList()[0].AwardDetails));
Assert.IsTrue(lResult.Entries.Any(ent => ent.Id > 0 && ent.Score == 50 && ent.IsAwarded == false && ent.IsAccepted == true));
Assert.IsTrue(lResult.Entries.Any(ent => ent.Id > 0 && !ent.Score.HasValue && !ent.IsAwarded.HasValue && !ent.IsAccepted.HasValue));
Assert.IsTrue(lResult.Entries.All(ent => !string.IsNullOrWhiteSpace(ent.ImageName)));
}
public async Task GetBasicSubmissionInfoByPersonId_GetsFromDb()
{
// Arrange
ImageEntity imageEntity = EntitiesHelper.GetImage();
var personEntity = EntitiesHelper.GetPerson();
await submissionRepository.Add(new SubmissionEntity
{
Notes = "test",
SalonYear = EntitiesHelper.GetSalonYear(),
Person = personEntity,
IsJudged = true,
Entries = new List <CompetitionEntryEntity>
{
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
IsAccepted = true,
IsAwarded = false,
Score = 50
},
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
}
}
});
await submissionRepository.Add(new SubmissionEntity
{
Notes = "test",
SalonYear = EntitiesHelper.GetSalonYear(),
Person = personEntity,
Entries = new List <CompetitionEntryEntity>
{
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
IsAccepted = true,
IsAwarded = false,
Score = 50
},
new CompetitionEntryEntity
{
Image = imageEntity,
Section = EntitiesHelper.GetSection(),
}
}
});
// Act
var lResult = await submissionRepository.GetBasicSubmissionInfoByPersonId(personEntity.Id);
// Assert
Assert.IsNotNull(lResult);
Assert.AreEqual(2, lResult.Count);
Assert.IsTrue(lResult[0].SubmissionId > 0);
Assert.IsTrue(lResult[0].IsJudged);
Assert.IsTrue(!string.IsNullOrWhiteSpace(lResult[0].DisplayName));
Assert.AreEqual(2, lResult[0].NumberOfEntries);
}