In this section I will discuss a bit more about my ASP.NET work which although started out with VB.NET moved to C# in 2005.
Each of the systems detailed below are generic details as this would be potentially detailing company information.
Commission Management
This system allowed for the entry and management of commission for a sales person based on clients, products and regions. Written in ASP.NET using Telerik controls it allowed users to manage a sales persons clients and products and allow for entering and modifying the percentages of commission earned when sales were made. Commission could alter on a monthly basis and there was a batch Java overnight process that took the commission numbers which then generated commission dollars based on the trades made. This was passed to an OLAP system for slicing and dicing.
Full-Text Document searcher
This was written on the train and evenings and weekends for my employer as I did not have spare time in the office. It was a project for the research department that loaded Word documents in to SQL Server which then built a full-text search of the data. The ASP.NET system allowed users to type in a search, the results were displayed, results could be sorted, and finally a selected document could be downloaded as a PDF.
We had a predictions league on www.rolling-maul.com that was run using Excel. Predictors entered details on the site which was then transposed and some VBA in the background generated a table. It was all very manual and cumbersome so in January 2008 I wrote (evenings and weekends) the above website in ASP.NET using C#. This uses forms authentication and a SQL Server database to hold and manage the predictions, results, tables. Users log in to the site, and predict how many league points a match will generate for each team. Once the matches are played the results are entered, the site then initiates the process of giving users points, building a league table which is then displayed on the site.
I am looking to move this to use jQuery and potentially ASP.NET MVC.
Prototyping - XML
A short project I worked on that took information entered on a web page and built an XML file from it. This was a prototype for a new web based authoring tool.
Prototyping - Production database access authoriser
One of my the areas I believe in is to keep a production database secure and safe. I also realise that there are times that you do need to access production to make a change because of a bug or a problem. However you need to make sure that any changes are approved and better if they are audited. There are some tools around that will record logins and actions taken but that is too late. The change has happened. What I was building was the ability of a recoding the query you want to run to modify the data, check it, store it and then send an email to someone else to authorise the update. Once authorised, a mail would be sent back to the originator who would then be allowed to run the query, all via the tool. The details would be stored separately and so could be viewed at any time by auditors etc. This is an evenings and weekend project that I put on hold. Maybe time to get back to it.....
Rugby fantasy system
This was a system I used to get up to speed with C# and ASP.NET. It was a PURE fantasy system. Players, stats, etc were fictitious and was a rugby derivation of a football fantasy game I used to play called Sick Parrot. The system had no link to real players and so differs from Fantasy League systems that you see in the newspapers etc.