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 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()
   at System.Lazy`1.LazyInitValue()
   at Dynamicweb.Ecommerce.ProductCatalog.ViewEngine.<>c__DisplayClass3_2.<BulkCreateView>b__48()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   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__49()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at CompiledRazorTemplates.Dynamic.RazorEngine_4f23f5b913ef4754980b9e347ee303f4.Execute() in D:\dynamicweb.net\Solutions\twodayco3\evasolo.cloud.dynamicweb-cms.com\Files\Templates\Designs\Swift\eCom\ProductCatalog\ProductViewDetail.cshtml:line 67
   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:b9161fdd-4bd7-43c1-8a1f-577366229465
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

See more images 

Error executing template "Designs/Swift/Paragraph/Swift_ProductBadges.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 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_2ac4527e059a4b3c9672fdd993732529.Execute() in D:\dynamicweb.net\Solutions\twodayco3\evasolo.cloud.dynamicweb-cms.com\Files\Templates\Designs\Swift\Paragraph\Swift_ProductBadges.cshtml:line 105
   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:b9161fdd-4bd7-43c1-8a1f-577366229465
Error Number:-2,State:0,Class:11




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

Custom_USP1
Denne varen er en reservedel og ikke et komplett produkt.
See description and product details 
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 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()
   at System.Lazy`1.LazyInitValue()
   at Dynamicweb.Ecommerce.ProductCatalog.ViewEngine.<>c__DisplayClass3_2.<BulkCreateView>b__48()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   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__49()
   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 CompiledRazorTemplates.Dynamic.RazorEngine_59107d3ae1d3422bbe1aa9de38643e83.Execute() in D:\dynamicweb.net\Solutions\twodayco3\evasolo.cloud.dynamicweb-cms.com\Files\Templates\Designs\Swift\Paragraph\Swift_ProductPrice_Custom.cshtml:line 102
   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:b9161fdd-4bd7-43c1-8a1f-577366229465
Error Number:-2,State:0,Class:11




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



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 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()
   at System.Lazy`1.LazyInitValue()
   at Dynamicweb.Ecommerce.ProductCatalog.ViewEngine.<>c__DisplayClass3_2.<BulkCreateView>b__48()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   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__49()
   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 CompiledRazorTemplates.Dynamic.RazorEngine_5ec5be175e82422883f58617c214c676.Execute() in D:\dynamicweb.net\Solutions\twodayco3\evasolo.cloud.dynamicweb-cms.com\Files\Templates\Designs\Swift\Paragraph\Swift_ProductAddToCart_Custom.cshtml:line 77
   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:b9161fdd-4bd7-43c1-8a1f-577366229465
Error Number:-2,State:0,Class:11




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

Nærmeste postkontor eller post i butikk
75 NOK | GRATIS ved kjøp for 599 NOK

Du vil motta fraktinformasjon via e-post eller tekstmelding når bestillingen sendes fra vårt lager.

LEVERINGSTID: 2-6 virkedager

 

Levering med transportør

Du vil bli kontaktet av kundeservice angående levering.

LEVERINGSTID: 1-4 uker

Eva Solo community

Tagg oss i ditt instagraminnlegg for å bli omtalt i vårt Eva Solo Community.
Bruk en av følgende tagger: @evasolo_official, #evasolo, #evatrio eller #evasolofurniture.

Relatert innhold