Virtual/Adhoc Teams

I’m a fan of virtual teams, times when you pull together people from across many teams to form a team that is focused on a goal. Sometimes they are dedicated to the effort, a lot of times they aren’t – depends on the amount of work needed and all the other competing priorities. Time isn’t […]

Voting Theory

I was enjoyed the Sunday newspaper (on Sunday!) and ran across this column about various voting systems and that made me curious enough to dig a little more, starting with this article. There is a definite distinction between the system (often based on a math proof) and the implementation of the actual voting. Makes sense […]

Building a PASS Voting Solution – Part 6

Today we’ll try to finish up by looking at a couple of the semi-interesting parts of the code in this one page application. We’ll start with the page load event. On the first run of the page (not postback) I’m grabbing the two keys I need if they exist and calling the MyBallot.Validate method (show […]

Building a PASS Voting Solution – Part 5

Today we move over to the web side of things. I put this together with VS 2010, and it’s a single aspx page with a single class and a user control. I’m using DevExpress controls (they provide me with a free subscription, good stuff). Here’s the normal view that a voter will see if they’ve […]

Building a PASS Voting Solution – Part 4

We’re almost at the end of the SQL side of things, just needing to send out notifications/reminders. I was torn here, I already had a proc to send a link to a single user, but using it here would mean a loop. Even if it was slow it wouldn’t matter, we do a handful of […]

Building a PASS Voting Solution – Part 3

Today we’ll look at the server side code portion of the solution. I’m definitely in favor of stored procs, so that’s what you’ll see here. I typically only handle errors within a proc if I have the ability to do something there to fix the problem, otherwise I raise them back to the application. I […]

Building a PASS Voting Solution – Part 2

Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should be interesting to see how I fare with you all:-) Here are the tables I ended up with: As you might guess Ballot holds the overall description of what is being voted on, BallotDetail […]

Building a PASS Voting Solution – Part 1

Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst solution – easy to use, low cost, no real testing to do. But in practice it caused some pain. Quite a few emails to voters were lost to spam filters and we didn’t have a […]

SQLAndy

Virtual Teams