SQL Server

Application is an electronic song book that will be used at Karaoke shows. Users can browse and search the selection of songs (by artist or title). Once a desired song is found, they can enter their name and signup to sing that song. The application will send an email to a specified EMail address to perform the signup.
This must be developed in ASP.NET connecting to existing MS SQL database.
Detailed Requirements:
Different venues will connect to this application from various types hardware. This application must be able to detect and configure itself for properly display on either mobile devices (tablet computer, e.g. HP WebOS or Android) or desktop device (standard windows PC or laptop)
Data exists on an existing SQL SERVER database.
Pages:
1. Initial page allows employee to select which venue location they are located at. Venues are stored in a table in the database. Drop a cookie to remember this for later (will be needed later when user selects a song so that the correct email address can be used).
2. "home screen" page. Should consist of a rotating background image that will rotate between various images stored in a database table for the specified venue. In this way, each venue can have a series of rotating images welcoming customers to their venue, promoting sales or special events, etc. All specific (and different) for the selected venue. Clicking anywhere on the image proceeds to next page. Note that all subsequent pages in the application will have a timeout that will return to this home screen after "x" minutes of inactivity.
3. Search page. Allow search for entered text. Search will be for both artist and title. So search for "RIVER" will match artists such as "JOHNNY RIVERS" as well as titles such as "RIVER OF LOVE". This page also has the English alphabet laid out as buttons. Clicking a button will browse for songs starting with that letter. User must specify if browsing by artist or title. Either function will proceed to search results page.
4. Search results page: Display search results from table in database. Limit results to "x' number per page - with next/previous/first/last buttons. A NEW SEARCH button to return to signup page. Each row will have a "signup" button to allow the user to select that song for signup (go to signup page).
5. Signup page: Allow user to to enter their name and submit the song via email. EMail address will be based on the selected venue. Email body will contain user's name, song title and artist.
Worker: On pay-for-deliverable
projects, all deliverables must be
uploaded to
vWorker.com before the
deadline(s)Â…with no exceptions. If
this contract makes it impossible
to do this (for example if it is
for a service that cannot be
uploaded), then do not start
this project. Otherwise, you
may find
yourself unprotected by the
payment guarantee.
Instead, ask the employer
to switch this project to
pay-for-time, so you are
guaranteed payment. If the
employer will not switch this, then
please alert us.
(Click here for more details...)

Example of unprotected/un-guaranteed work:
Imagine that this project is to
install something on the employers
website.
You do the work but upload nothing
to vWorker.com (because it takes too
long,
or you cannot). As long as there is
no dispute, you will not notice the
potential problem. But if the
employer disputes what you did then
we must make sure you delivered to the
triple-point-guarantee (100% to-contract: and
done in the industry exepcted manner, and
by the deadline). If the employer
does not allow us access to their
website, or accidentally/deliberately
changes the work you did on their
website, when we go to test it, we
will see that it does not work.
Then you would have no proof that
you delivered the final deliverables,
lose the arbitration, the escrowed
funds and receive a poor rating
(which will say “testing showed
the final deliverables did not
work”).
So for this reason,
you should have instead followed
the above instructions and
switched it to pay-for-time.
Had you done this, we would simply
have checked the Accutimcard to
make sure you punched-in the time
and were working on it. You would
have been paid for every hour
you worked.

Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.

Categories:

The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.

Like everything else on this page, these categories are part of the original contract
for this project.

Web development, User interface (UI) programming, Database, SQL Server, Other (Web development), XML / XHTML, Technology, Web programming, Other (web programming), Software Development, Other (Software development), Tech details
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract.
2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer).
2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

I would like to do the upgrade of data (SQL) of Nopcommerce from version 1.9 to 2.3.Steps:Writing scripts to import data. (must be delivered)Importing data from old database to the new version 2.3General control of the data and front end.Weekly maintenance
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?Software related (Includes desktop applications and internet websites)
Project Parts:
What do you want the worker to do on this project?

Requirements:
The worker will analyze the problem and propose a software-based solution to the problem.
Programming:
The worker will take the requirements and translate them into the language of the computer (and test it).
User installation:
The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:
What kind of documentation do you want for this project?Informal documentation - As the employer talks back and forth about the project with the worker, those conversations become the requirements.Remember to communicate ALL of the details of your project on the vWorker.com site. If you don't, and there is a dispute, then important details of the contract will not be documented and cannot be taken into account in arbitration. If you feel you MUST go offsite (for example, using the phone or IM) then afterwards post everything onsite and get the other party to post that they agree to those contractual terms.
Program Type:
What kind of software should the worker create (and/or install)?An internet web-site: This software runs on a web server and users will access it using their internet browser.A desktop or server program: This software runs on a user's own PC/workstation, or on a server.Other:SQL scripts
Internet web-site info

Design and functionality:
What does the programming of this project involve?Program Functionality: Making the website "work".
Modeling another site:
Do you wish to model another site? No
Size of website:
How many pages need to be created/edited in this website?I don't know. Other info:No pages, scripts only
Programming Language:
What programming language(s) do you want your website written in?I do know the language(s).Languages(s):C#ASP .NETOther: SQL scipting
Database:
Will this project include a database?Yes, it does include a database.Details:SQL Server -- version(s): 2008 r2
Browser Type(s)/Version(s):
Which browser/version combinations must this website support?IE 8.0
Server Hosting Environment:
What is your server hosting environment?I have a server at a 3rd party hosting company.The name of the hosting company is: ARVIXEThe server's shared/dedicated status is: Shared with other people.Component Compatibility Protection:Sometimes a worker may create features on the website that rely on componentswhich work fine on their own server, but won't work with your 3rd party hosting company's server. There are many reasons for this including version incompatibility, restricted permissions, etc... vWorker.com normally requires that the worker verify in advance that your 3rd party hosting provider will support the components.  If they do not, then they are responsible for any incompatibilities, rather than you. Do you want this protection on your project?No, I will be responsible for any components of the final solution that do not work with my hosting company.
Server Hosting Environment:
Will the worker develop "live" on your server?Yes. The worker may develop live on my production server.
Physical installation:
Who will perform the physical installation?I will perform the physical installation. The worker is only responsible for providing instructions and assistance regarding what I must do. I understand and agree that if the worker provides adequate instructions, but I am unable to follow them, then this is a valid reason for them to miss the final deadline without penalty (in arbitration).
Desktop / server program info

Size of application:
How many screens/forms need to be created/edited in this application?Exactly 0.
Programming Language:
What programming language(s) do you want your application written in?I do know the language(s).Languages(s):C#
Operating system(s)
What operating systems(s) do you want your application to work on?I do know the operating system(s):Microsoft Windows -- version(s): 2008
Database:
Will this project include a database?Yes, it does include a database.Details:SQL Server -- version(s): 2008 R2
Installation Program:
Does the worker need to create an installation program?Other. Details: Writing Scrips and scrips execution only.
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract. 2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer). 2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer). 3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

I need a program in vb dot net 2003 that will process a view from SQL Server into an Excel file on the local network.
The program will :-
1. Allow selection of the view (View names will exist in a table)
2. Create a temporary View on SQL Server using a subset of the above view (View field names that are to be used will exist in a table)
3. Prompt the user for the network path to install the completed Excel file into.
4. Use vb dot net code to fill the individual Excel cells
5. The program will use a URL and therefore be accessable from anywhere on the internet
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?
Legal:
1) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law.
1b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.

We need a solution that can back up contacts stored on a SIM card or phone.Availability of this service will be initiated by dialing a short code number and the contacts will be copied and stored in a secure server for first time use. Subsequent dialing of this short code will initiate data transfer in both directions and SIM card contacts and Server contacts will be synchronized.This service is to assist subscribers who lose their SIM cards or upgrade their phones access their contacts conveniently.We foresee the data(contacts) transfer being handled by an integrator. Network operator will issue a short code which will sit with the integrator. Subscribers will dial this number and they upload/download (synchronize) contacts.Only the dialing mobile number will be able to synchronize with the data it had earlier uploaded.If this process can also include all other data including photo's, calendar etc, the better.Send us your suggestion/proposal for consideration together with timelines as well as cost.We are open as to whether any program needs to be downloaded to the phone or not because we want the solution to cover all phones available (But this is you to advise).Is a website required for this?
Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.

Untitled Page

//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>

Project Type:
What kind of work do you need done?Software related (Includes desktop applications and internet websites)
Project Parts:
What do you want the worker to do on this project?

Requirements:
The worker will analyze the problem and propose a software-based solution to the problem.
Programming:
The worker will take the requirements and translate them into the language of the computer (and test it).
User installation:
The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:
What kind of documentation do you want for this project?Formal documentation - After talking back and forth, the worker creates a formal document and/or prototype, as follows:Prototype: The analyst will create a non-working mockup of all pages/screens in the final software. Creating a prototype makes it easier for the user to visualize the final software, and reduces misunderstandings.Requirements Document: The analyst will create a document describing everything the final software will do (other than what is documented in the prototype...if the employer required one).
Program Type:
What kind of software should the worker create (and/or install)?A desktop or server program: This software runs on a user's own PC/workstation, or on a server.
Desktop / server program info

Size of application:
How many screens/forms need to be created/edited in this application?Approximately 2.
Programming Language:
What programming language(s) do you want your application written in?I don't know what language (and need the worker's assistance to suggest it).Other info:The programmer will choose what works best for this requirement.
Operating system(s)
What operating systems(s) do you want your application to work on?I don't know (and need the worker's assistance to suggest it).Details: Programmer should advise what works best for tis kind of job.
Database:
Will this project include a database?Yes, it does include a database.Details:Microsoft Access -- version(s): LatestMySQL -- version(s): LatestSQL Server -- version(s): LatestMisc. details: Programmer will specify which database best suits the application for synchronizing between handset and server.
Installation Program:
Does the worker need to create an installation program?Yes AND the program will be installed on multiple computers and needs to work on all of them.Details: All on the same specification of server as agreed.
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2b) Any website server-side deliverables must be installed in ready-to-run condition in the employer's environment (unless overridden otherwise by the employer elsewhere in this contract. 2c) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the winning worker in ready-to-run condition (unless specified elsewhere by the employer). 2d) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer). 3) Employer will receive exclusive and complete copyrights to all work paid for. All paid for deliverables will be considered 'work made for hire' under U.S. Copyright law. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.