public void UpdateOrInsert(Product product)
{
string query = $@"IF EXISTS (SELECT TOP 1 *
FROM Prodcuts
WHERE ProductID = {product.ID})
BEGIN
UPDATE Products
SET Name = '{product.Name}'
SET [Single Price] = {product.SinglePrice}
SET CategoryID = '{product.CategoryID}'
WHERE ProductID = {product.ID}
END
ELSE
BEGIN
SET IDENTITY_INSERT Products ON
INSERT INTO Products
VALUES ({product.ID}, '{product.Name}', {product.SinglePrice}, '{product.CategoryID}')
SET IDENTITY_INSERT Products OFF
END";
ExecuteNonQuery(query);
}
public void UpdateOrInsert(Product prod)
{
string query = $@"IF EXISTS (SELECT TOP 1 *
FROM Products
WHERE ProductID = {prod.Id})
BEGIN
UPDATE Products
SET Name = '{prod.Name}'
SET Price = {prod.Price}
SET Category = {prod.CategoryId}
WHERE ProductID = {prod.Id}
END
ELSE
BEGIN
SET IDENTITY_INSERT Products ON
INSERT INTO Products
VALUES ({prod.Id}, '{prod.Name}', {prod.Price}, {prod.CategoryId});
SET IDENTITY_INSERT Products OFF
END";
ExecuteNonQuery(query);
}
