ASP.net SQL server admin/database job

IN PROGRESS
Bids
18
Avg Bid (USD)
$151
Project Budget (USD)
$30 - $250

Project Description:
INTRODUCTION:

I run a website. I have two email-related forms. One form is www.domain.com/contact.aspx and the second is www.domain.com/tellafriend.aspx.

Currently this is how the form works: When someone fills out the contact.aspx form a message is sent from a noreply email to a specific email address that we get messages to. I get an email with the user's message, for example:
Name: , Email: Topic: Event Inquiry, Message: SampleCommentMessage

When someone uses the form on www.domain.com/tellafriend.aspx I get a message from a noreply email to our email address. The message says for example:

Someone has referred a friend on NY Minute Dating.

Referred By:
Name:
Email:
Message:

Referred To:
Email:

--------------------------------------------
THE PROBLEM

While I get an email message of the message that is sent to us through the contact form, and I get an email when someone refers a friend to the site, the problem is that none of these messages are saved to our database in anyway.

--------------------------------------------
SOLUTION

I want to create two new pages on the admin panel. One will be called Messages and the other Friend Referrals.

--------------------------------------------

MESSAGES page
When someone submits a message through the Contact.aspx page, the message will appear on the Messages pages in the admin. The columns will be:

Date, Name, Email address, Message.

You will create a table in the database called Messages with the tables:

Date, Name, EmailAddress, Message

The date format will be like this: Wednesday, November 23, 2011 7:00 PM End: 11:00 PM - this is how the date appears on the current pages of my admin panel.

--------------------------------------------

Friend Referral page
When someone submits a message through the TellaFriend.aspx form, a row will appear in the Friend Referral page with the following columns:

Date, Referred by, Email, Friend's Email

You will create a database table called ReferredBy with the following columns:

Date, ReferredBy, ReferredByEmail, ReferredToEmail, CommentForRefer

--------------------------------------------
It may be a good idea for each entry on each database table to have a unique key so it can be easy to develop further more easily in future.

--------------------------------------------
I want to continue receiving email messages any time someone submits through the contact form or tell-a-friend form.

--------------------------------------------

I will give you a blank copy of my current database and a copy of my EmailHelper.cs in case you need to have it, and also a copy of the contact.aspx, contact.aspx.cs, and tellafriend.aspx, and tellafriend.aspx.cs. I doubt you will need to make any changes to the EmailHelper.cs file. If you do make a change, I need to give me a reason.
I will also give you a copy of my default.aspx page for my admin. Hopefully this is all you need in order to complete the job.

--------------------------------------------

I will not give you direct access to my server or database. Instead, you will complete the work on your end, and then install on my computer via remote desktop. You will need to know how to run queries and other such things in order to create the table, etc. You will transfer to me updated files via Skype and I will place files on correct folder.

I need someone very capable who can complete the project in less than 2 days.

Skills required:
.NET, C# Programming, IIS, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 1 days
$ 200
in 3 days
Hire sathyavcs
$ 80
in 5 days
$ 100
in 7 days
Hire ProExpert
$ 30
in 2 days
Hire topcoder133
$ 100
in 2 days
Hire falgunidoshi
$ 250
in 2 days
Hire Piusn
$ 180
in 3 days
Hire RPJINFOTECH
$ 200
in 7 days
Hire mjguru
$ 100
in 2 days