In Progress

[url removed, login to view] SQL server admin/database job

INTRODUCTION:

I run a website. I have two email-related forms. One form is [url removed, login to view] and the second is [url removed, login to view]

Currently this is how the form works: When someone fills out the [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] in case you need to have it, and also a copy of the [url removed, login to view], [url removed, login to view], and [url removed, login to view], and tellafriend.aspx.cs. I doubt you will need to make any changes to the [url removed, login to view] file. If you do make a change, I need to give me a reason.

I will also give you a copy of my [url removed, login to view] 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: .NET, C# Programming, IIS, SQL

See more: database job , sql get date, server domain, referral key, reason job change, sql create database, messages job, job event, job asp, job admin, want domain transfer, need asp email, develop website easily, develop database access, develop website asp net, get direct referrals, easy domain transfer, develop website second job, dating website format, case net, asp net job site, asp develop website, admin cs, sql server job, sql server admin

About the Employer:
( 5 reviews ) S Ozone Park, United States

Project ID: #1299172

Awarded to:

ehsankayani

HI, I am an expert in this work and you can see on my profile that i recently made a website using asp.net and sql server 2008 so i am perfect for this job. Thank you

$100 USD in 1 day
(32 Reviews)
5.9

17 freelancers are bidding on average $154 for this job

manhpham

I am confident to do this project.Contact me ASAP.

$200 USD in 3 days
(28 Reviews)
4.8
sathyavcs

hello, thanks for the brief explanation. I can make it pretty simple to save all the info in to the DB when the button clicked. Please check PMB for more details.

$80 USD in 5 days
(7 Reviews)
4.4
DERRIC

7 days not more than that.

$100 USD in 7 days
(1 Review)
2.0
ProExpert

Hi Please check PMB

$30 USD in 2 days
(2 Reviews)
1.6
dotnetnaresh

Hi, Surely i would do this for you.We are experts in ASP.Net,C#.Net, ,and SQL Server as well.I understand your project. and I can solve it. Price is bit negotiable. Kindly reply meThanks

$200 USD in 2 days
(0 Reviews)
0.0
RPJINFOTECH

Hi, We have a dedicated and technically sound team, working with 2 MNC's in collaboration. Give us a chance to prove our self. We will surely meet your all expectations. Best Regards, RPJ Infotech Pvt. Ltd.

$200 USD in 7 days
(0 Reviews)
0.0
Piusn

Hello, having read you project description and understood i will be glad to work on ASAP and giving all the functionality.

$180 USD in 3 days
(0 Reviews)
2.8
falgunidoshi

Hi, I am having 8 years of experience in developing and maintaining .NET web applications, windows applications, web services using C#, ADO.NET, SQL Server, XML, XSL, CSS, HTML, Javascript. I have hands on experien More

$250 USD in 2 days
(0 Reviews)
0.0
topcoder133

Hi, I have 5 years experience in asp.net. I can do it.

$100 USD in 2 days
(2 Reviews)
0.0
skynyxtech

I am ready for this task ...

$120 USD in 1 day
(0 Reviews)
0.0
developertima

Hi, I read the requirements and can help you in that. It will take maximum 15 hrs. Thanks!

$200 USD in 1 day
(0 Reviews)
0.0
dotnetexpert86

I have work experience in e-commerce based application, product catalogue and CMS based application, Please check PMB.

$250 USD in 10 days
(0 Reviews)
0.0
markoljpetrovic

ok, this is pretty easy

$150 USD in 2 days
(1 Review)
0.0
arunbera

I am Working Professional with VB.Net,C# and Sql Server Database and also HTML,SP or LINQ to SQL Entity Model,Sms,E-Mail Processing Systems on Web or Windows, So Your Requirement Will Be Full Fill As you want.. Good Da More

$75 USD in 3 days
(0 Reviews)
0.0
vedangsoftware

Hi, We request you to consider our bid, please refer the PM for more details warm regards Team Vedang

$200 USD in 7 days
(0 Reviews)
0.0
aparam28

Hello, My expertise in .NET, C# with any database, so I am very well able to full fill your requirement. I am expecting positive reply from you.

$190 USD in 3 days
(0 Reviews)
0.0
mjguru

Hi, please check your private message for more information.

$100 USD in 2 days
(0 Reviews)
0.0