How to Update multiple tables in a single MVC view?

Question

Hello I have 3 tables Employee EmployeeDepartment and EmployeeSalary. All 3 tables are related and presented as a grid values in index.cshtml view. From the index view grid rows i want to edit single employee id(Edit.cshtml) which should post the datas in all the 3 tables. What could be the best approach for posting this values from view to database?

Ramesh Palanivel · Answer

Hi Manikandan Create your model like below format public class Employee { public int EmpId { get ; set ; } public string EName { get ; set ; } public string Email { get ; set ; } public int DeptId { get ; set ; } public string DeptName { get ; set ; } public double Salary { get ; set ; } public DateTime SalaryDate { get ; set ; } } Create your controller which receives your EmpId while clicking the table in records [HttpPost] Public ActionResult EditEmployee( int EmpId) { Employee emp= new Employee(); EmployeeEntities _Entitty=New EmployeeEntities(); emp=_Entity.Employee.where(x=>x.EmpId==EmpId).select(x=> new Employee { EmpId=x.EmpId EName=x.EName Email=x.Email DeptId=x.EmployeeDepartment.DeptID DeptName=x.EmployeeDepartment.DepName Salary=x.EmployeeSalary.Salary SalaryDate=x.EmployeeSalary.SalaryDate }); return View(emp); } Create view for this EditEmployee ActionResult. I hope!.. It should work!..

Ramesh Palanivel · Answer

HI manikandan My mail id is srameshsaral@gmail.com Just send one email from your mail id

Ramesh Palanivel · Answer

Hi manikandan Is it your team viewer is running your machine? If it is running Kindly share your team viewer version

manikandan r · Answer

3931

Ramesh Palanivel · Answer

Hi Manikandan Share Ur team viewer password to connect Ur machine

Ramesh Palanivel · Answer

Hi Manikandan It should work!.. Can you share your code? If you have team viewer share your team viewer details I will help you!..

manikandan r · Answer

Yes Ramesh.

Ramesh Palanivel · Answer

Hi Manikandan Is your EmployeeId mapped as foreign key in EmployeeDepartment and EmployeeSalary table?

manikandan r · Answer

Hi Ramesh Not working!! unable to access the other table entities in below lines. x holds only the Employee model attributes. DeptId=x.EmployeeDepartment.DeptID DeptName=x.EmployeeDepartment.DepName Salary=x.EmployeeSalary.Salary SalaryDate=x.EmployeeSalary.SalaryDate

manikandan r · Answer

Hi Ramesh Table is simple. Table 1 - Employee Columns - EmpId(pk) ENameEmail Table 2 - EmployeeDepartment Columns - EmpId DeptID DepName Table 3 - EmployeeSalary Columns - EmpID Salary SalaryDate Columns to display in UI as a table - EmpIdENameEmail DepName Salary SalaryDate I am looking for CRUD code for able details. I am using Entity framework here

manikandan r · Answer

Hi Marimuthu Thanks for your response!! Can you send me the code for Index and Edit actions as well? I want to know how do you join select the muliple tables and updating the same in database. Regards Mani

Marimuthu Karuppaiah · Answer

Hi Try out this logic. Create a ViewModel with all required fields from the three tables. public class ViewModel { public int EmpID { get; set; } //Employee Table public string EmpName { get; set; } //Employee Table public string EmpDepartment { get; set; } //EmployeeDepartment Table public int Salary { get; set; } //EmployeeSalary Table } Create an instance for that ViewModel and assign values to the fields. And pass to your view. //Controller.cs public ActionResult Create(int Id) { ViewModel mymodel = new ViewModel(); mymodel.EmpID =1; mymodel.EmpName =Test; mymodel.EmpDepartment =Test; mymodel.Salary =10; return View(mymodel) } You can retrieve the passed values in your view by importing the ViewModel. //View @model Web.Controllers.YourController.ViewModel

Ramesh Palanivel · Answer

Hi Manikandan Can you share table Details I will give the solution for yoru problem.