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); }