public ActionResult Index() { if (Session["username"] == null) { return(RedirectToAction("HomePage", "Home")); } var username = Session["username"].ToString(); int branchid = 0; var listo = userManager.GetAll().Where(c => c.UserName == username); foreach (var t in listo) { branchid = t.BranchId; } var result = from move in movementPermisionManager.GetAll().Where(c => c.Permision == false && c.BranchId == branchid) join asset in assetManager.GetAll() on move.AssetId equals asset.Id join org in organizationManager.GetAll() on move.OrganizationId equals org.Id join branch in branchManager.GetAll() on move.BranchId equals branch.Id select new { id = move.Id, date = move.RegistrationDate, asset = asset.Name, fromOrg = move.OrganizationName, frombranch = move.BranchName, toorg = org.Name, tobranch = branch.Name, moveby = move.MoveBy, permision = move.Permision }; var jsonitem = result.Select(c => new { c.id, c.date, c.asset, c.fromOrg, c.frombranch, c.toorg, c.tobranch, c.moveby, c.permision }); List <MovementAuthorityN> list = new List <MovementAuthorityN>(); foreach (var j in jsonitem) { MovementAuthorityN authorityN = new MovementAuthorityN(); authorityN.id = j.id; authorityN.date = j.date; authorityN.asset = j.asset; authorityN.fromOrg = j.fromOrg; authorityN.frombranch = j.frombranch; authorityN.toorg = j.toorg; authorityN.tobranch = j.tobranch; authorityN.moveby = j.moveby; authorityN.permision = j.permision; list.Add(authorityN); } ViewBag.list = list; return(View()); }