domitor/intwenty

Create meta data driven applications with java script and ASP.NET Core

Intwenty

Is a meta data driven Template that simplifies developing CMS, Blog Engines and other systems. Intwenty is built on Vue.js and ASP.NET Core.

• It lets you create meta models that describes UI and data.
• Models are stored as data instead of strongly typed objects.
• It uses the model to create the database, render UI and make you happier.
• Applications (models) are easily localized and may be defined either programaticly or visually with included designers.
• Implements and extends Asp.Net Core Identity. Intwenty adds organization and product management.
• Has built in support for tenant isolation
• Uses Intwenty.DataClient (Instead of entity framework) a small but fast Db connection library with ORM functions and JSON support
• The Nuget version is an RCL Package (Razor Class Library) that includes both UI and Controllers to get you up and running fast.
• Is constantly improved (and changing)

How to ?

Task
Quick start
Configure intwenty (Settings)
Configure intwenty (Application Startup)
The Intwenty DataService
The Intwenty ModelService

Intentions

1. Boost productivity
2. To be lightweight
3. Keep dependencies to a minimum.

Backend Dependencies

• asp.net core 3.1
• Microsoft.AspNetCore.Mvc 2.2.0
• Intwenty.DataClient
• Swashbuckle.AspNetCore 5.6.3

Frontend Dependencies

• bootstrap 4.3.7
• popper.js 1.16.1
• vue.js 2.6.11
• jquery 3.3.1
• alasql 0.5.5
• fontawesome-free-5.12.1-web
• selectize 0.13.3

Works with the following databases

• MS Sql Server
• MySql
• Maria DB
• PostgreSQL
• SQLite

How to get started

Consult the Wiki

How to get Intwenty

• Fork this Repository.
• Download the latest release on github.
• Use the nuget package.

intwenty's Issues

Decimal not handled correctly when saving

Implement accordion in Default UI renderer

ApplicationValues from operationresult.data

Create new functionality that builds ApplicationValues from operationresult.data.

Hantera obligatoriska fält på klienten

Replace ApplicationId with hash

Export Meta Model

Ability to export model for one application or for the system

Create routes runtime for new endpoint models and applications

UI Editor - Can't select database column somtimes

If am UI Object (Textbox) is saved without a database column setting, then it is not possible to select a column later.

Implement new property on DatabaseItem = Unique

Bygg stöd för DP i NetCoreDBAccess

Modal DataView should be based on DataView Columns

Better filter in application listviews and dataviews

Make private properties in IntwentyDataService protected

Render menus based on user permissions

Add wwwroot folder to RCL

Integrations

Generate endpoints post / put / get for all applications markt for this feature.

User Admin Improvements

Delete User
Reset MFa

GetListView - reset filter

Run configure when editing datamodel

Implement API key generation for user

Fixa snyggare multi select

Dels kunna lägga till vidden lookupfields.
Dels kunna skriva en kod att göra uppslaget på eller kunna välja.

Can we integrate MongoDb ?

Hi,

Is it possible to use Data Client service for MongoDb collection.

Is it possible to Db connection with MongoDb..

#mongodb

Thank you.

Stöd för flera organisationer i en db

Remove entity framework

Stop using entity framework for model.

Fixa filtrering och paging i dataviews

Remove metatype LISTVIEW

LISTVIEW can be handled at DATACOLUMN level, as a property: IncludeInListView=true

SQL Lite begin commit rollback transaction fails, if sql error

Example: This fails on sqlite if the exception occurs in the database

try{
begin
dosql();
commit
}catch{
rollback
}

Create Blogg/Cms support

Use inwenty apps for admin but create a new view for presentation

• handle posts per page
• handle comment
  • Editgrid
  • Dialog create comments in subtable

Changes to editgrid
New Properties

• EDITMODE=CELL, MODAL, EXPANDER
• LAYOUT = GRID, CARD

New UI element HTML

App security

• Visibility = All, Owner, Admin
• Create = Admin, User, Everyone, Roles
• Edit =
• Delete =

Remove in listviews

Add functionality to remove applications from listviews

Change AllowedAccountTypes.Manual to Local

Manual is a bad name, use Local instead

Move to asp.net core 3 and bootstrap 4

Global Settings

• Startpage
  • Picture or Application
  • Text
  • Content layout, fullscreen, fluid

Användare och roller

JSON storage option

Changes to IntwentySqlDbDataManager

Create a new setting option: UseJSONStorage. If true save complete application json documents to a new table ApplicationName_JsonDoc (Id, Version,......JSON), also save a json object with application list columns to a new table: ApplicationName_JsonList (Id, Version.....JSON).

When retrieving data with: GetLatestVersion(), ApplicationName_JsonDoc can be used to get a saved json doc without using the model.

When retrieving data with: GetList(), ApplicationName_JsonList can be used to get a array of saved json objects without using the model.

UI för inmatning av meta data WYSIWYG ?

Better default value handling - Create New

Create empty json object on create new, this should include defaultvalues as well as table and subtable names.

Example
{"Order":{ "OrderId":"ORD1001", "OrderLines":[] }}

Updating a subtable row seems to fail

Verified with SQLite

Option on save - Add model if missing

Bygga filuppladdning

Create endpoint admin UI

Download PDF

Feature on open/edit

Download Excel

Feature on list pages

Add functionality to GetValues from ApplicationData

Add GetAsString, GetAsInt, GetAsDecimal etc.. in ClientStateInfo and OperationResult. An alternative is to create a wrapper class around ApplicationValues and add these methods there.

Add functionality tom modify json string in operationresult.data

Add methods: ClientStateInfo ?, OperationResult ? Wrapper ?

//Add a value to the application json object
AddToJson(dbname, jsonname, jsonvalue)

//Remove json values (and names) from jsonobject or array of objects
RemoveFromJson(dbname, jsonname)

Hämta en domän i stället för alla i en app

Create UI for properties

Create a UI for handling properties to be used in the UI editor and the database editor, to be able to assign properties to the model.

Properties should have the form NAME=VALUE#NAME2=VALUE

A property value can be always TRUE or selected from a valuedomain.

Hantera subtables

Add Ignore property to dataannotations to be able to specify properties that should not be included in db query

It should be possible to create a menu item without appmetacode if the item has an action and a controller value

This is useful for menuitems with no connection to a specific application

Force MFA