public async Task AddGGTeamToSQL(Match teamInfo,string key) { APIRequest ApiReq = new APIRequest (); DBComm command = new DBComm (key); Team team = new Team (); team.Name= teamInfo.Groups [2].Value; string logoUrl="http://www.gosugamers.net/"+teamInfo.Groups [1].Value; string tag=teamInfo.Groups [2].Value; team.Tag = tag; if (tag.Length > 10) { team.Tag = tag.Substring (0, 10); } team.LogoByte = await ApiReq.FetchByteArrAsync (logoUrl); command.Connect.Insert (team); command.Connect.Dispose(); }
public async Task AddTeamDotaToSQL(int id) { string url = "https://api.steampowered.com/IDOTA2Match_570/GetTeamInfoByTeamID/v1/?key=6A9C411A88D047DA4C9E843EDF0B02F5&" + "format=json&language=en_us&start_at_team_id="+id+"&teams_requested=1"; var ApiReq = new APIRequest (); //var PlayerReq = new Player (); var comm = new DBComm (); JToken temp = await ApiReq.FetchJsonAsync (url); //JObject jt = JObject.Parse (temp); string status = (string)temp.SelectToken("result.status"); JToken teams = (JToken)temp.SelectToken("result.teams"); if ((int)temp.SelectToken("result.teams[0].team_id")==id){ JToken teamJS = teams[0]; var newTeam = new Team (); newTeam.TeamId = (int)teamJS.SelectToken("team_id"); newTeam.Name = (string)teamJS.SelectToken("name"); newTeam.Tag = (string)teamJS.SelectToken("tag"); newTeam.LogoUGCId = (string)teamJS.SelectToken("logo"); newTeam.LogoByte = await GetTeamLogoAPI (newTeam.LogoUGCId); comm.Connect.Insert(newTeam); comm.Connect.Dispose (); /* for(int i=0;i<10;i++) { if ((teamJS.SelectToken("player_" + i + "_account_id"))!=null) { var newPlayer = new Player (); int playerId = (int)teamJS.SelectToken("player_" + i + "_account_id"); newPlayer=await newPlayer.GetPlayerAPI (Convert.ToInt64(playerId), newTeam.TeamId); comm.Connect.Insert (newPlayer); } else { comm.Connect.Dispose (); break; } }*/ System.Console.Out.WriteLine ("ID {0}", newTeam.ID); } }