public void Execute(ICommandQuery commandQuery)
{
var sql = $@"Insert into Players (FirstName, LastName, Email, Phone, RatingId, TeamId)
values (@FirstName, @LastName, @Email, @Phone, @RatingId, @TeamId)";
commandQuery.Execute(sql, _players);
}
Player IQuery <Player> .Execute(ICommandQuery commandQuery)
{
var sql = @"Insert into Players (FirstName, LastName, Email, Phone, RatingId, TeamId) values (@FirstName, @LastName, @Email, @Phone, @RatingId, @TeamId);
select cast(scope_identity() as int)";
_player.Id = commandQuery.Query <int>(sql, _player).First();
return(_player);
}
Team IQuery <Team> .Execute(ICommandQuery commandQuery)
{
var sql = @"Insert into Teams (Gender, Name, RatingId) values (@Gender, @Name, @RatingId);
select cast(scope_identity() as int)";
_team.Id = commandQuery.Query <int>(sql, _team).First();
return(_team);
}
public BookRepository(IEnumerable <IDbConnectionFactory> connectionFactory, ICommandQuery commandQuery, string connectionName = "")
{
_connectionFactory = string.IsNullOrEmpty(connectionName)
? connectionFactory.FirstOrDefault()
: connectionFactory.FirstOrDefault(c => c.ConnectionName == connectionName);
if (_connectionFactory == null)
{
throw new ArgumentNullException(nameof(connectionFactory));
}
_commandQuery = commandQuery;
}
public IEnumerable <Rating> Execute(ICommandQuery commandQuery)
{
return(commandQuery.Query <Rating>("select * from Ratings"));
}
public Database(ICommandQuery commandQuery)
{
_commandQuery = commandQuery;
}
public ConsoleLogger(ICommandQuery cmd, IDateTime dateTime)
{
command = cmd;
currDateTime = dateTime;
}
