Require ASP.Net MVC 4 Demo

See more:

ASP.NET

MVC

Dear Friends,

I am newer in MVC 4 Pattern in ASP.Net, But I have developed a page to add, edit, delete and view record for single table.

But, I am getting problem for multiple table. So Can anyone help me to develop as below functionality ?

Below requirement is for demo purpose only, if you can help me to develop this demo then I can implement that development in my project.

Thanks in Advance. :-)

Thanks and Regards,
Rohit

Table
Employee
EmpId (numeric - auto increament) (PK)
Username (nvarchar(20)) (Required)
Password (nvarchar(20)) (Required)

EmpPersonal
EPId (numeric- auto increament) (PK)
EmpId (numeric – FK of Employee table)
FirstName (nvarchar(20)) (Required)
LastName (nvarchar(20)) (Required)
BirthDate (datetime)
EmailId (nvarchar(20)) (Required)
MobileNo (nvarchar(20)) (Required)
HomePhone (nvarchar(20))

EmpQualification
EQId (numeric – auto increament) (PK)
EmpId (numeric – FK of Employee table)
PostDegree (nvarchar(20)) (like, MCA, ME, Mtech etc...)
PDPassingYear (numeric)
Degree (nvarchar(20)) (like, BE, BCA etc...)
DpassingYear (numeric)


User Interface Form

Login Information
Education Qualification
Username -[Textbox]
Password -[Textbox]
First Name - [Textbox]
Last Name - [Textbox]
Birth Date -[Date Picker]
Email id -[Textbox]
Mobile Number - [Textbox]
Home Phone - [Textbox]

Post Degree - [Drop Down]
Passing Year - [Drop Down] (Based on date of birth drop down will be filled]
Degree - [Drop Down]
Passing Year - [Drop Down] (Based on date of birth drop down will be filled]
Personal Information

[Save] [Cancel]



Grid
Full Name (firstname +lastname)
Email Id
Mobile
Action ([Edit] - [Delete])