public void InsertOrUpdateProductRelevanceStatus(int productId, ProductRelevance productRelevance, bool isLive)
{
using (var connection = new SqlConnection(_connectionString))
{
string sql = @" MERGE ProductRelevance AS TARGET
USING (SELECT @ProductID, @StatusID, @IsLive) AS source(ProductID, StatusID, IsLive)
ON TARGET.ProductID = source.ProductID AND TARGET.IsLive = source.IsLive
WHEN matched THEN
UPDATE
SET LastUpdateTime = GETDATE(),
StatusID = source.StatusID
WHEN NOT matched THEN
INSERT
(
ProductID,
StatusID,
IsLive
)
VALUES
(
source.ProductID,
source.StatusID,
source.IsLive
);";
var cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@ProductID", productId);
cmd.Parameters.AddWithValue("@StatusID", productRelevance);
cmd.Parameters.AddWithValue("@IsLive", isLive);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public void InsertOrUpdateProductRelevanceStatus(int productId, ProductRelevance productRelevance, bool isLive)
{
throw new NotImplementedException();
}
public void InsertOrUpdateProductRelevanceStatus(int productId, ProductRelevance productRelevance, bool isLive)
{
}
public void InsertOrUpdateProductRelevanceStatus(int productId, ProductRelevance productRelevance, bool isLive)
{
_repository.InsertOrUpdateProductRelevanceStatus(productId, productRelevance, isLive);
}
