public void MockPrototypeTableScorePollV2() { var getData = ScorePollCsvCollection.Find(it => true).ToList(); var rnd = new Random(); var listScorePoll = new List <ScorePollV2>(); foreach (var item in getData) { if (item.IdParty != "999") { if (item.IdParty != "000" && item.IdParty != "888") { var randomDiff = rnd.Next(500, 3500); var ScoreTarget = (rnd.Next(0, 1) == 0) ? item.Score + randomDiff : item.Score - randomDiff; listScorePoll.Add(new ScorePollV2 { Id = Guid.NewGuid().ToString(), IdParty = item.IdParty, NameParty = item.NameParty, IdArea = item.IdArea, NameArea = item.NameArea, datePoll = new DateTime(2019, 1, 1), Score = item.Score, Source = "Poll", TargetScoreDefault = ScoreTarget, TargetScore = ScoreTarget }); } else { listScorePoll.Add(new ScorePollV2 { Id = Guid.NewGuid().ToString(), IdParty = item.IdParty, NameParty = item.NameParty, IdArea = item.IdArea, NameArea = item.NameArea, datePoll = new DateTime(2019, 1, 1), Score = item.Score, Source = "Poll", TargetScoreDefault = 0, TargetScore = 0 }); } } } ScorePollV3Collection.InsertMany(listScorePoll); }
public void MockPrototypeTableScorePollCsv() { var readerCsv = new ReadCsv(); var getFromCsv = readerCsv.MockDataScorePoll(); var rnd = new Random(); var list = new List <ScorePollCsv>(); foreach (var item in getFromCsv) { if (item.IdParty != "999") { item.Score = rnd.Next(25000, 55000); list.Add(item); } else { list.Add(item); } } var groupByArea = list.GroupBy(it => it.IdArea).ToList(); var listScorePollCsv = new List <ScorePollCsv>(); foreach (var item in groupByArea) { var TotalGoodScore = item.Sum(it => it.Score); foreach (var data in item) { if (data.IdParty == "999") { data.Score = TotalGoodScore; listScorePollCsv.Add(data); } else { listScorePollCsv.Add(data); } } } ScorePollCsvCollection.InsertMany(listScorePollCsv); }