public void TestCreateGetParticipantExchangeVisitorDTOByIdQuery_InvalidProjectId() { var project = new Project { ProjectId = 100 }; var participant = new Participant { ParticipantId = 2, ProjectId = project.ProjectId, Project = project }; var visitor = new ParticipantExchangeVisitor { ParticipantId = participant.ParticipantId, Participant = participant, }; context.Projects.Add(project); context.Participants.Add(participant); context.ParticipantExchangeVisitors.Add(visitor); var queryResult = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorDTOByIdQuery(context, project.ProjectId, participant.ParticipantId).ToList(); Assert.AreEqual(1, queryResult.Count()); queryResult = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorDTOByIdQuery(context, project.ProjectId + 1, participant.ParticipantId).ToList(); Assert.AreEqual(0, queryResult.Count()); }
public void TestCreateGetParticipantExchangeVisitorDTOByIdQuery() { var project = new Project { ProjectId = 100 }; var participant = new Participant { ParticipantId = 2, ProjectId = project.ProjectId, Project = project }; var visitor = new ParticipantExchangeVisitor { ParticipantId = participant.ParticipantId, Participant = participant, }; context.Projects.Add(project); context.Participants.Add(participant); context.ParticipantExchangeVisitors.Add(visitor); Action <ParticipantExchangeVisitorDTO> tester = (result) => { Assert.IsNotNull(result); Assert.AreEqual(project.ProjectId, result.ProjectId); Assert.AreEqual(participant.ParticipantId, result.ParticipantId); }; var queryResult = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorDTOByIdQuery(context, project.ProjectId, participant.ParticipantId).ToList(); Assert.AreEqual(1, queryResult.Count()); tester(queryResult.First()); }
/// <summary> /// Returns a participantExchangeVisitors asyncronously /// </summary> /// <param name="participantId">The participant id to lookup</param> /// <returns>The participantExchangeVisitors</returns> public Task <ParticipantExchangeVisitorDTO> GetParticipantExchangeVisitorByIdAsync(int projectId, int participantId) { var participantExchangeVisitor = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorDTOByIdQuery(this.Context, projectId, participantId).FirstOrDefaultAsync(); this.logger.Trace("Retrieved participantExchangeVisitor by id [{0}].", participantId); return(participantExchangeVisitor); }
public void TestCreateGetParticipantExchangeVisitorsDTOQuery_CheckProperties() { var project = new Project { ProjectId = 100 }; var participant = new Participant { ParticipantId = 2, ProjectId = project.ProjectId, Project = project }; var fieldOfStudy = new FieldOfStudy { FieldOfStudyId = 3, Description = "field of study", }; var programCategory = new ProgramCategory { ProgramCategoryId = 3, Description = "program category", ProgramCategoryCode = "pccode" }; var position = new Position { PositionId = 4, Description = "position", PositionCode = "positioncode" }; var usGovAgency1 = new USGovernmentAgency { AgencyCode = "usgovcode1", AgencyId = 5, Description = "us gov agency1", }; var usGovAgency2 = new USGovernmentAgency { AgencyCode = "usgovcode2", AgencyId = 6, Description = "us gov agency2", }; var internationalOrg1 = new InternationalOrganization { Description = "int org 1", OrganizationCode = "int org 1 code", OrganizationId = 7, }; var internationalOrg2 = new InternationalOrganization { Description = "int org 2", OrganizationCode = "int org 2 code", OrganizationId = 8, }; var visitor = new ParticipantExchangeVisitor { ParticipantId = participant.ParticipantId, Participant = participant, FieldOfStudy = fieldOfStudy, FieldOfStudyId = fieldOfStudy.FieldOfStudyId, FundingGovtAgency1 = 2.0m, FundingGovtAgency2 = 3.0m, FundingIntlOrg1 = 4.0m, FundingIntlOrg2 = 5.0m, FundingOther = 6.0m, FundingPersonal = 7.0m, FundingSponsor = 8.0m, FundingTotal = 9.0m, FundingVisBNC = 10.0m, FundingVisGovt = 11.0m, GovtAgency1 = usGovAgency1, GovtAgency1Id = usGovAgency1.AgencyId, GovtAgency1OtherName = "other name", GovtAgency2 = usGovAgency2, GovtAgency2Id = usGovAgency2.AgencyId, GovtAgency2OtherName = "other other name", IntlOrg1 = internationalOrg1, IntlOrg1Id = internationalOrg1.OrganizationId, IntlOrg1OtherName = "other other other name", IntlOrg2 = internationalOrg2, IntlOrg2Id = internationalOrg2.OrganizationId, IntlOrg2OtherName = "other name 2", OtherName = "other name again", ProgramCategory = programCategory, ProgramCategoryId = programCategory.ProgramCategoryId, Position = position, PositionId = position.PositionId }; context.Projects.Add(project); context.Participants.Add(participant); context.FieldOfStudies.Add(fieldOfStudy); context.ProgramCategories.Add(programCategory); context.Positions.Add(position); context.ParticipantExchangeVisitors.Add(visitor); context.USGovernmentAgencies.Add(usGovAgency1); context.USGovernmentAgencies.Add(usGovAgency2); context.InternationalOrganizations.Add(internationalOrg1); context.InternationalOrganizations.Add(internationalOrg2); Action <ParticipantExchangeVisitorDTO> tester = (result) => { Assert.AreEqual(project.ProjectId, result.ProjectId); Assert.AreEqual(participant.ParticipantId, result.ParticipantId); Assert.AreEqual(visitor.FundingGovtAgency1, result.FundingGovtAgency1); Assert.AreEqual(visitor.FundingGovtAgency2, result.FundingGovtAgency2); Assert.AreEqual(visitor.FundingIntlOrg1, result.FundingIntlOrg1); Assert.AreEqual(visitor.FundingIntlOrg2, result.FundingIntlOrg2); Assert.AreEqual(visitor.FundingOther, result.FundingOther); Assert.AreEqual(visitor.FundingPersonal, result.FundingPersonal); Assert.AreEqual(visitor.FundingSponsor, result.FundingSponsor); Assert.AreEqual(visitor.FundingTotal, result.FundingTotal); Assert.AreEqual(visitor.FundingVisBNC, result.FundingVisBNC); Assert.AreEqual(visitor.FundingVisGovt, result.FundingVisGovt); Assert.AreEqual(visitor.GovtAgency1OtherName, result.GovtAgency1OtherName); Assert.AreEqual(visitor.GovtAgency2OtherName, result.GovtAgency2OtherName); Assert.AreEqual(visitor.IntlOrg1OtherName, result.IntlOrg1OtherName); Assert.AreEqual(visitor.IntlOrg2OtherName, result.IntlOrg2OtherName); Assert.AreEqual(visitor.OtherName, result.OtherName); Assert.AreEqual(visitor.FieldOfStudyId, result.FieldOfStudyId); Assert.AreEqual(fieldOfStudy.Description, result.FieldOfStudy); Assert.AreEqual(visitor.GovtAgency1Id, result.GovtAgency1Id); Assert.AreEqual(usGovAgency1.Description, result.GovtAgency1Name); Assert.AreEqual(visitor.GovtAgency2Id, result.GovtAgency2Id); Assert.AreEqual(usGovAgency2.Description, result.GovtAgency2Name); Assert.AreEqual(visitor.ProgramCategoryId, result.ProgramCategoryId); Assert.AreEqual(programCategory.Description, result.ProgramCategory); Assert.AreEqual(programCategory.ProgramCategoryCode, result.ProgramCategoryCode); Assert.AreEqual(visitor.IntlOrg1Id, result.IntlOrg1Id); Assert.AreEqual(internationalOrg1.Description, result.IntlOrg1Name); Assert.AreEqual(visitor.IntlOrg2Id, result.IntlOrg2Id); Assert.AreEqual(internationalOrg2.Description, result.IntlOrg2Name); Assert.AreEqual(visitor.PositionId, result.PositionId); Assert.AreEqual(visitor.Position.Description, result.Position); Assert.AreEqual(position.PositionCode, result.PositionCode); }; var queryResult = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorsDTOQuery(context).ToList(); Assert.AreEqual(1, queryResult.Count()); tester(queryResult.First()); }
public void TestCreateGetParticipantExchangeVisitorsDTOQuery_AllValuesNull() { var project = new Project { ProjectId = 100 }; var participant = new Participant { ParticipantId = 2, ProjectId = project.ProjectId, Project = project }; var visitor = new ParticipantExchangeVisitor { ParticipantId = participant.ParticipantId, Participant = participant, }; context.Projects.Add(project); context.Participants.Add(participant); context.ParticipantExchangeVisitors.Add(visitor); Action <ParticipantExchangeVisitorDTO> tester = (result) => { Assert.AreEqual(project.ProjectId, result.ProjectId); Assert.AreEqual(participant.ParticipantId, result.ParticipantId); Assert.AreEqual(0, result.FundingGovtAgency1); Assert.AreEqual(0, result.FundingGovtAgency2); Assert.AreEqual(0, result.FundingIntlOrg1); Assert.AreEqual(0, result.FundingIntlOrg2); Assert.AreEqual(0, result.FundingOther); Assert.AreEqual(0, result.FundingPersonal); Assert.AreEqual(0, result.FundingSponsor); Assert.AreEqual(0, result.FundingTotal); Assert.AreEqual(0, result.FundingVisBNC); Assert.AreEqual(0, result.FundingVisGovt); Assert.AreEqual(string.Empty, result.GovtAgency1OtherName); Assert.AreEqual(string.Empty, result.GovtAgency2OtherName); Assert.AreEqual(string.Empty, result.IntlOrg1OtherName); Assert.AreEqual(string.Empty, result.IntlOrg2OtherName); Assert.AreEqual(string.Empty, result.OtherName); Assert.AreEqual(visitor.FieldOfStudyId, result.FieldOfStudyId); Assert.AreEqual(0, result.GovtAgency1Id); Assert.AreEqual(string.Empty, result.GovtAgency1Name); Assert.AreEqual(0, result.GovtAgency2Id); Assert.AreEqual(string.Empty, result.GovtAgency2Name); Assert.IsFalse(result.ProgramCategoryId.HasValue); Assert.AreEqual(string.Empty, result.ProgramCategory); Assert.AreEqual(string.Empty, result.ProgramCategoryCode); Assert.AreEqual(0, result.IntlOrg1Id); Assert.AreEqual(string.Empty, result.IntlOrg1Name); Assert.AreEqual(0, result.IntlOrg2Id); Assert.AreEqual(string.Empty, result.IntlOrg2Name); Assert.IsFalse(result.PositionId.HasValue); Assert.AreEqual(string.Empty, result.Position); Assert.AreEqual(string.Empty, result.PositionCode); }; var queryResult = ParticipantExchangeVisitorQueries.CreateGetParticipantExchangeVisitorsDTOQuery(context).ToList(); Assert.AreEqual(1, queryResult.Count()); tester(queryResult.First()); }