Sql / ASP

Looking for quotes for a small SQL database with ASP query and admin functionality.

1. SQL.

a) db will contain vacation rental home data: house name, unique id, calendar availability, rate data (nightly and weekly costs).

b) Phase II of project will add cleaning date at end of client stay, maintenance block dates, etc (phase II is NOT budgeted currently).

2. Calendar Page or Pages (ASP).

a) Query db(on page load) and create a calendar page illustrating either individual vacation rental home calendar or one page listing all vacation homes with respective availability dates (like a spreadsheet view - flexible on this requirement as to whether to use a single page or individual pages for each vacation home)

3. Reservation form (ASP).

a) Based on home selected and date range (less than 6 nights would be nightly rate, 6 or greater nights would be weekly rate) sql query would populate a calculable rate field (dollar amount) on the Reservation page.

b) Flexible on phase I requirement: Could use a single rate or lookup actual rates (based on selected dates) to calculate the total cost.

c) Rate is based on either a nightly rate (less than 6 nights in date range) or a weekly rate (6 nights or greater in date range). Rate for Cost (less than 6 nights) = nightly rate x number of nights + number of guests over 4 x 10.00/night + tax + reservation fee) AND the deposit amount (30% of total cost + $55.00 fee). Rate for Cost (6 or more nights) = weekly rate + number of guests over 4 x 10.00/night + tax + reservation fee).

d) The deposit amount is illustrated BELOW the TOTAL cost from above. It is calculated as 30% of total rate with taxes + $55.00 fee).

e) We currently have a Reservation form which uses CDONTS to send Reservation form data via email. This same form will be edited to include this new functionality. The newly edited page will send (CDONTS) new data as well as "RESPOND" via a "THANK YOU" page to the client the total amount to be charged and the respective deposit amount mentioned above.

d) NONE of the calculable data is stored in the db - that would be a phase II project.

e) Phase II would include CALLING an API (provided by credit card gateway) to run credit card transaction for DEPOSIT amount specified above.

Example (needs to be in a table format for readability - not like below). $ Amounts should be right justified. This information would be BELOW the information provided by the client. The client should be able to MODIFY entered data (above this area) using the same fields originally used (change dates, cabin selected, etc.)

Cabin Selected: Amazing Grace

Date: 7/1/2009 - 7/8/2009 (7 nights)

Rate: $2100.00 (weekly rate)

Guest charges: $140.00 (number of guests over 4 x $10.00/night)

Tax: $224.00

Reservation fee: $55.00

Total: $2519.00

Deposit: $794.00 (amount charged to your card today)

Balance: $1725.00 (charged to your card 15 days prior to arrival)

4. Admin page, vacation homes (ASP).

a) Create, edit, and delete vacation home data: cabin name, unique ID (auto generated), address, rate schedule (5 seasons each have a nightly rate and weekly rate which varies per vacation home). b) Rates vary based on the calendar day. Would like to be able to select dates to edit rates based on a "CALENDAR VIEW". Select individual days, week, weekend, or entire month if possible.

b) Page needs password protection

5. Calendar page (ASP).

a) Reserve and Un-Reserve dates for respective vacation homes. Would like to be able to change the status of dates (reserve, block, open) based on a "CALENDAR VIEW". Select individual days, week, weekend, entire month through a CALENDAR view as well as specify by entering arrival/departure dates in respective fields.

b) Phase II - data in this table would be populated by Reservation form, but Admin functionality through an "admin" page would still be required.

C) Page needs password protection.

*** Notes ***

1) Site is currently ASP. Would consider .Net if needed for this functionality. If switching to .Net we would provide current asp and html pages for inclusion in build process.

2) Load script. Require a script to create db with sp's (need to verify with Godaddy hosting to determine access rights first).

3) Backup script. Require a script to backup data (need to verify with Godaddy hosting to determine access rights first).

4) Site is hosted by Godaddy with ability to support 1 MS Sql db

5) Phase II (not currently budgeted) will include customer and vendor data along with a number of respective reports

Extended the bidding for 30 days. Several bids through PM have misunderstood the project. I am developing mockup pages with visual descriptions to clarify the project (thoroughly I hope). I hope to have these mockup pages done within 7-10 days. Afterwhich you are welcome to adjust your bid, ask questions, etc.

Also, the project will need to be coded in .Net using MS-Sql.

Taidot: .NET, SQL

Näytä lisää: sql calendar reserve, access mls, x rates, vendor database ms access, used for cleaning home, transaction charges, thank you notes, schedule api, rental auto, range query, one dollar site, ms lookup, html spreadsheet example, html form to spreadsheet, dollar days, customer support cost, cleaning a house, calculate availability, auto rental rates, auto rental, asp net quotes, access vendor database, a 1 auto rental, 5 dollar site, need create page edits sql information asp

Tietoa työnantajasta:
( 0 arvostelua ) Atlanta, United States

Projektin tunnus: #465437

59 freelanceria on tarjonnut keskimäärin 512 $ tähän työhön


Hi, More info is in the PM. Thanks,

750 $ USD 8 päivässä
(64 arvostelua)

Hello, Your work description is very clear and I loved to work on this project. Having total 8 year development experience with ASP so can easily modify your current site and add this new functionality. I also Lisää

500 $ USD 7 päivässä
(54 arvostelua)

Hi, Pls. check PMB. Thanks

450 $ USD 15 päivässä
(89 arvostelua)

We are expert in doing this sort of stuff... No upfront needed, all payments through GAF escrow.. Can start right away.. Thanks

600 $ USD 14 päivässä
(42 arvostelua)

I`ll do it..,

600 $ USD 25 päivässä
(25 arvostelua)

have a glance at PM. Regards,

486 $ USD 12 päivässä
(53 arvostelua)

Hello, Please check PMB for details. Regards, New Horizons India Ltd.

600 $ USD 30 päivässä
(9 arvostelua)

I am an IT professional with 10 yrs of experience. I have very good experience with ASP, SQL Server, ASP.Net. I will provide quick & professional service.

500 $ USD 21 päivässä
(18 arvostelua)

can be done. lets start:)

740 $ USD 5 päivässä
(21 arvostelua)

Hello, Expert Computer Engineer, Having Experience with ASP.net3.5 And Sql2005 Can Start Work on Immediately effect. Thanx

550 $ USD 7 päivässä
(9 arvostelua)

Hello Sir, I have an working experiance of 10+ yr with Microsoft Technologies like Asp.Net, Sql Server 2005, Sql Server 2000 including Ajax, javascript,photoshop,flash etc. Please check your pm

350 $ USD 10 päivässä
(7 arvostelua)

Please check my PM.

500 $ USD 10 päivässä
(5 arvostelua)

Hi, we can do this project. We have 15+ years of coding experience. ASP/Jscript/PHP websites, VB/VB.Net/ActiveX desktop apps. Database experts also, bearing years of knowledge and experience in the field. Please see PM Lisää

490 $ USD 15 päivässä
(2 arvostelua)

please see pm

550 $ USD 25 päivässä
(3 arvostelua)

Hello, Please check Pmb for details. Regards, Punit

750 $ USD 25 päivässä
(1 arvostelu)

Hi, I am very happy to bid this project. I have 5.5 years experience in ASP and with SQL in different domains. I will work full time and complete with in the time frame. I am looking forward from you.. Tha Lisää

550 $ USD 12 päivässä
(1 arvostelu)

I can do anything with ASP.

550 $ USD 7 päivässä
(1 arvostelu)

Greetings! I was worked in GE as Project Lead I am interested on your work I fallow six sigma rules while coding for performance and other issues. Please see PMB

360 $ USD 20 päivässä
(0 arvostelua)

Have 6 + years of experiance in asp and sql and looking for freelance work

260 $ USD 15 päivässä
(0 arvostelua)

Please check PM for bid details. regards, -Kshitij.

550 $ USD 25 päivässä
(0 arvostelua)