// public void UpdateTable2()
public async Task UpdateTable2()
{
var dataTable2 = Table2Collection.Find(it => true).ToList();
if (dataTable2.Any())
{
foreach (var data in dataTable2.GroupBy(it => it.IdArea))
{
Table2Collection.DeleteMany(it => it.IdArea == data.Key);
}
}
// Problem can't insert
try
{
var getData = Table4Collection.Find(it => true).ToList();
for (int i = 0; i < getData.Count; i += AtATime)
{
var list = getData.Skip(i).Take(AtATime);
Table2Collection.InsertMany(list);
await Task.Delay(Delay);
}
}
catch (System.Exception e)
{
throw e;
}
}
public List <string> GetAllTagTable2()
{
var getDataTag = Table2Collection.Find(it => true).ToList();
var listTag = new List <string>();
foreach (var data in getDataTag)
{
foreach (var tags in data.Tags)
{
if (tags != "" && data.Tags.Any(i => i != tags))
{
listTag.Add(tags);
}
}
}
var getAllDuplicateTag = listTag.GroupBy(it => it).ToList();
var listTagWithOutDuplicate = new List <string>();
foreach (var data in getAllDuplicateTag)
{
listTagWithOutDuplicate.Add(data.Key);
}
return(listTagWithOutDuplicate);
}
public List <ScoreArea> GetAreaTable2(string idArea)
{
var getArea = Table2Collection.Find(it => it.IdArea == idArea.ToUpper()).ToList()
.OrderByDescending(it => it.Score).ToList();
return(getArea);
}
public List <ScoreArea> GetTable2()
{
var getDataTable2 = Table2Collection.Find(it => true).ToList()
.OrderBy(it => it.IdRegion)
.OrderBy(it => it.IdArea).ToList();
return(getDataTable2);
}
public List <ScoreArea> GetAllAreaTable2()
{
var getData = Table2Collection.Find(it => true).ToList()
.OrderBy(it => it.IdRegion)
.GroupBy(it => it.IdRegion).ToList();
var listArea = new List <ScoreArea>();
foreach (var dataRegion in getData)
{
var dataGroupByArea = dataRegion.OrderBy(it => it.IdArea).GroupBy(it => it.IdArea).ToList();
foreach (var data in dataGroupByArea)
{
var getArea = data.FirstOrDefault();
listArea.Add(getArea);
}
}
return(listArea);
}
public List <ScoreArea> GetAreaWithTagTable2(string getTag)
{
var getData = Table2Collection.Find(it => it.Tags.Any(i => i == getTag)).ToList();
return(getData);
}
public List <ScoreArea> GetAreaWithIdAreaTable2(string idArea)
{
var getData = Table2Collection.Find(it => it.IdArea == idArea.ToUpper()).ToList();
return(getData);
}
