210 likes | 307 Views
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
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.