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); } } }