private static void SetProductsAsSentToWehkamp(List <int> productIDs)
{
var sentToWehkampAttributeID = VendorSettingsHelper.GetSentToWehkampAttributeID();
using (var db = new PetaPoco.Database(Environments.Current.Connection, "System.Data.SqlClient"))
{
db.CommandTimeout = 30;
foreach (var productID in productIDs)
{
var sql = string.Format("IF EXISTS (SELECT * FROM [ProductAttributeValue] WHERE AttributeID = {0} AND ProductID = {1}) UPDATE [ProductAttributeValue] SET [Value] = 'true' WHERE AttributeID = {0} AND ProductID = {1} ELSE INSERT INTO [ProductAttributeValue] (AttributeID, ProductID, [Value], CreatedBy, CreationTime) VALUES ({0}, {1}, 'true', 1, getdate())", sentToWehkampAttributeID, productID);
db.Execute(sql);
}
}
}