public async Task AddBreeds(Breeds breeds)
{
if (!breeds.IsValid())
{
return;
}
else
{
var sqlCommand =
@"INSERT INTO breeds
(BreedsId, Name, Origin, Temperament, Description)
VALUES
(@BreedsId, @Name, @Origin, @Temperament, @Description)";
using (var conn = theCatContext.GetConnection)
{
await conn.ExecuteAsync(sqlCommand, breeds);
}
}
}
public async Task UpdateBreeds(Breeds breeds)
{
if (!breeds.IsValid())
{
return;
}
else
{
var sqlCommand =
@"UPDATE breeds SET
Name = @Name
, Origin = @Origin
, Temperament = @Temperament
, Description = @Description
WHERE BreedsId = @BreedsId";
using (var conn = theCatContext.GetConnection)
{
await conn.ExecuteAsync(sqlCommand, breeds);
}
}
}