public GetUserTeamsResponse GetUserTeams(GetUserTeamsRequest request)
{
var response = new GetUserTeamsResponse();
try
{
//var dbUsers = uow.Repository<UserEntity>().GetOverview();
var dbTeams = uow.Repository <TeamEntity>().GetOverview();
var dbXrefUsersTeam = uow.Repository <XrefUserTeamEntity>().GetOverview();
var userTeams = (from xref in dbXrefUsersTeam
//join user in dbUsers
// on xref.UserId equals user.UserId
join team in dbTeams
on xref.TeamId equals team.TeamId
where xref.UserId == request.UserId
select new Team
{
TeamId = team.TeamId,
TeamName = team.TeamName,
ProjectManagerId = team.ProjectManagerId
}
).ToList();
response.Teams = userTeams;
response.Success = true;
}
catch (Exception ex)
{
response.ErrorMessage = ex.Message;
response.Success = false;
}
return(response);
}
public IActionResult UserDashboard()
{
if (HttpContext.Session.GetString("UserId") != null)
{
int userId = Int32.Parse(HttpContext.Session.GetString("UserId"));
ViewBag.UserName = HttpContext.Session.GetString("UserName");
ViewBag.UserId = userId;
var request = new GetUserTeamsRequest {
UserId = userId
};
var response = service.GetUserTeams(request);
if (response.Success)
{
var teams = new List <TeamVM>();
foreach (var team in response.Teams)
{
teams.Add(new TeamVM
{
TeamId = team.TeamId,
TeamName = team.TeamName,
ProjectManagerId = team.ProjectManagerId,
ProductOwnerId = team.ProductOwnerId,
ScrumMasterId = team.ScrumMasterId
});
}
return(View(teams));
}
}
return(RedirectToAction("Login"));
}
