ZIL is a nocode platform, helps you to build business applications without coding.

ZIL is the easiest way to create apps for your management works. With ZIL, all app's components (like menu, window, workflow, report...) are pre-built like Lego bricks and pieces. You just choose, drag-drop and config them to build apps.

The ZIL tools includes:
• zForm: Configurable tool that creates from simple to complex app's input UI windows directly from customer's datasheet by select drag-drop corresponding tables and columns to the window layout.
• zWorkflow: Drawing tool that help you define customer's business by draw all steps of process in an intuitive and user-friendly way.
• zCloudData: The studio that user can define (table, column, view, sp...) and store their-own data sheet on the cloud. zCloudData also provides standard API allows other apps to read and write data via web.
• zReport: Design report tool like word processing software but on web. User can create report for their own with visual interface and then easily share the results to other.
• zMap: Map view functions for any app need location information. Map editor functions for app need collecting and manage spatial data.
• zMobile: Smart responsive web app with optimized interface for mobile users.

SQLRestC is a complete set of REST API for web enabled SQL Server.

SQLRestC is based on SQL Management Object (SMO) designed to allow for easy and simple programmatic management all aspects of Microsoft SQL Server.

The SQLRestC API includes:
• Token API: Authenticate and secure transmit data with SQL Server
• Database API: GetAll, Get, Create, Rename, Drop with database object
• Schema API: GetAll, Get, Create, Rename, Drop with schema object
• Table API: GetAll, Get, Create, Rename, Drop with table object
• View API: GetAll, Get, Create, Rename, Drop with view object
• Column API: GetAll, Get, Alters, Edit, Drop with column object
• Data API: Select, SelectByID, Insert, Update, UpdateByID, Delete, DeleteByID with data
• and more: ...

INSTALLATION GUIDE

Follow these steps to install ZIL:
• Step 1: Setup Microsoft SQL Server, download and restore file zilcode_nut.bak to new database zilcode_nut
• Step 2: In database zilcode_nut, open table n_service and correct url of first row as /rest/zilcode_nut/dbo/
• Step 3: Download zip source code from github
• Step 4: Extract zip and open file SQLRestC2.sln with Visual Studio
• Step 5: In Visual Studio correct config Connection in file appsettings.json that connect to your database zilcode_nut
• Step 6: In Visual Studio correct property BASE in file wwwroot/js/nut.js that is your webapp's url base (example https://localhost[:port]/)
• Step 7: In Visual Studio re-build and publish the project.

ZERO TO HERO

D E M O (admin.demo/12345678)
Website: zilcode.com
Email: vinhptfpt@gmail.com