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); }