Error executing template "Designs/Swift/Components/EcommerceBadge.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   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 Dynamicweb.Ecommerce.ProductCatalog.ViewEngine.GetDiscountInfo(PriceViewModelSettings settings, Product product)
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at Dynamicweb.Ecommerce.ProductCatalog.ViewEngine.<>c__DisplayClass3_2.<BulkCreateView>b__46()
   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.ProductCatalog.ViewEngine.GetPrice(PriceViewModelSettings settings, IList`1 products, Boolean& pricesHasBeenPrepared, Object lock, Lazy`1 priceInfo)
   at Dynamicweb.Ecommerce.ProductCatalog.ViewEngine.<>c__DisplayClass3_2.<BulkCreateView>b__51()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at CompiledRazorTemplates.Dynamic.RazorEngine_fb9df43abab648c49d8b429ac825bcdb.Execute() in D:\dynamicweb.net\Solutions\brdklee.cloud.dynamicweb-cms.com\files\Templates\Designs\Swift\Components\EcommerceBadge.cshtml:line 16
   at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader)
   at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag)
   at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass16_0.<RunCompile>b__0(TextWriter writer)
   at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
   at Dynamicweb.Rendering.RazorTemplateRenderingProvider.Render(Template template)
   at Dynamicweb.Rendering.TemplateRenderingService.Render(Template template)
   at Dynamicweb.Rendering.Template.RenderRazorTemplate()
ClientConnectionId:fef7765e-6e46-4ec9-ae86-c26a77b01d5e
Error Number:1205,State:52,Class:13


  1     @inherits ViewModelTemplate<ProductViewModel>
  2     @using Dynamicweb.Frontend
  3     @using Dynamicweb.Content
  4     @using Dynamicweb.Rendering
  5     @using Dynamicweb.Ecommerce.ProductCatalog
  6     
  7     @{
  8     	string sizeCssClass = GetViewParameter("size") != null ? GetViewParameter("size").ToString() : "";
  9     	string newBadgeCssClassName = GetViewParameter("newBadgeCssClassName") != null ? GetViewParameterString("newBadgeCssClassName").Trim().ToLower() : "";
 10     	bool newBadgeEnabled = newBadgeCssClassName != "" && newBadgeCssClassName != "none" ? true : false;
 11     
 12     	List<string> campaignBadgesValues = GetViewParameter("campaignBadgesValues") != null ? GetViewParameterString("campaignBadgesValues").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList() : new List<string>();
 13     }
 14     
 15     
 16     @if (Model.Discount.Price != 0)
 17     {
 18     	string saleBadgeCssClassName = GetViewParameter("saleBadgeCssClassName") != null ? GetViewParameterString("saleBadgeCssClassName").Trim().ToLower() : "";
 19     	bool saleBadgeEnabled = saleBadgeCssClassName != "" && saleBadgeCssClassName != "none" ? true : false;
 20     
 21     	if (saleBadgeEnabled)
 22     	{
 23     		string saleBadgeType = GetViewParameter("saleBadgeType") != null ? GetViewParameterString("saleBadgeType") : "amount";
 24     		string title = saleBadgeType == "amount" ? "-" + Model.Discount.PriceFormatted : "";
 25     		title = saleBadgeType == "percentage" ? "-" + Math.Round((Model.Discount.Price / Model.PriceBeforeDiscount.Price) * 100) + "%" : title;
 26     
 27     		string hideAutoLabel = "";
 28     		if (saleBadgeType == "amount" || saleBadgeType == "percentage")
 29     		{
 30     			hideAutoLabel = "badge-no-label";
 31     		}
 32     
 33     		<span class="@sizeCssClass"><span class="badge @hideAutoLabel @(saleBadgeCssClassName) rounded-0">@title</span></span>
 34     	}
 35     }
 36     
 37     @if (newBadgeEnabled)
 38     {
 39     	DateTime createdDate = Model.Created.Value;
 40     	double newPublicationDays = GetViewParameter("newPublicationDays") != null ? GetViewParameterDouble("newPublicationDays") : 0;
 41     
 42     	if ((newPublicationDays == 0) || (createdDate.AddDays(newPublicationDays) > DateTime.Now))
 43     	{
 44     		<span class="@sizeCssClass"><span class="badge @newBadgeCssClassName rounded-0"></span></span>
 45     	}
 46     }
 47     
 48     @if (campaignBadgesValues.Any())
 49     {
 50     	Dictionary<string, ParagraphInfoViewModel> badgeConfigurations;
 51     
 52     	if (Dynamicweb.Context.Current.Items.Contains("badgeConfigurations"))
 53     	{
 54     		badgeConfigurations = (Dictionary<string, ParagraphInfoViewModel>)Dynamicweb.Context.Current.Items["badgeConfigurations"];
 55     	}
 56     	else
 57     	{
 58     		var badgesPage = Pageview.AreaSettings.GetLink("EcommerceBadgesPage") != null ? Pageview.AreaSettings.GetLink("EcommerceBadgesPage").PageId : 0;
 59     		var allBadges = badgesPage != 0 ? Dynamicweb.Content.Services.Paragraphs.GetParagraphsByPageId(badgesPage) : null;
 60     
 61     		badgeConfigurations = new Dictionary<string, ParagraphInfoViewModel>();
 62     		foreach (Paragraph badge in allBadges)
 63     		{
 64     			var paragraphviewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreateParagraphInfoViewModel(badge);
 65     			string cssClassName = paragraphviewModel.Item.GetString("CssClassName").Trim().ToLower();
 66     			if (!badgeConfigurations.ContainsKey(cssClassName))
 67     			{
 68     				badgeConfigurations.Add(cssClassName, paragraphviewModel);
 69     			}
 70     		}
 71     		Dynamicweb.Context.Current.Items.Add("badgeConfigurations", badgeConfigurations);
 72     	}
 73     
 74     	int badgesCount = 0;
 75     	if (badgeConfigurations.Any())
 76     	{
 77     		foreach (string campaign in campaignBadgesValues)
 78     		{
 79     			if (!string.IsNullOrEmpty(campaign))
 80     			{
 81     
 82     				FieldValueViewModel availableCampaignsObject;
 83     				Model.ProductFields.TryGetValue("Campaign", out availableCampaignsObject);
 84     
 85     				if (availableCampaignsObject != null)
 86     				{
 87     					string campaignType = string.Empty;
 88     
 89     					if (badgeConfigurations.ContainsKey(campaign))
 90     					{
 91     						ParagraphInfoViewModel paragraphviewModel;
 92     						if (badgeConfigurations.TryGetValue(campaign, out paragraphviewModel))
 93     						{
 94     							campaignType = paragraphviewModel.Item.GetRawValueString("CampaignType");
 95     						}
 96     					}
 97     
 98     					List<FieldOptionValueViewModel> availableCampaigns = (List<FieldOptionValueViewModel>)availableCampaignsObject.Value;
 99     
100     					foreach (FieldOptionValueViewModel availableOption in availableCampaigns)
101     					{
102     						if (campaignType == availableOption.Value)
103     						{
104     							<span class="@sizeCssClass"><span class="badge @campaign.Trim().ToLower() rounded-0"></span></span>
105     							badgesCount++;
106     							break;
107     						}
108     					}
109     				}
110     			}
111     		}
112     	}
113     
114     	if (badgesCount == 0 && Pageview.IsVisualEditorMode)
115     	{
116     		<span class="@sizeCssClass"><span class="badge bg-success text-light rounded-0">@Translate("Badge example")</span></span>
117     	}
118     }
119     else if (Pageview.IsVisualEditorMode)
120     {
121     	<span class="@sizeCssClass"><span class="badge bg-success text-light rounded-0">@Translate("Badge example")</span></span>
122     }
123