public void TestCreateGetSevisGroupedParticipantsQuery_CheckProperties()
{
var project = new Project
{
ProjectId = 1
};
var participant = new Participant
{
ParticipantId = 10,
ProjectId = project.ProjectId,
Project = project
};
var participantPerson = new ParticipantPerson
{
ParticipantId = participant.ParticipantId,
Participant = participant,
SevisId = "sevis id"
};
participant.ParticipantPerson = participantPerson;
var status = new ParticipantPersonSevisCommStatus
{
Id = 1,
AddedOn = DateTimeOffset.Now,
ParticipantId = participant.ParticipantId,
ParticipantPerson = participantPerson,
SevisCommStatusId = SevisCommStatus.QueuedToSubmit.Id,
SevisOrgId = "org",
SevisUsername = "******"
};
participantPerson.ParticipantPersonSevisCommStatuses.Add(status);
context.Projects.Add(project);
context.ParticipantPersons.Add(participantPerson);
context.Participants.Add(participant);
context.ParticipantPersonSevisCommStatuses.Add(status);
var results = SevisBatchProcessingQueries.CreateGetSevisGroupedParticipantsQuery(context).ToList();
Assert.AreEqual(1, results.Count);
var firstResult = results.First();
Assert.AreEqual(status.SevisOrgId, firstResult.SevisOrgId);
Assert.AreEqual(status.SevisUsername, firstResult.SevisUsername);
Assert.AreEqual(1, firstResult.Participants.Count());
var firstParticipant = firstResult.Participants.First();
Assert.AreEqual(participant.ParticipantId, firstParticipant.ParticipantId);
Assert.AreEqual(project.ProjectId, firstParticipant.ProjectId);
Assert.AreEqual(participantPerson.SevisId, firstParticipant.SevisId);
Assert.AreEqual(status.SevisCommStatusId, firstParticipant.SevisCommStatusId);
}
public void TestCreateGetSevisGroupedParticipantsQuery_CheckLatestSevisCommStatus()
{
var project = new Project
{
ProjectId = 1
};
var participant = new Participant
{
ParticipantId = 10,
ProjectId = project.ProjectId,
Project = project
};
var participantPerson = new ParticipantPerson
{
ParticipantId = participant.ParticipantId,
Participant = participant,
SevisId = "sevis id"
};
participant.ParticipantPerson = participantPerson;
var status1 = new ParticipantPersonSevisCommStatus
{
Id = 1,
AddedOn = DateTimeOffset.Now.AddDays(-1.0),
ParticipantId = participant.ParticipantId,
ParticipantPerson = participantPerson,
SevisCommStatusId = SevisCommStatus.ReadyToSubmit.Id
};
var status2 = new ParticipantPersonSevisCommStatus
{
Id = 2,
AddedOn = DateTimeOffset.Now.AddDays(1.0),
ParticipantId = participant.ParticipantId,
ParticipantPerson = participantPerson,
SevisCommStatusId = SevisCommStatus.QueuedToSubmit.Id
};
participantPerson.ParticipantPersonSevisCommStatuses.Add(status1);
participantPerson.ParticipantPersonSevisCommStatuses.Add(status2);
context.Projects.Add(project);
context.ParticipantPersons.Add(participantPerson);
context.Participants.Add(participant);
context.ParticipantPersonSevisCommStatuses.Add(status1);
var results = SevisBatchProcessingQueries.CreateGetSevisGroupedParticipantsQuery(context).ToList();
Assert.AreEqual(1, results.Count);
}
public void TestCreateGetSevisGroupedParticipantsQuery_IsNotQueuedToSubmitOrIsQueuedToValidate()
{
var project = new Project
{
ProjectId = 1
};
var participant = new Participant
{
ParticipantId = 10,
ProjectId = project.ProjectId,
Project = project
};
var participantPerson = new ParticipantPerson
{
ParticipantId = participant.ParticipantId,
Participant = participant,
SevisId = "sevis id"
};
participant.ParticipantPerson = participantPerson;
var status = new ParticipantPersonSevisCommStatus
{
Id = 1,
AddedOn = DateTimeOffset.Now,
ParticipantId = participant.ParticipantId,
ParticipantPerson = participantPerson,
SevisCommStatusId = SevisCommStatus.ReadyToSubmit.Id
};
participantPerson.ParticipantPersonSevisCommStatuses.Add(status);
context.Projects.Add(project);
context.ParticipantPersons.Add(participantPerson);
context.Participants.Add(participant);
context.ParticipantPersonSevisCommStatuses.Add(status);
var results = SevisBatchProcessingQueries.CreateGetSevisGroupedParticipantsQuery(context).ToList();
Assert.AreEqual(0, results.Count);
}
