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