Geeks With Blogs


Steve Clements .Net and then some....

I mentioned a while back that I had something I was working on that involved a change in language, actually a pretty radical change. I have been working on vocational project written in and made heavy use of LINQ to SQL. I wasn't sure of LINQ to SQL for anything else other than RAD and to be honest I'm still not. Anyway, I'm not getting into that debate. Needless to say I went all the way and don't use a single sproc in this project.

Some of you will know I play cricket every Saturday for a local club (nothing special, just for fun!), well for a couple of years I have been thinking of putting a website together for the club, just never got round to it. However the other day I was looking at the starter kits on the website and came across The ClubSite v2.0, also hosted on codeplex, basically this is built on top of the original ClubSite, it adds functionality and has layered the code. Problem is, its American and the statistics part of the site relates in no way to cricket, which is a pretty statistics intensive sport.

I decided to write the cricket stats engine (that sounds fancy!), and take the opportunity to write some real code in and LINQ to SQL. I have pretty much completed this project on my train journey to and from work, which is about 40 mins each way. Working on it not every day, but most for the past month.

The original ClubSite makes use of submodal for its AJAX functionality and some modal popups, I am not really a fan of these and found them to work erratically so have replaced a few and plan to do the rest, using the AJAX control toolkit modal popup. I have also added update panels to make the UI some what slicker! I code is in no way of a work of art, that's not really been the point of the exercise.

I haven't finished the project, apart from very limited testing, I plan on using silverlight (to tick another "must learn more about" box) to create some pie charts etc to better represent the data. I have actually found some open source examples i intend to download soon.

I appreciate that cricket is a pretty captive audience and cricket playing geeks are no doubt even less, but hopefully I will get some downloads and help if finding bugs and enhancing the project. I have actually only found 1 other site that does cricket statistics and that is a national site and every club has a sub-site within the main site. Far to restrictive for my liking.

Go and check the project out here: Cricket Club Starter Kit

It's also worth mentioning that I haven't changed any of the original ClubSite v2.0 code, I have simply added on to it, mainly because I don't to miss out on anything that gets released/fixed with that project. Apart from perhaps a link of two in the menu to point to my new CricketStats folder and the graphic from a football (soccer ball) to a cricket related image. I haven't even fixed bugs that I have come across, that isn't the point of this project. On Codeplex I have checked all the code in, including scripts to create the schema in the db, but not all my test data (yet). I'm not sure if this is the best way to go about it, it might be better to simply check in the new code and some scripts to incorporate it in into the clubsite v2.0. That might over complicate the whole development process though.

A Few screen shots to give you a flavour!

Games in season overview - (Default.aspx)


Game Statistics


Team Statistics for the season


Player Statistics by season






Posted on Monday, June 23, 2008 7:25 AM .NET 3.5 , Personal , | Back to top

Comments on this post: Cricket Club Starter Kit CodePlex project

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
Cricket!? Why'd you want to play a game like that?
What's wrong with baseball? Too American....just kidding. Hey I installed this and tried to get it going - no luck. I added the subsonic and clubstarter dll's, since you still had references to them. Is there something I might be missing? Help get me set up and I can do some testing for you.

Thanks, Abner Doubleday
Left by Rick on Aug 28, 2008 2:24 AM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
I got it going
Left by Rick on Aug 28, 2008 3:04 AM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
Hey Rick,
Although it doesn't surprise me as I didn't put much work into cleaning it up etc etc...I'd be interested to know why it wasnt working.

As for Cricket, great game. Tactics and skill beyond baseball, baseball has two shots, hit hard, hit soft!!! Saying that, baseball would prob be my sport if I lived on that side of the pond!!
Left by Steve Clements on Aug 28, 2008 7:26 AM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...

I too grabbed a club starter kit with the emphasis on changing it to suit cricket. Our association has started using excel spreadsheets for results, so I added some google docs code to datamine the results.

Anyway very interested in what you are doing and will prob. grab your database code re cricket games and scoring. Have some google earth/silverlight stuff to add wagon wheel scoring and other stuff to the site.

Used the devcow version of the club starter kit coz I'm more of a c#er than a vb man. Vb is a beer. Anyhow check out where I'm getting. Stayed back with ASP.NET 2, ajaxed up the site, put in css friendly adapters for asp:menu to make google chrome and IE8 a bit happier.

Been out for a couple of ales so I'm waffling.. anyway check out site at http;//
Left by batfinger on Oct 17, 2008 12:58 PM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
Hi Steve

I had been using the clubstarterkit for a while now and had done a few tweaks for cricket but have decided to use your changes as much more complete. I seem to have all working except for the membership page, I get a onbject null ref error failing on MemberCountByLetter.

Any ideas?


Left by Mike Weston on May 05, 2009 1:44 PM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
Hello Steve i couldnt download the project and check can u tell me how to download and from where i have to download i m waiting for ur reply at the earliest
Left by karthikeyan on May 28, 2009 3:44 AM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
I am getting the following exception when i try to go to the CricketStats page. http://localhost:55181/CricketStats/default.aspx
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'cricket.Seasons'.

Source Error:

Line 217: Where s.SeasonStart < DateTime.Now AndAlso s.SeasonEnd > DateTime.Now _
Line 218: Select s
Line 219: If season.Count = 1 Then
Line 220: Dim s = season.Single()
Line 221: Current.Session.Item(WebSettings.Columns.CurrentSeason) = s.SeasonId

Left by Raju on Jun 04, 2009 4:25 PM

# Nice One
Requesting Gravatar...

I've never even thought about commenting till now. I guess if I really like a post I find myself checking the external links for more and favoriting (if that is a word) the post instead.From now on though I'll definitely try and drop a comment every so often.

Thank You
Left by Nepalese Kukri on Jul 06, 2010 12:09 AM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
Good and different post. usually we used to see technical projects. this time its slight difference that game project. Good effort and it works well too.
Left by Tania on Dec 21, 2010 11:41 PM

# re: Cricket Club Starter Kit CodePlex project
Requesting Gravatar...
Hi, I would love to use this starter kit. Is there any where I can download it?

Left by Tommy Ittu on May 11, 2011 7:00 PM

Your comment:
 (will show your gravatar)

Copyright © Steve Clements | Powered by: