public ActionResult _UserRoleByProject(int id)
{
List <DataUserRoleByProject> roleUserByProject = (from ur in db.UserRole
join u in db.AspNetUsers on ur.UserId equals u.Id
join r in db.AspNetRoles on ur.RoleId equals r.Id
where ur.id_project == id
select new DataUserRoleByProject()
{
IdProject = id,
IdUser = ur.UserId,
IdRole = ur.RoleId,
FirstName = u.FirstName,
LastName = u.LastName,
Username = u.UserName,
RoleName = r.Name
}).ToList();
UserRoleByProject userRoleProjectModel = new UserRoleByProject
{
//Id = id,
dataUserRoleByProject = roleUserByProject
};
if (userRoleProjectModel == null)
{
//Then Error
}
return(PartialView(userRoleProjectModel));
}
public ActionResult EditUserRoleByProject(int idProject, string idUser, string idRole)
{
//Verificar o if
if (idProject.Equals("") || idProject <= 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
List <EditDataUserRoleByProject> DataUserRoleByProject = (from ur in db.UserRole
join u in db.AspNetUsers on ur.UserId equals u.Id
join r in db.AspNetRoles on ur.RoleId equals r.Id
join p in db.Project on ur.id_project equals p.id
where ur.UserId == idUser && ur.id_project == idProject
select new EditDataUserRoleByProject()
{
IdProject = idProject,
IdUser = ur.UserId,
IdRole = ur.RoleId,
FirstName = u.FirstName,
LastName = u.LastName,
Username = u.UserName,
RoleName = r.Name,
ProjectDescription = p.description,
ProjectName = p.name,
UrlImage = p.logo_url
}).ToList();
UserRoleByProject userRoleByProject = new UserRoleByProject()
{
editDataUserRoleByProject = DataUserRoleByProject
};
getRolesAndProjectsDropDownEdit(idProject, idRole);
return(View(userRoleByProject));
}
