Find Jobs
Hire Freelancers

ASP.NET & SQL One page web app

$30-250 USD

Completed
Posted about 10 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 5520346

About the project

8 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have questionsIn regarding your requirements: 1. When display the option to evenly distribute, does the page need to rule out option like "student name, id" etc...? If yes, what field will be rule out? 2. In the file layout of Scientist/Student/Researcher do we have a column Name or Student ID? 3. Do we distribute only in one field or can be 2 or more (i.e. distribute evenly male/female and subject number?) Regards,
$150 USD in 3 days
4.8 (12 reviews)
5.5
5.5
8 freelancers are bidding on average $185 USD for this job
User Avatar
Hello, I am very much interested to do this work by ms sql server 2008 with asp.net & vb.net as i am experienced a lot with these. I think i can do your work efficiently. Looking forward to have a positive response from you. Thans
$130 USD in 7 days
4.9 (282 reviews)
7.5
7.5
User Avatar
Hi, I am experienced .net developer. I can work on this project in .net VB (vs 2010) and MS SQL server 2012 ( can generate script which will run on 2005/2008) Thanks
$177 USD in 5 days
4.7 (9 reviews)
3.4
3.4
User Avatar
Hello, Based on the looks of it you, i started thinking that most likely you would not need this anymore. However, I could do such a task if I was there at the right time :) Wishing you a great day, Oskars
$133 USD in 1 day
5.0 (4 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$177 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cincinnati, United States
5.0
3
Payment method verified
Member since Aug 12, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.