Tilhenger av norsk kvalitet

Error executing template "Designs/Swift/Paragraph/Swift_ArticleListFrontpage_Custom.cshtml"
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Invalid column name 'pris_inkl_mva'.
   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.Content.Items.Queries.Repository.SelectByParentPageIds(IEnumerable`1 parentIds, Query query, Boolean includeParagraphs, Boolean includeChildItems, Boolean checkPermissions, Boolean includeInheritedItems)
   at Dynamicweb.ItemPublisher.Frontend.GetItems()
   at Dynamicweb.ItemPublisher.Frontend.List()
   at Dynamicweb.ItemPublisher.Frontend.GetContent()
   at Dynamicweb.ItemPublisher.Frontend.GetContentBySettings(String settings)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Dynamicweb.Extensibility.AddIns.AddInManager.InvokeFunction(Object instance, String functionName, Object[] arguments)
   at Dynamicweb.Rendering.TemplateBase`1.RenderItemList(Object settings)
   at CompiledRazorTemplates.Dynamic.RazorEngine_be23bb98f7fa480a89c4bd172b4f2d38.<>c__DisplayClass1_0.<RenderArticleList>b__0(TextWriter __razor_helper_writer)
   at CompiledRazorTemplates.Dynamic.RazorEngine_be23bb98f7fa480a89c4bd172b4f2d38.Execute()
   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()


  1     @inherits Dynamicweb.Rendering.ViewModelTemplate<Dynamicweb.Frontend.ParagraphViewModel>
  2     
  3     @{ 
  4     	string listSource = !string.IsNullOrEmpty(Model.Item.GetString("ListSource")) ? Model.Item.GetString("ListSource") : Model.PageID.ToString();
  5     	string articleListSortOrder = !string.IsNullOrEmpty(Model.Item.GetString("ArticleListSortOrder")) ? Model.Item.GetString("ArticleListSortOrder") : "Descending";
  6     	int maxItemsInList = !string.IsNullOrEmpty(Model.Item.GetInt32("MaxItemsInList").ToString()) ? Model.Item.GetInt32("MaxItemsInList") : 10;
  7     	string articleListLayout = !string.IsNullOrEmpty(Model.Item.GetString("ArticleListLayout")) ? Model.Item.GetString("ArticleListLayout") : "grid";
  8     	string columnTheme = !string.IsNullOrEmpty(Model.Item.GetString("ColumnTheme")) ? Model.Item.GetString("ColumnTheme") : string.Empty;
  9     	string columnThemeClass = columnTheme != string.Empty ? " theme " + columnTheme + " p-3" + (articleListLayout == "carousel" ? " px-lg-4" : string.Empty) : string.Empty;
 10     	int gridSettings = !string.IsNullOrEmpty(Model.Item.GetInt32("GridSettings").ToString()) ? Model.Item.GetInt32("GridSettings") : 4;
 11     	int carouselSettings = !string.IsNullOrEmpty(Model.Item.GetInt32("CarouselSettings").ToString()) ? Model.Item.GetInt32("CarouselSettings") : 4;
 12     	string settingsClassGrid = string.Empty;
 13     	string settingsClassCarousel = string.Empty;
 14     
 15     	switch (gridSettings)
 16     	{
 17     		case 2:
 18     			settingsClassGrid = " grid-md-2";
 19     			break;
 20     		case 3:
 21     			settingsClassGrid = " grid-md-3";
 22     			break;
 23     		case 4:
 24     			settingsClassGrid = " grid-md-2 grid-lg-3 grid-xl-4";
 25     			break;
 26     		case 5:
 27     			settingsClassGrid = " grid-md-2 grid-lg-3 grid-xl-5";
 28     			break;
 29     	}
 30     	switch (carouselSettings)
 31     	{
 32     		case 2:
 33     			settingsClassCarousel = " slider-item-show2";
 34     			break;
 35     		case 3:
 36     			settingsClassCarousel = " slider-item-show3";
 37     			break;
 38     		case 4:
 39     			settingsClassCarousel = " slider-item-show4";
 40     			break;
 41     		case 5:
 42     			settingsClassCarousel = " slider-item-show5";
 43     			break;
 44     	}
 45     
 46     	switch (articleListLayout)
 47     	{
 48     		case "grid":
 49     			<div class="grid gap-md-4 grid-1@(settingsClassGrid)@(columnThemeClass)">
 50     				@RenderArticleList("Swift_Article", listSource, maxItemsInList, articleListSortOrder)
 51     				@RenderArticleList("Swift_ArticleListPage", listSource, maxItemsInList, articleListSortOrder)
 52     			</div>
 53     			break;
 54     
 55     		case "carousel":
 56     			<div>
 57     				@if (Pageview.Device == Dynamicweb.Frontend.Devices.DeviceType.Mobile)
 58     				{	
 59     					@RenderArticleListMobile("Swift_Article", listSource, maxItemsInList, articleListSortOrder)
 60     				}
 61     				else
 62     				{
 63     					@RenderArticleList("Swift_Article", listSource, maxItemsInList, articleListSortOrder)	
 64     				}
 65     			</div>
 66     			break;
 67     
 68     	}
 69     }
 70     
 71     @helper RenderArticleListMobile(string itemType, string listSource, int maxItemsInList, string articleListSortOrder)
 72     {
 73     	@RenderItemList(new
 74     	{
 75     		ItemType = itemType,
 76     		ListTemplate = "ItemPublisher/List/Mobile_ListFrontpage_Custom.cshtml",
 77     		ItemFieldsList = "*",
 78     		ListSourceType = "Page",
 79     		ListSourcePage = listSource,
 80     		ListPageSize = maxItemsInList,
 81     		ListOrderBy = "PublishedDate",
 82     		ListSecondOrderBy = "Updated",
 83     		ListOrderByDirection = articleListSortOrder,
 84     		IncludeAllChildItems = true,
 85     		Filter = "ShowOnFrontpage = true"
 86     	})
 87     }
 88     
 89     @helper RenderArticleList(string itemType, string listSource, int maxItemsInList, string articleListSortOrder)
 90     {
 91     	@RenderItemList(new
 92     	{
 93     		ItemType = itemType,
 94     		ListTemplate = "ItemPublisher/List/ListFrontpage_Custom.cshtml",
 95     		ItemFieldsList = "*",
 96     		ListSourceType = "Page",
 97     		ListSourcePage = listSource,
 98     		ListPageSize = maxItemsInList,
 99     		ListOrderBy = "PublishedDate",
100     		ListSecondOrderBy = "Updated",
101     		ListOrderByDirection = articleListSortOrder,
102     		IncludeAllChildItems = true,
103     		Filter = "ShowOnFrontpage = true"
104     	})
105     }