Project Summary
To Develop an Automated Coding Standard that can Generate Standard Codes right from Database CRUD Operations on the Back End to the Front End Files once the Data Base Architecture Is Finalised.
Key Words
Code Builder,Enterprise Resource Planning, Low Code, Code Automator, SDLC, Software Development Life Cycle
Introduction
We have always had this Idea of Generating entire minimum required Codes for an Application once the Database Architecture is finalised by the Architectand hence Code Builder has been evolving with us as a Manifested Brain Child of Aurom India that can Generate Stored Procedures, Models, Controllers, Area Registraton Files and necessary Views for MVC Technology Based on Factory Patterns.
Origin Of Proposal
These days an kind of a minimum accepted requirements of Application Software Demands that it should be Online that is it must be Web Based. Often we find delays in Interpreting Client Requirements Understood by Analysts and Deigned by Architects to give a Solution.
Problem Definition
To reduce the Time Estimates and Resources in Software Development Life Cycle Irrespective of Platform Choosen.
Work plan
We will be starting with MS SQL Server as a Database, C# as Code Behind language and MVC.net with HTML as the Front End to start with and Development on other Databases and other Languages at a later stage depending on the Demand and need of the Technology. Although we had Orginally Designed the platform for ASP.NET we have Successfully Migrated in coming out with a Base Version for MVC.
Project Information
Review and Status of Research and Development in the Subject
Project Features / Product Catalog
Designed Tables Get Here
- Define Your Table Structures by Queries With Constraints. Paste them on the Text area and then Click the Button to Generate them on the Data Base.
Generate Your Stored Procedures
- Create All the Stored Procedures on the Server in the Database where your Tables Recide that are Necessary with Naming Conventions for CRUD Operations with Click of a Button.
Generate
- Entire Project Models(It Creates Area Registration Files And Web Configuration Files) Needless to mention All Folders along with Naming Conventions are Created which you just need to Copy and Paste in the Areas Folder of your MVC Project and Include in the Project.
Generate
- Controllers And Views For Entire Project. Needless to mention All Folders along with Naming Conventions are Created which you just need to Copy and Paste in the Areas Folder of your MVC Project and Include in the Project.
Near Future Mandatory Necessary Enhancements Planned
What Seems to be a problem we are trying to Solve the worst a Programmer’s Nightmare but an Architect’s Delight is aliasing of Repetitive Master Keys in the related tables that need to be named differently than ones specified in the Master.
Once this is achieved we would like to call this as a Stable Release.
Future Planned Releases that need to be worked out depending on availability of Resources are as follows
1. An Intelligent Basic Designer for managing the HTML Layout.
2. Choice of Controls like a Table in place of a Drop Down list, an Auto suggestion from the System to analyse the Designers intent that can over ridden by the End User.
3. We should try to provide the End User a choice of a Template of his own which as of now is not possible.
4. Advanced Child and Master Data Entry Screens with or without Images.
5. Inline Editing of Advanced Master Screens with choice of Text Boxes for Respective Controls.
6. A Process Designer with all the above Design Base Ingredients to form a Tool for PROCESS DESIGN for a Business Owner with some Basic Design Skills and Relational Concept Subtlety.
Sample Entity Relationship Diagram
Sample Entity Relationship Diagram
Time Schedule of Work Plan
| Sl No | Broad Work Element | Time Estimates In Months |
| 1 | Laying out principles of Table Design with One Primary Key for each table Irrespective of Database Choosen. | 2 |
| 2 | Ensure that Code Builder utility checks the Keys and provides a report for the missing ones in the Schema. | 3 |
| 3 | Developing a Master Stored Procedure that will generate all the Stores Procedures for CRUD Operations methodically with proper naming conventions for all the tables in the Database. | 2 |
| 4 | Developing a Methodology to generate User Input Screens for all the Master Tables with a click of a button with grids for Display and Printing of master data if necessary. | 3 |
| 5 | Developing a mehodology to access the Database Layer with the User Input Screens with the help of a Code Behind File a term that is usually used that will have the code to access Data from Tables and change the same. | 2 |
| 6 | Allowing the Architect or the Designer to Identify the Master and Child Tables that will involve Primary and Foreign Key Constraints enabled. | 1 |
| 7 | Allowing the Designer to choose amongst the type of the Interface that the Code Builder Utility can offer as a UI suitable for Data Entry and subsequent generation of the Ui screens and Code Behind Files so that nearly an error free Code is generated ready for Data Entry. | 2 |
| 8 | Develop Teams that can Identify the layers that need to be developed so that Application Speed can remain constant irrespective of the growth of data in the Database. | 1 |
Minimum Group Organisation
| Sl No | Group Code | Position Description | No Of Posts |
| 1 | 1 | Testing Administrator | 1 |
| 2 | 2 | Assistant DB Architect | 4 |
| 3 | 3 | Internal User Interface Administrator | 1 |
| 4 | 4 | Data Mapper Administrator | 2 |
| 5 | 5 | Process Experts | 2 |
| 6 | 6 | Programmers | 10 |
| 7 | 7 | Accountants | 1 |
| 8 | 8 | Process Designers | 2 |
| 9 | 9 | Internal Marketing Administrator | 1 |
| 10 | 10 | Internal Project Manager | 1 |
Suggested plan of action for utilization of Research Outcome Expected from the project
We are planning to Tie Up with Ramakrishna Mission Vivekananda Educational and Research Institute http://rkmvu.ac.in/ so that they can maintain the Entire Design, Source Code and Related Documentation necessary for it to Survive and Grow or Tie up with Microsoft Corporation / Microsoft Foundation so that A Team can be formed to Ensure that these Services and Upgrades are available to All Organisations in India freely to Develop and Enhance but not to Voilate the Set Statuatory and Predefined Standards.
Budget Estimates: Summary
| Item | BUDGET | (in Rupees) | |||
| 1st Year | 2nd Year | 3rd Year | Total | ||
| A. | Recurring | ||||
| Salary Expenses | 67500000 | 74250000 | 81675000 | 223425000 | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 | |
| Travelling Expenses | 2400000 | 2640000 | 2904000 | 7944000 | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 | |
| B. | Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
| Grand Total (A+B) | 72600000 | 79860000 | 87846000 | 240306000 |
Budget for Salaries/Wages
| Position Description | No Of Posts | Monthly Emoluments | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |||
| Testing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Assistant DB Architect | 4 | 250000 | 12000000 | 13200000 | 14520000 | 39720000 |
| Internal User Interface Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Data Mapper Administrator | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Process Experts | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Programmers | 10 | 200000 | 24000000 | 26400000 | 29040000 | 79440000 |
| Accountants | 1 | 125000 | 1500000 | 1650000 | 1815000 | 4965000 |
| Process Designers | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Internal Marketing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Internal Project Manager | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Totals | 67500000 | 74250000 | 81675000 | 223425000 |
Budget for Consumable Materials
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 |
Budget for Travelling Expences
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Travelling Expenses | 2400000 | 2640000 | 3630000 | 8670000 |
Budget for Other Expenditures
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 |
Budget for Equipment If Applicable
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
Infrastructural Facilities
| SrNo | Infrastructural Facility | Status |
| 1 | Workshop Facility | Yes – Sharing basis |
| 2 | Water & Electricity | Yes - Sharing basis |
| 3 | Laboratory Space/ Furniture | Yes - Sharing basis |
| 4 | Power Generator | No |
| 5 | AC Room or AC | No |
| 6 | Air Cooler If Tempratures are too High | Yes |
| 7 | Telecommunication including e-mail & fax | Yes |
| 8 | Transportation | Yes |
| 9 | Administrative/ Secretarial support | Yes – Sharing Basis |
| 10 | Information facilities like Internet/ Library | Yes – Sharing Basis |
| 11 | Computational facilities | Yes – Sharing Basis |
| 12 | Animal/ Glass House | No |
| 13 | Any other special facility being provided | Not Required |
Equipment available with the Institute/ Group/ Department/ Other Institutes for the project
| Sl No | Equipment Available | Generic Name Of Equipment | Qty Available | Model Make And Year Of Purchase | Remarks Including Accessories Available And Current Usage Of Equipment |
| 1 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 2 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 3 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
