Data not deleting from parent child table

Hello,

Please check the Front-end code from where you are calling API. make sure CompanyId and StaffId passing properly.

Also, add a check if the company and staff are not null and empty before calling the remove method. check below sample code.

public ActionResult DeleteStaff(int StaffId, int CompanyId)
{
  try
  {
     ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
     var company = db.tblCompany.Where(x => x.CompanyId == CompanyId ).FirstOrDefault();
     var Staff = db.tblStaffs.Where(x => x.StaffId == StaffId ).FirstOrDefault();
     if(company != null)
       db.tblCompany.Remove(company);
     if(Staff != null)
       db.tblStaffs.Remove(Staff);
     db.SaveChanges();
     return Json(true, JsonRequestBehavior.AllowGet);
  }
  catch (Exception)
  {
     return Json(false, JsonRequestBehavior.AllowGet);
  }
}

 

Thanks