The worst web development project is a project you inherit from someone else. There are some things I don’t do in any of my ASP.NET projects one of them being automatic editing provided by the GridView, I prefer to be more in control and usually build a popup or something.
Recently I took over a project from a developer that loved in-row editing and when I had to add new screens I decided to use the same format to keep consistency.
Not knowing (out of preference) about all the pitfalls I got a bug when you initiate the update. The GridView is linked to a SqlDataSource with an UpdateCommand pointing to a stored procedure. When the user click on the Update button I added in a template field I get an error saying: “Procedure or function myProcedureName has too many arguments specified.”
After a few hours of poking around on the web I finally got an answer. My template fields contained fields that are not updated in the stored procedure. For the fields that were not supposed to be updated, I also used the Bind function as opposed to Eval. I changed the Binding in the EditItemTemplate from Bind(”SomeDatafield”) to Eval(”SomeDataField”) and it solved the problem.
In an effort to improve service quality to customers I decided to setup a helpdesk website where clients could log tickets, get a ticket number and follow the progress on a ticket. To my surprise I found very few solutions that actually worked the way I wanted. I don’t need complicated support structures and I definitely don’t want to send my customers on training to use our support system. Most free open source helpdesk systems on the other hand were too basic and didn’t give me the control and functionality I needed. So, after some careful consideration we decided to develop our own system.
With the product now finished and working for us I decided to share some information for other companies that may also be in need of a powerful but simple helpdesk solution.
Our version 1.0 product currently features:
· Multiple customers
· Multiple products per customer
· Automatic ticket numbers
· Email status updates to parties involved in a ticket
· Unlimited comments with date stamps on tickets
· File attachments to tickets
· SMS notifications to the support personnel when a ticket is logged
· Dashboard for easy administration
Helpdesk Dashboard Interface
Helpdesk Ticket Creation
Helpdesk User & Company Management
Since we own the source code it’s easy for us to add any additional functionality and customize it to specific needs.
For an online demonstration click here. (Log in with “admin” as the email/login and “admin” for the password)
Companies interested in this solution please contact Erhard Smit on 083 656 4309 or via email.
