Tool Rental Web Application 9
Associative table for checking out and returning tools. MS SQL stored procedures for writing to multiple tables. RentTool.aspx and ReturnTool.aspx for renting and returning tools, including DateAdd to add three days to the current date. ViewAllRentals for connecting to the new associative table to view a list of active rentals. Editing the ViewAllTools page gridview to hide "No" and "Damaged". ToolsDueToday.aspx to view a list of tools due to be returned today which can be edited to find overdue tools. (SQL query to match date stored in DateDueBack field)
Associative table for checking out and returning tools. MS SQL stored procedures for writing to multiple tables. RentTool.aspx and ReturnTool.aspx for renting and returning tools, including DateAdd to add three days to the current date. ViewAllRentals for connecting to the new associative table to view a list of active rentals. Editing the ViewAllTools page gridview to hide "No" and "Damaged". ToolsDueToday.aspx to view a list of tools due to be returned today which can be edited to find overdue tools. (SQL query to match date stored in DateDueBack field)