Free totebag on orders above 99 €  •  Pizza deal save 25% - click here
Private | Partnershop 
Error executing template "Designs/Swift/eCom/ProductCatalog/ProductViewDetail.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Ecommerce.Products.ProductRepository.Dynamicweb.Ecommerce.Products.IProductRepository.GetProductKeysByGroupId(String groupId, Boolean useOrderBy, Boolean includeVariants, String productLanguageId, Boolean doRefactoring, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.ProcessProductSelections(HashSet`1& productKeys, HashSet`1& includedQueries, HashSet`1& excludedQueries)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.GetRelevantProductKeys()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.StatelessSetLookup(Discount discount, ConcurrentDictionary`2 lookup)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.InitializeLookup()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.GetDiscounts(DiscountApplyType[] discountTypes, String[] productKeys, User user)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountInfoCollection.LoadDiscounts()
   at Smartpage.EvaSolo.CampaignPrices.Extender.ProductIndexExtender.ExtendDocument(IndexDocument indexDocument) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\Extender\ProductIndexExtender.cs:line 29
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.WriteDocument(IndexDocument document, Int64 currentAutoId, IIndexWriter writer, Tracker tracker)
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)
ClientConnectionId:2c5d5499-8170-4f6c-908b-bac0f0db21a1
Error Number:-2,State:0,Class:11




  1     @inherits ViewModelTemplate<ProductViewModel>
  2     @using Dynamicweb.Rendering
  3     @using Dynamicweb.Ecommerce.ProductCatalog
  4     @using Dynamicweb.Core
  5     @using Dynamicweb.Environment
  6     
  7     @{
  8     	string metaDescription = string.IsNullOrEmpty(Model.MetaDescription) ? Model.Name : Model.MetaDescription;
  9     
 10     	Pageview.Meta.AddTag($"<meta property=\"og:image\" content=\"{Dynamicweb.Context.Current.Request.Url.Scheme}://{Dynamicweb.Context.Current.Request.Url.Host}{Model.DefaultImage.Value}\">");
 11     	Pageview.Meta.AddTag($"<meta property=\"og:image:alt\" content=\"{Model.Name}\">");
 12     	Pageview.Meta.AddTag($"<meta property=\"og:description\" content=\"{metaDescription}\">");
 13     
 14     	Pageview.Meta.AddTag("twitter:image", Model.DefaultImage.Value);
 15     	Pageview.Meta.AddTag("twitter:image:alt", Model.Name);
 16     	Pageview.Meta.AddTag("twitter:description", metaDescription);
 17     }
 18     
 19     @{
 20     	if (Dynamicweb.Context.Current.Items.Contains("ProductDetails"))
 21     	{
 22     		Dynamicweb.Context.Current.Items["ProductDetails"] = Model;
 23     	}
 24     	else
 25     	{
 26     		Dynamicweb.Context.Current.Items.Add("ProductDetails", Model);
 27     	}
 28     
 29     	bool isLazyLoadingForProductInfoEnabled = Dynamicweb.Core.Converter.ToBoolean(Dynamicweb.Context.Current.Items["IsLazyLoadingForProductInfoEnabled"]);
 30     	if (isLazyLoadingForProductInfoEnabled)
 31     	{
 32     		string showPricesWithVat = Pageview.Area.EcomPricesWithVat.ToLower();
 33     		bool neverShowVat = string.IsNullOrEmpty(showPricesWithVat);
 34     		bool hasVariantId = !string.IsNullOrEmpty(Model.VariantId);
 35     		string variantIdParam = hasVariantId ? $"/{Model.VariantId}" : "";
 36     		string priceFilledProperties = $"Price,PriceFormatted{(showPricesWithVat == "false" && !neverShowVat ? ",PriceWithVat,PriceWithVatFormatted" : "")}";
 37     		string productInfoFeed = $@"/dwapi/ecommerce/products/{Model.Id}{variantIdParam}
 38     	?UserId={Converter.ToString(Pageview.User?.ID)}
 39     	&LanguageId={Pageview.Area.EcomLanguageId}&CurrencyCode={Pageview.Area.EcomCurrencyId}&CountryCode={Pageview.Area.EcomCountryCode}&ShopId={Pageview.Area.EcomShopId}
 40     	&FilledProperties=Id,Price,PriceBeforeDiscount,StockLevel,VariantInfo,NeverOutOfstock,Prices
 41     	&PriceSettings.ShowPricesWithVat={Pageview.Area.EcomPricesWithVat}
 42     	&PriceSettings.FilledProperties={priceFilledProperties}
 43     	&getproductinfo=true";
 44     		Dynamicweb.Context.Current.Items["ProductInfoFeed"] = productInfoFeed;
 45     
 46     		<script type="module">
 47     			swift.LiveProductInfo.init();
 48     		</script>
 49     	}
 50     
 51     	string googleTagManagerID = Pageview.AreaSettings.GetString("GoogleTagManagerID");
 52     	string googleAnalyticsMeasurementID = Pageview.AreaSettings.GetString("GoogleAnalyticsMeasurementID");
 53     
 54     	bool allowTracking = true;
 55     	if (CookieManager.IsCookieManagementActive)
 56     	{
 57     		var cookieOptInLevel = CookieManager.GetCookieOptInLevel();
 58     		allowTracking = cookieOptInLevel == CookieOptInLevel.All || (cookieOptInLevel == CookieOptInLevel.Functional && CookieManager.GetCookieOptInCategories().Contains("Statistical"));
 59     	}
 60     
 61     	if ((!string.IsNullOrWhiteSpace(googleAnalyticsMeasurementID) || !string.IsNullOrWhiteSpace(googleTagManagerID)) && allowTracking)
 62     	{
 63     		<script>
 64           	window.addEventListener('CookieInformationConsentGiven', function (event) {
 65            		 if (CookieInformation.getConsentGivenFor('cookie_cat_necessary')) {
 66     				gtag("event", "view_item", {
 67     					currency: "@Model.Price.CurrencyCode",
 68     					value: @PriceViewModelExtensions.ToStringInvariant(Model.Price),
 69     					items: [
 70     					{
 71     						item_id: "@Model.Number",
 72     						item_name: "@Dynamicweb.Core.Encoders.HtmlEncoder.JavaScriptStringEncode(Model.Name)",
 73     						currency: "@Model.Price.CurrencyCode",
 74     						price: @PriceViewModelExtensions.ToStringInvariant(Model.Price)
 75     					}
 76     					]
 77     				});
 78           		}
 79            	}, false);
 80     		</script>
 81     	}
 82     }
 83     
 84     <script>
 85     	window.addEventListener('load', function (event) {
 86     		swift.Video.init();
 87     	});
 88     </script>
 89
DETAIL571016LANG1default
DETAIL571016LANG1Lifestyle_Photo_1
DETAIL571016LANG1Product_Photo_1
DETAIL571016LANG1Product_Photo_2
DETAIL571016LANG1Product_Photo_3
DETAIL571016LANG1Product_Photo_4
  1. Living
  2. Outdoor
  3. Bird feeding

Hanging suet bird feeder

Custom_USP1
Invite the little birds of winter, on something delicious for the beak
Custom_USP2
Provides easy access to the feed while large birds cannot fly away with it
Custom_USP3
Easy to see when more feed is needed
Custom_USP4
Easy installation with string for hanging on a branch or on an overhang
See description and product details 
Error executing template "Designs/Swift/Paragraph/Swift_ProductBadges_Custom.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Ecommerce.Products.ProductRepository.Dynamicweb.Ecommerce.Products.IProductRepository.GetProductKeysByGroupId(String groupId, Boolean useOrderBy, Boolean includeVariants, String productLanguageId, Boolean doRefactoring, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.ProcessProductSelections(HashSet`1& productKeys, HashSet`1& includedQueries, HashSet`1& excludedQueries)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.GetRelevantProductKeys()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.StatelessSetLookup(Discount discount, ConcurrentDictionary`2 lookup)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.InitializeLookup()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.GetDiscounts(DiscountApplyType[] discountTypes, String[] productKeys, User user)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountInfoCollection.LoadDiscounts()
   at Smartpage.EvaSolo.CampaignPrices.Extender.ProductIndexExtender.ExtendDocument(IndexDocument indexDocument) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\Extender\ProductIndexExtender.cs:line 29
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.WriteDocument(IndexDocument document, Int64 currentAutoId, IIndexWriter writer, Tracker tracker)
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)
ClientConnectionId:2c5d5499-8170-4f6c-908b-bac0f0db21a1
Error Number:-2,State:0,Class:11




  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     @using System
  3     @using System.Collections.Generic
  4     @using System.Linq
  5     @using Dynamicweb.Frontend
  6     @using Dynamicweb.Content
  7     @using Dynamicweb.Core
  8     @using Dynamicweb.Ecommerce.ProductCatalog
  9     
 10     @{
 11     	ProductViewModel product = null;
 12     	if (Dynamicweb.Context.Current.Items.Contains("ProductDetails"))
 13     	{
 14     		product = (ProductViewModel)Dynamicweb.Context.Current.Items["ProductDetails"];
 15     	}
 16     	else if (Pageview.Page.Item["DummyProduct"] != null && Pageview.IsVisualEditorMode)
 17     	{
 18     		var pageViewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreatePageInfoViewModel(Pageview.Page);
 19     		ProductListViewModel productList = pageViewModel.Item.GetValue("DummyProduct") != null ? pageViewModel.Item.GetValue("DummyProduct") as ProductListViewModel : new ProductListViewModel();
 20     
 21     		if (productList?.Products is object)
 22     		{
 23     			product = productList.Products[0];
 24     		}
 25     	}
 26     
 27     	DateTime launchDate = product.ProductFields.ContainsKey("Custom_LaunchDate") ? Converter.ToDateTime(product.ProductFields["Custom_LaunchDate"].Value) : DateTime.MinValue;
 28     	DateTime currentDate = DateTime.Today;
 29     	bool showComingSoonBadge = currentDate < launchDate && string.Equals( Model.Item.GetRawValueString("NewBadgeDesign"), "comingsoon", StringComparison.InvariantCultureIgnoreCase );
 30     }
 31     
 32     @if (product is object)
 33     {
 34     	var badgeParms = new Dictionary<string, object>();
 35     	badgeParms.Add("size", "h7");
 36     	badgeParms.Add("saleBadgeType", Model.Item.GetRawValue("SaleBadgeType"));
 37     	badgeParms.Add("saleBadgeCssClassName", Model.Item.GetRawValue("SaleBadgeDesign"));
 38     	badgeParms.Add("newBadgeCssClassName", Model.Item.GetRawValue("NewBadgeDesign"));
 39     	badgeParms.Add("newPublicationDays", Model.Item.GetInt32("NewPublicationDays"));
 40     	badgeParms.Add("campaignBadgesValues", Model.Item.GetRawValueString("CampaignBadges"));
 41     
 42     	string badgeSize = Model.Item.GetRawValueString("BadgeSize", "fs-2");
 43     	string horizontalAlign = Model.Item.GetRawValueString("HorizontalAlignment", "");
 44     	horizontalAlign = horizontalAlign == "center" ? "text-center" : horizontalAlign;
 45     	horizontalAlign = horizontalAlign == "end" ? "text-end" : horizontalAlign;
 46     
 47     	Dictionary<string, ParagraphInfoViewModel> badgeConfigurations;
 48     	List<string> campaignBadgesValues = Model.Item.GetRawValueString("CampaignBadges") != null ? Model.Item.GetRawValueString("CampaignBadges").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList() : new List<string>();
 49     
 50     	if (Dynamicweb.Context.Current.Items.Contains("badgeConfigurations"))
 51     	{
 52     		badgeConfigurations = (Dictionary<string, ParagraphInfoViewModel>)Dynamicweb.Context.Current.Items["badgeConfigurations"];
 53     	}
 54     	else
 55     	{
 56     		var badgesPage = Pageview.AreaSettings.GetLink("EcommerceBadgesPage") != null ? Pageview.AreaSettings.GetLink("EcommerceBadgesPage").PageId : 0;
 57     		var allBadges = badgesPage != 0 ? Dynamicweb.Content.Services.Paragraphs.GetParagraphsByPageId(badgesPage) : null;
 58     
 59     		badgeConfigurations = new Dictionary<string, ParagraphInfoViewModel>();
 60     
 61     		if ( allBadges != null )
 62     		{
 63     			foreach ( Paragraph badge in allBadges )
 64     			{
 65     				var paragraphviewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreateParagraphInfoViewModel( badge );
 66     				string cssClassName = paragraphviewModel.Item.GetString( "CssClassName" )?.Trim().ToLower() ?? string.Empty;;
 67     				if ( !badgeConfigurations.ContainsKey( cssClassName ) )
 68     				{
 69     					badgeConfigurations.Add( cssClassName, paragraphviewModel );
 70     				}
 71     			}
 72     		}
 73     
 74     		Dynamicweb.Context.Current.Items.Add("badgeConfigurations", badgeConfigurations);
 75     	}
 76     
 77     	int badgesCount = 0;
 78     	if (badgeConfigurations.Any())
 79     	{
 80     		foreach (string campaign in campaignBadgesValues)
 81     		{
 82     			if (!string.IsNullOrEmpty(campaign))
 83     			{
 84     				FieldValueViewModel availableCampaignsObject;
 85     				product.ProductFields.TryGetValue("Campaign", out availableCampaignsObject);
 86     
 87     				if (availableCampaignsObject != null)
 88     				{
 89     					string campaignType = string.Empty;
 90     
 91     					if (badgeConfigurations.ContainsKey(campaign))
 92     					{
 93     						ParagraphInfoViewModel paragraphviewModel;
 94     						if (badgeConfigurations.TryGetValue(campaign, out paragraphviewModel))
 95     						{
 96     							campaignType = paragraphviewModel.Item.GetRawValueString("CampaignType");
 97     						}
 98     					}
 99     
100     					List<FieldOptionValueViewModel> availableCampaigns = (List<FieldOptionValueViewModel>)availableCampaignsObject.Value;
101     
102     					foreach (FieldOptionValueViewModel availableOption in availableCampaigns)
103     					{
104     						if (campaignType == availableOption.Value)
105     						{
106     							badgesCount++;
107     							break;
108     						}
109     					}
110     				}
111     			}
112     		}
113     	}
114     
115     	bool saleBadgeEnabled = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("SaleBadgeDesign")) && Model.Item.GetRawValueString("SaleBadgeDesign") != "none" ? true : false;
116     	bool newBadgeEnabled = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("NewBadgeDesign")) && Model.Item.GetRawValueString("NewBadgeDesign") != "none" ? true : false;
117     	DateTime createdDate = product.Created.Value;
118     	bool showBadges = saleBadgeEnabled && product.Discount.Price != 0 ? true : false;
119     	showBadges = (newBadgeEnabled && Model.Item.GetInt32("NewPublicationDays") == 0) || (newBadgeEnabled && (createdDate.AddDays(Model.Item.GetInt32("NewPublicationDays")) > DateTime.Now)) ? true : showBadges;
120     	showBadges = (!string.IsNullOrEmpty(Model.Item.GetRawValueString("CampaignBadges")) && badgesCount != 0) || showComingSoonBadge || showBadges;
121     
122     	if (showBadges)
123     	{
124     		<div class="@badgeSize @horizontalAlign item_@Model.Item.SystemName.ToLower()">
125     			@RenderPartial("Components/EcommerceBadge_Custom.cshtml", product, badgeParms)
126     		</div>
127     	}
128     	else if (Pageview.IsVisualEditorMode)
129     	{
130     		<span class="badge bg-success text-light rounded-0">@Translate("Badge example")</span>
131     	}
132     }
133     else if (Pageview.IsVisualEditorMode)
134     {
135     	<span class="badge bg-success text-light rounded-0">@Translate("Badge example")</span>
136     }
137     
138     



Error executing template "/Designs/Swift/Paragraph/Swift_ProductPrice_Custom.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Ecommerce.Products.ProductRepository.Dynamicweb.Ecommerce.Products.IProductRepository.GetProductKeysByGroupId(String groupId, Boolean useOrderBy, Boolean includeVariants, String productLanguageId, Boolean doRefactoring, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.ProcessProductSelections(HashSet`1& productKeys, HashSet`1& includedQueries, HashSet`1& excludedQueries)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.GetRelevantProductKeys()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.StatelessSetLookup(Discount discount, ConcurrentDictionary`2 lookup)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.InitializeLookup()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.GetDiscounts(DiscountApplyType[] discountTypes, String[] productKeys, User user)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountInfoCollection.LoadDiscounts()
   at Smartpage.EvaSolo.CampaignPrices.Extender.ProductIndexExtender.ExtendDocument(IndexDocument indexDocument) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\Extender\ProductIndexExtender.cs:line 29
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.WriteDocument(IndexDocument document, Int64 currentAutoId, IIndexWriter writer, Tracker tracker)
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)
ClientConnectionId:2c5d5499-8170-4f6c-908b-bac0f0db21a1
Error Number:-2,State:0,Class:11




  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     @using Dynamicweb.Configuration @*//CUSTOM*@
  3     @using Dynamicweb.Core.Encoders @*//CUSTOM*@
  4     @using Dynamicweb.Ecommerce.ProductCatalog
  5     @using System.Globalization
  6     @using System.IO @*//CUSTOM*@
  7     
  8     @* CUSTOMIZED STANDARD SWIFT (v1.25.0) TEMPLATE *@
  9     
 10     @{
 11     	ProductViewModel product = null;
 12     	if (Dynamicweb.Context.Current.Items.Contains("ProductDetails"))
 13     	{
 14     		product = (ProductViewModel)Dynamicweb.Context.Current.Items["ProductDetails"];
 15     	}
 16     	else if (Pageview.Page.Item["DummyProduct"] != null && Pageview.IsVisualEditorMode)
 17     	{
 18     		var pageViewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreatePageInfoViewModel(Pageview.Page);
 19     		ProductListViewModel productList = pageViewModel.Item.GetValue("DummyProduct") != null ? pageViewModel.Item.GetValue("DummyProduct") as ProductListViewModel : new ProductListViewModel();
 20     
 21     		if (productList?.Products is object)
 22     		{
 23     			product = productList.Products[0];
 24     		}
 25     	}
 26     
 27     	string anonymousUsersLimitations = Pageview.AreaSettings.GetRawValueString("AnonymousUsers", "");
 28     	bool anonymousUser = Pageview.User == null;
 29     	bool isErpConnectionDown = !Dynamicweb.Core.Converter.ToBoolean(Dynamicweb.Context.Current.Items["IsWebServiceConnectionAvailable"]);
 30     	bool hidePrice = anonymousUsersLimitations.Contains("price") && anonymousUser || Pageview.AreaSettings.GetBoolean("ErpDownHidePrices") && isErpConnectionDown;
 31     
 32     	bool productIsDiscontinued = product is object && product.Discontinued;
 33     	bool doNotShowPriceIfProductIsDiscontinued = Model.Item.GetBoolean("DoNotShowPriceIfProductIsDiscontinued");
 34     	var isDiscontinued = productIsDiscontinued && doNotShowPriceIfProductIsDiscontinued;
 35     
 36     	//CUSTOM
 37     	var outletCampaign = SystemConfiguration.Instance.GetValue("/Globalsettings/Smartpage/Outlet/Campaign");
 38     	var productCampaigns = product is object && product.ProductFields.ContainsKey("Campaign") ? (product.ProductFields["Campaign"].Value as List<FieldOptionValueViewModel>) : new List<FieldOptionValueViewModel>();
 39     	var showOutlet = !string.IsNullOrEmpty(outletCampaign) && productCampaigns.Any(i => i.Value == outletCampaign);
 40     
 41     	var discountText = "";
 42     	if (showOutlet)
 43     	{
 44     		discountText = Translate("Outlet - tilbuddet gælder så længe lager haves");
 45     	}
 46     	else
 47     	{
 48     		var discountInfo = Smartpage.EvaSolo.CampaignPrices.Helpers.DiscountHelper.GetDiscountInfo(product.Id, product.VariantId, product.LanguageId);
 49     		if (discountInfo != null)
 50     		{
 51     			discountText = string.Format(Translate("Tilbuddet gælder {0} - {1}"), $"&zwnj;{discountInfo.ValidFromFormatted}&zwnj;", $"&zwnj;{discountInfo.ValidToFormatted}&zwnj;");
 52     		}
 53     	}
 54     	//--CUSTOM
 55     }
 56     
 57     @if (product is object && !hidePrice && !isDiscontinued)
 58     {
 59     	bool showInformativePrice = Model.Item.GetBoolean("ShowInformativePrice");
 60     	string unitId = !string.IsNullOrEmpty(Dynamicweb.Context.Current.Request.Form.Get("UnitId")) ? Dynamicweb.Context.Current.Request.Form.Get("UnitId") : string.Empty;
 61     
 62     	string priceFontSize = Model.Item.GetRawValueString("PriceSize", "h6 justify-content-lg-start"); //CUSTOM
 63     	string horizontalAlign = Model.Item.GetRawValueString("HorizontalAlignment", "");
 64     	string layout = Model.Item.GetRawValueString("Layout", "horizontal");
 65     	string textAlign = horizontalAlign == "center" ? "text-center" : string.Empty;
 66     	textAlign = horizontalAlign == "end" ? "text-end" : textAlign;
 67     
 68     	horizontalAlign = horizontalAlign == "center" && layout == "horizontal" ? "justify-content-center" : horizontalAlign;
 69     	horizontalAlign = horizontalAlign == "end" && layout == "horizontal" ? "justify-content-end" : horizontalAlign;
 70     	horizontalAlign = horizontalAlign == "center" && layout == "vertical" ? "align-items-center" : horizontalAlign;
 71     	horizontalAlign = horizontalAlign == "end" && layout == "vertical" ? "align-items-end" : horizontalAlign;
 72     
 73     	string flexDirection = layout == "horizontal" ? string.Empty : "flex-column";
 74     	string flexGap = layout == "horizontal" ? "gap-3" : string.Empty;
 75     	string order = layout == "horizontal" ? string.Empty : "order-2";
 76     	string theme = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("Theme")) ? "theme " + Model.Item.GetRawValueString("Theme").Replace(" ", "").Trim().ToLower() : "";
 77     	theme = GetViewParameter("theme") != null ? GetViewParameterString("theme") : theme;
 78     
 79     	string contentPadding = Model.Item.GetRawValueString("ContentPadding", "");
 80     	contentPadding = contentPadding == "none" ? "p-0" : contentPadding;
 81     	contentPadding = contentPadding == "small" ? "p-1 px-md-2 py-md-1" : contentPadding;
 82     	contentPadding = contentPadding == "large" ? "p-2 px-md-3 py-md-2" : contentPadding;
 83     
 84     	//CUSTOM
 85     	string discountType = Model.Item.GetRawValueString("Custom_DiscountType", "none");
 86     	string discountTheme = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("Custom_DiscountTheme")) ? "theme " + Model.Item.GetRawValueString("Custom_DiscountTheme").Replace(" ", "").Trim().ToLower() : string.Empty;
 87     	string discountIconColor = Model.Item.GetString("Custom_DiscountIconColor", "text-inherit");
 88     	string discountIconSize = Model.Item.GetRawValueString("Custom_DiscountIconSize", "2");
 89     	string discountImageSrc = !string.IsNullOrEmpty(Model.Item.GetString("Custom_DiscountImage")) ? Model.Item.GetFile("Custom_DiscountImage").Path : string.Empty;
 90     	string discountImagePath = discountImageSrc != string.Empty ? discountImageSrc : Model.Item.GetRawValueString("Custom_DiscountIcon", string.Empty);
 91     	discountImagePath = Path.GetExtension(discountImagePath).ToLower() != ".svg" ? "/Admin/Public/GetImage.ashx?image=" + discountImagePath + "&height=" + discountIconSize + "&width=" + discountIconSize + "&Crop=0&format=webp" : discountImagePath;
 92     	string discountImgAltText = Model.Item.GetRawValueString("FeatureAltText", string.Empty);
 93     	//--CUSTOM
 94     
 95     	string showPricesWithVat = Pageview.Area.EcomPricesWithVat.ToLower();
 96     	bool neverShowVat = string.IsNullOrEmpty(showPricesWithVat);
 97     
 98     	string priceMin = "";
 99     	string priceMax = "";
100     
101     	string liveInfoClass = "";
102     	string productInfoFeed = "";
103     	bool isLazyLoadingForProductInfoEnabled = Dynamicweb.Core.Converter.ToBoolean(Dynamicweb.Context.Current.Items["IsLazyLoadingForProductInfoEnabled"]);
104     	if (isLazyLoadingForProductInfoEnabled)
105     	{
106     		if (Dynamicweb.Context.Current.Items.Contains("ProductInfoFeed"))
107     		{
108     			productInfoFeed = Dynamicweb.Context.Current.Items["ProductInfoFeed"]?.ToString();
109     			if (!string.IsNullOrEmpty(productInfoFeed))
110     			{
111     				productInfoFeed = $"data-product-info-feed=\"{productInfoFeed}\"";
112     			}
113     		}
114     		liveInfoClass = "js-live-info";
115     	}
116     
117     	<div class="@textAlign @liveInfoClass item_@Model.Item.SystemName.ToLower()" data-product-id="@product.Id" data-variant-id="@product.VariantId" @productInfoFeed>
118     		@if (showInformativePrice && product.PriceInformative.Price != 0)
119     		{
120     			<div class="opacity-50">
121     				<span>@Translate("RRP") </span>
122     				<span class="text-decoration-line-through text-price">@product.PriceInformative.PriceFormatted</span>
123     			</div>
124     		}
125     		<div class="@priceFontSize m-0 d-flex flex-wrap @flexDirection @flexGap @horizontalAlign" style="row-gap: 0 !important" itemprop="offers" itemscope itemtype="https://schema.org/Offer">
126     			<span itemprop="priceCurrency" content="@product.Price.CurrencyCode" class="d-none"></span>
127     
128     			@if (showPricesWithVat == "false" && !neverShowVat)
129     			{
130     				if (isLazyLoadingForProductInfoEnabled && !Pageview.IsVisualEditorMode)
131     				{
132     					<span itemprop="price" content="" class="d-none"></span>
133     					<span class="text-decoration-line-through js-text-decoration-line-through opacity-75 me-3 text-price js-text-price d-none" data-show-if="LiveProductInfo.product.Price.Price != LiveProductInfo.product.PriceBeforeDiscount.Price"></span>
134     				}
135     				else
136     				{
137     					string beforePrice = !string.IsNullOrEmpty(unitId) ? product.GetPrice(unitId).PriceBeforeDiscount.PriceWithoutVatFormatted : product.PriceBeforeDiscount.PriceWithoutVatFormatted;
138     
139     					<span itemprop="price" content="@product.Price.PriceWithoutVat.ToString(CultureInfo.InvariantCulture)" class="d-none"></span> @*//CUSTOM*@
140     					if (product.Price.Price != product.PriceBeforeDiscount.Price)
141     					{
142     						<span class="text-decoration-line-through opacity-75 @order">@beforePrice</span>
143     					}
144     				}
145     			}
146     			else
147     			{
148     				if (isLazyLoadingForProductInfoEnabled && !Pageview.IsVisualEditorMode)
149     				{
150     					<span itemprop="price" content="" class="d-none"></span>
151     					<span class="text-decoration-line-through js-text-decoration-line-through opacity-75 me-3 text-price js-text-price d-none" data-show-if="LiveProductInfo.product.Price.Price < LiveProductInfo.product.PriceBeforeDiscount.Price"></span> @*//CUSTOM*@
152     				}
153     				else
154     				{
155     					string beforePrice = !string.IsNullOrEmpty(unitId) ? product.GetPrice(unitId).PriceBeforeDiscount.PriceFormatted : product.PriceBeforeDiscount.PriceFormatted;
156     
157     					<span itemprop="price" content="@product.Price.Price.ToString(CultureInfo.InvariantCulture)" class="d-none"></span> @*//CUSTOM*@
158     
159     					if (product.Price.Price < product.PriceBeforeDiscount.Price)
160     					{
161     						<span class="text-decoration-line-through opacity-75 @order">
162     							<span class="text-price">@beforePrice</span>
163     						</span>
164     					}
165     				}
166     			}
167     
168     			@if (showPricesWithVat == "false" && !neverShowVat)
169     			{
170     				if (isLazyLoadingForProductInfoEnabled && !Pageview.IsVisualEditorMode)
171     				{
172     					<span class="text-price js-text-price">
173     						<span class="spinner-border" role="status"></span>
174     					</span>
175     				}
176     				else
177     				{
178     					string price = !string.IsNullOrEmpty(unitId) ? product.GetPrice(unitId).Price.PriceWithoutVatFormatted : product.Price.PriceWithoutVatFormatted;
179     
180     					if (product?.VariantInfo?.VariantInfo != null)
181     					{
182     						priceMin = product?.VariantInfo?.PriceMin?.PriceWithoutVatFormatted != null ? product.VariantInfo.PriceMin.PriceWithoutVatFormatted : "";
183     						priceMax = product?.VariantInfo?.PriceMax?.PriceWithoutVatFormatted != null ? product.VariantInfo.PriceMax.PriceWithoutVatFormatted : "";
184     					}
185     					if (priceMin != priceMax)
186     					{
187     						price = priceMin + " - " + priceMax;
188     					}
189     					<span class="@theme"> @*//CUSTOM*@
190     						<span class="text-price">@price</span>
191     					</span>
192     				}
193     			}
194     			else
195     			{
196     				if (isLazyLoadingForProductInfoEnabled && !Pageview.IsVisualEditorMode)
197     				{
198     					<span class="text-price js-text-price">
199     						<span class="spinner-border" role="status"></span>
200     					</span>
201     				}
202     				else
203     				{
204     					string price = !string.IsNullOrEmpty(unitId) ? product.GetPrice(unitId).Price.PriceFormatted : product.Price.PriceFormatted;
205     
206     					if (product?.VariantInfo?.VariantInfo != null)
207     					{
208     						priceMin = product?.VariantInfo?.PriceMin?.PriceFormatted != null ? product.VariantInfo.PriceMin.PriceFormatted : "";
209     						priceMax = product?.VariantInfo?.PriceMax?.PriceFormatted != null ? product.VariantInfo.PriceMax.PriceFormatted : "";
210     					}
211     					if (priceMin != priceMax)
212     					{
213     						price = priceMin + " - " + priceMax;
214     					}
215     					<span class="@theme"> @*//CUSTOM*@
216     						<span class="text-price">@price</span>
217     					</span>
218     				}
219     			}
220     
221     			@*//CUSTOM*@
222     			@if (discountType == "icon-tooltip" && product.Price.Price != product.PriceBeforeDiscount.Price)
223     			{
224     				var discountInfo = Smartpage.EvaSolo.CampaignPrices.Helpers.DiscountHelper.GetDiscountInfo(product.Id, product.VariantId, product.LanguageId);
225     				if (discountInfo != null)
226     				{
227     					if ((!string.IsNullOrEmpty(Model.Item.GetString("Custom_DiscountImage")) || !discountImagePath.ToLower().Contains("none")) && discountImagePath != string.Empty)
228     					{
229     						<span data-bs-toggle="tooltip" data-bs-custom-class="@(discountTheme)" data-bs-html="true" data-bs-title="@HtmlEncoder.HtmlAttributeEncode(discountText)" data-bs-custom-prevent-event="click" data-bs-custom-click-close-delay="2000">
230     							@if (Path.GetExtension(discountImagePath).ToLower() == ".svg")
231     							{
232     								<span class="icon-auto @(discountIconColor)" style="vertical-align:text-top;height:@(discountIconSize)px;width:@(discountIconSize)px;">@ReadFile(discountImagePath)</span>
233     							}
234     							else
235     							{
236     								<img loading="lazy" src="@(discountImagePath)" alt="@HtmlEncoder.HtmlAttributeEncode(discountImgAltText)" title="@HtmlEncoder.HtmlAttributeEncode(discountImgAltText)" style="height:@(discountIconSize)px;width:@(discountIconSize)px;">
237     							}
238     						</span>
239     					}
240     				}
241     			}
242     			@*//--CUSTOM*@
243     
244     			@* Stock state for Schema.org, start *@
245     			@{
246     				Uri url = Dynamicweb.Context.Current.Request.Url;
247     			}
248     
249     			<link itemprop="url" href="@url">
250     
251     			@{
252     				bool IsNeverOutOfStock = product.NeverOutOfstock;
253     			}
254     
255     			@if (IsNeverOutOfStock)
256     			{
257     				<span itemprop="availability" class="d-none">@Translate("Available in stock")</span>
258     			}
259     			else
260     			{
261     				if (product.StockLevel > 0)
262     				{
263     					<span itemprop="availability" class="d-none">InStock</span>
264     				}
265     				else
266     				{
267     					<span itemprop="availability" class="d-none">OutOfStock</span>
268     				}
269     			}
270     			@* Stock state for Schema.org, stop *@
271     
272     		</div>
273     
274     		@if (showPricesWithVat == "false" && !neverShowVat)
275     		{
276     			if (isLazyLoadingForProductInfoEnabled && !Pageview.IsVisualEditorMode)
277     			{
278     				<small class="opacity-85 fst-normal js-text-price-with-vat d-none" data-suffix="@Translate("Incl. VAT")"></small>
279     			}
280     			else
281     			{
282     				string price = !string.IsNullOrEmpty(unitId) ? product.GetPrice(unitId).Price.PriceWithVatFormatted : product.Price.PriceWithVatFormatted;
283     
284     				if (product?.VariantInfo?.VariantInfo != null)
285     				{
286     					priceMin = product?.VariantInfo?.PriceMin?.PriceWithVatFormatted != null ? product.VariantInfo.PriceMin.PriceWithVatFormatted : "";
287     					priceMax = product?.VariantInfo?.PriceMax?.PriceWithVatFormatted != null ? product.VariantInfo.PriceMax.PriceWithVatFormatted : "";
288     				}
289     				if (priceMin != priceMax)
290     				{
291     					price = priceMin + " - " + priceMax;
292     				}
293     				<small class="opacity-85 fst-normal">@price @Translate("Incl. VAT")</small>
294     			}
295     		}
296     
297     		@*//CUSTOM*@
298     		@if (discountType == "inline" && product.Price.Price != product.PriceBeforeDiscount.Price && !string.IsNullOrEmpty(discountText))
299     		{
300     			var discountFontSize = priceFontSize.Contains("h6") ? priceFontSize.Replace("h6", "small") : "small";
301     
302     			<div class="@(discountFontSize) mt-1 d-flex flex-wrap @(flexDirection) @(horizontalAlign)">
303     				@discountText
304     			</div>
305     		}
306     		@*//--CUSTOM*@
307     
308     	</div>
309     }
310     else if (Pageview.IsVisualEditorMode)
311     {
312     	<div class="alert alert-dark m-0" role="alert">
313     		<span>@Translate("No products available")</span>
314     	</div>
315     }
316     



Error executing template "Designs/Swift/Paragraph/Swift_ProductBadges_Custom.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Ecommerce.Products.ProductRepository.Dynamicweb.Ecommerce.Products.IProductRepository.GetProductKeysByGroupId(String groupId, Boolean useOrderBy, Boolean includeVariants, String productLanguageId, Boolean doRefactoring, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.ProcessProductSelections(HashSet`1& productKeys, HashSet`1& includedQueries, HashSet`1& excludedQueries)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.GetRelevantProductKeys()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.StatelessSetLookup(Discount discount, ConcurrentDictionary`2 lookup)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.InitializeLookup()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.GetDiscounts(DiscountApplyType[] discountTypes, String[] productKeys, User user)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountInfoCollection.LoadDiscounts()
   at Smartpage.EvaSolo.CampaignPrices.Extender.ProductIndexExtender.ExtendDocument(IndexDocument indexDocument) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\Extender\ProductIndexExtender.cs:line 29
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.WriteDocument(IndexDocument document, Int64 currentAutoId, IIndexWriter writer, Tracker tracker)
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)
ClientConnectionId:2c5d5499-8170-4f6c-908b-bac0f0db21a1
Error Number:-2,State:0,Class:11




  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     @using System
  3     @using System.Collections.Generic
  4     @using System.Linq
  5     @using Dynamicweb.Frontend
  6     @using Dynamicweb.Content
  7     @using Dynamicweb.Core
  8     @using Dynamicweb.Ecommerce.ProductCatalog
  9     
 10     @{
 11     	ProductViewModel product = null;
 12     	if (Dynamicweb.Context.Current.Items.Contains("ProductDetails"))
 13     	{
 14     		product = (ProductViewModel)Dynamicweb.Context.Current.Items["ProductDetails"];
 15     	}
 16     	else if (Pageview.Page.Item["DummyProduct"] != null && Pageview.IsVisualEditorMode)
 17     	{
 18     		var pageViewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreatePageInfoViewModel(Pageview.Page);
 19     		ProductListViewModel productList = pageViewModel.Item.GetValue("DummyProduct") != null ? pageViewModel.Item.GetValue("DummyProduct") as ProductListViewModel : new ProductListViewModel();
 20     
 21     		if (productList?.Products is object)
 22     		{
 23     			product = productList.Products[0];
 24     		}
 25     	}
 26     
 27     	DateTime launchDate = product.ProductFields.ContainsKey("Custom_LaunchDate") ? Converter.ToDateTime(product.ProductFields["Custom_LaunchDate"].Value) : DateTime.MinValue;
 28     	DateTime currentDate = DateTime.Today;
 29     	bool showComingSoonBadge = currentDate < launchDate && string.Equals( Model.Item.GetRawValueString("NewBadgeDesign"), "comingsoon", StringComparison.InvariantCultureIgnoreCase );
 30     }
 31     
 32     @if (product is object)
 33     {
 34     	var badgeParms = new Dictionary<string, object>();
 35     	badgeParms.Add("size", "h7");
 36     	badgeParms.Add("saleBadgeType", Model.Item.GetRawValue("SaleBadgeType"));
 37     	badgeParms.Add("saleBadgeCssClassName", Model.Item.GetRawValue("SaleBadgeDesign"));
 38     	badgeParms.Add("newBadgeCssClassName", Model.Item.GetRawValue("NewBadgeDesign"));
 39     	badgeParms.Add("newPublicationDays", Model.Item.GetInt32("NewPublicationDays"));
 40     	badgeParms.Add("campaignBadgesValues", Model.Item.GetRawValueString("CampaignBadges"));
 41     
 42     	string badgeSize = Model.Item.GetRawValueString("BadgeSize", "fs-2");
 43     	string horizontalAlign = Model.Item.GetRawValueString("HorizontalAlignment", "");
 44     	horizontalAlign = horizontalAlign == "center" ? "text-center" : horizontalAlign;
 45     	horizontalAlign = horizontalAlign == "end" ? "text-end" : horizontalAlign;
 46     
 47     	Dictionary<string, ParagraphInfoViewModel> badgeConfigurations;
 48     	List<string> campaignBadgesValues = Model.Item.GetRawValueString("CampaignBadges") != null ? Model.Item.GetRawValueString("CampaignBadges").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList() : new List<string>();
 49     
 50     	if (Dynamicweb.Context.Current.Items.Contains("badgeConfigurations"))
 51     	{
 52     		badgeConfigurations = (Dictionary<string, ParagraphInfoViewModel>)Dynamicweb.Context.Current.Items["badgeConfigurations"];
 53     	}
 54     	else
 55     	{
 56     		var badgesPage = Pageview.AreaSettings.GetLink("EcommerceBadgesPage") != null ? Pageview.AreaSettings.GetLink("EcommerceBadgesPage").PageId : 0;
 57     		var allBadges = badgesPage != 0 ? Dynamicweb.Content.Services.Paragraphs.GetParagraphsByPageId(badgesPage) : null;
 58     
 59     		badgeConfigurations = new Dictionary<string, ParagraphInfoViewModel>();
 60     
 61     		if ( allBadges != null )
 62     		{
 63     			foreach ( Paragraph badge in allBadges )
 64     			{
 65     				var paragraphviewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreateParagraphInfoViewModel( badge );
 66     				string cssClassName = paragraphviewModel.Item.GetString( "CssClassName" )?.Trim().ToLower() ?? string.Empty;;
 67     				if ( !badgeConfigurations.ContainsKey( cssClassName ) )
 68     				{
 69     					badgeConfigurations.Add( cssClassName, paragraphviewModel );
 70     				}
 71     			}
 72     		}
 73     
 74     		Dynamicweb.Context.Current.Items.Add("badgeConfigurations", badgeConfigurations);
 75     	}
 76     
 77     	int badgesCount = 0;
 78     	if (badgeConfigurations.Any())
 79     	{
 80     		foreach (string campaign in campaignBadgesValues)
 81     		{
 82     			if (!string.IsNullOrEmpty(campaign))
 83     			{
 84     				FieldValueViewModel availableCampaignsObject;
 85     				product.ProductFields.TryGetValue("Campaign", out availableCampaignsObject);
 86     
 87     				if (availableCampaignsObject != null)
 88     				{
 89     					string campaignType = string.Empty;
 90     
 91     					if (badgeConfigurations.ContainsKey(campaign))
 92     					{
 93     						ParagraphInfoViewModel paragraphviewModel;
 94     						if (badgeConfigurations.TryGetValue(campaign, out paragraphviewModel))
 95     						{
 96     							campaignType = paragraphviewModel.Item.GetRawValueString("CampaignType");
 97     						}
 98     					}
 99     
100     					List<FieldOptionValueViewModel> availableCampaigns = (List<FieldOptionValueViewModel>)availableCampaignsObject.Value;
101     
102     					foreach (FieldOptionValueViewModel availableOption in availableCampaigns)
103     					{
104     						if (campaignType == availableOption.Value)
105     						{
106     							badgesCount++;
107     							break;
108     						}
109     					}
110     				}
111     			}
112     		}
113     	}
114     
115     	bool saleBadgeEnabled = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("SaleBadgeDesign")) && Model.Item.GetRawValueString("SaleBadgeDesign") != "none" ? true : false;
116     	bool newBadgeEnabled = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("NewBadgeDesign")) && Model.Item.GetRawValueString("NewBadgeDesign") != "none" ? true : false;
117     	DateTime createdDate = product.Created.Value;
118     	bool showBadges = saleBadgeEnabled && product.Discount.Price != 0 ? true : false;
119     	showBadges = (newBadgeEnabled && Model.Item.GetInt32("NewPublicationDays") == 0) || (newBadgeEnabled && (createdDate.AddDays(Model.Item.GetInt32("NewPublicationDays")) > DateTime.Now)) ? true : showBadges;
120     	showBadges = (!string.IsNullOrEmpty(Model.Item.GetRawValueString("CampaignBadges")) && badgesCount != 0) || showComingSoonBadge || showBadges;
121     
122     	if (showBadges)
123     	{
124     		<div class="@badgeSize @horizontalAlign item_@Model.Item.SystemName.ToLower()">
125     			@RenderPartial("Components/EcommerceBadge_Custom.cshtml", product, badgeParms)
126     		</div>
127     	}
128     	else if (Pageview.IsVisualEditorMode)
129     	{
130     		<span class="badge bg-success text-light rounded-0">@Translate("Badge example")</span>
131     	}
132     }
133     else if (Pageview.IsVisualEditorMode)
134     {
135     	<span class="badge bg-success text-light rounded-0">@Translate("Badge example")</span>
136     }
137     
138     



Error executing template "/Designs/Swift/Paragraph/Swift_ProductAddToCart_Custom.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout)
   at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout)
   at Dynamicweb.Ecommerce.Products.ProductRepository.Dynamicweb.Ecommerce.Products.IProductRepository.GetProductKeysByGroupId(String groupId, Boolean useOrderBy, Boolean includeVariants, String productLanguageId, Boolean doRefactoring, Boolean useAssortments)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.ProcessProductSelections(HashSet`1& productKeys, HashSet`1& includedQueries, HashSet`1& excludedQueries)
   at Dynamicweb.Ecommerce.Orders.Discounts.Discount.GetRelevantProductKeys()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.StatelessSetLookup(Discount discount, ConcurrentDictionary`2 lookup)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.InitializeLookup()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountService.GetDiscounts(DiscountApplyType[] discountTypes, String[] productKeys, User user)
   at Dynamicweb.Ecommerce.Orders.Discounts.DiscountInfoCollection.LoadDiscounts()
   at Smartpage.EvaSolo.CampaignPrices.Extender.ProductIndexExtender.ExtendDocument(IndexDocument indexDocument) in D:\a\1\s\Smartpage.EvaSolo.CampaignPrices\Extender\ProductIndexExtender.cs:line 29
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.WriteDocument(IndexDocument document, Int64 currentAutoId, IIndexWriter writer, Tracker tracker)
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)
ClientConnectionId:2c5d5499-8170-4f6c-908b-bac0f0db21a1
Error Number:-2,State:0,Class:11




  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     @using System
  3     @using Dynamicweb.Ecommerce.ProductCatalog
  4     @using Dynamicweb.Ecommerce.CustomerExperienceCenter.Favorites
  5     @using Dynamicweb.Ecommerce.Products.FieldDisplayGroups
  6     @using Dynamicweb.Frontend
  7     @using Dynamicweb.Core
  8     @using System.Drawing
  9     @using System.Web
 10     @using Dynamicweb.Environment
 11     @using System.Globalization
 12     
 13     @* TODO: REFACTURE/UPGRADE TO SWIFT (v1.25.0) *@
 14     
 15     @{
 16     	bool isVisualEditor = !string.IsNullOrEmpty(Dynamicweb.Context.Current.Request.QueryString.Get("VisualEdit")) ? Convert.ToBoolean(Dynamicweb.Context.Current.Request.QueryString.Get("VisualEdit")) : false;
 17     
 18     	ProductViewModel product = new ProductViewModel();
 19     
 20     	ProductViewModelSettings productSetting = new ProductViewModelSettings
 21     	{
 22     		LanguageId = Dynamicweb.Ecommerce.Common.Context.LanguageID,
 23     		CurrencyCode = Dynamicweb.Ecommerce.Common.Context.Currency.Code,
 24     		CountryCode = Dynamicweb.Ecommerce.Common.Context.Country.Code2,
 25     		ShopId = Pageview.Area.EcomShopId
 26     	};
 27     
 28     	if (Dynamicweb.Context.Current.Items.Contains("ProductDetails"))
 29     	{
 30     		product = (ProductViewModel)Dynamicweb.Context.Current.Items["ProductDetails"];
 31     	}
 32     	else if (Pageview.Item["DummyProduct"] != null)
 33     	{
 34     
 35     		string dummyProductId = "";
 36     		var pageViewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreatePageInfoViewModel(Pageview.Page);
 37     		ProductListViewModel productList = pageViewModel.Item.GetValue("DummyProduct") != null ? pageViewModel.Item.GetValue("DummyProduct") as ProductListViewModel : new ProductListViewModel();
 38     		if (productList.Products != null)
 39     		{
 40     			foreach (var p in productList.Products) { dummyProductId = p.Id; }
 41     			ProductViewModel dummyProduct = dummyProductId != "" ? ViewModelFactory.CreateView(productSetting, dummyProductId) : new ProductViewModel();
 42     			product = dummyProduct;
 43     		}
 44     		else
 45     		{
 46     			product = ViewModelFactory.CreateView(productSetting, Dynamicweb.Ecommerce.Services.Products.GetLastActiveProducts(1, Dynamicweb.Ecommerce.Common.Context.LanguageID, false).FirstOrDefault().Id);
 47     		}
 48     	}
 49     	else if (Pageview.Item["DummyProduct"] == null)
 50     	{
 51     		product = ViewModelFactory.CreateView(productSetting, Dynamicweb.Ecommerce.Services.Products.GetLastActiveProducts(1, Dynamicweb.Ecommerce.Common.Context.LanguageID, false).FirstOrDefault().Id);
 52     	}
 53     
 54     	string url = "/Default.aspx?ID=" + (GetPageIdByNavigationTag("CartService"));
 55     	if (!url.Contains("LayoutTemplate"))
 56     	{
 57     		url += url.Contains("?") ? "&LayoutTemplate=Swift_MiniCart.cshtml" : "?LayoutTemplate=Swift_MiniCart.cshtml";
 58     	}
 59     	bool stockLevelZeroOrless = product.StockLevel <= 0;
 60     	bool isDiscontinued = product.Discontinued;
 61     	bool IsNeverOutOfStock = product.NeverOutOfstock;
 62     	bool plytixIsNotForSale = product.ProductFields.ContainsKey("Custom_NotForSale") ? Converter.ToBoolean(product.ProductFields["Custom_NotForSale"].Value) : false;
 63     	string anonymousUsersLimitations = Pageview.AreaSettings.GetRawValueString("AnonymousUsers", "");
 64     	bool anonymousUser = Pageview.User == null;
 65     	bool isErpConnectionDown = !Dynamicweb.Core.Converter.ToBoolean(Dynamicweb.Context.Current.Items["IsWebServiceConnectionAvailable"]);
 66     	bool hideAddToCart = anonymousUsersLimitations.Contains("cart") && anonymousUser || Pageview.AreaSettings.GetBoolean("ErpDownHideAddToCart") && isErpConnectionDown;
 67     	hideAddToCart = product?.VariantInfo?.VariantInfo != null && Model.Item.GetBoolean("HideVariantSelector") ? true : hideAddToCart;
 68     	bool isCartDisabled = stockLevelZeroOrless || isDiscontinued;
 69     	isCartDisabled = IsNeverOutOfStock ? false : isCartDisabled;
 70     	string disableAddToCart = isCartDisabled ? "disabled" : "";
 71     	string minQty = product.PurchaseMinimumQuantity != 1 ? "min=\"" + product.PurchaseMinimumQuantity.ToString() + "\"" : "min=\"1\"";
 72     	string stepQty = product.PurchaseQuantityStep > 1 ? product.PurchaseQuantityStep.ToString() : "1";
 73     	string valueQty = product.PurchaseMinimumQuantity > product.PurchaseQuantityStep ? product.PurchaseMinimumQuantity.ToString() : stepQty;
 74     	string qtyValidCheck = stepQty != "1" ? "onkeyup=\"swift.Cart.QuantityValidate(event)\"" : "";
 75     }
 76     
 77     @if (!hideAddToCart)
 78     {
 79     	DateTime launchDate = product.ProductFields.ContainsKey("Custom_LaunchDate") ? Converter.ToDateTime(product.ProductFields["Custom_LaunchDate"].Value) : DateTime.MinValue;
 80     	DateTime currentDate = DateTime.Today;
 81     
 82     	if ( currentDate < launchDate )
 83     	{
 84     		<p class="mb-1 mt-2">@Translate("Available from") @launchDate.ToLocalTime().ToLongDateString()</p>
 85     	}
 86     	else
 87     	{
 88     	<div class="d-flex flex-row flex-nowrap gap-2 order-2 order-lg-4 mb-3 mb-lg-0">
 89     		<form method="post" action="@url" class="flex-fill">
 90     			<input type="hidden" name="redirect" value="false">
 91     			<input type="hidden" name="ProductId" value="@product.Id">
 92     			<input type="hidden" name="ProductName" value="@Dynamicweb.Core.Encoders.HtmlEncoder.HtmlAttributeEncode(product.Name)">
 93     			<input type="hidden" name="ProductPrice" value="@product.Price.Price">
 94     			<input type="hidden" name="ProductCurrency" value="@product.Price.CurrencyCode">
 95     			<input type="hidden" name="ProductReferer" value="product_details_info">
 96     			<input type="hidden" name="cartcmd" value="add">
 97     
 98     			@if (!string.IsNullOrEmpty(product.VariantId))
 99     			{
100     				<input type="hidden" name="VariantId" value="@product.VariantId">
101     			}
102     
103     			@if (!plytixIsNotForSale)
104     			{
105     				if (Model.Item.GetBoolean("QuantitySelector") || isCartDisabled)
106     				{
107     					string buttonTitle = isCartDisabled ? Translate("Sold out") : Translate("Add to cart");
108     
109     					<input id="Quantity_@product.Id" name="Quantity" value="@valueQty" type="hidden">
110     					<button type="button" onclick="swift.Cart.Update(event)" class="btn btn-primary w-100 js-add-to-cart-button @disableAddToCart" @disableAddToCart title="@Dynamicweb.Core.Encoders.HtmlEncoder.HtmlAttributeEncode(buttonTitle)" id="AddToCartButton@(product.Id)_@Pageview.CurrentParagraph.ID">@buttonTitle</button>
111     				}
112     				else
113     				{
114     					<div class="input-group input-primary-button-group js-input-group d-flex flex-row flex-nowrap">
115     						<label for="Quantity_@(product.Id)" class="visually-hidden">@Translate("Quantity")</label>
116     						<input id="Quantity_@product.Id" name="Quantity" value="@valueQty" step="@stepQty" @minQty class="form-control" style="max-width: 96px; min-width:64px;" type="number" onkeydown="swift.Cart.UpdateOnEnterKey(event)">
117     						<button type="button" onclick="swift.Cart.Update(event)" class="btn btn-primary flex-fill js-add-to-cart-button @disableAddToCart" @disableAddToCart title="@Dynamicweb.Core.Encoders.HtmlEncoder.HtmlAttributeEncode(Translate("Add to cart"))" id="AddToCartButton@(product.Id)_@Pageview.CurrentParagraph.ID">@Translate("Add to cart")</button>
118     					</div>
119     				}
120     
121     				if (stepQty != "1")
122     				{
123     					<div class="invalid-feedback d-none">
124     						@Translate("Please select a quantity that is dividable by") @stepQty
125     					</div>
126     				}
127     			}
128     		</form>
129     	</div>
130     	}
131     }
132

Delivery from €5
Free delivery on orders over €89
14 days full refund

Invite small birds for a treat like seeded suet cakes or fat balls and serve them in a hanging bird feeder. The suet bird feeder gives the birds easy access to the food, and prevents large birds from snatching the treats. The bird feeder holder takes three suet fat balls, and it is easy to see when it needs refilling. To refill, simply lift the black top. Easy to attach using string to a tree or window eave so you can watch the busy birds.

Read more
Color Black
Cleaning Wash by hand.
Dishwasher Safe Yes
Material: polyester,powder-coated stainless steel,stainless steel
Height (cm) 26
Width (cm) 8
Depth (cm) 8
Diameter (cm): 7.5
Weight (kg): 0.38
Designer: Tools Design
Brand Eva Solo
SKU 571016
EAN 5706631217552
Hanging suet bird feeder

Eva Solo community

Tag us in your instagram post to be featured in our Eva Solo community.
Use one of the following tags: @evasolo_official, #evasolo, #evatrio or #evasolofurniture

Related content