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