Capture data from a file to output to another file
$30-100 USD
Completed
Posted almost 13 years ago
$30-100 USD
Paid on delivery
From a file containing the room number and other details we would like to take a look at the room number and see if there is a guest . Some rooms have multiple beds. But it should count only the beds from the look up table in the database.
## Deliverables
From a file containing the room number and other details we would like to take a look at the room number and see if there is a guest . Some rooms have multiple beds. But it should count only the beds from the look up table in the database. From the look up table find out if it is a BASIC EXEC or PREMIUM category and create a file which contains information about the occupied and available beds in BASIC EXEC or PREMIUM CATEEGORY
Attached is the example file. Assuming the lookup table contains only 609-1 , 610-1, 610-2 and 611-1 for basic category. Since only 610-1 is available the output file will have a line basic, occupied 3, available 1
.
Need the sorce code. Can develop in vb.net or C# with access database or sql express backend