Error executing template "Designs/Hags2024/ItemPublisher/List/Case Study List.cshtml"
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj, Int32& totalCharsRead)
   at System.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName)
   at System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)
   at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
   at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)
   at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at Dynamicweb.Content.Items.Item.DeserializeFrom(IDataReader reader)
   at Dynamicweb.Content.Items.Queries.Repository.SelectInternal(IEnumerable`1 ids, Query query)
   at Dynamicweb.Content.Items.Queries.Repository.SelectAll()
   at Dynamicweb.Frontend.UrlProviders.ItemTypeProvider.GetMappings()
   at Dynamicweb.Frontend.UrlProviders.Handler.GetUrls()
   at Dynamicweb.Frontend.UrlProviders.Handler.Initialize()
   at Dynamicweb.Frontend.UrlProviders.Handler.HandleModuleUrl(String& url, String& querystring, String alternatekey)
   at Dynamicweb.Frontend.SearchEngineFriendlyURLs.ResolveQueryString(String fullQueryString, Int32 pageid, String alternatekey)
   at Dynamicweb.Frontend.PageView.get_SearchFriendlyUrl()
   at CompiledRazorTemplates.Dynamic.RazorEngine_0fc56e004c6d44f79044314f68431f5b.Execute() in B:\Projects\Hags_Dw915\Files\Templates\Designs\Hags2024\ItemPublisher\List\Case Study List.cshtml:line 7
   at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader)
   at RazorEngine.Templating.RazorEngineCore.RunTemplate(ICompiledTemplate template, TextWriter writer, Object model, DynamicViewBag viewBag)
   at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag)
   at RazorEngine.Templating.DynamicWrapperService.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 RazorEngine.Templating.RazorEngineServiceExtensions.RunCompile(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()


  1     @inherits Dynamicweb.Rendering.RazorTemplateBase<Dynamicweb.Rendering.RazorTemplateModel<Dynamicweb.Rendering.Template>>
  2     @using System.Web;
  3     
  4     @{
  5         Dynamicweb.Frontend.PageView thisPage = Dynamicweb.Frontend.PageView.Current() ?? Dynamicweb.Frontend.PageView.Current();
  6         string baseUrl = GetGlobalValue("Global:Request.Scheme") + "://" + GetGlobalValue("Global:Request.Host");
  7         string pageUrl = baseUrl + thisPage.SearchFriendlyUrl;
  8     
  9         if (thisPage.SearchFriendlyUrl.Contains("Business_Category"))
 10         {
 11             string canonicalUrl = baseUrl + Dynamicweb.Frontend.SearchEngineFriendlyURLs.GetFriendlyUrl("Default.aspx?ID=" + thisPage.ID);  // works
 12             string canonicalListUrl = "<link rel=\"canonical\" href=\"" + canonicalUrl + "\" />";
 13             //override the canonical tag
 14             Pageview.Meta.AddTag("customCan", canonicalListUrl);
 15         }
 16     }
 17     
 18     @* for this page we don't want the header to be positioned over the content *@
 19     @SnippetStart("headerClass")@("in-flow")@SnippetEnd("headerClass")
 20     
 21     @{
 22         string designBaseUrl = GetString("Template:DesignBaseUrl");
 23     }
 24     
 25     @helper renderCaseStudyPagination()
 26     {
 27     
 28     
 29         string grouplink = "/Default.aspx?ID=" + GetValue("ItemPublisher:Global.PageId");
 30         HashSet<String[,]> catList = new HashSet<String[,]>();
 31     
 32         //catList = HagsWeb.Library.Methods.Items.ItemTypeMethods.GetStudyBusinessCategories(GetGlobalValue("Global:Area.ID"), GetGlobalValue("Global:Page.ID"), GetGlobalValue("Global:Area.LongLang"));
 33     
 34         //https://doc.dynamicweb.com/documentation-9/content/apps/item-publisher#sideNavTitle1-2
 35     
 36     
 37         if (GetInteger("ItemPublisher:Items.Paging.TotalPages") > 1)
 38         {
 39             var hasPrevPage = GetInteger("ItemPublisher:Items.Paging.CurrentPage") > 1;
 40             var hasNextPage = GetInteger("ItemPublisher:Items.Paging.CurrentPage") < GetInteger("ItemPublisher:Items.Paging.TotalPages");
 41     
 42             var prevLink = @GetString("ItemPublisher:Items.Paging.PrevPage");
 43             var nextLink = @GetString("ItemPublisher:Items.Paging.NextPage");
 44             var prevLinkClass = (prevLink == "#") ? "inactive" : "";
 45             var nextLinkClass = (nextLink == "#") ? "inactive" : "";
 46             string businessCategory = HttpContext.Current.Request.QueryString.Get("business_category");
 47             string appendCategory = (businessCategory != "") ? "&Business_Category=" + businessCategory : "";
 48             string anchorTagPrev = (prevLink != "") ? "<a id=\"prevpage\" href=\"" + prevLink + appendCategory + "\" aria-label=\"Previous\">" : "";
 49             string anchorTagPrevClose = (prevLink != "") ? "</a>" : "";
 50             string anchorTagNext = (nextLink != "") ? "<a id=\"nextpage\" href=\"" + nextLink + appendCategory + "\" aria-label=\"Next\">" : "";
 51             string anchorTagNextClose = (nextLink != "") ? "</a>" : "";
 52     
 53     
 54             <nav class="pagination">
 55                 <ul class="pagination__list" role="list">
 56     
 57                     <li class="@prevLinkClass">
 58                         @(anchorTagPrev)
 59                         <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 212 212" class="h24-icon h24-icon--prev"><path fill="currentColor" fill-rule="evenodd" d="M106 6c55.193 0 100 44.807 100 100s-44.807 100-100 100S6 161.193 6 106 50.807 6 106 6Zm0 5.333c-26.124 0-49.792 10.603-66.928 27.74C21.936 56.207 11.333 79.875 11.333 106c0 26.124 10.603 49.792 27.74 66.928 17.135 17.136 40.803 27.739 66.927 27.739 26.124 0 49.792-10.603 66.928-27.74 17.136-17.135 27.739-40.803 27.739-66.927 0-26.124-10.603-49.792-27.74-66.928C155.793 21.936 132.125 11.333 106 11.333Zm16.66 55.907c2.993-2.14 7.16-1.44 9.3 1.553 2.14 2.994 1.44 7.16-1.554 9.3L113.21 90.376l-1.168.834L91.333 106l39.073 27.907c2.994 2.14 3.694 6.306 1.554 9.3-2.14 2.993-6.307 3.693-9.3 1.553l-20.642-14.745-1.038-.741-1.562-1.116-1.041-.744-14.79-10.567A13.319 13.319 0 0 1 78 106c0-4.307 2.08-8.347 5.586-10.847l14.79-10.567 1.042-.744 1.562-1.116 1.038-.741L122.66 67.24Z"/></svg>
 60                         <span class="visually-hidden">@Translate("page_Previous", "Previous")</span>
 61                         @(anchorTagPrevClose)
 62                     </li>
 63     
 64                     @foreach (var p in GetLoop("ItemPublisher:Items.Paging.Pages"))
 65                     {
 66                         var isCurrent = p.GetBoolean("ItemPublisher:Items.Paging.Pages.Page.IsCurrent");
 67                         string currentClass = isCurrent ? "active" : "";
 68                         string pageLink = "";
 69                         <li class="@currentClass">
 70                             @if (isCurrent)
 71                             {
 72                                 <span>@p.GetValue("ItemPublisher:Items.Paging.Pages.Page.Number")</span>
 73                             }
 74                             else
 75                             {
 76                                 pageLink = p.GetValue("ItemPublisher:Items.Paging.Pages.Page.Url") + appendCategory;
 77                                 pageLink = @System.Web.HttpUtility.HtmlEncode(pageLink);
 78                                 <a href="@(pageLink)">@p.GetValue("ItemPublisher:Items.Paging.Pages.Page.Number")</a>
 79                             }
 80                         </li>
 81                     }
 82     
 83                     <li class="@nextLinkClass">
 84                         @(anchorTagNext)
 85                         <span class="visually-hidden">@Translate("page_Next", "Next")</span>
 86                         <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 212 212" class="h24-icon h24-icon--next"><path fill="currentColor" fill-rule="evenodd" d="M106 6c55.193 0 100 44.807 100 100s-44.807 100-100 100S6 161.193 6 106 50.807 6 106 6Zm0 5.333c-26.124 0-49.792 10.603-66.928 27.74C21.936 56.207 11.333 79.875 11.333 106c0 26.124 10.603 49.792 27.74 66.928 17.135 17.136 40.803 27.739 66.927 27.739 26.124 0 49.792-10.603 66.928-27.74 17.136-17.135 27.739-40.803 27.739-66.927 0-26.124-10.603-49.792-27.74-66.928C155.793 21.936 132.125 11.333 106 11.333ZM96.54 67.24l20.642 14.745 1.038.741 1.561 1.116 1.042.744 1.559 1.114 1.034.739 12.197 8.714A13.319 13.319 0 0 1 141.2 106c0 4.307-2.08 8.347-5.587 10.847l-12.197 8.714-1.034.739-1.559 1.114-1.042.744-1.561 1.116-1.038.741A512447.69 512447.69 0 0 1 96.54 144.76c-2.993 2.14-7.16 1.44-9.3-1.553-2.14-2.994-1.44-7.16 1.553-9.3L127.867 106 88.793 78.093c-2.993-2.14-3.693-6.306-1.553-9.3 2.14-2.993 6.307-3.693 9.3-1.553Z"/></svg>
 87                         @(anchorTagNextClose)
 88                     </li>
 89     
 90     
 91                 </ul>
 92             </nav>
 93         }
 94     
 95     
 96         <ul class="product-nav" role="list">
 97             <li><span class="product-nav__label">@Translate("FilterBy", "Filter by"):</span> </li>
 98             <li><a href="@(grouplink)">@Translate("Any", "Any")</a></li>
 99             <li><a href="@(grouplink)&Business_Category=play">Play</a></li>
100             <li><a href="@(grouplink)&Business_Category=sport">Sport</a></li>
101             <li><a href="@(grouplink)&Business_Category=park">Park</a></li>
102             @*foreach (var a in catList)
103                 {
104                     string filterUrl = grouplink + "&Business_Category=" + a[0,0];
105                     <li><a href="@(filterUrl)">@a[0, 1]</a></li>
106                 }*@
107         </ul>
108     
109     
110     }
111     
112     @* This snippet is set on the intro paragraph template *@
113     @* we do this to prevent the parargraph rendering in the details template - the details template does not render this snippet *@
114     @RenderSnippet("ModuleIntro")
115     
116     <section>
117     
118         <div class="wrapper flow">
119             @inherits Dynamicweb.Rendering.RazorTemplateBase<Dynamicweb.Rendering.RazorTemplateModel<Dynamicweb.Rendering.Template>>
120     @using System.Web.Optimization;
121     @using HagsCustomModules.CustomModules.HagsMaps;
122     @{
123         string googleMapsApiKey = (string)Dynamicweb.Configuration.SystemConfiguration.Instance.GetValue("/Globalsettings/Settings/GoogleMaps/GoogleMapsAPIKey");
124         string mapsApi = "https://maps.googleapis.com/maps/api/js?v=3&key=" + googleMapsApiKey + "&libraries=places,geometry";
125         // @google errors my page
126         string mapsmarker = "https://unpkg.com/@google/markerclustererplus@4.0.1/dist/markerclustererplus.min.js";
127     
128         string areaId = GetGlobalValue("Global:Area.ID");
129     
130         SortedSet<StudyLocation> locations = new SortedSet<StudyLocation>();
131     
132         locations = HagsWeb.Library.Methods.Items.ItemTypeMethods.GetMapCaseStudies(areaId);
133     
134     }
135     
136     @SnippetStart("caseStudyScripts")
137     <script type="text/javascript" src="@mapsApi"></script>
138     <script type="text/javascript" src="@mapsmarker"></script>
139     @*Scripts.Render("~/bundle/CaseStudyMap")*@
140     <script type="text/javascript" src="@(designBaseUrl)assets/js/functions/kdl-case-study-map.js"></script>
141     @SnippetEnd("caseStudyScripts")
142     
143     <div class="fc-map wrapper flow" id="kdl-map-1" data-area-id="@areaId">
144     
145         <div class="fc-map__controls flow-tight">
146     
147             <p><strong>Find case studies within:</strong></p>
148     
149             <div class="fc-map__filter-group location">
150     
151                 <span class="fc-map__filter-box">
152                     <label for="search-radius-1">
153                         <select class="fc-map__input fc-map__filter-radius" name="search-radius" id="search-radius-1">
154                             <option value="500" selected="selected">@Translate("Select_Distance", "Select distance")...</option>
155                             <option value="10">10km</option>
156                             <option value="50">50km</option>
157                             <option value="150">150km</option>
158                             <option value="200">200km</option>
159                             <option value="500">500km</option>
160                             <option value="1500">1500km</option>
161                         </select>
162                     </label>
163                 </span>
164                 
165                 <span class="fc-map__filter-box">
166                     <label for="search-location-1">
167                          @Translate("From_Location", "from location"):
168                         <input class="fc-map__filter-location" type="text" name="search-location" id="search-location-1" value="">
169                     </label>
170                 </span>
171                 
172                 <button class="fc-map__button fc-map__button--clear-loc" style="display: none;">Clear location</button>
173                 <button class="fc-map__button fc-map__button--reset">@Translate("Reset_All", "Reset All")</button>
174     
175             </div>
176      
177             <p><strong>Filter results by:</strong></p>
178     
179             <div class="fc-map__filter-group category">
180                 <span class="fc-map__filter-box">
181                     <label for="filter-1"><input class="fc-map__filter-input" type="checkbox" name="hagsCategory" value="play" id="filter-1">Play</label>
182                 </span>
183                 <span class="fc-map__filter-box">
184                     <label for="filter-2"><input class="fc-map__filter-input" type="checkbox" name="hagsCategory" data-filter-name="hagsCategory" value="sport" id="filter-2">Sport and Fitness</label>
185                 </span>
186                 <span class="fc-map__filter-box">
187                     <label for="filter-3"><input class="fc-map__filter-input" type="checkbox" name="hagsCategory" data-filter-name="hagsCategory" value="park" id="filter-3">Park and Urban</label>
188                 </span>
189             </div>
190                                     
191             <div class="fc-map__filter-group range">
192                 <label for="min-cost-1">
193                     <select id="range-cost-1" class="fc-map__filter-cost fc-map__filter-cost--range" name="rangeCost" title=" Project cost">
194                         <option value="-" selected="selected">Select project value...</option>
195                         <option value="0-50000">0 > 50,000</option>
196                         <option value="50000-75000">50,000 > 75,000</option>
197                         <option value="75000-100000">75,000 > 100,000</option>
198                         <option value="100000-125000">100,000 > 125,000</option>
199                         <option value="125000-150000">125,000 > 150,000</option>
200                         <option value="150000-175000">150,000 > 175,000</option>
201                         <option value="175000-200000">175,000 > 200,000</option>
202                         <option value="200000-225000">200,000 > 225,000</option>
203                         <option value="225000-250000">225,000 > 250,000</option>
204                     </select>
205                 </label>
206             </div>
207     
208         </div>
209     
210     
211         <div class="fc-map__holder">@* MAP GOES HERE *@</div>
212                                 
213         <ol class="fc-map__marker-list area-@areaId" style="display:none;">
214     
215         @foreach (var location in locations)
216         {
217         <!--$$(location.Item["Country"])-->
218     
219         <li class="fc-map__marker-item" style="padding: 24px;" data-lat="@location.Latitude" data-lng="@location.Longitude"
220             data-title="@location.Name" data-filter-value="@location.Category" data-filter-values="@location.Category,," data-filter-projectvalue="@location.ProjectValue" data-image-url="/Files/Images/Case Studies/UK/Canal-Way_1.jpg" data-sort-value="@location.Name" data-icon="">
221             <div class="fc-map__marker-html">
222                 <div style="float: left; padding:0px 16px 0px 0px">
223                     <img src="/Admin/Public/GetImage.ashx?Image=@(location.ImageUrl)&Crop=0&Format=jpg&Width=120&Compression=75">
224                 </div>
225                 <div class="info" style="float:right;">
226                     <div class="name">
227                         <a href="@location.Hyperlink" target="_blank"><b>@location.Name</b></a>
228                     </div>
229                     <div class="adr">
230                         <div class="street-address">@location.Item["Address"]</div>
231                         <div class="extended-address">@location.Item["Address2"]</div>
232                         <span class="postal-code">@location.Item["Zip"]</span>
233                         <span class="locality">@location.Item["City"]</span>
234                         <div class="country-name">@location.Item["Country"]</div>
235                         <!--<div class="project-value"><strong>Project Value:</strong> @location.ProjectValue</div>
236                         <div class="business-category"><strong>Business Category:</strong> @location.Category</div>-->
237                         <div class="lat-lng">Latitude / Longitude: @location.Latitude / @location.Longitude</div>
238                     </div>
239                 </div>
240             </div>
241         </li>
242     
243         }
244         </ol>
245     
246     </div>
247     
248         </div>
249     
250     </section>
251     
252     <section>
253     
254         <div class="wrapper flow">
255     
256             @renderCaseStudyPagination()
257     
258             @if (!GetBoolean("ItemPublisher:Items.Any"))
259             {
260                 <p class="error">@Translate("No_items_found", "No items found")</p>
261             }
262             else
263             {
264                 <div class="attractor-panels">
265     
266                     @foreach (LoopItem item in GetLoop("ItemPublisher:Items.List"))
267                     {
268                         // Select any Single Primary Case study Image
269                         var image = string.Empty;
270     
271     
272     
273                         var itemTest = item.GetValue("ItemPublisher:ItemType.Field.Name");
274                         //var itemLat = item.Getvalue("ItemPublisher:Item.Study_Geolocation.Lat");
275     
276     
277                         Dynamicweb.Content.Items.Item studyImage = new Dynamicweb.Content.Items.Item();
278                         Dynamicweb.Content.Items.Item studyLink = new Dynamicweb.Content.Items.Item();
279     
280                         if (!string.IsNullOrEmpty(item.GetString("ItemPublisher:Item.Images")))
281                         {
282                             studyImage = HagsWeb.Library.Methods.Items.ItemTypeMethods.GetItemImages(item.GetString("ItemPublisher:Item.Images"), 1).FirstOrDefault();
283                             if (studyImage != null)
284                             {
285                                 image = studyImage["Image"].ToString();
286                                 image = "/Admin/Public/GetImage.ashx?Image=" + image + "&Crop=0&Format=jpg&Height=350&Compression=75";
287                             }
288     
289                         }
290                         else
291                         {
292                             image = designBaseUrl + "assets/img/default-panel-texture.jpg";
293                         }
294     
295                         <div class="card card--vignette card--with-copy" data-lat="" data-lng="">
296                             <div class="card__core">
297                                 <div class="card__media">
298                                     <!--$$item.GetValue("ItemPublisher:ItemType.Field.Name")-->
299                                     <a href="@(item.GetValue("ItemPublisher:Item.DetailsUrl"))"><img src="@image"></a>
300                                 </div>
301     
302                                 <div class="card__copy card__copy--panel card__copy--long-title flow">
303                                     <h4 class="t-center ts-2">
304                                         <a href="@(item.GetString("ItemPublisher:Item.DetailsUrl"))">@item.GetString("ItemPublisher:Item.Study_Heading")</a>
305                                     </h4>
306     
307                                     @{
308                                         Dynamicweb.Content.Items.Item CaseStudyLink = Dynamicweb.Content.Items.Item.GetItemById("Hyperlink_Button", item.GetString("ItemPublisher:Item.Read_More_Button"));
309                                         string hyperlinkText = (CaseStudyLink != null && !string.IsNullOrEmpty(CaseStudyLink["Button_Text"].ToString())) ? CaseStudyLink["Button_Text"].ToString() : Translate("ReadMore", "Read More");
310                                         string hyperLink = item.GetString("ItemPublisher:Item.DetailsUrl");
311                                     }
312     
313                                     <div class="card__btn">
314                                         <a class="btn" href="@hyperLink">@hyperlinkText</a>
315                                     </div>
316     
317                                 </div>
318     
319                             </div>
320                             <div class="card__copy-extra flow">
321                                 <p>@item.GetString("ItemPublisher:Item.Study_Content")</p>
322                             </div>
323                         </div>
324                     }
325                 </div>
326             }
327     
328             @renderCaseStudyPagination()
329     
330         </div>
331     
332     </section>
333     
334