sql asp.net C#

キャンセルされた 投稿 May 8, 2013 着払い
キャンセルされた 着払い

Project Description:

Your first task is to migrate this database dump into your ASP .NET solution. (You may

choose either an online or offline migration approach.) It also implies that you should

consider verifying the validity of data entries. The third step is to allocate eligible employees

into appropriate membership classes according to the business logic. Then, you should

create a membership database consisting of at least the following fields:

• MembershipId (integer, primary key, not null) – a new entry that you have to

generate.

• FirstName (string, not null) – contents copied from the salary database.

• LastName (string, not null) – contents copied from the salary database.

• MembershipClass (string, not null) – one of the three possible values “gold”, “silver”

or “regular”.

• VerificationCode (string, not null) – a new entry that stores information which can

be used to validate employee’s date-of-birth and salary.

(Note: Your database should not store date-of-birth, salary and gender information of any

employee in plain text.)

To manage the membership, you will need to create an ASP .NET website with one web

form. On this web form (e.g. “[url removed, login to view]”), there should be at least the following controls:

• SQL database controls for displaying membership information including

MembershipId, names, and MembershipClass and so on.

• “TextBox” controls for updating member’s MembershipId, names, and

MembershipClass and so on.

• “Label” controls to indicate error messages.

• A CSS component.

• And a few “Button” controls to enable “add member”, “remove member”, “update

member” and “search member” functionalities.

In the C# file associated with the form (e.g., “[url removed, login to view]”), you should write a piece of

C# code to implement the following actions:

1. Implement “add member”, “remove member” and “update member” functionalities

to membership database.

2. Implement “search member” functionalities according to given MembershipId,

FirstName and LastName.

3. Implement a “verify member” functionality which validates a given member’s

MembershipClass based on his/her salary and age by comparing to a corresponding

verification code.

Additionally, in order to demonstrate the correctness of your implementation of the

business rule, you should include a salary histogram of all your members, an age histogram

of all members, and a list of the members who:

• Earn average salary of gold class.

• Earn the highest salary of silver class.

• Earn the lowest salary of regular class.

Here is all the files you need for the project. Thanks

[url removed, login to view]

Skills required:

ASP, SQL, Website Design

グラフィックデザイン HTML MySQL PHP ウェブサイトのデザイン

プロジェクトID: #4500816

プロジェクトについて

7個の提案 リモートプロジェクト アクティブ May 8, 2013

7人のフリーランサーが、平均$584 で、この仕事に入札しています。

bistanil98

have gone through with the requirement and we can start this project now. I want to introduce our self, we are a group of freelancers we have 11 year of experience in web application development and design, we w もっと

$567 AUD 16日以内
(11件のレビュー)
5.4
mehta2010

We understand your requirements and are ready to start. We have 6+ years of experience in asp.net/c#/sql server. Please check your PM for more information.

$555 AUD 15日以内
(4件のレビュー)
4.9
on2it

Hi, We at on2itonline would love to work with you on this, we do MAD "full service" websites on a clear and fixed budget. We have lots to offer that others don't ,like our lifetime FREE hosting on every website for a s もっと

$773 AUD 10日以内
(3件のレビュー)
4.6
workbeezcom

hi, i can help you easily. thanks.

$555 AUD 3日以内
(6件のレビュー)
3.4
SurfrazAhmad

Let's Start this Project

$333 AUD 5日以内
(3件のレビュー)
3.1
getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and t もっと

$773 AUD 28日以内
(7件のレビュー)
1.6
btslx

Dear Buyer, We have a expert development team with almost 10 year experience in .net, C#, sql server. We are highly interested on your project. We read and understand your requirements as we have experienced mobile もっと

$533 AUD 10日以内
(0件のレビュー)
3.3
expertzsol

Dear Sir, we are pleased to inform you that we have studied all the requirements and can deliver the same to u . we have similar work experience and can handle this quite well We are one of the leading service もっと

$526 AUD 22日以内
(0件のレビュー)
0.0