Suljettu

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 [url removed, login to view] + tax + reservation fee) AND the deposit amount (30% of total cost + $[url removed, login to view] fee). Rate for Cost (6 or more nights) = weekly rate + number of guests over 4 x [url removed, login to view] + 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 + $[url removed, login to view] 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: $[url removed, login to view] (weekly rate)

Guest charges: $[url removed, login to view] (number of guests over 4 x $[url removed, login to view])

Tax: $[url removed, login to view]

Reservation fee: $[url removed, login to view]

Total: $[url removed, login to view]

Deposit: $[url removed, login to view] (amount charged to your card today)

Balance: $[url removed, login to view] (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

Taidot: .NET, SQL

Näytä lisää: sql calendar reserve, access mls, x rates, used cleaning home, transaction charges, schedule api, rental auto, range query, one dollar site, ms lookup, html spreadsheet example, dollar days, customer support cost, calculate availability, auto rental rates, asp net quotes, access vendor database, auto rental, net ria, freelancer sql erver, windows admin sql, online shopping project download, number icons png, verify tax, verify credit card number

About the Employer:
( 0 reviews ) Atlanta, United States

Projektin tunnus: #465437

60 freelanceria on tarjonnut keskimäärin 511 $ tähän työhön

yousefla

Hi, More info is in the PM. Thanks,

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

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ä
(39 arvostelua)
6.9
AnisInfoTech

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ä
(41 arvostelua)
6.9
ITservice

Hi, Pls. check PMB. Thanks

450 $ USD 15 päivässä
(36 arvostelua)
6.3
lsweb

Hello. Please check your PM. Thanks.

500 $ USD 21 päivässä
(19 arvostelua)
6.2
shmai

have a glance at PM. Regards,

486 $ USD 12 päivässä
(52 arvostelua)
6.2
XpertzDotNet

I`ll do it..,

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

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

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

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)
4.8
YashpalSingh123

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)
4.8
Rautella

can be done. lets start:)

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

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)
4.4
Ravilochna

Please check my PM.

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

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)
3.1
webchilly

please check pmb

459 $ USD 10 päivässä
(1 arvostelu)
3.0
sriv151

please see pm

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

Hello, Please check Pmb for details. Regards, Punit

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

Hi, I am very happy to bid this project. I have 5.5 years experience in ASP and ASP.net 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)
2.0
achive9696

I can do anything with ASP.

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

Dear sir, Pls check PMB Ready

400 $ USD 2 päivässä
(1 arvostelu)
0.0