Make this application Windows DNA architecture compliant.
NO additional functionality is required other than building the 3rd tier (see below).
Create the proper classes (data access layer and business objects layer) for the tables: tbGroups, tbGroupSecurity, tbGroupMembers, tbKeys, tbTypes, tbUsers tables. There are already stored procedures created (SQL Server) that maintain these tables. Prefer to leave them alone, but if necessary for performance, they can be changed. Basically, bring this application in to the new age using all the pieces necessary for this to be part of a commercial application.
The classes, properties, and method names should conform to a standard naming convention. That convention is up to the developer so long as it is strictly adhered to throughout the entire code base. We need really good code practices to be used.
The application currently runs in 2-tier SQL Server only. There is a setting in the registry that tells this client application to run 2 or 3-tier. COM+ experience is a must. I need COM+ component(s) created to handle the 3rd tier. This app needs to run 2-tier or 3-tier based upon the setting in the registry. You will be supplied with a small utility that switches the registry settings as necessary.
This application allows a user to maintain User and User Group records for a larger application. Users can be assigned into one or more User Groups.
The screens in the attachments are all the screens that are in the system. I need clear, concise, well-documented code.
The current code and scripts to create the data tables with test data will be provided. The grids utilize true db grid pro 7.
This project is a precursor to a much larger project (previously for bid on RAC but we decided to go with this smaller one first to "test the waters" how successful this is going to be). We have another application that requires at least 1,500 main hours of work to complete. We’d like to keep the same service provider across this application and the next of course since this small app maintains a portion of the larger app.
We would prefer bids from firms with more than a single developer.
Please include the hours you expect this to take so that I may accurately calculate your hourly equivalent rate (in mind for the next bigger project).
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Visual Basic 6, SP5
Windows 2000 or equivalent for COM+ portion