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