public void CreateLiveCollection()
{
MatchAnalysis manalysis = new MatchAnalysis();
manalysis.CommandTimeout = 0;
manalysis.ContextOptions.LazyLoadingEnabled = true;
manalysis.live_Table_lib.MergeOption = MergeOption.NoTracking;
DateTime dt_now = DateTime.Now.AddDays(-1);
var today_ma = manalysis.live_Table_lib.Where(e => e.match_time.Value > dt_now);
foreach (var ma in today_ma)
{
LiveDataETLsDocument ldata = new LiveDataETLsDocument();
ldata._id = ma.live_table_lib_id*1000;
ldata.live = 1;
ldata.html_position = ma.html_position;
ldata.home_team_big = ma.home_team_big;
ldata.away_team_big = ma.away_team_big;
ldata.match_type = ma.match_type;
ldata.match_time = ma.match_time;
ldata.asia_odds = ma.status;
ldata.home_team = ma.home_team;
ldata.away_team = ma.away_team;
ldata.home_red_card = ma.home_red_card;
ldata.away_red_card = ma.away_red_card;
ldata.full_home_goals = ma.full_home_goals;
ldata.full_away_goals = ma.full_away_goals;
ldata.half_home_goals = ma.half_home_goals;
ldata.half_away_goals = ma.half_away_goals;
if (LiveMatchETL.matches.Contains(ldata.match_type))
mongo_LiveDataETL.MongoDropColCreateCol.Insert(ldata);
}
Console.WriteLine("live_Table_lib->mongo->ok");
}
private void CreateJzCollection(ILookup<string, result_tb_lib> lookup_matchType, LiveDataETLsDocument today_m)
{
HistoryDataTopJzDocument hdataHost = new HistoryDataTopJzDocument();
hdataHost._id = today_m._id;
hdataHost.home_team = today_m.home_team;
hdataHost.away_team = today_m.away_team;
hdataHost.home_team_big = today_m.home_team_big;
hdataHost.away_team_big = today_m.away_team_big;
hdataHost.match_type = today_m.match_type;
var history_data = lookup_matchType[today_m.match_type]
.Where(e => e.match_time < today_m.match_time)
.Where(e => (e.home_team_big == today_m.home_team_big && e.away_team_big == today_m.away_team_big)
|| (e.home_team_big == today_m.away_team_big && e.away_team_big == today_m.home_team_big))
.OrderByDescending(e => e.match_time).Take(take_match_num);
hdataHost.history_data_etl = new List<HistoryDataETLs>();
foreach (var ma in history_data)
{
hdataHost.match_count++;
HistoryDataETLs hdata = new HistoryDataETLs();
hdata._id = ma.result_tb_lib_id;
hdata.html_position = ma.html_position;
hdata.home_team_big = ma.home_team_big;
hdata.away_team_big = ma.away_team_big;
hdata.match_type = ma.match_type;
hdata.match_time = ma.match_time;
hdata.asia_odds = ma.odds;
hdata.home_team = ma.home_team;
hdata.away_team = ma.away_team;
hdata.home_red_card = ma.home_red_card;
hdata.away_red_card = ma.away_red_card;
hdata.full_home_goals = ma.full_home_goals;
hdata.full_away_goals = ma.full_away_goals;
hdata.half_home_goals = ma.half_home_goals;
hdata.half_away_goals = ma.half_away_goals;
hdata.win_loss_big = ma.win_loss_big;
hdataHost.history_data_etl.Add(hdata);
}
mongo_HistoryDataTopJzDocument.MongoDropColCreateCol.Insert(hdataHost);
}
