public async Task GetSubmissionChanges_InvokesStoredProcedureAndReturnsResult()
{
// Arrange
var context = A.Fake<WeeeContext>();
var memberUploadId = Guid.NewGuid();
var storedProcedureResult = new List<SubmissionChangesCsvData>();
A.CallTo(() => context.StoredProcedures.SpgSubmissionChangesCsvData(memberUploadId))
.Returns(storedProcedureResult);
var dataAccess = new GetSubmissionChangesCsvDataAccess(context);
// Act
var result = await dataAccess.GetSubmissionChanges(memberUploadId);
// Assert
A.CallTo(() => context.StoredProcedures.SpgSubmissionChangesCsvData(memberUploadId))
.MustHaveHappened();
Assert.Equal(storedProcedureResult, result);
}
public async Task GetSubmissionChanges_InvokesStoredProcedureAndReturnsResult()
{
// Arrange
var context = A.Fake <WeeeContext>();
var memberUploadId = Guid.NewGuid();
var storedProcedureResult = new List <SubmissionChangesCsvData>();
A.CallTo(() => context.StoredProcedures.SpgSubmissionChangesCsvData(memberUploadId))
.Returns(storedProcedureResult);
var dataAccess = new GetSubmissionChangesCsvDataAccess(context);
// Act
var result = await dataAccess.GetSubmissionChanges(memberUploadId);
// Assert
A.CallTo(() => context.StoredProcedures.SpgSubmissionChangesCsvData(memberUploadId))
.MustHaveHappened();
Assert.Equal(storedProcedureResult, result);
}
public async Task GetMemberUpload_ReturnsNull_WhenMemberUploadWithSpecifiedIdNotFound()
{
using (DatabaseWrapper db = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(db.Model);
Scheme scheme = helper.CreateScheme();
MemberUpload memberUpload = helper.CreateSubmittedMemberUpload(scheme);
memberUpload.ComplianceYear = 2016;
db.Model.SaveChanges();
var dataAccess = new GetSubmissionChangesCsvDataAccess(db.WeeeContext);
// Act
var result = await dataAccess.GetMemberUpload(Guid.NewGuid());
// Assert
Assert.Null(result);
}
}
public async Task GetMemberUpload_ReturnsNull_WhenMemberUploadWithSpecifiedIdNotFound()
{
using (DatabaseWrapper db = new DatabaseWrapper())
{
// Arrange
ModelHelper helper = new ModelHelper(db.Model);
Scheme scheme = helper.CreateScheme();
MemberUpload memberUpload = helper.CreateSubmittedMemberUpload(scheme);
memberUpload.ComplianceYear = 2016;
db.Model.SaveChanges();
var dataAccess = new GetSubmissionChangesCsvDataAccess(db.WeeeContext);
// Act
var result = await dataAccess.GetMemberUpload(Guid.NewGuid());
// Assert
Assert.Null(result);
}
}
