Your module receives prepared billing rows of a Hotel-booking case from a SQL Server 2005.
These rows contain date, departmentname and/or ID and name of participant, description of service, number, amount1, amount2=number*amount1, three tax amounts (for 0,10 and 20 percent).
These rows have to be written in the bill.
You also receive the booking-ID(bid), the customer billing address and a parameter, which defines where subtotals of the rows should be sumed up and written:
0..no subtotals
1..one subtotal for each department (the rows are ordered the right way of course)
2..one subtotal for each participant
At the end there is always a total sum to be written.
There are three tax-rates, so each sub total and the total sum has to write also these tax-amounts. All amounts are rounded to two digits.
After the rows are loaded, the user has the opportunity to add, change and remove rows as he wish. The total sums are reflecting these changes every time the user has changed a row.
Finally, after the user has finished his changes, he saves the data-rows in the database in a seperat table as a version of the bill (versionname by timestamp and user, versionID by auto identity field).
If there are already versions of this bill, the user can - at the beginning of the program - decide whether to load a new bill or to open an existing version of this bill. By clicking a checkbox the user can always make one - but only one! - version the only valid version of this bill. By clicking a button, the user can print out the bill.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
The code should be written in ASP.NET in Visual Basic.
C# would also be accepted.
Our programming environment: Visual Studio 2005
Server: Windows Server 2003, IIS 6
Database: SQL Server 2005
Client: IE 6 and above, client-scripts in vbscript are possible