public void SetTag()
{
var getData = Table4Collection.Find(it => true).ToList();
var groupByArea = getData.GroupBy(it => it.IdArea).ToList();
var listScoreArea = new List <ScoreArea>();
foreach (var item in groupByArea)
{
var listMaxScore = item.Where(it => it.Score == item.Max(i => i.Score)).ToList();
var getMaxScore = listMaxScore.FirstOrDefault();
foreach (var data in item)
{
if (data.Id == getMaxScore.Id)
{
data.Tags = new List <string> {
"ชนะ"
};
listScoreArea.Add(data);
}
else
{
data.Tags = new List <string> {
"แพ้"
};
listScoreArea.Add(data);
}
}
}
Table4Collection.DeleteMany(it => true);
Table4Collection.InsertMany(listScoreArea);
}
public void MockPrototypeScoreTable4()
{
var getData = ScorePollV3Collection.Find(it => true).ToList();
var groupByArea = getData.GroupBy(it => it.IdArea).ToList();
var listScoreTable4 = new List <ScoreArea>();
foreach (var item in groupByArea)
{
var groupByParty = item.GroupBy(it => it.IdParty).ToList();
foreach (var data in groupByParty)
{
if (data.Key != "000" && data.Key != "888")
{
var getCurrentScore = data.OrderByDescending(it => it.datePoll).ToList().FirstOrDefault();
listScoreTable4.Add(new ScoreArea
{
Id = Guid.NewGuid().ToString(),
IdArea = getCurrentScore.IdArea,
IdParty = getCurrentScore.IdParty,
Score = getCurrentScore.Score,
Source = getCurrentScore.Source
});
}
}
}
Table4Collection.DeleteMany(it => true);
Table4Collection.InsertMany(listScoreTable4);
}
public async Task MockTable4()
{
var dataDemoTable4 = DemoTable4Collection.Find(it => true).ToList();
for (int i = 0; i < dataDemoTable4.Count; i += AtATime)
{
var list = dataDemoTable4.Skip(i).Take(AtATime);
Table4Collection.InsertMany(list);
await Task.Delay(Delay);
}
}
public async Task FillDataIntoTable4_2()
{
var dataListT4 = ListT4Collection.Find(it => true).ToList();
for (int i = 0; i < dataListT4.Count; i += 550)
{
var list = dataListT4.Skip(i).Take(550);
Table4Collection.InsertMany(list);
await Task.Delay(1000);
}
foreach (var data in dataListT4)
{
ListT4Collection.DeleteOne(it => it.IdArea == data.IdArea &&
it.IdParty == data.IdParty);
}
}
public void MatchDataWithTable2()
{
var readerCsv = new ReadCsv();
var getTable2 = readerCsv.MockPrototypeDataTable2();
var getData = Table4Collection.Find(it => true).ToList();
var listTable4 = new List <ScoreArea>();
foreach (var item in getData)
{
var getMatch = getTable2.FirstOrDefault(it => it.IdArea == item.IdArea &&
it.IdParty == item.IdParty);
item.NameArea = getMatch.NameArea;
item.NameInitial = getMatch.NameInitial;
item.NameParty = getMatch.NameParty;
item.NameRegister = getMatch.NameRegister;
item.NoRegister = getMatch.NoRegister;
item.Status = true;
listTable4.Add(item);
}
Table4Collection.DeleteMany(it => true);
Table4Collection.InsertMany(listTable4);
}