Skip to content

Latest commit

 

History

History
32 lines (26 loc) · 1.41 KB

README.md

File metadata and controls

32 lines (26 loc) · 1.41 KB
Raw

Arthur's Seat Ski Hire

An equipment rental management system

Includes:

  • Manage Customer Details
  • Manage Equipment Stocks
  • Create leases
  • Store records of all previous leases

Summary:

The website is has been programmed using Ruby and PSQL for databasing. The web application framework, Sinatra, has been employed to run the website in the browser.

Screenshots:

home page

Customer Details

Equipment Details 1 Equipment Details 2

Create lease 1 Create lease 2

Current and Ended Leases

Features

  • The database is protected against SQL injection by using prepared statements.
  • For each requested lease the stock availability is checked within the proposed date range. The process counts the number of items leased for each proposed date and focuses on the maximum number leased over the range, if this is equal to the total stock, then that item cannot be leased in this date range.
  • On an ended lease, all of the data is copied to a 'records' table, such that the dependencies on the Equipment and Customer SQL tables are severed and the information can be changed without altering the recorded lease details.