Conex 401 förkromad vinkelkoppling 18 cu x cu

Error executing template "Designs/Swift_custom/Paragraph/Swift_BackInStockNotification.cshtml"
System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 114) 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.Stocks.StockUnitRepository.GetAllStockUnits()
   at Dynamicweb.Ecommerce.Stocks.StockUnitService.InitializeCache()
   at Dynamicweb.Caching.DictionaryCache`2.InitializeCacheDictionary()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at Dynamicweb.Caching.DictionaryCache`2.GetCacheResult(IEnumerable`1 keys)
   at Dynamicweb.Caching.ServiceCache`2.GetCache(IEnumerable`1 keys)
   at Dynamicweb.Caching.ServiceCache`2.GetCache(TKey key)
   at Dynamicweb.Ecommerce.Stocks.StockService.GetStockUnits(String productId, String variantId)
   at CompiledRazorTemplates.Dynamic.RazorEngine_686809cad8ec4ebfa3f8b7680beb5c97.Execute() in D:\dynamicweb.net\Solutions\Capo\hugocarping.cloud.dynamicweb-cms.com\files\Templates\Designs\Swift_custom\Paragraph\Swift_BackInStockNotification.cshtml:line 65
   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:29bddf65-ccb7-4c96-8d5a-a221ff177a55
Error Number:1205,State:52,Class:13


  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     @using Dynamicweb.Core
  3     @using Dynamicweb.Ecommerce.ProductCatalog
  4     @using Dynamicweb.Ecommerce.Products
  5     
  6     @{
  7     	bool productViewModelFound = false;
  8     	ProductViewModel product = new ProductViewModel();
  9     
 10     	ProductViewModelSettings productSetting = new ProductViewModelSettings
 11     	{
 12     		LanguageId = Dynamicweb.Ecommerce.Common.Context.LanguageID,
 13     		CurrencyCode = Dynamicweb.Ecommerce.Common.Context.Currency.Code,
 14     		CountryCode = Dynamicweb.Ecommerce.Common.Context.Country.Code2,
 15     		ShopId = Pageview.Area.EcomShopId
 16     	};
 17     
 18     	if (Dynamicweb.Context.Current.Items.Contains("ProductDetails"))
 19     	{
 20     		productViewModelFound = true;
 21     		product = (ProductViewModel)Dynamicweb.Context.Current.Items["ProductDetails"];
 22     	}
 23     	if (Pageview.IsVisualEditorMode && !productViewModelFound)
 24     	{
 25     		if (Pageview.Item["DummyProduct"] != null)
 26     		{
 27     			productViewModelFound = true;
 28     			string dummyProductId = "";
 29     			var pageViewModel = Dynamicweb.Frontend.ContentViewModelFactory.CreatePageInfoViewModel(Pageview.Page);
 30     			ProductListViewModel productList = pageViewModel.Item.GetValue("DummyProduct") != null ? pageViewModel.Item.GetValue("DummyProduct") as ProductListViewModel : new ProductListViewModel();
 31     			if (productList.Products != null)
 32     			{
 33     				foreach (var p in productList.Products) { dummyProductId = p.Id; }
 34     				ProductViewModel dummyProduct = dummyProductId != "" ? ViewModelFactory.CreateView(productSetting, dummyProductId) : new ProductViewModel();
 35     				product = dummyProduct;
 36     			}
 37     			else
 38     			{
 39     				product = ViewModelFactory.CreateView(productSetting, Dynamicweb.Ecommerce.Services.Products.GetLastActiveProducts(1, Dynamicweb.Ecommerce.Common.Context.LanguageID, false).FirstOrDefault().Id);
 40     			}
 41     		}
 42     		else if (Pageview.Item["DummyProduct"] == null)
 43     		{
 44     			productViewModelFound = true;
 45     			product = ViewModelFactory.CreateView(productSetting, Dynamicweb.Ecommerce.Services.Products.GetLastActiveProducts(1, Dynamicweb.Ecommerce.Common.Context.LanguageID, false).FirstOrDefault().Id);
 46     		}
 47     	}
 48     
 49     	int pageId = GetPageIdByNavigationTag("ProductDetailPage");
 50     	string userName = Pageview.User != null ? Pageview.User.Name : String.Empty;
 51     	string productLink = product.GetProductLink(pageId);
 52     	Product prod = Dynamicweb.Ecommerce.Services.Products.GetProductById(product.Id, product.VariantId, product.LanguageId);
 53     	bool productNotificationRegistered = ProductBackInStockNotification.BackInStockNotificationExists(prod, String.Empty);
 54     
 55     	bool hideTitle = Model.Item.GetBoolean("HideTitle");
 56     	string theme = !string.IsNullOrWhiteSpace(Model.Item.GetRawValueString("Theme")) ? " theme " + Model.Item.GetRawValueString("Theme").Replace(" ", "").Trim().ToLower() : "";
 57     
 58     	Dynamicweb.Ecommerce.Stocks.StockLocationCategory websiteSLCategory = null;
 59     	websiteSLCategory = Dynamicweb.Ecommerce.Services.StockService.GetStockLocationCategories().Where(sc => sc.Name.Contains("#" + Pageview.Area.Name)).FirstOrDefault();
 60     
 61     	var lagerlagdArlov = product.ProductFields["BcLagerlagd_10"].Value.ToString();
 62     	//TODO: Setting this to true until we get this info from BC. Fix when we can.
 63     	//var lagerlagdArlov = "True";
 64     	var stockLocations = Dynamicweb.Ecommerce.Services.StockService.GetStockLocations(true);
 65     	var stockUnits = Dynamicweb.Ecommerce.Services.StockService.GetStockUnits(product.Id, product.VariantId);
 66     	int filialStockCount = 0;
 67     
 68     	foreach (var sl in stockLocations)
 69     	{
 70     		if (sl.CategoryId == websiteSLCategory.Id)
 71     		{
 72     			// Carpings is supporting only one sales unit per product, so we only use the first stockunit matching the stocklocationId 
 73     			var matchingSu = stockUnits.Where(su => su.StockLocationId == sl.ID).FirstOrDefault();
 74     
 75     			if (matchingSu != null && matchingSu.StockQuantity > 0) {
 76     				var matchingSuStockLevel = Convert.ToInt32(matchingSu.StockQuantity);
 77     				filialStockCount += matchingSuStockLevel;
 78     			}
 79     		}
 80     	}
 81     
 82     	if (filialStockCount < 1 && lagerlagdArlov != "True" && !string.IsNullOrWhiteSpace(userName)) {
 83     		<div class="@(theme) item_@Model.Item.SystemName.ToLower()">
 84     			@if (!hideTitle)
 85     			{
 86     				<h3 class="h6">@Model.Item.GetRawValueString("Title")</h3>
 87     			}
 88     
 89     			@if (productNotificationRegistered != true && userName != "")
 90     			{
 91     				<a class="btn btn-secondary" href='@product.GetProductLink(pageId)&cartcmd=createnotificationforthisproduct' title="@Translate("Create Notification tooltip", "Notify me when product is back in stock")"> @Translate("Create Notification", "Create notification")</a>
 92     			}
 93     			else if (productNotificationRegistered != true && userName == "")
 94     			{
 95     				<form name='@product.Id' id='NotificationForm_@product.Id' method='post' action='/Default.aspx?ID=@pageId'>
 96     					<input type="hidden" name="ProductID" id="ProductID" value='@product.Id' />
 97     					<input type="hidden" name="VariantID" id="VariantID" value='@product.VariantId' />
 98     					<input type="hidden" name="LanguageID" id="LanguageID" value='@product.LanguageId' />
 99     					<input type="hidden" name="CartCmd" id="CartCmd" value="createnotificationforthisproduct" />
100     					<label for="NotificationEmail">@Translate("Email", "Email")</label>
101     					<input type="email" required="required" id="NotificationEmail" name="NotificationEmail" value="">
102     					<input type="submit" class="btn btn-secondary" value='@Translate("Create Notification", "Create notification")' title="@Translate("Create Notification tooltip", "Notify me when product is back in stock")"/>
103     				</form>
104     			}
105     				else if (productNotificationRegistered == true && userName != "")
106     			{
107     			<div class="col-md-8"><i>@Translate("You will be notified when it is back in stock")</i></div>
108     			}
109     				else if (productNotificationRegistered == true && userName == "")
110     			{
111     				<div class="col-md-8"><i>@Translate("You will be notified when it is back in stock")</i></div>
112     			}
113     		</div>
114     	}
115     }
116