public void TestCreateGetItinerariesByProjectIdQuery()
{
var project = new Project
{
ProjectId = 1
};
var itinerary = new Itinerary
{
EndDate = DateTimeOffset.Now.AddDays(1.0),
ItineraryId = 1,
Name = "name",
ProjectId = project.ProjectId,
Project = project,
StartDate = DateTimeOffset.Now.AddDays(-10.0),
};
itinerary.History.RevisedOn = DateTimeOffset.Now.AddDays(-2.0);
context.Projects.Add(project);
context.Itineraries.Add(itinerary);
var results = ItineraryQueries.CreateGetItinerariesByProjectIdQuery(context, project.ProjectId);
Assert.AreEqual(1, results.Count());
var firstResult = results.First();
}
public void TestCreateGetItinerariesQuery_NoItineraries()
{
Assert.AreEqual(0, context.Itineraries.Count());
var results = ItineraryQueries.CreateGetItinerariesQuery(context);
Assert.AreEqual(0, results.Count());
}
public void TestCreateGetItineraryParticipants_CheckProperties()
{
var project = new Project
{
ProjectId = 1
};
var itinerary = new Itinerary
{
EndDate = DateTimeOffset.Now.AddDays(1.0),
ItineraryId = 1,
Name = "name",
ProjectId = project.ProjectId,
Project = project,
StartDate = DateTimeOffset.Now.AddDays(-10.0),
};
var person1 = new Person
{
PersonId = 1,
FullName = "full name"
};
var participant1 = new Participant
{
ParticipantId = 1,
PersonId = person1.PersonId,
Person = person1
};
itinerary.Participants.Add(participant1);
context.Participants.Add(participant1);
context.People.Add(person1);
context.Projects.Add(project);
context.Itineraries.Add(itinerary);
var results = ItineraryQueries.CreateGetItineraryParticipantsQuery(context, itinerary.ItineraryId, project.ProjectId);
Assert.AreEqual(1, results.Count());
var firstResult = results.First();
Assert.AreEqual(person1.FullName, firstResult.FullName);
Assert.AreEqual(participant1.ParticipantId, firstResult.ParticipantId);
Assert.AreEqual(person1.PersonId, firstResult.PersonId);
}
/// <summary>
/// Returns the itineraries for the given project by project id.
/// </summary>
/// <param name="projectId">The id of the project.</param>
/// <returns>The itineraries of the project.</returns>
public List <ItineraryDTO> GetItinerariesByProjectId(int projectId)
{
var itineraries = ItineraryQueries.CreateGetItinerariesByProjectIdQuery(this.Context, projectId).ToList();
return(itineraries);
}
/// <summary>
/// Returns the itineraries for the given project by project id.
/// </summary>
/// <param name="projectId">The id of the project.</param>
/// <returns>The itineraries of the project.</returns>
public Task <List <ItineraryDTO> > GetItinerariesByProjectIdAsync(int projectId)
{
var itineraries = ItineraryQueries.CreateGetItinerariesByProjectIdQuery(this.Context, projectId).ToListAsync();
return(itineraries);
}
private IQueryable <ItineraryDTO> CreateGetItineraryByIdAndProjectId(int projectId, int id)
{
var query = ItineraryQueries.CreateGetItinerariesQuery(this.Context).Where(x => x.ProjectId == projectId && x.Id == id);
return(query);
}
/// <summary>
/// Returns the participants on the itinerary.
/// </summary>
/// <param name="projectId">The project id of the itinerary.</param>
/// <param name="itineraryId">The itinerary id.</param>
/// <returns>The participants.</returns>
public async Task <List <ItineraryParticipantDTO> > GetItineraryParticipantsAsync(int projectId, int itineraryId)
{
var participants = await ItineraryQueries.CreateGetItineraryParticipantsQuery(this.Context, itineraryId, projectId).ToListAsync();
return(participants);
}
/// <summary>
/// Returns the participants on the itinerary.
/// </summary>
/// <param name="projectId">The project id of the itinerary.</param>
/// <param name="itineraryId">The itinerary id.</param>
/// <returns>The participants.</returns>
public List <ItineraryParticipantDTO> GetItineraryParticipants(int projectId, int itineraryId)
{
var participants = ItineraryQueries.CreateGetItineraryParticipantsQuery(this.Context, itineraryId, projectId).ToList();
return(participants);
}
public void TestCreateGetItinerariesQuery_CheckProperties()
{
var participant1 = new Participant
{
ParticipantId = 1,
};
var participant2 = new Participant
{
ParticipantId = 2
};
var participant3 = new Participant
{
ParticipantId = 3
};
var cityLocationType = new LocationType
{
LocationTypeId = LocationType.City.Id,
LocationTypeName = LocationType.City.Value
};
var countryLocationType = new LocationType
{
LocationTypeId = LocationType.Country.Id,
LocationTypeName = LocationType.Country.Value
};
var arrival = new Location
{
LocationId = 1,
LocationName = "city 1",
LocationType = cityLocationType,
LocationTypeId = cityLocationType.LocationTypeId
};
var departureDestination = new Location
{
LocationId = 2,
LocationName = "country 1",
LocationType = countryLocationType,
LocationTypeId = countryLocationType.LocationTypeId
};
var project = new Project
{
ProjectId = 1
};
var itinerary = new Itinerary
{
Arrival = arrival,
ArrivalLocationId = arrival.LocationId,
Departure = departureDestination,
DepartureLocationId = departureDestination.LocationId,
EndDate = DateTimeOffset.Now.AddDays(1.0),
ItineraryId = 1,
Name = "name",
ProjectId = project.ProjectId,
Project = project,
StartDate = DateTimeOffset.Now.AddDays(-10.0),
};
var stop = new ItineraryStop
{
Itinerary = itinerary,
ItineraryId = itinerary.ItineraryId,
};
stop.Participants.Add(participant1);
stop.Participants.Add(participant2);
stop.Participants.Add(participant3);
itinerary.Participants.Add(participant1);
itinerary.Participants.Add(participant2);
itinerary.Participants.Add(participant3);
itinerary.Stops.Add(stop);
itinerary.History.RevisedOn = DateTimeOffset.Now.AddDays(-2.0);
context.LocationTypes.Add(cityLocationType);
context.LocationTypes.Add(countryLocationType);
context.Locations.Add(arrival);
context.Locations.Add(departureDestination);
context.Projects.Add(project);
context.Itineraries.Add(itinerary);
context.ItineraryStops.Add(stop);
context.Participants.Add(participant1);
context.Participants.Add(participant2);
context.Participants.Add(participant3);
var results = ItineraryQueries.CreateGetItinerariesQuery(context);
Assert.AreEqual(1, results.Count());
var firstResult = results.First();
Assert.AreEqual(arrival.LocationId, firstResult.ArrivalLocation.Id);
Assert.AreEqual(departureDestination.LocationId, firstResult.DepartureLocation.Id);
Assert.AreEqual(project.ProjectId, firstResult.ProjectId);
Assert.AreEqual(itinerary.History.RevisedOn, firstResult.LastRevisedOn);
Assert.AreEqual(itinerary.EndDate, firstResult.EndDate);
Assert.AreEqual(itinerary.ItineraryId, firstResult.Id);
Assert.AreEqual(itinerary.Name, firstResult.Name);
Assert.AreEqual(itinerary.StartDate, firstResult.StartDate);
Assert.AreEqual(3, firstResult.ParticipantsCount);
}