public IEnumerable <TfsChangesetWrapper> QueryChangesets(IEnumerable <TfsWorkItemWrapper> workItems, ITrackProgress trackProgress, CancellationToken cancelled = default(CancellationToken))
{
var results = new System.Collections.Concurrent.ConcurrentBag <TfsChangesetWrapper>();
Parallel.ForEach(workItems,
(workItem, state) =>
{
if (Repository.Instance.TfsConnectionInfo.Uri == null)
{
state.Stop();
return;
}
if (cancelled.IsCancellationRequested)
{
state.Stop();
return;
}
trackProgress.Increment();
foreach (var changeset in workItem.RelatedChangesets)
{
trackProgress.ProgressInfo = String.Format("Processing work item #{0} ({1} related changesets)", workItem.TfsWorkItem.Id, workItem.RelatedChangesetCount);
results.Add(UpdateChangesetFromCache(new TfsChangesetWrapper(changeset)));
}
});
cancelled.ThrowIfCancellationRequested();
var resultList =
results
.GroupBy(item => item.TfsChangeset.Changeset.ChangesetId)
.Select(item => item.First());
return(resultList.ToList().AsEnumerable());
}
public IEnumerable <TfsWorkItemWrapper> QueryWorkItems(IEnumerable <TfsChangesetWrapper> changesets, ITrackProgress trackProgress, CancellationToken cancelled = default(CancellationToken))
{
var results = new System.Collections.Concurrent.ConcurrentBag <TfsWorkItemWrapper>();
Parallel.ForEach(changesets,
(changeset, state) =>
{
if (Repository.Instance.TfsConnectionInfo.Uri == null)
{
state.Stop();
return;
}
if (cancelled.IsCancellationRequested)
{
state.Stop();
return;
}
foreach (var workItem in changeset.TfsChangeset.RelatedWorkItems)
{
results.Add(UpdateWorkItemFromCache(new TfsWorkItemWrapper(workItem)));
}
trackProgress.Increment();
});
cancelled.ThrowIfCancellationRequested();
var resultList =
results
.GroupBy(item => item.TfsWorkItem.Id)
.Select(item => item.First());
return(resultList.ToList().AsEnumerable());
}
public IEnumerable<CompareAnalyzeData> CompareData(string research_id)
{
var research = db.GetResearch(research_id);
if (research == null) return new List<CompareAnalyzeData>();
var items = db.Items.Where(n => n.Resarch.ResearchId == research.ResearchId).Select(n => n.ItemId).ToArray();
var itemAttribute = db.ItemAttributes.Where(n => items.Contains(n.Item.ItemId)).ToArray();
var users = db.UserAnswerCompleted.Where(n => n.Research.ResearchId == research.ResearchId).Select(n => n.User).ToArray();
var resultAll = from answer in db.ItemCompareAnsweres.Where(n => n.Research.ResearchId == research.ResearchId)
join complete in db.UserAnswerCompleted.Where(n => n.Research.ResearchId == research.ResearchId)
on answer.User.UserId equals complete.User.UserId into z
select answer;
var groupUser = resultAll.GroupBy(n => n.User.UserId);
var count = db.UserAnswerCompleted.Where(n => n.Research.ResearchId == research.ResearchId).Count();
Dictionary<int, List<Tuple<string, string, double>>> userData = new Dictionary<int, List<Tuple<string, string, double>>>();
foreach (var data in groupUser)
{
List<Tuple<string, string>> list = new List<Tuple<string, string>>();
//属性の大小関係書き出し
foreach (var item in data)
{
if (item.ItemBad != null && item.ItemGood != null)
{
if (item.ItemBad.ItemAttribute != null && item.ItemGood.ItemAttribute != null)
{
var atribute = from good in item.ItemGood.ItemAttribute
from bad in item.ItemBad.ItemAttribute
where good.AttributeName == bad.AttributeName && good.Value != bad.Value
select new { good = good.Value, bad = bad.Value };
foreach (var pair in atribute)
{
list.Add(new Tuple<string, string>(pair.good, pair.bad));
}
}
}
}
//ペアの組み合わせの数をかぞえる。
var result = list.GroupBy(n => new { n.Item1, n.Item2 }).Select(n => new Tuple<string, string, int, string>(n.Key.Item1, n.Key.Item2, n.Count(), Tool.GetSortText(n.Key.Item1, n.Key.Item2))).GroupBy(n => n.Item4);
List<Tuple<string, string, double>> list2 = new List<Tuple<string, string, double>>();
foreach (var item in result)
{
var tmp = item.OrderByDescending(n => n.Item3).ToArray();
if (tmp.Length > 1)
{
list2.Add(new Tuple<string, string, double>(tmp.First().Item1, tmp.First().Item2, (double)tmp.First().Item3 / (double)(tmp.First().Item3 + tmp.Last().Item3)));
}
else
{
list2.Add(new Tuple<string, string, double>(tmp.First().Item1, tmp.First().Item2, (double)tmp.First().Item3 / (double)(tmp.First().Item3)));
}
}
if (list2.Count > 0)
{
userData.Add(data.Key, list2);
}
}
System.Collections.Concurrent.ConcurrentBag<Tuple<string, List<string>, int>> stockData = new System.Collections.Concurrent.ConcurrentBag<Tuple<string, List<string>, int>>();
System.Threading.Tasks.Parallel.ForEach(userData, (data) =>
{
foreach (var item in Tool.ConverMuitiRelation(data.Value, 0.7, false))
{
stockData.Add(new Tuple<string, List<string>, int>(item.Item1.Aggregate((n, m) => n + "\t" + m), item.Item1, data.Key));
}
});
var result3 = stockData.GroupBy(n => n.Item1).Select(n => new CompareAnalyzeData()
{
AttributeOrder = n.First().Item2,
Rate = (double)n.Count() * 100 / (double)userData.Count,
Count = n.Count(),
UserIds = n.Select(m => m.Item3).ToList()
}).ToList();
int i = 0;
foreach (var item in result3)
{
item.Id = "compare" + i.ToString();
List<int> idList = new List<int>(item.UserIds);
item.QuestionAnswer = db.QuestionAnsweres.Where(n => idList.Contains(n.User.UserId)).GroupBy(n => n.QuestionChoice).Select(n => new { n.Key, Count = n.Count() }).ToArray().Select(n => new Tuple<QuestionChoice, int>(n.Key, n.Count));
i++;
}
return result3;
}