sql asp.net C#
$250-750 AUD
着払い
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
プロジェクトID: #4500816
プロジェクトについて
7人のフリーランサーが、平均$584 で、この仕事に入札しています。
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 もっと
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.
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 もっと
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 もっと