@(Html.Kendo().Grid<ParteMovimientoLineaVM>()
.Name("listadoMovimientosLinea")
.Mobile()
.Columns(columns =>
{
columns.Bound(model => model.ParteMovimientoLineaID).Hidden();
columns.Bound(model => model.Cantidad).Title("Cantidad").Width("10%");
columns.Bound(model => model.TipoMovimiento).Title("Movimiento");
columns.Bound(model => model.MedioAuxiliar).Title("Medio / Maquinaria");
columns.Bound(model => model.TipoEstado).Title("Estado / Ret. Completa");
columns.Command(command => {
command.Destroy().Text(" ").IconClass("bi bi-trash");
command.Edit().Text(" ").IconClass("bi bi-pencil-square");
});
})
.ToolBar(t =>
{
t.Custom().Text("AƱadir").HtmlAttributes(new { id = "addLineBtn" });
})
.Editable(editable =>
{
editable.Mode(GridEditMode.PopUp).TemplateName("_FormMovimientoLinea");
})
.BindTo(Model.Lineas) // This is a test, it should be a dataSource with the Read Action
)
@model MyPath.Models.Movimientos.ParteMovimientoLineaVM
<fieldset class="k-edit-form-container d-flex flex-column gap-4">
<div class="k-form-field">
@(Html.Kendo().NumericTextBoxFor(m => m.Cantidad)
.Min(1)
.Step(1)
.Value(1)
.Format("n0")
.Spinners(true)
.Label(l => l.Content("Cantidad")))
</div>
<div class="k-form-field">
@(Html.Kendo().DropDownListFor(m => m.TipoMovimiento)
.BindTo(new List<string> { "Movimiento 1", "Movimiento 2", "Movimiento 3" }) // Datos de prueba
.OptionLabel("Selecciona un movimiento")
.Label(l => l.Content("Tipo de movimiento"))
)
</div>
<div class="k-form-field">
@(Html.Kendo().DropDownListFor(m => m.MedioAuxiliar)
.BindTo(new List<string> { "Medio 1", "Medio 2", "Medio 3" }) // Datos de prueba
.OptionLabel("Selecciona un medio")
.Label(l => l.Content("Medio Axuiliar"))
)
</div>
<div class="k-form-field">
@(Html.Kendo().DropDownListFor(m => m.TipoEstado)
.Label(l => l.Content("Estado / Ret. Completa"))
.DataTextField("Text")
.DataValueField("Value")
.OptionLabel("Selecciona un estado")
.DataSource(source =>
{
source.ServerFiltering(true);
source.Read(read => read.Action("GetMantenimientosDropDown", "MantenimientosSimples", routeValues: new { entidad = EMantenimientoGenericoEntidad.TipoEstado }));
}))
</div>
</fieldset>
AddEventos(): void {
if (this.grid) {
this.grid.bind("save", (e: kendo.ui.GridSaveEvent) => {
if (e.model?.isNew()) {
console.log("New row save:", e.model);
}
e.model!.dirty = false;
this.grid?.refresh();
});
this.grid.bind("remove", (e: kendo.ui.GridRemoveEvent) => {
console.log("Row delete:", e.model);
this.grid?.dataSource.remove(e.model!);
this.grid?.refresh();
});
}
}
AddCustomButtonEvent(): void {
$("#addLineBtn").on("click", () => {
if (this.grid) {
this.grid.addRow();
}
});
}
In the example below products is actually DbSet<Product>
public async Task<ActionResult> Products_Read([DataSourceRequest]DataSourceRequest request)
{
using (var northwind = new SampleEntities())
{
IQueryable<Product> products = northwind.Products;
DataSourceResult result = await products.ToDataSourceResultAsync(request);
return Json(result);
}
}
Under the hood the ToDataSourceResultAsync call is executed inside Task.Run
And that Task.Run is calling sync methods of IQueryable which means EntityframeworkCore queries are not taking place with async I/O
I came up with something like below. But couldnt figured out how to support groups and aggregates.
It works with filters, sorts and paging.
public static Task<AsDataSourceResult<TResult>> ToAsDataSourceResult<TModel, TResult>(this IQueryable<TModel> enumerable, DataSourceRequest request, Func<TModel, TResult> selector)
{
return enumerable.AsCreateDataSourceResultAsync(request, selector);
}
private static async Task<AsDataSourceResult<TResult>> AsCreateDataSourceResultAsync<TModel, TResult>(this IQueryable<TModel> queryable, DataSourceRequest request, Func<TModel, TResult> selector)
{
var result = new AsDataSourceResult<TResult>();
var data = queryable;
if (request.Filters.Count > 0)
data = (IQueryable<TModel>)data.Where(request.Filters);
result.Total = await data.CountAsync();
var sort = new List<SortDescriptor>();
if (request.Sorts != null)
sort.AddRange(request.Sorts);
if (sort.Count == 0 && queryable.Provider.IsEntityFrameworkProvider())
{
// The Entity Framework provider demands OrderBy before calling Skip.
var sortDescriptor = new SortDescriptor
{
Member = queryable.ElementType.FirstSortableProperty()
};
sort.Add(sortDescriptor);
}
if (sort.Count > 0)
data = (IQueryable<TModel>)data.Sort(sort);
data = data.Page(request.Page - 1, request.PageSize);
var list = new List<TResult>();
a
result.Data = list;
return result;
}
private static IQueryable<TResult> Page<TResult>(this IQueryable<TResult> source, int pageIndex, int pageSize)
{
var query = source;
query = query.Skip(pageIndex * pageSize);
if (pageSize > 0)
query = query.Take(pageSize);
return query;
}
private static string FirstSortableProperty(this Type type)
{
var firstSortableProperty = type.GetProperties().FirstOrDefault(property => property.PropertyType.IsPredefinedType()) ?? throw new NotSupportedException("Exceptions.CannotFindPropertyToSortBy");
return firstSortableProperty.Name;
}
private static bool IsEntityFrameworkProvider(this IQueryProvider provider)
{
var name = provider.GetType().FullName;
return name == "System.Data.Objects.ELinq.ObjectQueryProvider" ||
name == "System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider" ||
name.StartsWith("LinqKit.ExpandableQueryProvider") ||
name.StartsWith("Microsoft.Data.Entity.Query.EntityQueryProvider") ||
name.StartsWith("System.Data.Entity.Internal.Linq");
}
AsDataSourceResult<TResult> is wrapper for typed access to DataSourceResult
How do i support all operations which ToDataSourceResult (sync) one supports.
I have list of tabs in my model like
In cshtml: my Tabstrip looks like this
Since Html.Action is no longer works in .net 8. Need suggestion to overcome this issue.
Now, I'm unable to navigate to the page which has this tabstrip due to Html.Action issue
I have a grid with the following template columns:
columns.Template("<input type='checkbox' />");
columns.Template("<input type='hidden' value='#=Ssid#' />");
Html.Kendo().Template().AddHtml() cannot be used because it does not return a string.
How can I rewrite the code to be compatible with a strict content security policy (e.g. without using unsafe-inline)?
Thank you
Grouping colapsed after the save.
Grouping should be in the same state as before the save
Need help on this issue. will waiting for you response.
We have a complicated Kendo Grid with Tag Helper notification. We need to use On Cancel Event within edit operation, by pressing Cancel button. Here is an example (but not Tag Helper)
@(Html.Kendo().Grid<MyModel>()I have an Editor on a page and there are several Content Security Policy violations in the console. Here is an example:
Refused to apply inline style because it violates the following Content Security Policy directive: "style-src-attr 'unsafe-hashes' 'sha256-aqNNdDLnnrDOnTNdkJpYlAxKVJtLt9CtFLklmInuUAE='". Either the 'unsafe-inline' keyword, a hash ('sha256-5TmCSWsRHHKtNC4AgS23KS5Z9SBqma0xikI6H6iJ1/Y='), or a nonce ('nonce-...') is required to enable inline execution.
Is it possible to use an Editor without adding unsafe-inline to style-src-attr?
Thank you