---> Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'if'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource
1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action2 paramReader) in //Dapper/SqlMapper.cs:line 2797at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in //Dapper/SqlMapper.cs:line 568
at YesSql.Sql.SchemaBuilder.Execute(IEnumerable
1 statements)
at YesSql.Sql.SchemaBuilder.AlterTable(String name, Action1 table)at OrchardCore.Autoroute.Migrations.UpdateFrom3() in C:\projects\orchardcore\src\OrchardCore.Modules\OrchardCore.Autoroute\Migrations.cs:line 84
ClientConnectionId:cf32ff6d-9ca2-411b-9d6a-c27f1818c2a8
@captmomo
I'm trying to create a part to display Json data in a html table and am really struggling with the concept of shapes and parts.
Typically if I wish to display such a view in normal MVC, I will just pass a model then render it. However, I would like to make it a re-useable part like the rest of orchard core.
My question is how do I pass a part to a view ?
I know the view for a part is using:
@model ShapeViewModel<DynamicViewModule.Models.DataTablePart>but what about a view where I want to pass the part in and render it?
do I just call DisplayAsync? and how would the controller for the view look like?
@await DisplayAsync(Model.Content)```
@model dynamic
@inject OrchardCore.ContentManagement.Display.IContentItemDisplayManager ContentItemDisplayManager
<div class="columns is-centered">
<div class="column is-half">
<div class="box">
<div class="content">
@await DisplayAsync(Model.Content)
</div>
</div>
</div>
</div>
3 replies
@foreach (var contentItem in Model.BagPart.ContentItems)
{
var item = await ContentItemDisplayManager.BuildDisplayAsync(contentItem, Model.BuildPartDisplayContext.Updater, Model.Settings.DisplayType ?? "Summary", Model.BuildPartDisplayContext.GroupId);
@await DisplayAsync(item)
}Contents.ItemController to see how it works in the standard controller
whats the liquid equivilent to
<partial name="LoginMenu" />
@Jus56288672_twitter so because somewhere a shape template file is rendered as a partial view, and because here the LoginMenu doesn't need any specific view model, just try the following that works
{% shape "LoginMenu" %}But because it has to be discovered as a shape put the LoginMenu.cshtml directly under your theme views folder, not under a child Shared folder as done in TheTheme, to separate shape template file you can also use a Views/Items/... subfolder.
Then as soon as you use a razor view, you need the right sdk in your project file, you may need a _ViewImports.cshtml e.g. to add tag helpers, and if you not only use mvc tag helpers (e.g. our tag helpers), to make them working in prod your module / theme needs to reference the projects / packages that define these tag helpers, this because in prod we use precompiled razor views that are precompiled in the context of your module / theme.
services.AddContentPart<DataTablePart>();
services.AddScoped<IDataMigration, Migrations.Migrations>(); public int Create()
{
_contentDefinitionManager.AlterPartDefinition(nameof(DataTablePart), part => part
.WithDescription("Provides input field properties with additional extensions."));
_contentDefinitionManager.AlterTypeDefinition($"DatatableWidget", type => type
.WithPart("FormInputElementPart")
.WithPart("FormElementPart")
.WithPart(nameof(DataTablePart))
.Stereotype("Widget"));
return 1;
}//controller
public async Task<IActionResult> DisplayAsync(string jsonData)
{
var contentItem = await _contentManager.NewAsync("DatatableWidget");
// Explicit syntax
var testPart = contentItem.As<DataTablePart>();
testPart.JsonData = jsonData;
contentItem.Apply(testPart);
return View(contentItem);
}//view
@model dynamic
@inject OrchardCore.ContentManagement.Display.IContentItemDisplayManager ContentItemDisplayManager
<div class="columns is-centered">
<div class="column is-half">
<div class="box">
<div class="content">
@{
var item = await ContentItemDisplayManager.BuildDisplayAsync(Model.Content.DataTablePart, Model.BuildPartDisplayContext.Updater);
await DisplayAsync(item);
}
</div>
</div>
</div>
</div> public async Task<IActionResult> DisplayAsync(string jsonData)
{
var contentItem = await _contentManager.NewAsync("DatatableWidget");
// Explicit syntax
var testPart = contentItem.As<DataTablePart>();
testPart.JsonData = jsonData;
contentItem.Apply(testPart);
var model = await _contentItemDisplayManager.BuildDisplayAsync(contentItem, _updateModelAccessor.ModelUpdater);
return View(model);
}@using OrchardCore.ContentManagement
@using OrchardCore.Mvc.Utilities
@{
ContentItem contentItem = Model.ContentItem;
//Html.AddPageClassNames("preview", "detail-" + contentItem.ContentType.HtmlClassify());
}
@await DisplayAsync(contentItem)then I get this
DatatableWidget (4ja56fkxmz24s2a5f3j5n36bxt)
lol at this point I'm really considering giving up
@DisplayAsync(Model), I just get an empty widget body
Hello,
Can anybody help me here to explain the steps of Azure AD migration for ORCHARD CMS tool.
We tried with multiple ways with my existing application, But not getting the exact way-
From where and How to start to Azure AD migration for my old application?
Strongly need your help here........
Alright im working on my custom Comments API, decided to just make it an independent service instead of coupling it to orchard in any way. It'll just never happen.
**I am using a razor view in my modified BlogTheme as the comment section component, but I'll need to be able to gather the ContentItemId from whatever liquid template is rendering the CommentSection as a shape
So say in the Content-BlogPost.liquid, I am rendering the comment section (CommentsSection.cshtml) like {% shape "CommentsSection" %}
Is it possible to make CommentsSection aware of the BlogPost's ContentItemId?
@using OrchardCore.ContentManagement.Routing
@inject IAutorouteEntries Entries
@{
Entries.TryGetEntryByPath(Context.Request.Path.Value, out var entry);
}
Current content item id: @entry?.ContentItemId