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());
}
