ASP.NET Ticket System

Language: ASP.NET (using VB.NET or C#) Database: MySQL It should be a simple ticket system, we'll probably need to add new features in the future but we want to start with something simple for now. Also because it should be less code to manage (we will review your code, because we're searching for a long term working relationship with .NET coders). You have to provide full source code. You will design the database. The ticket system will run on the internet, on a website with a simple and clean interface (you design it, very easy, no images..) because it will be used also from mobile phones. Access level is - Superuser - User The superuser creates users. Each user has - name - surname - email - phone 1 - phone 2 - username - password The superuser does not delete users, he can just remove access (login) rights to users. You design and create the database, that was just some info. Right now users are: call center employees and technical staff. The call center receives the request, creates a new ticket into the web application, then the staff will update tickets until closing it. The user after logging in can view/create/update tickets. The ticket can be unassigned, or assigned to an user. Every user can assign a ticket to another user. Creating a ticket means inserting: - select the customer from a list (if it's a new customer, go to the "new customer page" then go back and select it) - select the assigned user (optional, can be unassigned) - insert ticket title and description - select ticket status (new, open, closed) the ticket has the "created by" information it has also the "assigned to" information, but can actually be unassigned every user can update those informations, title and description excluded title will be fixed, description will be more like a log of what has happened at every ticket change. The ticket can have attachments (by now only PDF is expected, but could be other formats in the future) IT'S IMPORTANT FOR IT TO BE OBJECT ORIENTED CODE, CLEAN, COMMENTED, EASY TO MODIFY. DO NOT MIX TOO MUCH PRESENTATION CODE (ASPX/HTML) WITH BUSINESS CODE (VB.NET OR C#), SO FOR EXAMPLE AVOID SQL QUERIES INSIDE HTML. !IMPORTANT: IT WILL BE TRANSLATED OR MULTILINGUAL, SO CODE USING VARIABLES, CONSTANTS OR FUNCTION CALLS WHEN PRINTING (OUTPUT ON THE SCREEN) TO THE USER SOURCE CODE IS NEEDED. ASP.NET (VB.NET OR C#) AND MYSQL It should be everything, it's a very simple and common application, but I wanted to add as many informations as possible. If you have more questions, please ask!