private async Task <Sport> CreateSportAsync(string name)
{
var id = await _sqlConnection.InsertAsync(SportsTable, ColumnValuePair.CreateName(name));
return(new Sport()
{
Id = id,
Name = name
});
}
private async Task <Bookkeeper> CreateBookerAsync(string name)
{
var id = await _sqlConnection.InsertAsync(BookersTable, ColumnValuePair.CreateName(name));
return(new Bookkeeper()
{
Id = id,
Name = name
});
}
private async Task <Country> CreateCountryAsync(string name)
{
var id = await _sqlConnection.InsertAsync(CountriesTable, ColumnValuePair.CreateName(name));
return(new Country()
{
Id = id,
Name = name
});
}
private async Task <Team> CreateTeamAsync(string name, Sport sport)
{
var id = await _sqlConnection.InsertAsync(TeamsTable,
ColumnValuePair.CreateName(name),
ColumnValuePair.Create(new ForegnKeyTableColumn(TeamsTable, SportsTable, "Id").ColumnName, sport.Id));
return(new Team()
{
Id = id,
Name = name,
Sport = sport
});
}
public async Task <Sport> GetSportAsync(string name)
{
var dbId = await _sqlConnection.GetIdAsync(SportsTable, ColumnValuePair.CreateName(name));
if (dbId > 0)
{
return(new Sport
{
Id = dbId,
Name = name
});
}
return(null);
}
private async Task <Bookkeeper> GetBookerAsync(string name)
{
var dbId = await _sqlConnection.GetIdAsync(BookersTable, ColumnValuePair.CreateName(name));
if (dbId > 0)
{
return(new Bookkeeper
{
Id = dbId,
Name = name
});
}
return(null);
}
public async Task <Country> GetCountryAsync(string name)
{
var dbId = await _sqlConnection.GetIdAsync(CountriesTable, ColumnValuePair.CreateName(name));
if (dbId > 0)
{
return(new Country
{
Id = dbId,
Name = name
});
}
return(null);
}
private async Task <League> CreateLeagueAsync(string name, bool isFirst, Sport sport, Country country)
{
var id = await _sqlConnection.InsertAsync(LeaguesTable,
ColumnValuePair.CreateName(name),
ColumnValuePair.Create(new ForegnKeyTableColumn(LeaguesTable, SportsTable, "Id").ColumnName, sport.Id),
ColumnValuePair.Create(new ForegnKeyTableColumn(LeaguesTable, CountriesTable, "Id").ColumnName, country.Id),
ColumnValuePair.Create(nameof(League.IsFirst), isFirst));
return(new League()
{
Id = id,
Name = name,
Sport = sport,
Country = country,
IsFirst = isFirst
});
}
public async Task <Team> GetTeamAsync(string name, Sport sport)
{
var dbId = await _sqlConnection.GetIdAsync(TeamsTable,
ColumnValuePair.CreateName(name),
ColumnValuePair.Create(new ForegnKeyTableColumn(TeamsTable, SportsTable, "Id").ColumnName, sport.Id));
if (dbId > 0)
{
return(new Team
{
Id = dbId,
Name = name,
Sport = sport
});
}
return(null);
}
public async Task <League> GetLeagueAsync(string name, Sport sport, Country country)
{
var dbId = await _sqlConnection.GetIdAsync(LeaguesTable,
ColumnValuePair.CreateName(name),
ColumnValuePair.Create(new ForegnKeyTableColumn(LeaguesTable, SportsTable, "Id").ColumnName, sport.Id),
ColumnValuePair.Create(new ForegnKeyTableColumn(LeaguesTable, CountriesTable, "Id").ColumnName, country.Id));
if (dbId > 0)
{
return(new League
{
Id = dbId,
Name = name,
Sport = sport,
Country = country
});
}
return(null);
}