public IActionResult DeleteUser(int id) { var u = dbContext.users.Find(id); var doc = dbContext.documents.Where(x => x.UserID == id).ToList(); foreach (var d in doc) { var df = dbContext.documentFiles.Where(x => x.document_file_id == d.DocumentFileID).FirstOrDefault(); df.numberOf_document--; var deletedDoc = new DeletedDocument(); deletedDoc.deleted_document_name = d.document_name; deletedDoc.deleted_document_type = d.document_type; deletedDoc.UserID = d.UserID; dbContext.deletedDocuments.Add(deletedDoc); dbContext.Remove(d); dbContext.SaveChanges(); } dbContext.users.Remove(u); dbContext.SaveChanges(); TempData.Add("Alert", "User was deleted"); return(RedirectToAction("Index")); }