I have a website that customers order food through. WHen they add food to the order, it populates a Sql Server database. It then displays the order for the customer and they pay for the order. I need a windows application built to run on a server so that when an order is placed it detects it and sends the order to a printer.
The application you build must do the following:
1. When the program starts, it should prompt the user to select the printer to send orders.
2. Run on a timer to check for ordres.
3. Use a database query that I provide to determine if an order exists. (exmple: Select * from orders where O_Complete=1 and O_Paid=1 and Client_ID = 1, and store_id = 1 and O_printed=0).
4. If an order does exist, send the details of that order to a printer that is selected at startup of the application.
(I will provide exact details of print job, but will contain, name, date, items and total for the order)
5. The information will be printed to a receipt printer running a Generic Text driver.
6. After the print job is sent, it should update the database using an update query to change the O_Printed field to 1 so it doesn't show up again and get printed twice.
7. The main screen of the program should have a grid displaying a list of orders that were received for that day. It should update automatically when the timer is executed (Every 60 seconds).
8. There should be a right mouse click ability to "Re-print" an order. When this is selected it should update the database field O_printed back to 0 and run the timer event so that the order is reprinted.
That's it. Very simple databse program and printing is just to text driver.
I need this started right away and you must be able to complete quickly.
Let me know what you will program in and what is needed on the server.
Hi,
Recently I write an application in VB.Net for the Printer Q Monitoring. It is for a paperless printing.
The project is intended for the retail stores.
Below is my understanding about your requirements.
a) You need a windows application that is deployed on the server - I assume Windows 7 or Windows 2008 R2.
b) The application should monitor the Orders for the selected printer at the application start-up.
c) If Order received than don't print the receipt else print the text receipt.
d) The application main screen should have a table showing number of orders received and updated every 60 seconds.
e) The order should be reprinted if selected from the order table.
Please verify the understanding and do your inputs as well.
Looking forward for the positive response and longer association with you.
Thanks & Regards,
Hey There,
I can develop this for you very quickly.
I will need .NET framework on your server. What database do you have? MySql?
Awaiting your response. Thanks.