public void Two_transient_entities_should_not_be_equal()
{
var p1 = new Product();
var p2 = new Product();
Assert.AreNotEqual(p1, p2, "Different transient entities should not be equal");
}
public void Entities_with_different_id_should_not_be_equal()
{
var p1 = new Product { Id = 2 };
var p2 = new Product { Id = 5 };
Assert.AreNotEqual(p1, p2, "Entities with different ids should not be equal");
}
public void Entity_should_not_equal_transient_entity()
{
var p1 = new Product { Id = 1 };
var p2 = new Product();
Assert.AreNotEqual(p1, p2, "Entity and transient entity should not be equal");
}
public void Two_references_to_same_transient_entity_should_be_equal()
{
var p1 = new Product();
var p2 = p1;
Assert.AreEqual(p1, p2, "Two references to the same transient entity should be equal");
}
public void Two_references_with_the_same_id_should_be_equal()
{
int id = 10;
var p1 = new Product { Id = id };
var p2 = new Product { Id = id };
Assert.AreEqual(p1, p2, "Entities with the same id should be equal");
}
public void Entities_with_same_id_but_different_type_should_not_be_equal()
{
int id = 10;
var p1 = new Product { Id = id };
var c1 = new Category { Id = id };
Assert.AreNotEqual(p1, c1, "Entities of different types should not be equal, even if they have the same id");
}
public void Equality_works_using_operators()
{
var p1 = new Product { Id = 1 };
var p2 = new Product { Id = 1 };
Assert.IsTrue(p1 == p2);
var p3 = new Product();
Assert.IsTrue(p1 != p3);
}
public void Can_save_and_load_product()
{
var product = new Product
{
Name = "Name 1",
ShortDescription = "ShortDescription 1",
FullDescription = "FullDescription 1",
AdminComment = "AdminComment 1",
VendorId = 1,
ProductTemplateId = 2,
ShowOnHomePage = false,
MetaKeywords = "Meta keywords",
MetaDescription = "Meta description",
MetaTitle = "Meta title",
AllowCustomerReviews = true,
ApprovedRatingSum = 2,
NotApprovedRatingSum = 3,
ApprovedTotalReviews = 4,
NotApprovedTotalReviews = 5,
SubjectToAcl = true,
LimitedToStores = true,
Published = true,
Deleted = false,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02),
};
var fromDb = SaveAndLoadEntity(product);
fromDb.ShouldNotBeNull();
fromDb.Name.ShouldEqual("Name 1");
fromDb.ShortDescription.ShouldEqual("ShortDescription 1");
fromDb.FullDescription.ShouldEqual("FullDescription 1");
fromDb.AdminComment.ShouldEqual("AdminComment 1");
fromDb.VendorId.ShouldEqual(1);
fromDb.ProductTemplateId.ShouldEqual(2);
fromDb.ShowOnHomePage.ShouldEqual(false);
fromDb.MetaKeywords.ShouldEqual("Meta keywords");
fromDb.MetaDescription.ShouldEqual("Meta description");
fromDb.AllowCustomerReviews.ShouldEqual(true);
fromDb.ApprovedRatingSum.ShouldEqual(2);
fromDb.NotApprovedRatingSum.ShouldEqual(3);
fromDb.ApprovedTotalReviews.ShouldEqual(4);
fromDb.NotApprovedTotalReviews.ShouldEqual(5);
fromDb.SubjectToAcl.ShouldEqual(true);
fromDb.LimitedToStores.ShouldEqual(true);
fromDb.Published.ShouldEqual(true);
fromDb.Deleted.ShouldEqual(false);
fromDb.CreatedOnUtc.ShouldEqual(new DateTime(2010, 01, 01));
fromDb.UpdatedOnUtc.ShouldEqual(new DateTime(2010, 01, 02));
}
public void Can_save_and_load_product_with_productCategories()
{
var product = new Product
{
Name = "Name 1",
Published = true,
Deleted = false,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02)
};
product.ProductCategories.Add
(
new ProductCategory
{
IsFeaturedProduct = true,
DisplayOrder = 1,
Category = new Category()
{
Name = "Books",
Description = "Description 1",
MetaKeywords = "Meta keywords",
MetaDescription = "Meta description",
MetaTitle = "Meta title",
ParentCategoryId = 2,
PictureId = 3,
PageSize = 4,
PriceRanges = "1-3;",
ShowOnHomePage = false,
Published = true,
Deleted = false,
DisplayOrder = 5,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02),
}
}
);
var fromDb = SaveAndLoadEntity(product);
fromDb.ShouldNotBeNull();
fromDb.Name.ShouldEqual("Name 1");
fromDb.ProductCategories.ShouldNotBeNull();
(fromDb.ProductCategories.Count == 1).ShouldBeTrue();
fromDb.ProductCategories.First().IsFeaturedProduct.ShouldEqual(true);
fromDb.ProductCategories.First().Category.ShouldNotBeNull();
fromDb.ProductCategories.First().Category.Name.ShouldEqual("Books");
}
public virtual void AddProductTokens(IList<Token> tokens, Product product)
{
tokens.Add(new Token("Product.Name", product.Name));
tokens.Add(new Token("Product.ShortDescription", product.ShortDescription, true));
//TODO add a method for getting URL (use routing because it handles all SEO friendly URLs)
var productUrl = string.Format("{0}{1}", _webHelper.GetStoreLocation(false), product.GetSeName());
tokens.Add(new Token("Product.ProductURLForCustomer", productUrl, true));
//event notification
_eventPublisher.EntityTokensAdded(product, tokens);
}
public static Product ToEntity(this ProductModel model, Product destination)
{
return Mapper.Map(model, destination);
}
/// <summary>
/// Inserts a product
/// </summary>
/// <param name="product">Product</param>
public virtual void InsertProduct(Product product)
{
if (product == null)
throw new ArgumentNullException("product");
//insert
_productRepository.Insert(product);
//clear cache
_cacheManager.RemoveByPattern(PRODUCTS_PATTERN_KEY);
_cacheManager.RemoveByPattern(PRODUCTVARIANTS_PATTERN_KEY);
//event notification
_eventPublisher.EntityInserted(product);
}
/// <summary>
/// Delete a product
/// </summary>
/// <param name="product">Product</param>
public virtual void DeleteProduct(Product product)
{
if (product == null)
throw new ArgumentNullException("product");
product.Deleted = true;
//delete product
UpdateProduct(product);
//delete product variants
foreach (var productVariant in product.ProductVariants)
DeleteProductVariant(productVariant);
}
/// <summary>
/// Update product review totals
/// </summary>
/// <param name="product">Product</param>
public virtual void UpdateProductReviewTotals(Product product)
{
if (product == null)
throw new ArgumentNullException("product");
int approvedRatingSum = 0;
int notApprovedRatingSum = 0;
int approvedTotalReviews = 0;
int notApprovedTotalReviews = 0;
var reviews = product.ProductReviews;
foreach (var pr in reviews)
{
if (pr.IsApproved)
{
approvedRatingSum += pr.Rating;
approvedTotalReviews ++;
}
else
{
notApprovedRatingSum += pr.Rating;
notApprovedTotalReviews++;
}
}
product.ApprovedRatingSum = approvedRatingSum;
product.NotApprovedRatingSum = notApprovedRatingSum;
product.ApprovedTotalReviews = approvedTotalReviews;
product.NotApprovedTotalReviews = notApprovedTotalReviews;
UpdateProduct(product);
}
private void UpdatePictureSeoNames(Product product)
{
foreach (var pp in product.ProductPictures)
_pictureService.SetSeoFilename(pp.PictureId, _pictureService.GetPictureSeName(product.Name));
}
private void PrepareProductPictureThumbnailModel(ProductModel model, Product product)
{
if (model == null)
throw new ArgumentNullException("model");
if (product != null)
{
if (_adminAreaSettings.DisplayProductPictures)
{
var defaultProductPicture = _pictureService.GetPicturesByProductId(product.Id, 1).FirstOrDefault();
model.PictureThumbnailUrl = _pictureService.GetPictureUrl(defaultProductPicture, 75, true);
}
}
}
private void PrepareVariantsModel(ProductModel model, Product product)
{
if (model == null)
throw new ArgumentNullException("model");
if (product != null)
{
var variants = _productService.GetProductVariantsByProductId(product.Id, true);
foreach (var variant in variants)
{
var variantModel = variant.ToModel();
if (String.IsNullOrEmpty(variantModel.Name))
variantModel.Name = "Unnamed";
model.ProductVariantModels.Add(variantModel);
}
}
}
private void SaveProductTags(Product product, string[] productTags)
{
if (product == null)
throw new ArgumentNullException("product");
//product tags
var existingProductTags = product.ProductTags.ToList();
var productTagsToRemove = new List<ProductTag>();
foreach (var existingProductTag in existingProductTags)
{
bool found = false;
foreach (string newProductTag in productTags)
{
if (existingProductTag.Name.Equals(newProductTag, StringComparison.InvariantCultureIgnoreCase))
{
found = true;
break;
}
}
if (!found)
{
productTagsToRemove.Add(existingProductTag);
}
}
foreach (var productTag in productTagsToRemove)
{
product.ProductTags.Remove(productTag);
_productService.UpdateProduct(product);
}
foreach (string productTagName in productTags)
{
ProductTag productTag = null;
var productTag2 = _productTagService.GetProductTagByName(productTagName);
if (productTag2 == null)
{
//add new product tag
productTag = new ProductTag()
{
Name = productTagName
};
_productTagService.InsertProductTag(productTag);
}
else
{
productTag = productTag2;
}
if (!product.ProductTagExists(productTag.Id))
{
product.ProductTags.Add(productTag);
_productService.UpdateProduct(product);
}
}
}
public void Can_save_and_load_product_with_productVariants()
{
var product = new Product
{
Name = "Name 1",
Published = true,
Deleted = false,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02)
};
product.ProductVariants.Add
(
new ProductVariant
{
Name = "Product variant name 1",
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04)
}
);
var fromDb = SaveAndLoadEntity(product);
fromDb.ShouldNotBeNull();
fromDb.Name.ShouldEqual("Name 1");
fromDb.ProductVariants.ShouldNotBeNull();
(fromDb.ProductVariants.Count == 1).ShouldBeTrue();
fromDb.ProductVariants.First().Name.ShouldEqual("Product variant name 1");
}
public void Can_save_and_load_product_with_productPictures()
{
var product = new Product
{
Name = "Name 1",
Published = true,
Deleted = false,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02)
};
product.ProductPictures.Add
(
new ProductPicture
{
DisplayOrder = 1,
Picture = new Picture()
{
PictureBinary = new byte[] { 1, 2, 3 },
MimeType = "image/pjpeg",
IsNew = true
}
}
);
var fromDb = SaveAndLoadEntity(product);
fromDb.ShouldNotBeNull();
fromDb.Name.ShouldEqual("Name 1");
fromDb.ProductPictures.ShouldNotBeNull();
(fromDb.ProductPictures.Count == 1).ShouldBeTrue();
fromDb.ProductPictures.First().DisplayOrder.ShouldEqual(1);
fromDb.ProductPictures.First().Picture.ShouldNotBeNull();
fromDb.ProductPictures.First().Picture.MimeType.ShouldEqual("image/pjpeg");
}
private void PrepareTags(ProductModel model, Product product)
{
if (model == null)
throw new ArgumentNullException("model");
if (product != null)
{
var result = new StringBuilder();
for (int i = 0; i < product.ProductTags.Count; i++)
{
var pt = product.ProductTags.ToList()[i];
result.Append(pt.Name);
if (i != product.ProductTags.Count - 1)
result.Append(", ");
}
model.ProductTags = result.ToString();
}
}
private void PrepareCopyProductModel(ProductModel model, Product product)
{
if (model == null)
throw new ArgumentNullException("model");
if (product != null)
{
model.CopyProductModel.Id = product.Id;
model.CopyProductModel.Name = "Copy of " + product.Name;
model.CopyProductModel.Published = true;
model.CopyProductModel.CopyImages = true;
}
}
private void PrepareStoresMappingModel(ProductModel model, Product product, bool excludeProperties)
{
if (model == null)
throw new ArgumentNullException("model");
model.AvailableStores = _storeService
.GetAllStores()
.Select(s => s.ToModel())
.ToList();
if (!excludeProperties)
{
if (product != null)
{
model.SelectedStoreIds = _storeMappingService.GetStoresIdsWithAccess(product);
}
else
{
model.SelectedStoreIds = new int[0];
}
}
}
/// <summary>
/// Import products from XLSX file
/// </summary>
/// <param name="stream">Stream</param>
public virtual void ImportProductsFromXlsx(Stream stream)
{
// ok, we can run the real code of the sample now
using (var xlPackage = new ExcelPackage(stream))
{
// get the first worksheet in the workbook
var worksheet = xlPackage.Workbook.Worksheets.FirstOrDefault();
if (worksheet == null)
throw new NasException("No worksheet found");
//the columns
var properties = new string[]
{
"Name",
"ShortDescription",
"FullDescription",
"VendorId",
"ProductTemplateId",
"ShowOnHomePage",
"MetaKeywords",
"MetaDescription",
"MetaTitle",
"SeName",
"AllowCustomerReviews",
"Published",
"ProductVariantName",
"SKU",
"ManufacturerPartNumber",
"Gtin",
"IsGiftCard",
"GiftCardTypeId",
"RequireOtherProducts",
"RequiredProductVariantIds",
"AutomaticallyAddRequiredProductVariants",
"IsDownload",
"DownloadId",
"UnlimitedDownloads",
"MaxNumberOfDownloads",
"DownloadActivationTypeId",
"HasSampleDownload",
"SampleDownloadId",
"HasUserAgreement",
"UserAgreementText",
"IsRecurring",
"RecurringCycleLength",
"RecurringCyclePeriodId",
"RecurringTotalCycles",
"IsShipEnabled",
"IsFreeShipping",
"AdditionalShippingCharge",
"IsTaxExempt",
"TaxCategoryId",
"ManageInventoryMethodId",
"StockQuantity",
"DisplayStockAvailability",
"DisplayStockQuantity",
"MinStockQuantity",
"LowStockActivityId",
"NotifyAdminForQuantityBelow",
"BackorderModeId",
"AllowBackInStockSubscriptions",
"OrderMinimumQuantity",
"OrderMaximumQuantity",
"AllowedQuantities",
"DisableBuyButton",
"DisableWishlistButton",
"CallForPrice",
"Price",
"OldPrice",
"ProductCost",
"SpecialPrice",
"SpecialPriceStartDateTimeUtc",
"SpecialPriceEndDateTimeUtc",
"CustomerEntersPrice",
"MinimumCustomerEnteredPrice",
"MaximumCustomerEnteredPrice",
"Weight",
"Length",
"Width",
"Height",
"CreatedOnUtc",
"CategoryIds",
"ManufacturerIds",
"Picture1",
"Picture2",
"Picture3",
};
int iRow = 2;
while (true)
{
bool allColumnsAreEmpty = true;
for (var i = 1; i <= properties.Length; i++)
if (worksheet.Cells[iRow, i].Value != null && !String.IsNullOrEmpty(worksheet.Cells[iRow, i].Value.ToString()))
{
allColumnsAreEmpty = false;
break;
}
if (allColumnsAreEmpty)
break;
string name = worksheet.Cells[iRow, GetColumnIndex(properties, "Name")].Value as string;
string shortDescription = worksheet.Cells[iRow, GetColumnIndex(properties, "ShortDescription")].Value as string;
string fullDescription = worksheet.Cells[iRow, GetColumnIndex(properties, "FullDescription")].Value as string;
int vendorId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "VendorId")].Value);
int productTemplateId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "ProductTemplateId")].Value);
bool showOnHomePage = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "ShowOnHomePage")].Value);
string metaKeywords = worksheet.Cells[iRow, GetColumnIndex(properties, "MetaKeywords")].Value as string;
string metaDescription = worksheet.Cells[iRow, GetColumnIndex(properties, "MetaDescription")].Value as string;
string metaTitle = worksheet.Cells[iRow, GetColumnIndex(properties, "MetaTitle")].Value as string;
string seName = worksheet.Cells[iRow, GetColumnIndex(properties, "SeName")].Value as string;
bool allowCustomerReviews = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "AllowCustomerReviews")].Value);
bool published = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "Published")].Value);
string productVariantName = worksheet.Cells[iRow, GetColumnIndex(properties, "ProductVariantName")].Value as string;
string sku = worksheet.Cells[iRow, GetColumnIndex(properties, "SKU")].Value as string;
string manufacturerPartNumber = worksheet.Cells[iRow, GetColumnIndex(properties, "ManufacturerPartNumber")].Value as string;
string gtin = worksheet.Cells[iRow, GetColumnIndex(properties, "Gtin")].Value as string;
bool isGiftCard = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "IsGiftCard")].Value);
int giftCardTypeId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "GiftCardTypeId")].Value);
bool requireOtherProducts = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "RequireOtherProducts")].Value);
string requiredProductVariantIds = worksheet.Cells[iRow, GetColumnIndex(properties, "RequiredProductVariantIds")].Value as string;
bool automaticallyAddRequiredProductVariants = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "AutomaticallyAddRequiredProductVariants")].Value);
bool isDownload = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "IsDownload")].Value);
int downloadId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "DownloadId")].Value);
bool unlimitedDownloads = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "UnlimitedDownloads")].Value);
int maxNumberOfDownloads = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "MaxNumberOfDownloads")].Value);
int downloadActivationTypeId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "DownloadActivationTypeId")].Value);
bool hasSampleDownload = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "HasSampleDownload")].Value);
int sampleDownloadId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "SampleDownloadId")].Value);
bool hasUserAgreement = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "HasUserAgreement")].Value);
string userAgreementText = worksheet.Cells[iRow, GetColumnIndex(properties, "UserAgreementText")].Value as string;
bool isRecurring = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "IsRecurring")].Value);
int recurringCycleLength = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "RecurringCycleLength")].Value);
int recurringCyclePeriodId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "RecurringCyclePeriodId")].Value);
int recurringTotalCycles = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "RecurringTotalCycles")].Value);
bool isShipEnabled = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "IsShipEnabled")].Value);
bool isFreeShipping = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "IsFreeShipping")].Value);
decimal additionalShippingCharge = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "AdditionalShippingCharge")].Value);
bool isTaxExempt = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "IsTaxExempt")].Value);
int taxCategoryId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "TaxCategoryId")].Value);
int manageInventoryMethodId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "ManageInventoryMethodId")].Value);
int stockQuantity = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "StockQuantity")].Value);
bool displayStockAvailability = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "DisplayStockAvailability")].Value);
bool displayStockQuantity = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "DisplayStockQuantity")].Value);
int minStockQuantity = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "MinStockQuantity")].Value);
int lowStockActivityId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "LowStockActivityId")].Value);
int notifyAdminForQuantityBelow = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "NotifyAdminForQuantityBelow")].Value);
int backorderModeId = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "BackorderModeId")].Value);
bool allowBackInStockSubscriptions = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "AllowBackInStockSubscriptions")].Value);
int orderMinimumQuantity = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "OrderMinimumQuantity")].Value);
int orderMaximumQuantity = Convert.ToInt32(worksheet.Cells[iRow, GetColumnIndex(properties, "OrderMaximumQuantity")].Value);
string allowedQuantities = worksheet.Cells[iRow, GetColumnIndex(properties, "AllowedQuantities")].Value as string;
bool disableBuyButton = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "DisableBuyButton")].Value);
bool disableWishlistButton = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "DisableWishlistButton")].Value);
bool callForPrice = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "CallForPrice")].Value);
decimal price = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "Price")].Value);
decimal oldPrice = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "OldPrice")].Value);
decimal productCost = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "ProductCost")].Value);
decimal? specialPrice = null;
var specialPriceExcel = worksheet.Cells[iRow, GetColumnIndex(properties, "SpecialPrice")].Value;
if (specialPriceExcel != null)
specialPrice = Convert.ToDecimal(specialPriceExcel);
DateTime? specialPriceStartDateTimeUtc = null;
var specialPriceStartDateTimeUtcExcel = worksheet.Cells[iRow, GetColumnIndex(properties, "SpecialPriceStartDateTimeUtc")].Value;
if (specialPriceStartDateTimeUtcExcel != null)
specialPriceStartDateTimeUtc = DateTime.FromOADate(Convert.ToDouble(specialPriceStartDateTimeUtcExcel));
DateTime? specialPriceEndDateTimeUtc = null;
var specialPriceEndDateTimeUtcExcel = worksheet.Cells[iRow, GetColumnIndex(properties, "SpecialPriceEndDateTimeUtc")].Value;
if (specialPriceEndDateTimeUtcExcel != null)
specialPriceEndDateTimeUtc = DateTime.FromOADate(Convert.ToDouble(specialPriceEndDateTimeUtcExcel));
bool customerEntersPrice = Convert.ToBoolean(worksheet.Cells[iRow, GetColumnIndex(properties, "CustomerEntersPrice")].Value);
decimal minimumCustomerEnteredPrice = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "MinimumCustomerEnteredPrice")].Value);
decimal maximumCustomerEnteredPrice = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "MaximumCustomerEnteredPrice")].Value);
decimal weight = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "Weight")].Value);
decimal length = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "Length")].Value);
decimal width = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "Width")].Value);
decimal height = Convert.ToDecimal(worksheet.Cells[iRow, GetColumnIndex(properties, "Height")].Value);
DateTime createdOnUtc = DateTime.FromOADate(Convert.ToDouble(worksheet.Cells[iRow, GetColumnIndex(properties, "CreatedOnUtc")].Value));
string categoryIds = worksheet.Cells[iRow, GetColumnIndex(properties, "CategoryIds")].Value as string;
string manufacturerIds = worksheet.Cells[iRow, GetColumnIndex(properties, "ManufacturerIds")].Value as string;
string picture1 = worksheet.Cells[iRow, GetColumnIndex(properties, "Picture1")].Value as string;
string picture2 = worksheet.Cells[iRow, GetColumnIndex(properties, "Picture2")].Value as string;
string picture3 = worksheet.Cells[iRow, GetColumnIndex(properties, "Picture3")].Value as string;
var productVariant = _productService.GetProductVariantBySku(sku);
if (productVariant != null)
{
//product
var product = productVariant.Product;
product.Name = name;
product.ShortDescription = shortDescription;
product.FullDescription = fullDescription;
product.VendorId = vendorId;
product.ProductTemplateId = productTemplateId;
product.ShowOnHomePage = showOnHomePage;
product.MetaKeywords = metaKeywords;
product.MetaDescription = metaDescription;
product.MetaTitle = metaTitle;
product.AllowCustomerReviews = allowCustomerReviews;
product.Published = published;
product.CreatedOnUtc = createdOnUtc;
product.UpdatedOnUtc = DateTime.UtcNow;
_productService.UpdateProduct(product);
//search engine name
_urlRecordService.SaveSlug(product, product.ValidateSeName(seName, product.Name, true), 0);
//variant
productVariant.Name = productVariantName;
productVariant.Sku = sku;
productVariant.ManufacturerPartNumber = manufacturerPartNumber;
productVariant.Gtin = gtin;
productVariant.IsGiftCard = isGiftCard;
productVariant.GiftCardTypeId = giftCardTypeId;
productVariant.RequireOtherProducts = requireOtherProducts;
productVariant.RequiredProductVariantIds = requiredProductVariantIds;
productVariant.AutomaticallyAddRequiredProductVariants = automaticallyAddRequiredProductVariants;
productVariant.IsDownload = isDownload;
productVariant.DownloadId = downloadId;
productVariant.UnlimitedDownloads = unlimitedDownloads;
productVariant.MaxNumberOfDownloads = maxNumberOfDownloads;
productVariant.DownloadActivationTypeId = downloadActivationTypeId;
productVariant.HasSampleDownload = hasSampleDownload;
productVariant.SampleDownloadId = sampleDownloadId;
productVariant.HasUserAgreement = hasUserAgreement;
productVariant.UserAgreementText = userAgreementText;
productVariant.IsRecurring = isRecurring;
productVariant.RecurringCycleLength = recurringCycleLength;
productVariant.RecurringCyclePeriodId = recurringCyclePeriodId;
productVariant.RecurringTotalCycles = recurringTotalCycles;
productVariant.IsShipEnabled = isShipEnabled;
productVariant.IsFreeShipping = isFreeShipping;
productVariant.AdditionalShippingCharge = additionalShippingCharge;
productVariant.IsTaxExempt = isTaxExempt;
productVariant.TaxCategoryId = taxCategoryId;
productVariant.ManageInventoryMethodId = manageInventoryMethodId;
productVariant.StockQuantity = stockQuantity;
productVariant.DisplayStockAvailability = displayStockAvailability;
productVariant.DisplayStockQuantity = displayStockQuantity;
productVariant.MinStockQuantity = minStockQuantity;
productVariant.LowStockActivityId = lowStockActivityId;
productVariant.NotifyAdminForQuantityBelow = notifyAdminForQuantityBelow;
productVariant.BackorderModeId = backorderModeId;
productVariant.AllowBackInStockSubscriptions = allowBackInStockSubscriptions;
productVariant.OrderMinimumQuantity = orderMinimumQuantity;
productVariant.OrderMaximumQuantity = orderMaximumQuantity;
productVariant.AllowedQuantities = allowedQuantities;
productVariant.DisableBuyButton = disableBuyButton;
productVariant.DisableWishlistButton = disableWishlistButton;
productVariant.CallForPrice = callForPrice;
productVariant.Price = price;
productVariant.OldPrice = oldPrice;
productVariant.ProductCost = productCost;
productVariant.SpecialPrice = specialPrice;
productVariant.SpecialPriceStartDateTimeUtc = specialPriceStartDateTimeUtc;
productVariant.SpecialPriceEndDateTimeUtc = specialPriceEndDateTimeUtc;
productVariant.CustomerEntersPrice = customerEntersPrice;
productVariant.MinimumCustomerEnteredPrice = minimumCustomerEnteredPrice;
productVariant.MaximumCustomerEnteredPrice = maximumCustomerEnteredPrice;
productVariant.Weight = weight;
productVariant.Length = length;
productVariant.Width = width;
productVariant.Height = height;
productVariant.Published = published;
productVariant.CreatedOnUtc = createdOnUtc;
productVariant.UpdatedOnUtc = DateTime.UtcNow;
_productService.UpdateProductVariant(productVariant);
}
else
{
//product
var product = new Product()
{
Name = name,
ShortDescription = shortDescription,
FullDescription = fullDescription,
ShowOnHomePage = showOnHomePage,
MetaKeywords = metaKeywords,
MetaDescription = metaDescription,
MetaTitle = metaTitle,
AllowCustomerReviews = allowCustomerReviews,
Published = published,
CreatedOnUtc = createdOnUtc,
UpdatedOnUtc = DateTime.UtcNow
};
_productService.InsertProduct(product);
//search engine name
_urlRecordService.SaveSlug(product, product.ValidateSeName(seName, product.Name, true), 0);
//variant
productVariant = new ProductVariant()
{
ProductId = product.Id,
Name = productVariantName,
Sku = sku,
ManufacturerPartNumber = manufacturerPartNumber,
Gtin = gtin,
IsGiftCard = isGiftCard,
GiftCardTypeId = giftCardTypeId,
RequireOtherProducts = requireOtherProducts,
RequiredProductVariantIds = requiredProductVariantIds,
AutomaticallyAddRequiredProductVariants = automaticallyAddRequiredProductVariants,
IsDownload = isDownload,
DownloadId = downloadId,
UnlimitedDownloads = unlimitedDownloads,
MaxNumberOfDownloads = maxNumberOfDownloads,
DownloadActivationTypeId = downloadActivationTypeId,
HasSampleDownload = hasSampleDownload,
SampleDownloadId = sampleDownloadId,
HasUserAgreement = hasUserAgreement,
UserAgreementText = userAgreementText,
IsRecurring = isRecurring,
RecurringCycleLength = recurringCycleLength,
RecurringCyclePeriodId = recurringCyclePeriodId,
RecurringTotalCycles = recurringTotalCycles,
IsShipEnabled = isShipEnabled,
IsFreeShipping = isFreeShipping,
AdditionalShippingCharge = additionalShippingCharge,
IsTaxExempt = isTaxExempt,
TaxCategoryId = taxCategoryId,
ManageInventoryMethodId = manageInventoryMethodId,
StockQuantity = stockQuantity,
DisplayStockAvailability = displayStockAvailability,
DisplayStockQuantity = displayStockQuantity,
MinStockQuantity = minStockQuantity,
LowStockActivityId = lowStockActivityId,
NotifyAdminForQuantityBelow = notifyAdminForQuantityBelow,
BackorderModeId = backorderModeId,
AllowBackInStockSubscriptions = allowBackInStockSubscriptions,
OrderMinimumQuantity = orderMinimumQuantity,
OrderMaximumQuantity = orderMaximumQuantity,
AllowedQuantities = allowedQuantities,
DisableBuyButton = disableBuyButton,
CallForPrice = callForPrice,
Price = price,
OldPrice = oldPrice,
ProductCost = productCost,
SpecialPrice = specialPrice,
SpecialPriceStartDateTimeUtc = specialPriceStartDateTimeUtc,
SpecialPriceEndDateTimeUtc = specialPriceEndDateTimeUtc,
CustomerEntersPrice = customerEntersPrice,
MinimumCustomerEnteredPrice = minimumCustomerEnteredPrice,
MaximumCustomerEnteredPrice = maximumCustomerEnteredPrice,
Weight = weight,
Length = length,
Width = width,
Height = height,
Published = published,
CreatedOnUtc = createdOnUtc,
UpdatedOnUtc = DateTime.UtcNow
};
_productService.InsertProductVariant(productVariant);
}
//category mappings
if (!String.IsNullOrEmpty(categoryIds))
{
foreach (var id in categoryIds.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries).Select(x => Convert.ToInt32(x.Trim())))
{
if (productVariant.Product.ProductCategories.FirstOrDefault(x => x.CategoryId == id) == null)
{
//ensure that category exists
var category = _categoryService.GetCategoryById(id);
if (category != null)
{
var productCategory = new ProductCategory()
{
ProductId = productVariant.Product.Id,
CategoryId = category.Id,
IsFeaturedProduct = false,
DisplayOrder = 1
};
_categoryService.InsertProductCategory(productCategory);
}
}
}
}
//manufacturer mappings
if (!String.IsNullOrEmpty(manufacturerIds))
{
foreach (var id in manufacturerIds.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries).Select(x => Convert.ToInt32(x.Trim())))
{
if (productVariant.Product.ProductManufacturers.FirstOrDefault(x => x.ManufacturerId == id) == null)
{
//ensure that manufacturer exists
var manufacturer = _manufacturerService.GetManufacturerById(id);
if (manufacturer != null)
{
var productManufacturer = new ProductManufacturer()
{
ProductId = productVariant.Product.Id,
ManufacturerId = manufacturer.Id,
IsFeaturedProduct = false,
DisplayOrder = 1
};
_manufacturerService.InsertProductManufacturer(productManufacturer);
}
}
}
}
//pictures
foreach (var picture in new string[] { picture1, picture2, picture3 })
{
if (String.IsNullOrEmpty(picture))
continue;
productVariant.Product.ProductPictures.Add(new ProductPicture()
{
Picture = _pictureService.InsertPicture(File.ReadAllBytes(picture), "image/jpeg", _pictureService.GetPictureSeName(name), true),
DisplayOrder = 1,
});
_productService.UpdateProduct(productVariant.Product);
}
//update "HasTierPrices" and "HasDiscountsApplied" properties
_productService.UpdateHasTierPricesProperty(productVariant);
_productService.UpdateHasDiscountsApplied(productVariant);
//next product
iRow++;
}
}
}
protected ProductDetailsModel PrepareProductDetailsPageModel(Product product)
{
if (product == null)
throw new ArgumentNullException("product");
var model = new ProductDetailsModel()
{
Id = product.Id,
Name = product.GetLocalized(x => x.Name),
ShortDescription = product.GetLocalized(x => x.ShortDescription),
FullDescription = product.GetLocalized(x => x.FullDescription),
MetaKeywords = product.GetLocalized(x => x.MetaKeywords),
MetaDescription = product.GetLocalized(x => x.MetaDescription),
MetaTitle = product.GetLocalized(x => x.MetaTitle),
SeName = product.GetSeName(),
};
//template
var templateCacheKey = string.Format(ModelCacheEventConsumer.PRODUCT_TEMPLATE_MODEL_KEY, product.ProductTemplateId);
model.ProductTemplateViewPath = _cacheManager.Get(templateCacheKey, () =>
{
var template = _productTemplateService.GetProductTemplateById(product.ProductTemplateId);
if (template == null)
template = _productTemplateService.GetAllProductTemplates().FirstOrDefault();
if (template == null)
throw new Exception("No default template could be loaded");
return template.ViewPath;
});
//pictures
model.DefaultPictureZoomEnabled = _mediaSettings.DefaultPictureZoomEnabled;
var pictures = _pictureService.GetPicturesByProductId(product.Id);
if (pictures.Any())
{
//default picture
model.DefaultPictureModel = new PictureModel()
{
ImageUrl = _pictureService.GetPictureUrl(pictures.FirstOrDefault(), _mediaSettings.ProductDetailsPictureSize),
FullSizeImageUrl = _pictureService.GetPictureUrl(pictures.FirstOrDefault()),
Title = string.Format(_localizationService.GetResource("Media.Product.ImageLinkTitleFormat"), model.Name),
AlternateText = string.Format(_localizationService.GetResource("Media.Product.ImageAlternateTextFormat"), model.Name),
};
//all pictures
foreach (var picture in pictures)
{
model.PictureModels.Add(new PictureModel()
{
ImageUrl = _pictureService.GetPictureUrl(picture, _mediaSettings.ProductThumbPictureSizeOnProductDetailsPage),
FullSizeImageUrl = _pictureService.GetPictureUrl(picture),
Title = string.Format(_localizationService.GetResource("Media.Product.ImageLinkTitleFormat"), model.Name),
AlternateText = string.Format(_localizationService.GetResource("Media.Product.ImageAlternateTextFormat"), model.Name),
});
}
}
else
{
//no images. set the default one
model.DefaultPictureModel = new PictureModel()
{
ImageUrl = _pictureService.GetDefaultPictureUrl(_mediaSettings.ProductDetailsPictureSize),
FullSizeImageUrl = _pictureService.GetDefaultPictureUrl(),
Title = string.Format(_localizationService.GetResource("Media.Product.ImageLinkTitleFormat"), model.Name),
AlternateText = string.Format(_localizationService.GetResource("Media.Product.ImageAlternateTextFormat"), model.Name),
};
}
//product variants
foreach (var variant in _productService.GetProductVariantsByProductId(product.Id))
model.ProductVariantModels.Add(PrepareProductVariantModel(new ProductDetailsModel.ProductVariantModel(), variant));
return model;
}
private void UpdateLocales(Product product, ProductModel model)
{
foreach (var localized in model.Locales)
{
_localizedEntityService.SaveLocalizedValue(product,
x => x.Name,
localized.Name,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(product,
x => x.ShortDescription,
localized.ShortDescription,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(product,
x => x.FullDescription,
localized.FullDescription,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(product,
x => x.MetaKeywords,
localized.MetaKeywords,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(product,
x => x.MetaDescription,
localized.MetaDescription,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(product,
x => x.MetaTitle,
localized.MetaTitle,
localized.LanguageId);
//search engine name
var seName = product.ValidateSeName(localized.SeName, localized.Name, false);
_urlRecordService.SaveSlug(product, seName, localized.LanguageId);
}
}
protected void PrepareProductReviewsModel(ProductReviewsModel model, Product product)
{
if (product == null)
throw new ArgumentNullException("product");
if (model == null)
throw new ArgumentNullException("model");
model.ProductId = product.Id;
model.ProductName = product.GetLocalized(x => x.Name);
model.ProductSeName = product.GetSeName();
var productReviews = product.ProductReviews.Where(pr => pr.IsApproved).OrderBy(pr => pr.CreatedOnUtc);
foreach (var pr in productReviews)
{
var customer = pr.Customer;
model.Items.Add(new ProductReviewModel()
{
Id = pr.Id,
CustomerId = pr.CustomerId,
CustomerName = customer.FormatUserName(),
AllowViewingProfiles = _customerSettings.AllowViewingProfiles && customer != null && !customer.IsGuest(),
Title = pr.Title,
ReviewText = pr.ReviewText,
Rating = pr.Rating,
Helpfulness = new ProductReviewHelpfulnessModel()
{
ProductReviewId = pr.Id,
HelpfulYesTotal = pr.HelpfulYesTotal,
HelpfulNoTotal = pr.HelpfulNoTotal,
},
WrittenOnStr = _dateTimeHelper.ConvertToUserTime(pr.CreatedOnUtc, DateTimeKind.Utc).ToString("g"),
});
}
model.AddProductReview.CanCurrentCustomerLeaveReview = _catalogSettings.AllowAnonymousUsersToReviewProduct || !_workContext.CurrentCustomer.IsGuest();
model.AddProductReview.DisplayCaptcha = _captchaSettings.Enabled && _captchaSettings.ShowOnProductReviewPage;
}
protected IList<ProductSpecificationModel> PrepareProductSpecificationModel(Product product)
{
if (product == null)
throw new ArgumentNullException("product");
string cacheKey = string.Format(ModelCacheEventConsumer.PRODUCT_SPECS_MODEL_KEY, product.Id, _workContext.WorkingLanguage.Id);
return _cacheManager.Get(cacheKey, () =>
{
var model = _specificationAttributeService.GetProductSpecificationAttributesByProductId(product.Id, null, true)
.Select(psa =>
{
return new ProductSpecificationModel()
{
SpecificationAttributeId = psa.SpecificationAttributeOption.SpecificationAttributeId,
SpecificationAttributeName = psa.SpecificationAttributeOption.SpecificationAttribute.GetLocalized(x => x.Name),
SpecificationAttributeOption = !String.IsNullOrEmpty(psa.CustomValue) ? psa.CustomValue : psa.SpecificationAttributeOption.GetLocalized(x => x.Name),
};
}).ToList();
return model;
});
}
/// <summary>
/// Sends "email a friend" message
/// </summary>
/// <param name="customer">Customer instance</param>
/// <param name="languageId">Message language identifier</param>
/// <param name="product">Product instance</param>
/// <param name="customerEmail">Customer's email</param>
/// <param name="friendsEmail">Friend's email</param>
/// <param name="personalMessage">Personal message</param>
/// <returns>Queued email identifier</returns>
public virtual int SendProductEmailAFriendMessage(Customer customer, int languageId,
Product product, string customerEmail, string friendsEmail, string personalMessage)
{
if (customer == null)
throw new ArgumentNullException("customer");
if (product == null)
throw new ArgumentNullException("product");
var store = _storeContext.CurrentStore;
languageId = EnsureLanguageIsActive(languageId, store.Id);
var messageTemplate = GetLocalizedActiveMessageTemplate("Service.EmailAFriend", languageId, store.Id);
if (messageTemplate == null)
return 0;
//toekns
var tokens = new List<Token>();
_messageTokenProvider.AddStoreTokens(tokens, store);
_messageTokenProvider.AddCustomerTokens(tokens, customer);
_messageTokenProvider.AddProductTokens(tokens, product);
tokens.Add(new Token("EmailAFriend.PersonalMessage", personalMessage, true));
tokens.Add(new Token("EmailAFriend.Email", customerEmail));
//event notification
_eventPublisher.MessageTokensAdded(messageTemplate, tokens);
var emailAccount = GetEmailAccountOfMessageTemplate(messageTemplate, languageId);
var toEmail = friendsEmail;
var toName = "";
return SendNotification(messageTemplate, emailAccount,
languageId, tokens,
toEmail, toName);
}
private void PrepareAclModel(ProductModel model, Product product, bool excludeProperties)
{
if (model == null)
throw new ArgumentNullException("model");
model.AvailableCustomerRoles = _customerService
.GetAllCustomerRoles(true)
.Select(cr => cr.ToModel())
.ToList();
if (!excludeProperties)
{
if (product != null)
{
model.SelectedCustomerRoleIds = _aclService.GetCustomerRoleIdsWithAccess(product);
}
else
{
model.SelectedCustomerRoleIds = new int[0];
}
}
}
