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])