public ViewResult Index(string mode)
{
//var issues = db.Issues.Include(i => i.Category).Include(i => i.Priority);
//string query = "SELECT * FROM Issue WHERE Writer='" + System.Web.HttpContext.Current.User.Identity.Name + "' ORDER BY State ASC";
string query = "";
string a_query = "";//for "closed" issues
string e_query = ""; //for employee issues
//ViewBag.Message = "Welcome to ASP.NET MVC!";
string cuser = System.Web.HttpContext.Current.User.Identity.Name;
if (System.Web.HttpContext.Current.User.IsInRole("Customer"))
{
if (mode != null)
{
switch (mode)
{
case "id":
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY IssueID DESC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY IssueID DESC";
break;
case "state":
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY State ASC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY State ASC";
break;
case "cat":
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY CategoryID ASC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY CategoryID ASC";
break;
case "priority":
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY PriorityID DESC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY PriorityID DESC";
break;
case "title":
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY Title ASC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY Title ASC";
break;
default:
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY State ASC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY State ASC";
break;
}
}
else
{
query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State<'4' ORDER BY State ASC";
a_query = "SELECT * FROM Issue WHERE Writer='" + cuser + "' AND State='4' ORDER BY State ASC";
}
var listIssueviewModel = new IssueListViewModel
{
lissue = db.Issues.SqlQuery(query),
a_lissue = db.Issues.SqlQuery(a_query)
};
return View(listIssueviewModel);
}
else
{
if (mode != null)
{
switch (mode)
{
case "id":
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY IssueID DESC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY IssueID DESC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='" + cuser + "' ORDER BY IssueID DESC";
break;
case "state":
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY State ASC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY State ASC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='"+cuser+"' ORDER BY State ASC";
break;
case "cat":
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY CategoryID ASC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY CategoryID ASC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='" + cuser + "' ORDER BY CategoryID ASC";
break;
case "priority":
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY PriorityID DESC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY PriorityID DESC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='" + cuser + "' ORDER BY PriorityID ASC";
break;
case "title":
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY Title ASC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY Title ASC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='" + cuser + "' ORDER BY Title ASC";
break;
default:
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY State ASC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY State ASC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='" + cuser + "' ORDER BY State ASC";
break;
}
}
else
{
query = "SELECT * FROM Issue WHERE State<'4' ORDER BY State ASC";
a_query = "SELECT * FROM Issue WHERE State='4' ORDER BY State ASC";
e_query = "SELECT * FROM Issue WHERE State<'4' AND Employee='" + cuser + "' ORDER BY State ASC";
}
var listIssueviewModel = new IssueListViewModel
{
lissue = db.Issues.SqlQuery(query),
a_lissue = db.Issues.SqlQuery(a_query),
e_lissue = db.Issues.SqlQuery(e_query)
};
return View(listIssueviewModel);
}
//return View(issues.ToList());
}
public ActionResult Search(FormCollection c)
{
string query = "";
string s = c["search"];
string c_user = System.Web.HttpContext.Current.User.Identity.Name;
if (System.Web.HttpContext.Current.User.IsInRole("Customer"))
{
query = "SELECT * FROM Issue WHERE (IssueID LIKE '%"+s+"%' OR Title LIKE '%"+s+"%' OR Description LIKE '%"+s+"%') AND Writer='" + c_user + "'";
}
else
{
query = "SELECT * FROM Issue WHERE IssueID LIKE '%" + s + "%' OR Title LIKE '%" + s + "%' OR Description LIKE '%" + s + "%' OR Writer LIKE '%"+s+"%'";
}
var viewModel = new IssueListViewModel
{
lissue = db.Issues.SqlQuery(query)
};
return View(viewModel);
}
public MainWindow()
{
InitializeComponent();
DataContext = new IssueListViewModel();
FilterTextBox.Focus();
}
public async Task <IActionResult> Index(string repoSet)
{
using (_logger.BeginScope("Requesting Triage Data for {RepoSet}", repoSet))
{
HttpContext.AddTelemetryProperty("RepoSet", repoSet);
HttpContext.AddTelemetryProperty("RepoSetView", "Triage");
var metricsPrefix = $"TriageController:RepoSet({repoSet})";
var gitHubName = HttpContext.User.Identity.Name;
HttpContext.AddTelemetryProperty("GitHubUser", gitHubName);
var gitHubAccessToken = await HttpContext.GetTokenAsync("access_token");
// Authenticated and all claims have been read
var repoDataSet = _dataSource.GetRepoDataSet();
if (!repoDataSet.RepoSetExists(repoSet))
{
var invalidRepoSetPageViewTelemetry = new PageViewTelemetry("RepoSet")
{
Url = new Uri(Request.GetDisplayUrl()),
};
HttpContext.AddTelemetryProperty("RepoSetValid", false);
return(NotFound());
}
var requestStopwatch = new Stopwatch();
requestStopwatch.Start();
var repos = repoDataSet.GetRepoSet(repoSet);
var distinctRepos =
repos.Repos
.Distinct()
.Where(repo =>
repo.RepoInclusionLevel != RepoInclusionLevel.NotInRepoSet &&
repo.RepoInclusionLevel != RepoInclusionLevel.Ignored)
.ToArray();
var personSetName = repos.AssociatedPersonSetName;
var personSet = _dataSource.GetPersonSet(personSetName);
var peopleInPersonSet = personSet?.People ?? new string[0];
var workingLabels = repos.WorkingLabels ?? new HashSet <string>();
var allIssuesByRepo = new ConcurrentDictionary <RepoDefinition, RepoTask <IReadOnlyList <Issue> > >();
var allPullRequestsByRepo = new ConcurrentDictionary <RepoDefinition, RepoTask <IReadOnlyList <PullRequest> > >();
var gitHubClient = GitHubUtils.GetGitHubClient(gitHubAccessToken);
// Get missing repos
var distinctOrgs =
distinctRepos
.Select(
repoDefinition => repoDefinition.Owner)
.Distinct(StringComparer.OrdinalIgnoreCase)
.OrderBy(org => org)
.ToList();
var allOrgRepos = new ConcurrentDictionary <string, string[]>(StringComparer.OrdinalIgnoreCase);
using (_metricsService.Time($"{metricsPrefix}:GetAllRepositories"))
{
var getAllOrgReposTask = AsyncParallelUtils.ForEachAsync(distinctOrgs, 5, async org =>
{
IReadOnlyList <Repository> reposInOrg;
using (_metricsService.Time($"{metricsPrefix}:Org({org}):GetRepositories"))
{
reposInOrg = await gitHubClient.Repository.GetAllForOrg(org);
}
allOrgRepos[org] = reposInOrg.Where(repo => !repo.Fork).Select(repo => repo.Name).ToArray();
});
await getAllOrgReposTask;
}
var missingOrgRepos = allOrgRepos.Select(org =>
new MissingRepoSet
{
Org = org.Key,
MissingRepos =
org.Value
.Except(
repos.Repos
.Distinct()
.Where(repo =>
repo.RepoInclusionLevel != RepoInclusionLevel.NotInRepoSet)
.Select(repoDefinition => repoDefinition.Name), StringComparer.OrdinalIgnoreCase)
.OrderBy(repo => repo, StringComparer.OrdinalIgnoreCase)
.ToList(),
})
.OrderBy(missingRepoSet => missingRepoSet.Org, StringComparer.OrdinalIgnoreCase)
.ToList();
// Get bugs/PR data
Parallel.ForEach(distinctRepos, repo => allIssuesByRepo[repo] = GetIssuesForRepo(repo, gitHubClient, metricsPrefix));
Parallel.ForEach(distinctRepos, repo => allPullRequestsByRepo[repo] = GetPullRequestsForRepo(repo, gitHubClient, metricsPrefix));
// while waiting for queries to run, do some other work...
var distinctMainRepos = distinctRepos.Where(repo => repo.RepoInclusionLevel == RepoInclusionLevel.AllItems).ToArray();
var distinctExtraRepos = distinctRepos.Where(repo => repo.RepoInclusionLevel == RepoInclusionLevel.ItemsAssignedToPersonSet).ToArray();
var labelQuery = GetLabelQuery(repos.LabelFilter);
var openIssuesQuery = GetOpenIssuesQuery(GetExcludedMilestonesQuery(), labelQuery, distinctMainRepos);
var workingIssuesQuery = GetWorkingIssuesQuery(labelQuery, workingLabels, distinctMainRepos);
var unassignedIssuesQuery = GetUnassignedIssuesQuery(GetExcludedMilestonesQuery(), labelQuery, distinctMainRepos);
var untriagedIssuesQuery = GetUntriagedIssuesQuery(labelQuery, distinctMainRepos);
var openPRsQuery = GetOpenPRsQuery(distinctMainRepos);
var stalePRsQuery = GetStalePRsQuery(distinctMainRepos);
// now wait for queries to finish executing
var failuresOccurred = false;
try
{
Task.WaitAll(allIssuesByRepo.Select(x => x.Value.Task).ToArray());
}
catch (AggregateException)
{
// Just hide the exceptions here - faulted tasks will be aggregated later
failuresOccurred = true;
}
try
{
Task.WaitAll(allPullRequestsByRepo.Select(x => x.Value.Task).ToArray());
}
catch (AggregateException)
{
// Just hide the exceptions here - faulted tasks will be aggregated later
failuresOccurred = true;
}
using (_metricsService.Time($"{metricsPrefix}:PostQueryProcessingTime"))
{
// Log failures
var repoFailures = new List <RepoFailure>();
if (failuresOccurred)
{
repoFailures.AddRange(
allIssuesByRepo
.Where(repoTask => repoTask.Value.Task.IsFaulted || repoTask.Value.Task.IsCanceled)
.Select(repoTask =>
new RepoFailure
{
Repo = repoTask.Key,
IssueType = IssueType.Issue,
FailureMessage = string.Format("Issues couldn't be retrieved for the {0}/{1} repo", repoTask.Key.Owner, repoTask.Key.Name),
Exception = repoTask.Value.Task.Exception,
}));
repoFailures.AddRange(
allPullRequestsByRepo
.Where(repoTask => repoTask.Value.Task.IsFaulted || repoTask.Value.Task.IsCanceled)
.Select(repoTask =>
new RepoFailure
{
Repo = repoTask.Key,
IssueType = IssueType.PullRequest,
FailureMessage = string.Format("Pull requests couldn't be retrieved for the {0}/{1} repo", repoTask.Key.Owner, repoTask.Key.Name),
Exception = repoTask.Value.Task.Exception,
}));
foreach (var failure in repoFailures)
{
_logger.LogError(
failure.Exception,
"Error retrieving {IssueType} data for {RepositoryOwner}/{RepositoryName}",
failure.IssueType,
failure.Repo.Owner,
failure.Repo.Name);
}
}
var allIssues = allIssuesByRepo
.Where(repoTask => !repoTask.Value.Task.IsFaulted && !repoTask.Value.Task.IsCanceled)
.SelectMany(issueList =>
issueList.Value.Task.Result
.Where(
issue =>
!IsExcludedMilestone(issue.Milestone?.Title) &&
issue.PullRequest == null &&
IsFilteredIssue(issue, repos) &&
ItemIncludedByInclusionLevel(issue.Assignee?.Login, issueList.Key, peopleInPersonSet))
.Select(
issue => new IssueWithRepo
{
Issue = issue,
Repo = issueList.Key,
IsInAssociatedPersonSet = IsInAssociatedPersonSet(issue.Assignee?.Login, personSet),
}))
.OrderBy(issueWithRepo => issueWithRepo.WorkingStartTime)
.ToList();
var workingIssues = allIssues
.Where(issue =>
issue.Issue.Labels
.Any(label => workingLabels.Contains(label.Name, StringComparer.OrdinalIgnoreCase)))
.ToList();
var untriagedIssues = allIssues
.Where(issue => issue.Issue.Milestone == null).ToList();
var unassignedIssues = allIssues
.Where(issue => issue.Issue.Assignee == null).ToList();
var allPullRequests = allPullRequestsByRepo
.Where(repoTask => !repoTask.Value.Task.IsFaulted && !repoTask.Value.Task.IsCanceled)
.SelectMany(pullRequestList =>
pullRequestList.Value.Task.Result
.Where(
pullRequest => !IsExcludedMilestone(pullRequest.Milestone?.Title) &&
(ItemIncludedByInclusionLevel(pullRequest.Assignee?.Login, pullRequestList.Key, peopleInPersonSet) ||
ItemIncludedByInclusionLevel(pullRequest.User.Login, pullRequestList.Key, peopleInPersonSet)))
.Select(pullRequest =>
new PullRequestWithRepo
{
PullRequest = pullRequest,
Repo = pullRequestList.Key,
IsInAssociatedPersonSet = IsInAssociatedPersonSet(pullRequest.User?.Login, personSet),
}))
.OrderBy(pullRequestWithRepo => pullRequestWithRepo.PullRequest.CreatedAt)
.ToList();
var allIssuesInMainRepos = allIssues.Where(issue => distinctMainRepos.Contains(issue.Repo)).ToList();
var allIssuesInExtraRepos = allIssues.Where(issue => distinctExtraRepos.Contains(issue.Repo)).ToList();
var mainMilestoneData = distinctMainRepos
.OrderBy(repo => repo.Owner + "/" + repo.Name, StringComparer.OrdinalIgnoreCase)
.Select(repo =>
new MilestoneSummary()
{
Repo = repo,
MilestoneData = allIssuesInMainRepos
.Where(issue => issue.Repo == repo)
.GroupBy(issue => issue.Issue.Milestone?.Title)
.Select(issueMilestoneGroup => new MilestoneData
{
Milestone = issueMilestoneGroup.Key,
OpenIssues = issueMilestoneGroup.Count(),
})
.ToList(),
});
var fullSortedMainMilestoneList = mainMilestoneData
.SelectMany(milestone => milestone.MilestoneData)
.Select(milestone => milestone.Milestone)
.Distinct()
.OrderBy(milestone => new PossibleSemanticVersion(milestone));
var extraMilestoneData = distinctExtraRepos
.OrderBy(repo => repo.Owner + "/" + repo.Name, StringComparer.OrdinalIgnoreCase)
.Select(repo =>
new MilestoneSummary()
{
Repo = repo,
MilestoneData = allIssuesInExtraRepos
.Where(issue => issue.Repo == repo)
.GroupBy(issue => issue.Issue.Milestone?.Title)
.Select(issueMilestoneGroup => new MilestoneData
{
Milestone = issueMilestoneGroup.Key,
OpenIssues = issueMilestoneGroup.Count(),
})
.ToList(),
});
var fullSortedExtraMilestoneList = extraMilestoneData
.SelectMany(milestone => milestone.MilestoneData)
.Select(milestone => milestone.Milestone)
.Distinct()
.OrderBy(milestone => new PossibleSemanticVersion(milestone));
var lastApiInfo = gitHubClient.GetLastApiInfo();
_metricsService.Record("TriageController:RateLimitRemaining", lastApiInfo.RateLimit.Remaining);
var issueListViewModel = new IssueListViewModel
{
LastApiInfo = lastApiInfo,
RepoFailures = repoFailures,
GitHubUserName = gitHubName,
LastUpdated = DateTimeOffset.Now.ToPacificTime().ToString(),
ExtraLinks = repos.RepoExtraLinks,
RepoSetName = repoSet,
RepoSetNames = repoDataSet.GetRepoSetLists().Select(repoSetList => repoSetList.Key).ToArray(),
TotalIssues = allIssues.Where(issue => issue.Repo.RepoInclusionLevel == RepoInclusionLevel.AllItems).Count(),
WorkingIssues = workingIssues.Count,
UntriagedIssues = untriagedIssues.Where(issue => issue.Repo.RepoInclusionLevel == RepoInclusionLevel.AllItems).Count(),
UnassignedIssues = unassignedIssues.Count,
OpenPullRequests = allPullRequests.Where(pr => pr.Repo.RepoInclusionLevel == RepoInclusionLevel.AllItems).Count(),
StalePullRequests = allPullRequests.Where(pr => pr.Repo.RepoInclusionLevel == RepoInclusionLevel.AllItems && pr.PullRequest.CreatedAt < DateTimeOffset.Now.AddDays(-14)).Count(),
MainReposIncluded = distinctMainRepos.GetRepoSummary(allIssues, workingIssues, allPullRequests, labelQuery, workingLabels, this),
ExtraReposIncluded = distinctExtraRepos.GetRepoSummary(allIssues, workingIssues, allPullRequests, labelQuery, workingLabels, this),
MissingRepos = missingOrgRepos,
IgnoredRepos = repos.Repos
.Where(repo => repo.RepoInclusionLevel == RepoInclusionLevel.Ignored)
.GroupBy(repo => repo.Owner, StringComparer.OrdinalIgnoreCase)
.Select(ignoredRepoGroup => new MissingRepoSet
{
Org = ignoredRepoGroup.Key,
MissingRepos = ignoredRepoGroup
.Select(repo => repo.Name)
.OrderBy(repoName => repoName, StringComparer.OrdinalIgnoreCase)
.ToArray()
})
.OrderBy(missingRepoSet => missingRepoSet.Org, StringComparer.OrdinalIgnoreCase)
.ToArray(),
MainMilestoneSummary = new MilestoneSummaryData
{
MilestoneData = mainMilestoneData.ToList(),
MilestonesAvailable = fullSortedMainMilestoneList.ToList(),
},
ExtraMilestoneSummary = new MilestoneSummaryData
{
MilestoneData = extraMilestoneData.ToList(),
MilestonesAvailable = fullSortedExtraMilestoneList.ToList(),
},
OpenIssuesQuery = openIssuesQuery,
WorkingIssuesQuery = workingIssuesQuery,
UntriagedIssuesQuery = untriagedIssuesQuery,
UnassignedIssuesQuery = unassignedIssuesQuery,
OpenPRsQuery = openPRsQuery,
StalePRsQuery = stalePRsQuery,
GroupByAssignee = new GroupByAssigneeViewModel
{
Assignees =
new[]
{
new GroupByAssigneeAssignee
{
Assignee = "<assigned outside this person set>",
IsMetaAssignee = true,
IsInAssociatedPersonSet = false,
Issues = workingIssues
.Where(workingIssue =>
workingIssue.Issue.Assignee != null &&
!peopleInPersonSet.Contains(workingIssue.Issue.Assignee.Login, StringComparer.OrdinalIgnoreCase))
.ToList(),
PullRequests = allPullRequests
.Where(
pr =>
pr.PullRequest.Assignee != null &&
!peopleInPersonSet.Contains(pr.PullRequest.User.Login, StringComparer.OrdinalIgnoreCase) &&
!peopleInPersonSet.Contains(pr.PullRequest.Assignee.Login, StringComparer.OrdinalIgnoreCase))
.OrderBy(pr => pr.PullRequest.CreatedAt)
.ToList(),
OtherIssues = allIssues
.Where(issue =>
issue.Issue.Assignee != null &&
!peopleInPersonSet.Contains(issue.Issue.Assignee?.Login, StringComparer.OrdinalIgnoreCase))
.Except(workingIssues)
.OrderBy(issueWithRepo => issueWithRepo.Issue.Assignee.Login, StringComparer.OrdinalIgnoreCase)
.ThenBy(issueWithRepo => new PossibleSemanticVersion(issueWithRepo.Issue.Milestone?.Title))
.ThenBy(issueWithRepo => issueWithRepo.Repo.Name, StringComparer.OrdinalIgnoreCase)
.ThenBy(issueWithRepo => issueWithRepo.Issue.Number)
.ToList(),
},
new GroupByAssigneeAssignee
{
Assignee = "<unassigned>",
IsMetaAssignee = true,
IsInAssociatedPersonSet = false,
Issues = workingIssues
.Where(workingIssue =>
workingIssue.Issue.Assignee == null)
.ToList(),
PullRequests = allPullRequests
.Where(
pr =>
pr.PullRequest.Assignee == null &&
!peopleInPersonSet.Contains(pr.PullRequest.User.Login, StringComparer.OrdinalIgnoreCase))
.OrderBy(pr => pr.PullRequest.CreatedAt)
.ToList(),
OtherIssues = allIssues
.Where(issue => issue.Issue.Assignee == null)
.Except(workingIssues)
.OrderBy(issueWithRepo => new PossibleSemanticVersion(issueWithRepo.Issue.Milestone?.Title))
.ThenBy(issueWithRepo => issueWithRepo.Repo.Name, StringComparer.OrdinalIgnoreCase)
.ThenBy(issueWithRepo => issueWithRepo.Issue.Number)
.ToList(),
},
}
.ToList()
.AsReadOnly(),
},
};
requestStopwatch.Stop();
issueListViewModel.PageRequestTime = requestStopwatch.Elapsed;
HttpContext.AddTelemetryProperty("RepoSetValid", true);
return(View(issueListViewModel));
}
}
}
private IssueListViewModel IssuesIndex(bool isActive, bool deleted = false)
{
var issues = new IssueListViewModel();
List <Issue> issuesList = new List <Issue>();
var userId = User.Identity.GetUserId();
if (isActive)
{
issuesList = db.Issues.Where(i => i.State == 0 || i.State == 1).ToList();
}
else
if (!deleted)
{
issuesList = db.Issues.Where(i => i.State == 2).ToList();
}
else
{
issuesList = db.Issues.Where(i => i.State == 3).ToList();
}
if (!User.IsInRole("Admin"))
{
var filteredIssues = new List <Issue>();
if (User.IsInRole("ShowInformatics"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 1 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowHydraulics"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 2 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowElectrics"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 3 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowBuilding"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 4 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowOrdinal"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 5 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowPhones"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 6 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowResearch"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 7 && i.UserId != userId).ToList());
}
if (User.IsInRole("ShowOthers"))
{
filteredIssues.AddRange(issuesList.Where(i => i.TypeId == 8 && i.UserId != userId).ToList());
}
if (User.IsInRole("User"))
{
filteredIssues.AddRange(issuesList.Where(i => i.UserId == userId).ToList());
}
issuesList.Clear();
issuesList.AddRange(filteredIssues);
}
if (issuesList.Count != 0)
{
foreach (var item in issuesList)
{
var model = new IssuesViewModel();
model.Id = item.Id;
model.Title = item.Title;
if (db.Users.Single(u => u.Id == item.UserId) != null)
{
model.userName = db.Users.Single(u => u.Id == item.UserId).UserName;
}
else
{
model.userName = "******";
}
model.TypeId = item.TypeId;
model.StartDate = item.StartDate;
model.TimeElapsed = String.Format("{0:%d}d {0:%h}g {0:%m}m {0:%s}s", DateTime.Now - item.StartDate);
model.InventoryNumber = item.InventoryNumber;
issues.IssuesVM.Add(model);
}
}
issues.Types = db.Types.Where(t => t.Active).Select(c => new SelectListItem {
Text = c.Name, Value = c.Id.ToString()
});
return(issues);
}
public MilestoneViewModel(IssueListViewModel owner, string text)
{
_owner = owner;
_isChecked = true;
Text = text;
}
public IssueList()
{
InitializeComponent();
_viewModel = Factory.Get <IssueListViewModel>();
DataContext = _viewModel;
}
