Stock control management application

Background We have developed computerised vending machines that have the ability to track the quantity of stock it holds, sales and refills of stock. The hardware in each vending machine collects and stores all the stock and transaction information that occoured. Each vending machine is linked to a local network site consisting of approx 20-50 vending machines and a single pc. The pc is permanently connected to the WWW. There are a number of these sites. All hardware - software interface has been done and is available. The project involves the development of two interlinked applications. 1. I require an application which would query computerised vending machines for information related to sale of vending units, stock in the vending machine and refill information from each machine. This software is required to query the vending machine status on a regular basis and enter the information into a sql database. on an hourly basis, the application is required to upload/update the second web based application. (see point 2 below) The application is required to do some reporting functions as well. 2. A web based application is required for monitoring, reporting and backup of information from each site. The web based sql database will be populated by each of the different sites as explained in point 1 above. Development of the web based app should preferably be done in .NET.