public ActionResult DeleteConfirmed(int id) { Office office = db.Office.Find(id); int idUser = (int)Session["idUser"]; int idCompany = (int)Session["idCompany"]; using (var trans = db.Database.BeginTransaction()) { try { office.DeactivateOffice(); db.SaveChanges(); Log log = new Log { Who = idUser, OfficeId = id, New = "DISABLED", Old = "ACTIVATED", CompanyId = office.CompanyId }; db.Log.Add(log); db.SaveChanges(); trans.Commit(); TempData["confirm"] = "SUCCESSFUL DELETE"; return(RedirectToAction("Index")); } catch { trans.Rollback(); ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER"; return(RedirectToAction("Index")); } } }