Error executing template "Designs/Fjordgaarden/Paragraph/Boxes.cshtml" System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=7563; [Login] initialization=0; authentication=0; [Post-Login] complete=7256; ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.Open() at Dynamicweb.Data.DatabaseConnectionProvider.CreateConnection(Boolean open) at Dynamicweb.Data.DatabaseConnectionProvider.CreateConnection() at Dynamicweb.Data.DatabaseProvider.CreateConnection() at Dynamicweb.Data.Database.CreateConnection() at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout) at Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder) at Dynamicweb.Content.Items.Queries.Repository.SelectInternal(IEnumerable`1 ids, Query query) at Dynamicweb.Content.Items.Queries.Repository.SelectByIds(IEnumerable`1 ids, Query query, Boolean checkPermissions, Boolean includeInheritedItems) at Dynamicweb.Content.Items.Queries.Repository.SelectByIds(IEnumerable`1 ids, Query query, Boolean checkPermissions) at Dynamicweb.Content.Items.Queries.Repository.SelectByIds(IEnumerable`1 ids, Query query) at Dynamicweb.Content.Items.Queries.Repository.SelectById(String id, Query query) at Dynamicweb.Content.Items.Queries.Repository.SelectById(String id) at Dynamicweb.Content.Items.Queries.StorageManager.GetById(String systemName, String id) at Dynamicweb.Content.Items.Queries.StorageManager.GetByIds(String systemName, IEnumerable`1 ids) at Dynamicweb.Content.Items.ItemList.get_Relations() at Dynamicweb.Content.Items.Editors.ItemRelationListEditor.GetItems(Object value) at Dynamicweb.Content.Items.Editors.ItemRelationListEditor.GetViewModelValue(Object value) at Dynamicweb.Content.Items.Editors.Editor.GetViewModelValue(Object value, ItemField field) at Dynamicweb.Frontend.ContentViewModelFactory.GetValue(ItemField field, Item item, Object value) at Dynamicweb.Frontend.ContentViewModelFactory.<>c__DisplayClass16_0.<CreateItemFieldViewModel>g__modelValueFactory|0() at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode) --- End of stack trace from previous location --- at System.Lazy`1.CreateValue() at Dynamicweb.Frontend.ItemViewModel.GetItems(String systemName) at CompiledRazorTemplates.Dynamic.RazorEngine_5267fdbe9052496f886505f4f32c1b1b.ExecuteAsync() at RazorEngine.Templating.TemplateBase.Run(ExecuteContext context, TextWriter reader) at RazorEngine.Templating.RazorEngineCore.RunTemplate(ICompiledTemplate template, TextWriter writer, Object model, DynamicViewBag viewBag) at RazorEngine.Templating.RazorEngineService.Run(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag) at RazorEngine.Templating.DynamicWrapperService.Run(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag) at RazorEngine.Templating.RazorEngineServiceExtensions.Run(IRazorEngineService service, String name, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag) at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass23_0.<Run>b__0(TextWriter writer) at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter) at RazorEngine.Templating.RazorEngineServiceExtensions.Run(IRazorEngineService service, String name, Type modelType, Object model, DynamicViewBag viewBag) at Dynamicweb.Rendering.RazorTemplateRenderingProvider.Render(Template template) at Dynamicweb.Rendering.TemplateRenderingService.Render(Template template) at Dynamicweb.Rendering.Template.RenderRazorTemplate() ClientConnectionId:1b906655-b14c-4bd9-a55f-814553e15a36 Error Number:-2,State:0,Class:11
1 @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel> 2 @using Dynamicweb.Frontend 3 @using Dynamicweb.Frontend.Devices 4 @using Dynamicweb.VestjyskMarketing.Helpers 5 @using Dynamicweb.VestjyskMarketing.Models 6 @using Extensibility.Helpers 7 @using Dynamicweb.Content 8 9 @{ 10 var boxes = Model.Item.GetItems("Boxes"); 11 var boxesSystem = Model.Item.GetItems("BoxesSystem"); 12 List<ItemViewModel> totalBoxes = new List<ItemViewModel>(); 13 var colSize = 0; 14 var boxesAmount = 0; 15 var isMobile = Pageview.Device == Dynamicweb.Frontend.Devices.DeviceType.Mobile; 16 17 if (boxes != null || boxesSystem != null) 18 { 19 if (boxes != null) 20 { 21 foreach (var box in boxes) 22 { 23 totalBoxes.Add(box); 24 } 25 } 26 if (boxesSystem != null) 27 { 28 foreach (var box in boxesSystem) 29 { 30 totalBoxes.Add(box); 31 } 32 } 33 34 //Takes all boxes without BoxLocation empty first, sorts them and then adds boxes with empty BoxLocation, so that they get appended at the end of the list 35 totalBoxes = new BoxesHelper().GetSortedBoxes(totalBoxes); 36 37 @if (totalBoxes != null) 38 { 39 boxesAmount = totalBoxes.Count; 40 @if (boxesAmount > 0) 41 { 42 colSize = 12 / boxesAmount; 43 var enableCarousel = boxesAmount > 3; 44 45 <div class="boxes-container col-12 d-flex flex-wrap @(enableCarousel && !isMobile ? "boxes-carousel " : "")"> 46 <div class="@(enableCarousel && !isMobile ? "swiper-wrapper" : "w-100 h-100 d-flex flex-wrap") "> 47 @foreach (var box in totalBoxes) 48 { 49 var topText = box.GetString("TopText"); 50 var header = box.GetString("Header"); 51 var headerSmall = box.GetString("HeaderSmall"); 52 var image = ""; 53 var video = ""; 54 var useVideo = false; 55 var advancedImage = box.GetItem("AdvancedImage"); 56 var imageAlt = ""; 57 var imageStyle = ""; 58 bool disableZoom = box.GetBoolean("DisableZoom"); 59 60 if (advancedImage != null) 61 { 62 image = advancedImage.GetString("Image"); 63 imageAlt = advancedImage.GetString("ImageAlt"); 64 video = advancedImage.GetString("Video"); 65 useVideo = advancedImage.GetBoolean("UseVideo"); 66 67 var advancedImageHelper = new AdvancedImageHelper(); 68 imageStyle = advancedImageHelper.GetStyles(advancedImage, Pageview.Device); 69 } 70 71 var buttons = box.GetItems("Buttons"); 72 var priceText = box.GetString("PriceText"); 73 var price = box.GetString("Price"); 74 var priceClass = "justify-content-center"; 75 var globalPrice = box.GetString("GlobalPrice"); 76 77 if (!string.IsNullOrEmpty(globalPrice)) 78 { 79 var pageService = new PageService(); 80 var boxPage = pageService.GetPage(int.Parse(globalPrice)); 81 if (boxPage.Item != null) 82 { 83 if (boxPage.ItemType == "Box") 84 { 85 var itemId = boxPage.Item.Id; 86 var item = Dynamicweb.Content.Items.Item.GetItemById(boxPage.ItemType, itemId); 87 price = item["Price"].ToString(); 88 } 89 } 90 } 91 92 bool priceIsNotEmpty = !string.IsNullOrEmpty(priceText) && !string.IsNullOrEmpty(price); 93 94 if (priceIsNotEmpty) 95 { 96 priceClass = "justify-content-between"; 97 } 98 99 var zoomClass = "box-zoom"; 100 101 if (disableZoom) 102 { 103 zoomClass = ""; 104 } 105 106 if (!useVideo) 107 { 108 if (isMobile) 109 { 110 image = ImageHelper.ResizeImage(new ResizeImageSettings 111 { 112 Image = image, 113 Width = 2500, 114 Height = 2500, 115 Quality = 80, 116 Format = "webP" 117 }); 118 } 119 else 120 { 121 image = ImageHelper.ResizeImage(new ResizeImageSettings 122 { 123 Image = image, 124 Width = 5000, 125 Height = 5000, 126 Quality = 15, 127 Format = "webP" 128 }); 129 } 130 } 131 132 bool englishArea = Pageview.AreaID != 1; 133 134 if (price.Contains("kr.") && englishArea) 135 { 136 price = price.Replace("kr.", "DKK"); 137 } 138 139 var isContentEmpty = string.IsNullOrEmpty(header) && string.IsNullOrEmpty(headerSmall) && string.IsNullOrEmpty(priceText) && string.IsNullOrEmpty(price) && buttons.Count == 0; 140 var isOnlyOneButton = buttons.Count == 1; 141 142 <div class="box-container col-12 col-lg-@colSize @zoomClass @(enableCarousel && !isMobile ? "swiper-slide" : "box-border-right")"> 143 144 @if (isOnlyOneButton) 145 { 146 <a href="@buttons.First().GetString("Link")"> 147 <div class="box-container__media-container box-container__media-container--@colSize overflow-hidden @(colSize == 6 && isContentEmpty ? "content-empty" : "")"> 148 @if (useVideo) 149 { 150 <video class="w-100 h-100" autoplay loop muted playsinline style="@imageStyle" disablepictureinpicture> 151 <source src="@video" type="video/mp4"> 152 </video> 153 } 154 else 155 { 156 <img loading="lazy" style="@imageStyle" alt="@imageAlt" class="w-100 h-100" src="@image" /> 157 } 158 </div> 159 </a> 160 } 161 else 162 { 163 <div class="box-container__media-container box-container__media-container--@colSize overflow-hidden @(colSize == 6 && isContentEmpty ? "content-empty" : "")"> 164 @if (useVideo) 165 { 166 <video class="w-100 h-100" autoplay loop muted playsinline style="@imageStyle" disablepictureinpicture> 167 <source src="@video" type="video/mp4"> 168 </video> 169 } 170 else 171 { 172 <img loading="lazy" style="@imageStyle" alt="@imageAlt" class="w-100 h-100" src="@image" /> 173 } 174 </div> 175 } 176 177 178 179 <div class="box-container__top-text position-absolute text-white fw-bold text-uppercase translate-middle-x"> 180 @topText 181 </div> 182 <div class="box-container__header-container w-100"> 183 <div class="box-container__header-container__header box-container__header-container__header--@colSize dalafloda">@header</div> 184 <div class="box-container__header-container__header-small">@headerSmall</div> 185 </div> 186 <div class="box-container__button-price-container d-flex w-100 @priceClass"> 187 188 @if (priceIsNotEmpty) 189 { 190 <div class="box-container__button-price-container__price-container d-flex flex-column w-100 justify-content-end"> 191 <div class="box-container__button-price-container__price-container__text">@priceText</div> 192 <div class="box-container__button-price-container__price-container__price dalafloda">@price</div> 193 </div> 194 } 195 196 @if (buttons != null) 197 { 198 var justifyClass = "justify-content-center"; 199 var buttonWidth = "width: auto"; 200 201 if (priceIsNotEmpty) 202 { 203 justifyClass = "justify-content-end"; 204 } 205 else if (isMobile) 206 { 207 buttonWidth = "width: inherit"; 208 } 209 210 <div class="box-container__button-price-container__button-container d-flex align-items-end w-100 @justifyClass flex-column flex-lg-row"> 211 212 @{ 213 var buttonIndex = 1; 214 } 215 216 @foreach (var button in buttons) 217 { 218 var icon = button.GetString("Icon"); 219 var text = button.GetString("Text"); 220 221 var buttonMarginClass = "mb-0"; 222 223 if (buttonIndex != buttons.Count) 224 { 225 buttonMarginClass = "mb-3"; 226 } 227 228 <a href="@button.GetString("Link")" style="@buttonWidth" class="fn-button align-items-end @buttonMarginClass mb-lg-0 "> 229 230 @if (!string.IsNullOrEmpty(icon)) 231 { 232 <img loading="lazy" class="icon icon " alt="icon" src="@icon" /> 233 } 234 235 @if (string.IsNullOrEmpty(text)) 236 { 237 @header 238 } 239 else 240 { 241 @text 242 } 243 </a> 244 245 buttonIndex++; 246 } 247 248 </div> 249 } 250 251 </div> 252 </div> 253 } 254 255 </div> 256 @if (enableCarousel && !isMobile) 257 { 258 <img loading="lazy" alt="boxes venstre" class="boxes__left boxes__arrow" src="/Files/Images/Ikoner/svgs/regular/arrow-left-long.svg" /> 259 <img loading="lazy" alt="boxes højre" class="boxes__right boxes__arrow" src="/Files/Images/Ikoner/svgs/regular/arrow-right-long.svg" /> 260 } 261 </div> 262 } 263 } 264 } 265 }
Romantisk RO
Plads til tosomhed og kvalitetstid
BurgerRO
Kobl af med burger og kurbad
RO for to
Tag afsted til en velfortjent dosis RO
Bryn og vipper
Vejen til perfekte bryn og vipper
MorgenRO
Lækker morgenmad og kurbad
Kosmetolog
Kurbadssuiten
Køb gavekort
Møde & konference
Fester
0
