Reservation Functions
$30-80 USD
Paid on delivery
I'm adding several functions: These function will work with two seperate SQL Sever Tables. availablility - This table lists check_in dates and check_out dates for a specific property. These dates show when the property is NO longer available. known_avail - This table lists check_in dates and check_out dates for a specific property when it is known to be available. FUNCTIONS 1. I need a function that will add a range to a SQL Server table that says when a property IS available. This function will all check a different SQL Server table to make sure that the property has NOT been entered in the reserved table. 2. The second function will add a range to a table as to when a cabin is NOT available. This function will need to check and remove entries into known_avail that says the cabin is available. It will need to modify the known_available table if the dates do not 100% overlap. NOTES > Dates that are not reported available in the known availablility table are to be assumed unknown. > Dates that are reported available in the known availability table are to be assumed available. > Dates that are listed in the availability table are assumed not available. > Dates that are not listed in availability are to be assumed unknown.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows 2000 Server
Project ID: #2897154
About the project
8 freelancers are bidding on average $41 for this job
