The idea behind the application is to spot any differences in the production schedule and notify the selected users about them. Each ‘user’ can have their own profile so that they can select what changes and when they want to be notified about. Being more specific, the users can decide to catch the changes in a certain factory, to include pre-orders or remakes. They can also select to look for change in the delivery date, production date, frames quantity, batch ID, colour of the products, price or if the order changed from or to glazed or unglazed. Furthermore, the user can specify how far ahead the program should look for changes, and if the check should be performed at certain times of the day or every X minutes / hours / days. Finally, the user can also select if the notification email should have an XML or Excel files attached.

The program allows the company to react to any sudden changes in the orders that the employees are not aware of. The notification about selected differences helps the appropriate employees react within their field of work, for example, replanning the work force needed, ordering material or spotting any unusual behaviour within the operating software. Furthermore, the program is also capable of catching any deleted orders. This is especially important to catch any orders that might have been deleted by mistake.

The application connects to the SQL server and saves orders’ details for each user in separate XML documents. When the user’s check is executed, the new orders’ details are gathered and compared against the values stored in the saved XML document. If any changes are noticed, the user is notified by email about the relevant changes.

Technologies used:
Visual Studio, C#, WinForms, SQL, XML, Microsoft Office 2013 Primary Interop Assemblies