ASP.NET & SQL One page web app

Group Randomizer Design: The design isn't the most important here but a simple mock-up is included in PPT. The design will be added once functionality is complete. Concept: Build a one-page web app that creates random groups and then emails a file containing the groups to the user. User can specify at least one distribution group that should be evenly placed. Coding Language: ASP.NET using VB, SQL Server 2005 or 2008 or MySQL Use Case: Classroom teacher has a file with over 500 students and needs to randomly assign these students to groups with representation of each grade level within the groups File layout - name or student id, grade, teacher name Scientist/Student/Researcher has to assign control/placebo groups and uploads complete list of names which need to be randomly assigned into two groups with evenly distributed male/female distribution File layout - Subject number, Male/Female Steps: Upload file. (CSV or Text File) Read file. Put file in datatable or temporary table in database Present field names in distribution column drop down list and allow user (optional) to select which field needs to be present in all groups. The groups will evenly distribute this field within all groups. (For instance if groups should have an equal number of males and females...as much as possible, meet this criteria) Ask user for number of groups desired. Ask for email address with terms and conditions agreement which allows us to send advertising. Create groups. Send email to user containing file with groups. Code: upload & parse text/excel file Put data into data table (MYSQL or SQL Server) adding randomizedvalue column and group column (can use dataset versus table if prefered) Count records Divide records by number of groups to get how many in each group Randomize contents first - update record with randomized value in randomizedvalue field Count number of variables in distribution field and then use that as the loop upper bound If parameter chosen go through number of distribution elements and add person to each group Loop through records sorted by randomized value Loop through each distribution field and add to group Next parameter until all are satisfied Last pass evenly distributes who is left that did not have a value in the parameter field If parameters not chosen, count users and put in groups sorted by random update group column with group name (one less loop required) Add email address to marketing database if not already there (insert), if already there, add 1 to iTimesUsed counter, log last dateused, log IP address from which the user requested the file Create csv file Send email to user with file Delete data from table and delete file from system after emailing Table - SQL Server: tblEmail iEmailAddressID (identity field) sEmailaddress (varchar(255) dDateAdded (datetime) iTimesUsed (int) fromIPAddress (string) Finishing Up: After signing off that functionality works, credentials will be provided where the code can be uploaded to production site. Credentials will be provided to ensure connection to database. If prefer to log to live environment, credentials can be provided after project is awarded. Email credentials will be provided to send email once project is awarded.