Hotel edit program in VB.Net & SQL Server
virtualICE is a Call Centre system optimised for a particular mobile service worker industry.
The virtualICE system has a hotel table (tblHotel) which represents all Hotels & Motels in the Melbourne area.
Every virtualICE Booking must have an Address - either the Customer's home, or a "Venue" (Hotel). Where it is a venue a room number must be also be supplied.
The existing tblHotel data has been imported from an earlier system and has several flaws: no phone numbers, no number of rooms, and generally out of date.
A program is required to allow virtualICE receptionists to step through the hotel record one by one and check and update the records. This program will be done in two stages. The first stage will simply step through the records in alphabetical order.
The second stage will (a) allow the user to update each record, and (b) add a couple of new fields to tblHotel.
In the attached zip:
(1) viceHotel project (with frmHotelAdmin etc)
(2) A single table SQL Server 2008 R2 database backup file
(3) The T-SQL to create tblHotel (if for some reason you need to)
(4) A Word document on virtualICE logging and error handling
(5) A word document on how to use the virtualICE Data Access Layer dll
What you will need to be able to do this job:
(a) Visual Studio 2010 Professional, SQL Server 2008 R2 Express
(b) Fast internet connection
(c) Ability to code in VB.Net and SQL Server
What needs to be done:
Add sufficient code to the project to enable the following:
(a) On form load load tblHotel into a DB object and display the first (alphabetically) record.
(b) On click of cmdNext display the next record.
(c) On click of cmdBack display the previous record.
(d) If on the first record disable cmdBack.
(e) If on the last record disable cmdNext
(f) Include logging and error handling as per the attached notes
(g) All database access must be via the RobDB data access layer dll.