file_downloadPliki do pobrania

Error executing template "Designs/identity_v2/ecom/productlist/partials/download-products.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 Co3.ID.Dw.DAL.Repositories.PriceRepository.GetPrices(String priceGroup, String currency, Dictionary`2 prices, Product[] products, DateTime startDate)
   at Co3.ID.Dw.DAL.Repositories.PriceRepository.GetB2CPrices(Product[] products, String currency, String priceGroup, String command, DateTime startDate)
   at Co3.ID.Dw.Services.PriceService.GetB2CPrices(Product[] products, String currency, String priceGroup, String command, DateTime startDate)
   at Co3.ID.Dw.Providers.PriceProvider.FindPrice(Product product, Double quantity, String variantID, Currency currency, String unitID, User user)
   at Co3.Espresso.Dw.PriceProviders.EspressoDefaultPriceProvider.FindPrice(Product product, Double quantity, String variantId, Currency currency, String unitId, User user)
   at Dynamicweb.Ecommerce.Prices.PriceProvider.FindPrice(PriceContext context, PriceProductSelection selection)
   at Dynamicweb.Ecommerce.Prices.PriceManager.FindPriceInternal(PriceProvider provider, PriceContext context, PriceProductSelection selection, Boolean isInformative)
   at Dynamicweb.Ecommerce.Prices.PriceManager.FindPrice(PriceContext context, PriceProductSelection selection, Boolean isInformative)
   at Dynamicweb.Ecommerce.Prices.PriceManager.GetPrice(PriceContext context, Product product, String unitId, Int64 stockLocationId)
   at Dynamicweb.Ecommerce.Prices.PriceManager.GetPrice(Product product, String currencyCode, String countryCode, String unitId, Int32 userId, String shopId, StockLocation stockLocation)
   at Dynamicweb.Ecommerce.Products.Product.GetPrice(String currencyCode, String vatCountryCode)
   at Co3.Espresso.Website.Services.ProductService.GetPrice(Product product)
   at Co3.Espresso.Website.Models.FrontEnd.Ecommerce.EspressoProduct.get_Price()
   at CompiledRazorTemplates.Dynamic.RazorEngine_2a39f8e5c91849aa8be6570d5f5dda9d.Execute() in D:\dynamicweb.net\Solutions\id.espresso4.dk-e5\Files\Templates\Designs\identity_v2\ecom\productlist\partials\download-products.cshtml:line 99
   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:589082bb-c3ab-4de5-b5fc-759d90a6b7f8
Error Number:-2,State:0,Class:11


  1     @inherits ViewModelTemplate< EspressoProductList >
  2     @using Co3.Espresso.Base.Extensions
  3     @using Co3.Espresso.Website.Models.FrontEnd
  4     @using Co3.Espresso.Website.Models.FrontEnd.Ecommerce
  5     @using Co3.Espresso.Website.Models.FrontEnd.Elements
  6     @using Co3.Espresso.Website.Models.FrontEnd.Handlebars
  7     @using Co3.Espresso.Website.Models.FrontEnd.Settings
  8     @using Co3.Espresso.Website.Services
  9     @using Co3.ID.Dw.Models.Frontend.Ecommerce
 10     @using Dynamicweb.Frontend
 11     @using Dynamicweb.Rendering
 12     @using Dynamicweb.Rendering.Translation
 13     @{
 14       HandlebarsProductListTemplate handlebarsProductListTemplate = HandlebarsService.Instance.GetProductListTemplate( new HandlebarsProductListTemplateSettings() );
 15       handlebarsProductListTemplate.ItemClasses.AddClasses("js-identity-product-item-index");
 16     }
 17     
 18     <div class="col-12">
 19     
 20     <!-- Product paging for search engines that do not support dynamic rendering with js -->
 21     @if ( Model.Paging != null && Model.Paging.Any() )
 22     {
 23       <ul class="pagination js-e-productlist-pagination mt-1 justify-content-end" hidden>
 24         @foreach ( EspressoPagingPage espressoProductListPagingPage in Model.Paging )
 25         {
 26           <li class="page-item @( Model.CurrentPage.ToString() == espressoProductListPagingPage.Number ? "active" : string.Empty)">
 27             <a class="page-link" href="@espressoProductListPagingPage.Url">@espressoProductListPagingPage.Number</a>
 28           </li>
 29         }
 30       </ul>
 31     }
 32     
 33     <!--/ Product paging for search engines that do not support dynamic rendering with js -->
 34     <!-- Product template for dynamic rendering with js -->
 35     
 36     <script>
 37     var arrProducts = [];
 38     </script>
 39     
 40     <div class="row my-1">
 41         <div class="col-12">
 42             <button type="button" class="btn btn-seconary js-e-download-addall">
 43                 <span class="text-primary">+</span>
 44                 @Translate("eCom Download - Add All Cart - Button", "Add all products to download")
 45             </button>
 46         </div>
 47     </div>
 48     
 49     <div class="e-productlist e-productlist-download">
 50       @if ( Model.Products.Any() )
 51       {
 52         int productSkeletonCount = ( Model.PageSize * Model.CurrentPage ) - Model.PageSize;
 53         int previousPageNum = 1;
 54         int productCounter = 1;
 55     
 56           
 57     
 58         <div class="row" id="js-e-productlist-products">
 59           <!-- Previous products skeleton logics, if pagenum on load is more than 1 -->
 60           <!-- Page 1 of @Model.Paging?.Count -->
 61           @if ( productSkeletonCount > 0 && Model.CurrentPage > 1 )
 62           {
 63             int productsPerPageCounter = 0;
 64             string isObservable = string.Empty;
 65     
 66             for ( int i = 0; i < productSkeletonCount; i++ )
 67             {
 68     
 69               <div class="@handlebarsProductListTemplate.ItemClasses e-productlist-skeleton">
 70                 <div class="e-productlist-skeleton-item js-e-productlist-skeleton-item @isObservable" data-page="@previousPageNum" data-index="@productsPerPageCounter"></div>
 71               </div>
 72     
 73                 if ( productCounter % Model.PageSize == 0 )
 74               {
 75                 previousPageNum++;
 76                 <!-- Page @previousPageNum of @Model.Paging?.Count -->
 77               }
 78               productCounter++;
 79               productsPerPageCounter++;
 80               if ( productsPerPageCounter % Model.PageSize == ( Model.PageSize - 1 ) )
 81               {
 82                 isObservable = "is-observable";
 83               }
 84               else if ( ( productsPerPageCounter + 1 ) > Model.PageSize )
 85               {
 86                 productsPerPageCounter = 0;
 87                 isObservable = string.Empty;
 88               }
 89             }
 90           }
 91           <!-- Server rendered products from current page -->
 92           @foreach ( IdentityProduct espressoProduct in Model.Products )
 93           {
 94               @:<script>
 95               <text>
 96             arrProducts.push( {
 97                 "name": "@espressoProduct.Name",
 98                 "id": "@espressoProduct.Id",
 99                 "price": "@espressoProduct.Price.Value.ToJavaScript()",
100                 "brand": "@espressoProduct.BrandName",
101                 "category": "@espressoProduct.Category",
102                 "variant": "@espressoProduct.ColorVariantText",
103                 "list": "@PageView.Current().Page.GetDisplayName()",
104                 "position": @productCounter
105         
106             });
107             </text>
108               @:</script>
109             <div class="@handlebarsProductListTemplate.ItemClasses">
110               @RenderingService.Instance.PartialView( "ecom/productlist/partials/download-item.cshtml", espressoProduct )
111             </div>
112           }
113           <!-- Handlebars template for rendering of whole product list - on filtering/sort -->
114           <script id="js-e-handlebars-tmpl-productlist-products" type="text/x-handlebars-template">
115             {{#each products}}
116             {{> productlistProductPartial listItemHtml}}
117             {{/each}}
118            </script>
119            <!-- Handlebars partial for product list items -->
120            <script id="js-e-handlebars-tmpl-productlist-product-partial" type="text/x-handlebars-template">
121              <div class="@handlebarsProductListTemplate.ItemClasses">
122               {{{this}}}
123             </div>
124            </script>
125         </div>
126     
127     
128           <!-- Load more products button -->
129           <div class="row">
130             <div class="col-12 py-2 col-lg-4 col-xl-4 offset-lg-4">
131               <a class="btn btn-block btn-primary d-none js-e-productlist-load-more-products-btn e-productlist-load-more-products-btn" href="#">
132                 @Translate( "eCom Productlist - Load More Products - Button", "Hent flere produkter" ) <span class="material-icons">keyboard_arrow_down</span>
133               </a>
134             </div>
135           </div>
136       }
137       else
138       {
139         <div class="alert alert-info mt-2">
140           @Translation.GetTranslation( "eCom Productlist - No Products - Text" )
141         </div>
142       }
143       <div class="e-loading-overlay e-productlist-loading-overlay js-e-productlist-loading-overlay">
144         @RenderingService.Instance.PartialView( "_partials/loading-spinner.cshtml" )
145       </div>
146       
147       <div class="js-e-productlist-lazy-loading-block mt-4 position-relative text-center d-none">
148           @RenderingService.Instance.PartialView( "_partials/loading-spinner.cshtml" )
149       </div>
150     </div>
151     </div>
152     <script>
153     
154     dataLayer.push({
155       'ecommerce': {
156         'currencyCode': '@PageView.Current().Area.EcomCurrencyId',
157         'impressions': arrProducts
158       }
159     });
160     
161     </script>
162