public bool AddProductPhoto(string previewUrl, string originalUrl, Guid productId) { bool allRight = false; using (var db = new ShopDataContext()) { BL.ProductProperty productPropertyPreview = new BL.ProductProperty(); BL.ProductProperty productPropertyOriginal = new BL.ProductProperty(); try { using (var ts = new TransactionScope()) { productPropertyPreview.PropertyID = Guid.NewGuid(); productPropertyOriginal.PropertyID = Guid.NewGuid(); productPropertyPreview.ProductID = productId; productPropertyOriginal.ProductID = productId; productPropertyPreview.PropertyName = ProductPhoto.ProductPhotoPreview.ToString(); productPropertyOriginal.PropertyName = ProductPhoto.ProductPhotoOriginal.ToString(); productPropertyPreview.PropertyValue = previewUrl; productPropertyOriginal.PropertyValue = originalUrl; productPropertyPreview.IsImportant = true; productPropertyOriginal.IsImportant = true; productPropertyPreview.Sort = 0; productPropertyOriginal.Sort = 0; db.ProductProperties.InsertOnSubmit(productPropertyPreview); db.SubmitChanges(); db.ProductProperties.InsertOnSubmit(productPropertyOriginal); db.SubmitChanges(); ts.Complete(); allRight = true; } } catch (Exception) { allRight = false; } return allRight; } }
public bool AddProdProp(string name, string value, Guid productId) { bool allRight = false; using (var db = new ShopDataContext()) { BL.ProductProperty productProp = new BL.ProductProperty(); productProp.ProductID = productId; productProp.PropertyID = Guid.NewGuid(); productProp.IsImportant = true; productProp.PropertyName = name; productProp.PropertyValue = value; productProp.Sort = 0; db.ProductProperties.InsertOnSubmit(productProp); db.SubmitChanges(); allRight = true; } return allRight; }