public static List <Team> GetTeamsByIdCompetition(FootBallContext context, int idCompetition)
{
var series = SerieQueries.GetSeriesByIdCompetition(context, idCompetition).Select(s => (int?)s.IdSerie).ToList();
if (series.Any())
{
return(context.Teams.Where(t => t.IdSerie != null && series.Contains(t.IdSerie)).ToList());
}
return(new List <Team>());
}
public override void SaveEntity_EntityExists_EntityIsUpdated()
{
var personTitle = PersonTitleCreator.CreatePersonTitle(Context, out var person, out var title);
var team = TeamCommands.SaveTeam(new Team {
Description = RandomUtil.GetRandomString(), Name = RandomUtil.GetRandomString()
}, Context);
personTitle.IdTeam = team.IdTeam;
personTitle.SavePersonTitle(Context);
using (var context = new FootBallContext())
{
var personTitleDb = PersonTitleQueries.GetAllPersonsTitlesByIdTeam(context, team.IdTeam);
Assert.IsNotNull(personTitleDb);
}
}
public static List <Person> GetPersonsBetweenBirthDates(FootBallContext context, DateTime?startDate = null, DateTime?endDate = null)
{
if (startDate == null)
{
startDate = DateTime.Today;
}
if (endDate == null)
{
endDate = startDate.Value.AddDays(1);
}
if (startDate > endDate)
{
throw new Exception("EndDate has to be bigger then startdate");
}
return(context.Persons.Where(p => p.BirthDate >= startDate && p.BirthDate <= endDate).ToList());
}
public static PersonTitle CreatePersonTitle(FootBallContext context, out Person person, out Title title)
{
person = PersonCommands.SavePerson(
new Person {
FirstName = RandomUtil.GetRandomString(), LastName = RandomUtil.GetRandomString()
},
context);
Assert.IsNotNull(person);
title = TitleCommands.SaveTitle(new Title {
Description = RandomUtil.GetRandomString()
}, context);
Assert.IsNotNull(title);
return(PersonTitleCommands.SavePersonTitle(new PersonTitle {
IdPerson = person.IdPerson, IdTitle = title.IdTitle
},
context));
}
public static List <Title> GetTitlesByPartOfDescription(FootBallContext context, string description)
{
return(context.Titles.Where(t => t.Description.Contains(description)).ToList());
}
public static Title GetTitleById(FootBallContext context, int idTitle)
{
return(context.Titles.FirstOrDefault(t => t.IdTitle == idTitle));
}
public static Team GetTeamById(FootBallContext context, int idTeam)
{
return(context.Teams.FirstOrDefault(t => t.IdTeam == idTeam));
}
public static Team SaveTeam(this Team team, FootBallContext context)
{
context.Teams.AddOrUpdate(team);
context.SaveChanges();
return(team);
}
public static List <Team> GetTeamsByIdSerie(FootBallContext context, int idSerie)
{
return(context.Teams.Where(t => t.IdSerie == idSerie).ToList());
}
public static List <Person> GetPersonsByParthOfName(FootBallContext context, string name)
{
return(context.Persons.Where(p => p.FirstName.Contains(name) || p.FirstName.Contains(name)).ToList());
}
public static List <Competition> GetCompetitionByPartOfDescription(FootBallContext context, string description)
{
return(context.Competitions.Where(c => c.Description.Contains(description)).ToList());
}
public static Person SavePerson(this Person person, FootBallContext context)
{
context.Persons.AddOrUpdate(person);
context.SaveChanges();
return(person);
}
public static Competition SaveCompetition(this Competition competition, FootBallContext context)
{
context.Competitions.AddOrUpdate(competition);
context.SaveChanges();
return(competition);
}
public static PersonTitle SavePersonTitle(this PersonTitle personTitle, FootBallContext context)
{
context.PersonTitles.AddOrUpdate(personTitle);
context.SaveChanges();
return personTitle;
}
public static Serie GetSerieById(FootBallContext context, int idSerie)
{
return(context.Series.FirstOrDefault(s => s.IdSerie == idSerie));
}
public static List <Serie> GetSeriesByPartOfDescription(FootBallContext context, string description)
{
return(context.Series.Where(s => s.Description.Contains(description)).ToList());
}
public static List <Serie> GetSeriesByIdCompetition(FootBallContext context, int idCompetition)
{
return(context.Series.Where(s => s.IdCompetition == idCompetition).ToList());
}
public static Title SaveTitle(this Title title, FootBallContext context)
{
context.Titles.Add(title);
context.SaveChanges();
return(title);
}
public static Person GetPersonById(FootBallContext context, int idPerson)
{
return(context.Persons.FirstOrDefault(p => p.IdPerson == idPerson));
}
public DataTestBase()
{
Context = new FootBallContext();
}
public static List <PersonTitle> GetAllPersonsTitlesByIdTeam(FootBallContext context, int idTeam)
{
return(context.PersonTitles.Where(pt => pt.IdTeam == idTeam).ToList());
}
public static List <Competition> GetCompetitionByPartOfName(FootBallContext context, string name)
{
return(context.Competitions.Where(c => c.Name.Contains(name)).ToList());
}
public static PersonTitle GetPersonTitleByAllIds(FootBallContext context, int idTitle, int idPerson,
int?idTeam = null)
{
return(context.PersonTitles.FirstOrDefault(pt =>
pt.IdPerson == idPerson && pt.IdTitle == idTitle && pt.IdTeam == idTeam));
}
public static Competition GetCompetitionById(FootBallContext context, int idCompetition)
{
return(context.Competitions.FirstOrDefault(c => c.IdCompetition == idCompetition));
}
public static Serie SaveSerie(this Serie serie, FootBallContext context)
{
context.Series.AddOrUpdate(serie);
context.SaveChanges();
return(serie);
}
