Modal Popup is not able to update two table at the same time

I tried to create company model and staffmodel separately and join the method in companyStaffModelView but is still not working, kindly assist please 

With the update query that is .      SelectMany (x=>x.tblStaffs.Select(d=> new StaffManagementModel, the error message says MasterMVCPOS.Models.Staff does not contain a definition for tblStaffs,  and I tried to include public virtual ICollection tblStaffs {get; set; } in the model and the error still remains.

Hello Team,

Thank you all for your help, but after changing the code according to Vishal is still not working yet, I will appreciate if you could look at the code again for me please 

In the upStaffDetails function, you are making an AJAX request to the UpStaffDetail action in your controller. It looks like you are passing in a StaffId and Department parameter, but you are not using the Department parameter in your action. Your action is returning a JSON object, but I'm not sure if this is the correct data that you need to populate the fields in your modal popup. 

In the DeleteStaff function, you are using the sweetAlert library to confirm if the user wants to delete the staff member. If the user confirms, you are making an AJAX request to the DeleteStaff action in your controller, passing in the StaffId parameter.   I don't see where you are actually deleting the staff member from the database in your DeleteStaff action. It looks like you are just removing the staff member from the tblStaffs navigation property of a company, but not actually deleting it from the tblStaffs table in the database.

Hello

You need to do below changes to get staff details to update.

[HttpGet]
public ActionResult UpStaffDetail(int staffId)
{
    using (var db = new ASPNETMASTERPOSTEntities())
    {
        var dataList = db.tblCompanies.Include("tblStaffs").ToList();
        var modifiedData = dataList.AsEnumerable().where(a=>a.StaffId == staffId).SelectMany(x => x.tblStaffs.Select(d => new StaffManagementModel
        {
            CompanyId = x.CompanyId,
            DateJoin = x.DateJoin,
            Department = x.Department,
            JobTitle = x.JobTitle,
            StaffId = d.StaffId,
            Picture = d.Picture,
            StaffNo = d.StaffNo,
            FName = d.FName,
            LName = d.LName,
            BirthDate = d.BirthDate,
            PhoneNo = d.PhoneNo,
            Email = d.Email,
            FirstName = d.FirstName,
            LastName = d.LastName,
            PhoneNumb = d.PhoneNumb
        })).FirstOrDefault();

        return Json(modifiedData, JsonRequestBehavior.AllowGet);
    }
}

To Delete staff you need to do below changes in home controller DeleteStaff Method

[HttpPost]
public ActionResult DeleteStaff(int StaffId)
{
    try
    {
        ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
        var Staff = db.tblStaffs.Where(x => x.StaffId == StaffId).FirstOrDefault();
        db.tblStaffs.Remove(Staff);
        db.SaveChanges();
        return Json(true, JsonRequestBehavior.AllowGet);
    }
    catch (Exception)
    {
        return Json(false, JsonRequestBehavior.AllowGet);
    }
}

Thanks 

Vishal

Please it didn't work for me, I wish you could do the correction in the code for me. Thank you 

I will check it out and revert Swain. Thank you for your response 

On the provided code, there are a few things that need to be addressed in order to update both the parent and child tables using modal popup:

1. The UpStaffDetail action in the controller only returns one object (i.e., modifiedData) which contains the details of a single staff member. However, in the JavaScript code, it appears that there are multiple staff members that are being pushed into the tblStaffs array. This could be a possible source of error.

2. The DeleteStaff action in the controller only receives a single StaffManagementModel object as a parameter. However, in the JavaScript code, the StaffId is being passed as a separate parameter. This could also be a possible source of error.

3. It is unclear how the parent table (i.e., tblCompanies) is being updated. The provided code only shows the details of a single staff member being retrieved from the database and displayed in the modal popup. However, there is no code that updates the parent table based on any changes made in the modal popup.

To update both the parent and child tables using modal popup, you need to modify your code as follows:

1. Modify the UpStaffDetail action in the controller to return all the details of the staff member and their associated company. This can be achieved by removing the FirstOrDefault() method and returning the entire dataList instead.

2. Modify the upStaffDetails function in JavaScript to iterate over the dataList and push all the staff members and their associated companies into the tblStaffs array.

3. Modify the DeleteStaff action in the controller to receive the StaffId as a parameter and delete the corresponding staff member and their associated company from the database.

4. Add code to update the parent table (i.e., tblCompanies) based on any changes made in the modal popup. This can be achieved by adding a separate HttpPost action in the controller that receives the details of the staff member and their associated company and updates the database accordingly.