public bool DeleteClubProduct(ClubProduct clubProductToDelete, int id)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"Delete from [dbo].[ClubProduct]
WHERE Id = @id";
clubProductToDelete.Id = id;
return(db.Execute(sql, clubProductToDelete) == 1);
}
}
public void Delete(UpdateClubProductCommand updatedClubProductCommand, int id)
{
var repo = new ClubProductRepository();
var updatedClubProduct = new ClubProduct
{
ClubId = updatedClubProductCommand.ClubId,
ProductId = updatedClubProductCommand.ProductId,
};
repo.DeleteClubProduct(updatedClubProduct, id);
}
public bool UpdateClubProduct(ClubProduct clubProductToUpdate, int id)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"UPDATE [dbo].[ClubProduct]
SET [ClubId] = @clubId
,[ProductId = @productId
WHERE Id = @id";
clubProductToUpdate.Id = id;
return(db.Execute(sql, clubProductToUpdate) == 1);
}
}
