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