Develop Database Application with Minimal Coding - Kushal

Creating Sample SQLite Database Using Kushal.

Preview Of Data sample in Excel.

Database Design.

It can be accommodated in 3 different tables,

·Contact Master.

·Salutation.

·Relationship

Database Support.

Since this project is small, we will demonstrate Database Creation using SQLite. If your requirement is to develop an application in other popular databases like MS Access, My SQL or MS SQL you may use that database. But the whole procedure that we show here remains almost the same for all the databases.

Define Database in Excel Using Kushal.

Creating SQLite database using “Kushal”.

Traditionally creating database involves opening respective Database  application and we have to create database step by step. But with  Kushal designing database is very simple. You can use pre existing  database, you can newly create a database using a database application  or simply define the database field definition in Excel and Kushal will create the database.

In this example, we have entered the database definition in Excel.  Let us select the SQ Lite as the database and then let us select  designation folder. We will give Contact_Manager as the SQLite database  Name. Once we define all these and select the excel file, Kushal will  create the database. Let us open the database in SQLite interface and  browse it.

We can also generate a respective SQL Statement if required by clicking on SQL button.

Database preparing with normal techniques take considerably much  longer time than this. This is one very good example of how Kushal makes developing database applications much simpler.

Thank You.

Creating  Kushal Project – Contact_management.

Database Support & Code Generation.

Kushal will generate the code in the Visual Studio. Output program will be C HASH code.

Kushal works with 5 different Popular Databases.

·SQLite.

·My SQL.

·MS Access.

·MS SQL.

·SQL CE.

Prerequisites.

We need to ensure following things are ready before we start developing application in Kushal.

·Dot Net Frame Work 3.5 or higher installed on your system.

·Complete Database Application.

·Inno Setup or any other Installation Builder.

·Registered Version of Kushal.

If you are a Kushal Premium Version user and want to access the  project code, In addition to above requirements you need to have Visual  Studio Express 2008 or higher installed in your system.

Kushal Project Creation Procedure.

We will create a new Project and we will Name it as Contact Management.  That is we will Provide Project Contact_Management as Project name.

Let us define Company Name as ABC & Co.

We will keep Version Number as 1.Let project gets created in C: Kushal.  Please note that Kushal will create a subfolder with name  Contact_Managerment as that is the Project Name.

Since this is a simple application we will not select User Management.

Now we have SQLite Database so we will select SQLite. Note that you  need to know your system configuration, Is it 32 bit or 64 bit operating  system and accordingly you need to select the option as sqlite dlls are  different for different operating systems.

Kushal automatically creates a multi file system, we need to provide  an extension for end application files. Kushal will read Database  definition from original file and further create a copy of it when users  create new file in the end application. We will give ACN as the file  extension.

We will save the Project.

Thank You

Before you design the Kushal application, have a look at the prerequisites.

Prerequisites.

• You need to ensure the following things are ready before you start developing an application in Kushal.

• Dot Net Framework 3.5 or higher installed on your system.

• A database server or file system is available to connect. For Example,

• SQ Lite file is accessible,

• Authorized user having access to use MS SQL Server.

• Inno Setup Installation Builder.

• Reporting tool Example: My FYI

• Kushal.

• Visual Studio Express 2008 or Higher

Kushal will generate the code in Visual Studio. The output program will be in C SHARP code.

Kushal works with 5 different Popular Databases.

· SQLite

· SQL CE

· MS SQL

· My SQL

· MS Access

Assuming that you have installed all the required applications, revisit Contact Management Application. Create a new project and provide Display name - Contact Management. Please note that the display name can have spaces while the Project Name cannot. Provide Contact_Management as Project name.

Define the Company Name as ABC & Co, or any other of your choice.

Keep Version Number as 1.0.0.0

The project gets created in C:\Kushal\Contact_Management, which is the Project Name.

Since this is a simple application you need not select the User Management feature.

Next, enter database details. You are developing a sample application with SQLite Database, so you can select SQLite as database Type.

Kushal automatically creates a multi-file system, you need to provide an extension for the end application data file. Kushal will read the Database definition from the original file and further create a copy of it when users create a new file in the end application. In this example, give ACM as the file extension.

Save the Project.

Create Forms and Menu.

When you create a Project, Kushal will automatically create some default forms. These can be viewed by enabling the ‘Show Default Forms’ checkbox. Note that Kushal has already created many forms. You are allowed to change only the design of the default forms or its controls, like re-positioning controls, captions, and image changes and so on.

You can turn off Default Forms option and focus on Creating New Forms which are specific to this Project

Click on ‘New Form’ – A window opens, where you will be able to select the type of form that you want. Kushal offers many types of Forms which find application depending on varying requirements.

Select form Type as “Table-Detail Entry”. Select the table name as “Contact Master”. The primary key is already set. Click on Create.

In the next window “Control Type Selection”, based on the datatypes of the columns, you can set the Control Type as Dropdown, Checkbox, Radio Button, or keep it as default type.

In this form, Since Salutation and Relationship will fetch values from other tables, you have to change the control type to Drop Down Type.

A New Form will be created with all the required buttons such as “New”, “Save”, “Delete”, “Search” & “Export”. All of them will have predefined actions. You can delete them if you don’t need them, or change their properties if required.

Then, choose the salutation dropdown and select the SQL property. Enter “Select Salutation from Salutation” as SQL Statement, to fetch records from the salutation table.

In the same way, you can configure the relationship dropdown.

If you need to add more relationships, you can do that through the Relationship form.

Create the new form “Relationships” in the same way as the form you just created. You can also access this form directly from the “Contact Master” Form. To do this, add a button, and configure its properties. Change the Action type as “Show Form Refresh” property. Then, in “Form Name” assign “Relationship”. Set the input control by choosing the “Relationship” dropdown.

Similarly, you can Create the “Salutation” Form.

Next, you can add a ‘Search’ Form – Since one of the requirements is to Search Contacts depending on Inputs provided.

You can click on ‘New Form’ in Forms Tab and Select ‘Advanced Search Form’. Click on ‘Create’, and in the window that opens, click on the “Show Query Builder button”. The Query Builder window opens, where you can see the database structure. You can easily create a query. Double click on ‘Salutation’ table, The table is added, and a query is created. Click copy to clipboard button, close the Query Builder and Paste the query in the ‘Advanced Search Query’ Window. Click on ‘OK’. Select the fields and click on the ‘hit’ button, and then click on ‘ok’. In the Advanced Search Text Configuration, select the control Types as explained earlier, and click on ‘Ok’. Your Advanced Search Form is Ready.

Kushal will create an Advanced Search form. Further changes can be done here but You can just go ahead and assign it to Advanced Search form. Click on the form, and in ‘Form Properties’, under Miscellaneous Properties, select the “Search Form”.

Now, You have completed designing all Forms.

Now you can design the Menu Items.

You will require only 3 Menu Items in this application.

· Salutation.

· Relationship.

· Contact Editor.

Select ‘Menu Definition’ Icon from the Ribbon in Kushal.

Click on ‘Add Root Menu’ a New Menu will be created. Now click on the ‘Rename’ button and call that menu as ‘Main’.

Right Click on ‘Main’ Menu and then Click on ‘Add Sub Menu’ and Create the 3 required Sub Menus – ‘Salutation’, ‘Relationship’ and ‘Contact Editor’. Now since you have not yet designed Forms, you will not be able to assign any functionality to menus.

Using arrow buttons provided on the right side of the Menu designer, it is possible to move the menu items up and down and also change the Menu Level.

As you change the menu Items, Menu gets changed in this window. You can get a preview of your menu design in the same window.

You can now assign Forms to Menus. Come back to Menu Definition Screen. Select ‘Salutation’ and Right Click and click on “Associate Form”. Click on Application Forms button, and in the window that opens, click the “Generate Automatically” button. This is a one-time procedure, whenever a new form is created.

Here, all forms created will now be generated. Close the window, and in the ‘List of Forms’ window, click on the Form which you want to associate, and click ‘Associate’ button. Here, associate the ‘Salutation’ Form.

In the same way, you can associate other forms to menus items.

On ‘Generate Source Code from Ribbon Menu. Kushal will generate the application in Specified Directory.

Before generating the code, Kushal will validate the controls and its properties. If any property is missing it will give appropriate warnings.

Click on ‘Open Folder’ to open the Source Code from the directory where the compiled application is to be created. Now you can explore how the Application is working.

Run the application, select ‘New’ from the ‘File’ menu and create a New File Called ‘Sample’.

The application will automatically make a copy of the Original Database – ‘Contact Management’ with ‘Sample. ACM’ name and it makes the database ready for making further entries.

Select Salutation from the menu, and make Some Salutation Entries like – Mr, Miss, Doctor Etc.

Similarly, select ‘Relationship menu item and enter some relationships.

Now you can open the Contact Editor window and make some entries. Observe that the dropdowns contain recently added salutations and relationships.

Note that the application also allows you to Delete or Edit Records.

After you make some entries, you can click Search to open the Search form and do Search operation.

Wow! Congratulations! You have built a fully functional Application now. Further, if you click Tools menu, you can see that the application has inbuilt utilities like Backup, Restore, etc. Help Menu also has many automatically generated Items.

Now you have had a preview of how Kushal works.

Once you build your application, it can run on your PC instantly. But if you want to distribute your application, then, the application along with supporting files have to be deployed on another machine. To deploy an application, you have to build Installation. There is much software, using which installation can be built. ‘INNO Install Builder’ is most popular among Free Installation builders available. For database applications, simple installation is sufficient to deploy your application. So, it is recommended that you use ‘INNO or ISTOOL’ setup for deploying applications you build using Kushal.

In Kushal, a Reporting tool called MyFYI is included, to create reports. However, that does not stop you including Crystal Report, Active Report or any other reporting tool of your choice.

In the sample project explained in the previous video, ‘Reporting’ was not explained since this is a detailed topic by itself.

Now, create a simple Report in MyFYI and then call it from a Kushal Project.

To do so, Open MyFYI, Click on ‘New Report’

In ‘Report Info Tab’, select Table

In ‘Connection Tab’ select SQLite since your database in SQLite

In Connection String Tab, provide Connection Sting for SQLite.

You need not select anything in the Parameter Tab

Provide SQL statement containing Field names that you want in the report.

Since you are creating a Contact Manager, you should provide SQL Statement which picks only required fields

Now by clicking on OK, a draft report will be ready.

Align fields in Report designer like the way you want to see them in the output

If you click on the ‘Preview’ tab – Instantly report will be generated.

But you should call this report from Kushal Project. So, save this RDL file with the name ContactEditor.
You can call this report from Search Screen which you have already designed.

To include reports in Kushal click on the Expression button. In the expression editor that opens, navigate to the Reports tab, and click on the ‘Add’ button. Select the report file which you have created.

Then, add a button for generating a Report called ‘Report’. In the button properties change the action type as ‘Show Report’. You should provide the rdl file path in ‘Report file name Properties’.

Now re-generate source code and see how this report is getting generated.

Kushal can also be used for Prototyping and Requirement Collection.

Develop 100% editable code in .NET

Kushal develops a 100% editable code in C# (. Net Technology) which is the most popular framework for developing Windows Applications in the Client-Server environment.

Compiled Code

The Generated code is pre-compiled by Kushal and Visual Studio.

Generate Automatic User Interface with numerous form types

Kushal includes form types that will help you to get an automatic User Interface by selecting a table or multiple tables from the Database. And easily you can change it as per your requirements and design standards.

Generate Fully Functional Menus easily

Define fully-functional multi-level Menus in Kushal, including assigning Icons for Menu Items. Also, you can call External applications from the Menu.

Create Useful Reports

Kushal comes with fully functional enterprise-class redistributable ReportViewer Control from Microsoft which is part of Kushal installation and is associated with the default Report Button.

Flexible data Connectivity

Kushal supports most popular databases like MS SQL (Available with Visual Studio), MySQL (Free till version 5.5), SQLite (Free), MS Access (Available with Microsoft Office) and SQLCe.

Generate SQL Quickly

Kushal comes with built-in excellent query builder, you can quickly generate SQL statements visually by dragging tables, fields while developing applications.

Strong Data Validation

Kushal extends the property of each control depending on the field type, this helps you to incorporate strong validations for each control defined in the application.

Custom Made Dot net controls

Kushal includes additional .Net Controls. Example: Link control (extended label control) comes with additional URL property, which takes users directly to the respective URL and Numeric Textboxes

Develop enhanced business logics in Expression Editor

Expression Editor module of Kushal allows you to develop business logic easily and quickly, thus mitigating the need for a full-time coding expert, for incorporating business logic.

Quick Data Import

You can configure Excel import in Kushal (Define Excel Templates) to allow users to import data from Excel directly to applications with validations.

User Management in Applications

Kushal allows you to configure modules by enabling user management. Users will be able to access Menu Items depending on the roles that are assigned to them.

File Management

When users develop File-based applications or Server-based applications, by default Kushal ensures multiple files (project) management or multiple database capability in the generated application.

Connect External Applications

Kushal allows configuring the external application and passing parameters to those applications. You can access external applications via a menu or button in Kushal.

Generate Business applications with standard application features

The generated solution will have standard product features such as File Management, User Management, Application Protection, Backup, Restore, Help and About Screens.

Secured software

Kushal comes with simple built-in application protection algorithms for end applications. Minor modifications in this algorithm will make it unique to your application.

Systematic Version Control

Whenever application enhancements are performed, those database changes are considered in maintaining the Database. Altering the queries in Kushal applications can port the latest database changes to the user files automatically.

Ready to Deploy Solutions

Users can generate Installation Script (Inno Setup Builder - Free Installer) Files from Kushal once a solution file is generated and build deployable setups.

No more dependency on 3rd party controls for developing applications

Most of the features required by DB applications are handled by Kushal effectively, it considerably reduces dependency on 3rd Party Controls to help you save money.

Build Variety of Applications in any Niche

Kushal finds application in a variety of applications, it can be used in any of the database-driven processes like Accounting, Payroll, Taxation, Office Automation Etc.

Since Kushal generates a 100% editable code, you are free to modify it as per your requirements.

Let us look at some of the business applications developed using Kushal.

The first is a Tailor-Made ERP Solution - GST Billing.

The GST Billing Software is a single solution for Preparing Invoices as per GST compliance, Preparing E-Way Bill & GST Returns, Managing Party Accounts, TDS, Inventory, CRM, Accounting and Exporting Data to Tally. The Invoices are also compatible with Bar Code Reader and Thermal Printer.

This application developed using Kushal, has a host of features required to run most of the operations in a business organization, including but not limited to, billing, accounting, inventory, CRM, managing party information, sending emails, Reports, excel export, and more. With this tailor-made ERP software, many organizations are running most of their business processes successfully.

Another application is the Payroll, an intuitive payroll processing application that automates salary payment calculations includes statutory components and generates payslips.

This software has enabled the clients to run payroll and leave management operations easily, and generate salaries with the click of a button, at the end of every wage cycle.

This Easy to Use Solution developed using Kushal, is fully compliant with statutory policies if Indian Payroll, like PF, PT, TDS, ESI, and features User Management, Employee Creation, Reports, Email Communication and more.

Some more applications developed in Kushal and further enhanced, are

· An Order Raising Software for Purchase Order Management, which is a role-based approval routing system with email communication, that can be used to effectively handle the complete purchase order process in an organized way.

· Lead Management application, consisting of a desktop application, web, and a mobile tool, to help your business track and manage leads of prospective customers and optimize the sales process for better results.

· Project Tracking and Management System, an effective project management tool for scheduling & managing projects smartly by tracking project status, resource utilization and recording payments.

· Suraksha CRM, a Secured License Management and CRM application to track user registrations, product licenses, and Customer Relationship Management Tasks.

· Bulk Email Sender, a high performance, mass email application that provides an easy means of communication for businesses and email marketing.

· Cheque book manager, a Smart and Easy Solution designed to store details of Cheques of any Bank and Print details on them easily.

· Leave manager, A simple Leave management software for small organizations to track Employee Leaves and Approvals and Generate monthly attendance reports.

· Bug Tracker, A simple and cost-effective bug tracking tool that helps to track bugs in software applications in an organized way.

· Library Management Software for Libraries which includes Book Registration, Member Registration, and Book Transactions.

· Fee Management Software for Schools and Tutorials to track Student Information, Fee Payment, Print Receipts and Email and SMS Communication.

· Petty Cash accounting application to track Petty Cash Transactions, Print Vouchers, and Generate Various monthly Reports.

After looking at these applications, you can see the enormous capabilities of Kushal. You can accomplish almost any feature you want to have in your business application with Kushal. And if you still want to do more, the code generated by Kushal is 100% editable.