Database data collection and reporting SQL ASP.net application.

Data collection application with user management to collect data and feed to a database (Microsoft SQL). Administration to create user accounts. Run Reports on data collected. Print batch print jobs. Reports based on print jobs. Reports on number of prints with shipping address and monetary value based on number of prints. Data collection for end user data collection and template reports with template maker GUI. ## Deliverables RBT ID Card Maker # Overview: An online system that allows registered users to enter data and produce templated ID cards printed at a central location. Registered users belong to companies. Companies can only see data entered for that company. End users can mark individual data entries to be queued to print or batch select data entries to be queued to print. Company administrators can do everything a registered user can do plus add / remove users. Access GUI for card template creation. Systems administrator can physically printed items marked for print queue ## 3 User levels: ? Registered Users: Access to data entry for assigned Company. Queue data for print. Clear printed status ? Company Administrators: Access to data entry for assigned Company. Queue data for print. . Add / Modify / Delete Registered Users within company. Add / Modify / Delete Card Templates. Clear printed status ? Systems Administrators: Access to all companies and all data. Ability to print queued jobs sorted by company. Automatically add printed status to printed data ## Data Entry GUI Proposed Standard ASP.net based FORMS And ASP.net based Data Grids. ## Card Template GUI Proposed Please see attached file for PDF with pictures. # Proposed structure ? Database o Company ? Company_ID ? Company_Name ? Billing_Contact ? Billing_Address ? Billing_Phone o Template ? Template_ID ? Template_Layout_Data ? Relationship_to_Company o User ? User_ID ? User_Name ? User_Password(encrypted?) ? Full_Name ? Athority_Level(1-3) ? Relationship_to_Company o Transactions ? Transaction_ID ? Relationship_to_Template ? Relationship_to_User ? Data1 ? Data2 ? Data3 ? Data4 ? Data5 ? Data6 ? Data7 ? Data8 ? Data9 ? Data10 ? Photo(jpg) ? Date_Created ? Date_Modified ? Print Status(0-2) (0=Unprinted 1=Queued 2=Printed) ? Print Date 1. The "Data Entry" you saying will be the form that represent the data fields (like Data1, Data2, Data4 on the sample template designer) on the card template? Is the form should include the uploading for the [Photo] field? Yes the data fields will be represented by adding a Dynamic field to the template. When adding the Dynamic Field to the Template there should be a dialog that request which data field will be mapped. The Photo should allow for the end user to size and place the photo as well as read from the database the stored JPG. The data entry screen can look like a basic forms project with a file upload option. 2. I need further details for Card Template GUI. What are the functionality of it? On the proposed GUI, I see barcode, etc. The Card Template GUI is for creating Card Templates. Technically making report templates. The gui should allow the end user to add data fields that map back to the transaction portion of the database. The data field labeled barcode will store the data that will be printed on the card. The barcode is a numerical value that when displayed on report / card or screen should use the code 39 font and begin and end with the astrix *. Example the value of 1234 is *1234* When the Systems Administrator processes the print job basically there should be an interactive query based on transactions that the printed status = queued. 3. What it means by, "Clear printed status" for Company Administrator? And also "Automatically add printed status to printed data" by System administrator. There will need to be a form or dashboard for the company administrator to select entries from the transaction table to be printed. If selected the print status field for that row should be set to a value = queued. On the systems administrator form or dashboard there should be an option to print all queued data entries and place the data in the expected template format as a report. The systems administrator should then be able to print the report(s) sorted by company. Once printed the data in the transactions table should have the print status value = printed. Optionally on a data entry by data entry basis or on the company administrators dashboard there should be an option to reset the printed value to value = unprinted. 4. You say "Ability to print queued jobs...", is it the Asp.net application should have an feature o f physically printing the card template using company data? No however it should be able to generate a report based on the templates assigned to the data. For example if a user for abc company enters data and another user for xyz company enters data and they both send the data to queue I want the systems administrator to be able to run a report sorted by the company and by the template selected and fill out the template into a printable format that can be sent to a standard windows printer. PDF is an acceptable format. 5. Finally can I use technologies like [ASP.NET][1] MVC for web app and possibly Silverlight for template designer? I would prefer ASP.net VB or C#. the MVC framework would be fine. Flash silver light or java for the designer would be fine. If you bid is accepted at a defined time I can demonstration what I want based on screenshot of similar software. * * *This broadcast message was sent to all bidders on Wednesday Oct 19, 2011 5:50:07 PM: Updates... The Card template GUI as dipicted in the project atachment is basicly a report maker. A template is a Photo ID layout with static and dynamic fields. The static fields such as company logo company text etc should not change for any card printed using that template. The dynamic fields should be data fields from the database. When asigning a print job to queue basically the enduser will be preforming an update script to the transactions database and populating a view. The project should build a printable report using the data from the view with the layout of the template. * * *This broadcast message was sent to all bidders on Wednesday Oct 19, 2011 5:51:52 PM: More Q and A 1. The "Data Entry" you saying will be the form that represent the data fields (like Data1, Data2, Data4 on the sample template designer) on the card template? Is the form should include the uploading for the [Photo] field? Yes the data fields will be represented by adding a Dynamic field to the template. When adding the Dynamic Field to the Template there should be a dialog that request which data field will be mapped. The Photo should allow for the end user to size and place the photo as well as read from the database the stored JPG. The data entry screen can look like a basic forms project with a file upload option. 2. I need further details for Card Template GUI. What are the functionality of it? On the proposed GUI, I see barcode, etc. The Card Template GUI is for creating Card Templates. Technically making report templates. The gui should allow the end user to add data fields that map back to the transaction portion of the database. The data field labeled barcode will store the data that will be printed on the card. The barcode is a numerical value that when displayed on report / card or screen should use the code 39 font and begin and end with the astrix *. Example the value of 1234 is *1234* When the Systems Administrator processes the print job basically there should be an interactive query based on transactions that the printed status = queued. 3. What it means by, "Clear printed status" for Company Administrator? And also "Automatically add printed status to printed data" by System administrator. There will need to be a form or dashboard for the company administrator to select entries from the transaction table to be printed. If selected the print status field for that row should be set to a value = queued. On the systems administrator form or dashboard there should be an option to print all queued data entries and place the data in the expected template format as a report. The systems administrator should then be able to print the report(s) sorted by company. Once printed the data in the transactions table should have the print status value = printed. Optionally on a data entry by data entry basis or on the company administrators dashboard there should be an option to reset the printed value to value = unprinted. 4. You say "Ability to print queued jobs...", is it the Asp.net application should have an feature o f physically printing the card template using company data? No however it should be able to generate a report based on the templates assigned to the data. For example if a user for abc company enters data and another user for xyz company enters data and they both send the data to queue I want the systems administrator to be able to run a report sorted by the company and by the template selected and fill out the template into a printable format that can be sent to a standard windows printer. PDF is an acceptable format. 5. Finally can I use technologies like ASP.NET MVC for web app and possibly Silverlight for template designer? I would prefer ASP.net VB or C#. the MVC framework would be fine. Flash silver light or java for the designer would be fine. If you bid is accepted at a defined time I can demonstration what I want based on screenshot of similar software. * * *This broadcast message was sent to all bidders on Monday Nov 14, 2011 5:33:19 PM: Here is a website with something similar to what I am trying to do. Please take a look at the videos. [login to view URL]