210 likes | 312 Vues
This project, developed by Ian Gass, presents a robust ASP-based system for managing production data. It securely allows users to enter, edit, and delete production records while managing user accounts. The system includes essential functionalities such as daily log entries, user management, and verification processes. Each module, including DailyLogEntry.asp, DailyLogAdmin.asp, EditRecord.asp, and DeleteRecord.asp, interfaces smoothly to provide a seamless experience for users. The focus on security, accuracy, and usability ensures efficient production data management.
E N D
ASP Production Data Entry and Management EET 499 Final Project By Ian Gass
Project Goals • Secure • Enter Production Data • Manage Production Data • Manage User Accounts
Login.asp • Main( ) • InvalidPassword( ) • FailedMustWait( ) • LoginOK( )
DailyLogEntry.asp • Used to enter production data • Procedures • Includes CommonFunctions.inc • Main( ) • Calls VerificationForm( ) • Calls WriteToDB( ) • Calls LoggedOn( )
DailyLogAdmin.asp • Used to manage the production data • Procedures • Includes CommonFunctions.inc • Calls LoggedOn( ) • Sends results to Results.asp in URL
Results.asp • Displays results from the search created on DailyLogAdmin.asp • Creates links to EditRecord.asp and DeleteRecord.asp
EditRecord.asp • Get RecordID from URL • Opens database and selects the record • Displays the contents of the record • Saves changes
DeleteRecord.asp • Get RecordID from URL • Verifies that the user wants to delete the selected record • Removes the record from the table
AddUser.asp • Checks if new user already exists • Checks for duplicate username • Checks first name and last name • Adds to user table
EditUser.asp • Opens the table and retrieves record • Displays form with fields filled in • Writes any changes that were made
DeleteUser.asp • Opens the table and retrieves record • Verifies that the user wants to remove the selected record • Removes the record from the database.