We are a custom manufacturer and each of our orders follows the same steps through the production process. I need a web based database application that will allow us to keep track of which steps have been completed, as well as show both the order details and related notes and attachments for each step.
I am attaching a C# application that basically performs what I want, and should serve as a template for the web application.
The screen is basically a grid, with columns for the process steps, and individual orders in the rows. The boxes for each order will either be blank (meaning nothing is done), a check mark (step is completed), or a question mark (further information is needed to proceed). These will all be changed manually, there is no automation of these processes. It is just for us to keep track.
Adding a new order should bring up a window that the user can enter details of the order in. Clicking on each step of an order will bring up a window where the user can choose what mark should appear, as well as a text box to write notes, and buttons to add attachments.
The user will manually mark the order complete, which will move the order to a Completed Orders section. Both active and completed sections should be searchable.
There should be a simple login system and administrative screen to handle users and passwords.
This is a very time sensitive project and I need it working in 2 weeks. Please do not bid if you cannot make this deadline.
Clicking on each step for an order should open a window that allows the user to mark the step either “completed?? or “question mark??, as well as to remove any mark. This window should have buttons that allow the user to attach a file (could be any format), as well as to scan a document in (if possible). The files that are scanned or attached are only available within this window. If possible though, it would be nice to be able to see all attachments and scans in one place, for example, when viewing the order details, but we can discuss this. This window should also have space to write a note.
The steps can be completed in any order, and they do not all have to be completed for an order to be finished, so there is no automation of these steps, it will all be recorded manually.
Once the order is completed, the user will manually mark it as finished, which will then automatically move it from the “Active Orders?? to “Completed Orders??. There should be a way to move an order that has been marked completed back to active, in case there is an error.
Here is the list of column headings:
Cutter File Requested
Cutter File Received
Misc To install the program, run both the ordermanager and database installer. The attached installation program places the application in an Order Manager folder under Program Files. It does not make a shortcut, so you have to navigate there. The config file has to be changed to show the name and location of the database instance (I believe the database installer does this, with a default name of SQLEXPRESS, but you may need to change it for your specific system)
This feature is not absolutely required, but would be good. Please specify in your bid if you include it or not:
The order details will be entered through a form, and these details could then be outputted to a printed contract, such as a PDF (I will supply the template, just a basic contract, after the bid is accepted).