Пример #1
0
		public async void AddGameItemToSQL()
		{
		
			string url = "https://api.steampowered.com/IEconDOTA2_570/GetGameItems/v1/?key=6A9C411A88D047DA4C9E843EDF0B02F5&format=json&" +
				"language=en_us";
			var ApiReq = new APIRequest ();
			var comm = new DBComm ();
			var temp = (JToken)await ApiReq.FetchJsonAsync (url);
			var jItems = (JToken)temp.SelectToken ("result.items");

				foreach (JToken jItem in jItems) {
					var item = new Item ();
					string cdnUrl = "http://cdn.dota2.com/apps/dota2/images/items/";
					item.ItemId = (int)jItem.SelectToken ("id");
					item.Name = (string)jItem.SelectToken ("name");
					item.LocalName = (string)jItem.SelectToken ("localized_name");
					string itemName = item.Name;
					itemName=itemName.Substring(itemName.IndexOf("_")+1);
					item.ImageUrl = cdnUrl+itemName+"_lg.png";
					try {
						comm.Connect.Insert(item);
						Console.Out.WriteLine (item.LocalName);
					} catch (SQLiteException e) {
						Console.Out.WriteLine (e.Message);
					}
			}
			comm.Connect.Dispose ();
		}
Пример #2
0
		public async void AddGameHeroToSQl ()
		{

			string url = "https://api.steampowered.com/IEconDOTA2_570/GetHeroes/v1/?key=6A9C411A88D047DA4C9E843EDF0B02F5&format=json&" +
				"language=en_us&itemizedonly=0";
			var ApiReq = new APIRequest ();
			var comm = new DBComm ();
			var temp = (JToken)await ApiReq.FetchJsonAsync (url);
			var jHeroes = (JToken)temp.SelectToken ("result.heroes");
			foreach (JToken jHero in jHeroes) {
				var hero = new Hero ();
				string cdnUrl = "http://cdn.dota2.com/apps/dota2/images/heroes/";
				hero.HeroId =(int) jHero.SelectToken ("id");
				hero.Name = (string)jHero.SelectToken ("name");
				hero.LocalName = (string)jHero.SelectToken ("localized_name");
				string heroName = hero.Name;
				heroName = heroName.Substring (14);
				hero.SHorImgUrl = cdnUrl+heroName+"_sb.png";
				hero.LHorImgUrl = cdnUrl+heroName+"_lg.png";
				hero.FHorImgUrl = cdnUrl+heroName+"_full.png";
				hero.FVerImgUrl = cdnUrl+heroName+"_vert.jpg";
				try {
						comm.Connect.Insert(hero);
						Console.Out.WriteLine (hero.LocalName);

				} catch (SQLiteException e) {
					Console.Out.WriteLine (e.Message);
				}
			}

		}
Пример #3
0
		public Hero GetHeroFromSQL(int id)
		{
			DBComm comm = new DBComm ();
			//using (var conn= new SQLiteConnection 
			var hero = comm.Connect.Table<Hero>().Where (i => i.HeroId == id).ToList();
			comm.Connect.Dispose();
			return hero [0];


		}
Пример #4
0
		public async Task<CSMap> GetMap(int id)
		{
			DBComm command = new DBComm ("CSGO");
			var temp = command.Connect.Table<CSMap> ().Where (x => x.MapId == id).ToList ();
			command.Connect.Dispose();
			if (temp.Count == 0) {
				var deck=await AddMap (id);
				return deck;
			}
			return temp [0];
		}
Пример #5
0
		public League GetLeagueFromSQL(int leagueId)
		{
			if (leagueId == 0)
				return new League();
			DBComm comm = new DBComm ();
			//using (var conn= new SQLiteConnection 
			var league = comm.Connect.Table<League>().Where (i => i.LeagueId == leagueId).ToList();
			//Console.Out.WriteLine ("id: {0}" + " \nName: {1}", team[0].TeamId, team[0].Name);
			comm.Connect.Dispose();
			if (league.Count == 0)
				return new League ();
			return league [0];
		}
Пример #6
0
		public async Task<League> AddLeague(int id,string gameName)
		{
			string url = SettingsDB.ServerAPIAddress+gameName+"/GetLeague?league_id="+id;
			var ApiReq = new APIRequest ();
			var comm = new DBComm ();
			JToken temp = await ApiReq.GetJsonAsync (url);
			var league = JsonConvert.DeserializeObject<League> (temp.ToString ());
			if (temp.ToString () != "") {
				comm.Connect.Insert (league);
				comm.Connect.Dispose ();
			}
			return league;
		}
Пример #7
0
		public async Task<League> GetLeague(int leagueId,string gameName)
		{
			if (leagueId == 0)
				return null;
			DBComm comm = new DBComm (gameName);
			var league = comm.Connect.Table<League>().Where (i => i.LeagueId == leagueId).ToList();
			comm.Connect.Dispose();
			if (league.Count == 0) {
				var temp = await AddLeague (leagueId,gameName);
				return temp;
			}
			return league[0];
		}
Пример #8
0
		public async Task<CSMap> AddMap(int id)
		{
			string url = SettingsDB.ServerAPIAddress+"CSGO/GetMap?map_id="+id;
			var ApiReq = new APIRequest ();
			DBComm command = new DBComm ("CSGO");
			JToken temp = await ApiReq.GetJsonAsync (url);
			var map = JsonConvert.DeserializeObject<CSMap> (temp.ToString ());
			if (temp.ToString () != "") {
				command.Connect.Insert (map);
				command.Connect.Dispose ();
			}
			return map;
		}
Пример #9
0
 public List<EnemyHero> FindEnemies(List<int> listFriendsHero,List<int> listEnemiesHero)
 {
     DBComm Command = new DBComm ();
     List<EnemyHero> listEnemies = new List<EnemyHero> ();
     //FriendsHero friends;
     for (var i = 0; i < listFriendsHero.Count; i++) {
         var id = listFriendsHero [i];
         for (var j = i; j < listEnemiesHero.Count; j++) {
             var id1 = listEnemiesHero [j];
             var temp = Command.Connect.Table<EnemyHero> ().Where (enemy => enemy.HeroId == id && enemy.EnemyHeroId == id1).ToList ();
             listEnemies.AddRange (temp);
         }
     }
     return listEnemies;
 }
Пример #10
0
		public async Task<Player> GetPlayerFromSQL(long steamId)
		{
			var player = new Player ();
			DBComm comm = new DBComm ();
			//using (var conn= new SQLiteConnection 
			//var id = Convert.ToInt32 (teamId);
			var players = comm.Connect.Table<Player>().Where (i => i.SteamId32 == steamId).ToList();
			if (players.Count == 0) {
				player = await GetPlayerAPI (steamId);
				//player = comm.Connect.Table<Player>().Where (i => i.SteamId32 == steamId).ToList();
				return player;
			} else {
				return players [0];
			}


		}
Пример #11
0
		public Item GetItemFromSQL(int id)
		{
			Item item1 = new Item();
			item1.ImageByte=new byte[256];
			if (id == 0) {
				return item1;
			}
			DBComm comm = new DBComm ();
			var item = comm.Connect.Table<Item>().Where (i => i.ItemId == id).ToList();
			comm.Connect.Dispose();
			if (item.Count == 0) {
				return item1;
			} else {
				return item [0];
			}

		}
Пример #12
0
		public List<League> GetLastLeague(int unixDtStop)
		{
			DBComm comm = new DBComm ();
			//DateTime dtNow = DateTime.UtcNow;
			//var dtStop = dtNow.AddDays (-3);
			//var unixDtStop=(int)(dtStop - new DateTime (1970, 1, 1,0,0,0,System.DateTimeKind.Utc)).TotalSeconds;
			var leaguePremium = comm.Connect.Table<League> ().Where (i => i.Tier == "premium").ToList();
			leaguePremium = leaguePremium.GetRange (leaguePremium.Count-10, 10).ToList ();
			var listleaguePremium=new List<League>();
			foreach (var leag in leaguePremium) {
				if (leag.StopTime > unixDtStop || leag.StopTime==0) {
					listleaguePremium.Add (leag);
				}
			}
			var leagueProfessional = comm.Connect.Table<League>().Where (i => i.Tier == "professional").ToList();
			var listleagueProfessional = leagueProfessional.GetRange (leagueProfessional.Count-10, 10).ToList ();
			listleaguePremium.AddRange (listleagueProfessional);
			return listleaguePremium;
		}
Пример #13
0
		protected override void OnCreate (Bundle bundle)
		{
			//RequestWindowFeature(WindowFeatures.NoTitle);
			base.OnCreate (bundle);
			Density.GetDensity (this);
			DBComm comm = new DBComm (true);
			comm.CopyDatabase (this.ApplicationContext);

			// Set our view from the "main" layout resource
			SetContentView (Resource.Layout.Main);
			CheckFirstRun ();
			//pb.Visibility=ViewStates.Visible;
			ActionBarTitle.SetTitle (this,Resource.Layout.ActionBarLayout,Resources.GetString(Resource.String.app_name),"DOTA 2");
			int resId = Resources.GetIdentifier("action_bar_container", "id", "android");
			var view = FindViewById<View> (resId);
			buttonRefresh=view.FindViewById<Button>(Resource.Id.buttonRefreshActionBar);
			buttonRefresh.Click += ButtonRefreshClick;	
			Button buttonGame = view.FindViewById<Button> (Resource.Id.buttonChangeGame);
			buttonGame.Click += buttomGameChangeClick;
			pb=view.FindViewById<ProgressBar> (Resource.Id.progressBar3);
			//pb.Visibility= ViewStates.Gone;
			//mActionBar.SetDisplayShowCustomEnabled(true);
			//You can now use and reference the ActionBar
			ActionBar.NavigationMode = ActionBarNavigationMode.Tabs;
			cts = new CancellationTokenSource ();
			SettingsApp.GameName="DOTA2";
			SettingsApp.ResourceId=Resource.Drawable.dota2_icon;
			fragmentsTab = new Fragment[] {
				new FragmentTabRecent (cts,this),
				new FragmentTabLive (cts,this),
				new FragmentTabUpcoming (cts,this)
			};
			AddTabToActionBar (Resource.String.tabRecent, 0);
			AddTabToActionBar (Resource.String.tabLive, 0);
			AddTabToActionBar (Resource.String.tabUpcoming, 0);
		}
Пример #14
0
		public async Task<Team> AddTeam(int id,string gameName)
		{
			string url = SettingsDB.ServerAPIAddress + gameName + "/GetTeam?team_id=" + id;
			var ApiReq = new APIRequest ();
			//var PlayerReq = new Player ();
			var comm = new DBComm (gameName);
			JToken temp = await ApiReq.GetJsonAsync (url);
			var team = JsonConvert.DeserializeObject<Team> (temp.ToString ());
			if (temp.ToString () != "") {
				comm.Connect.Insert (team);
				comm.Connect.Dispose ();
			}
			return team;


		}
Пример #15
0
		public async Task<Team> GetTeam(int teamId,string gameName)
		{
			if (teamId == 0)
				return null;
			DBComm comm = new DBComm (gameName);
			var id = Convert.ToInt32 (teamId);
			var team = comm.Connect.Table<Team>().Where (i => i.TeamId == id).ToList();
			comm.Connect.Dispose();
			if (team.Count == 0) {
				//return new Team();
				var temp = await AddTeam (id, gameName);
				return temp;
			}
			return team [0];

		}
Пример #16
0
		public Team GetGGTeamFromSQL(string teamName, string key)
		{
			DBComm command = new DBComm (key);
			Team team = null;
			var temp = command.Connect.Table<Team> ().Where (x => x.Name == teamName).ToList ();
			command.Connect.Dispose();
			if (temp.Count == 0)
				return team;
			return temp [0];
		}
Пример #17
0
		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();
		}
Пример #18
0
		public async Task<Team> GetGGTeamFromSQL(Match teamInfo,string key)
		{
			DBComm command = new DBComm (key);
			string name= teamInfo.Groups [2].Value;
			var temp = command.Connect.Table<Team> ().Where (x => x.Name == name).ToList ();
			if (temp.Count == 0) {
				await AddGGTeamToSQL (teamInfo, key);
				temp = command.Connect.Table<Team> ().Where (x => x.Name == name).ToList ();
			}
			command.Connect.Dispose();
			return temp [0];
		}
Пример #19
0
		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);
			}
		}
Пример #20
0
		public void UpdateTeamDotaToSQL(int teamId)
		{
			DBComm comm = new DBComm ();
		}
Пример #21
0
		public async Task<Team> GetTeamDotaFromSQL(JToken teamId)
		{
			if (teamId == null)
				return new Team();
			DBComm comm = new DBComm ();
			//using (var conn= new SQLiteConnection 
			var id = Convert.ToInt32 (teamId);
			var team = comm.Connect.Table<Team>().Where (i => i.TeamId == id).ToList();
			if (team.Count == 0) {
				await AddTeamDotaToSQL (id);
				team = comm.Connect.Table<Team>().Where (i => i.TeamId == id).ToList();

			}
			System.Console.Out.WriteLine ("id: {0}" + " \nName: {1}", team[0].TeamId, team[0].Name);
			comm.Connect.Dispose();
			return team [0];
		}
Пример #22
0
        public List<FriendHero> FindFriends(List<int> listHeroes)
        {
            DBComm Command = new DBComm ();
            List<FriendHero> listFriends = new List<FriendHero> ();

            //FriendsHero friends;
            for (var i = 0; i < listHeroes.Count-1; i++) {
                var id = listHeroes [i];
                for (var j = i+1; j < listHeroes.Count; j++) {
                    var id1 = listHeroes [j];
                    var temp = Command.Connect.Table<FriendHero> ().Where (friend => friend.HeroId== id && friend.FriendHeroId == id1).ToList ();
                    listFriends.AddRange (temp);
                }
            }
            return listFriends;
        }
Пример #23
0
 public int QualityPick(List<int> listHeroes)
 {
     var quality = 0;
     DBComm Command = new DBComm ();
     for (var i = 0; i < listHeroes.Count; i++) {
         var id = listHeroes [i];
         if (id != 0) {
             var temp = Command.Connect.Table<HeroDescription> ().Where (hero => hero.HeroId == id).ToList ();
             quality += temp [0].AOE;
             quality += temp [0].Support;
             quality += temp [0].ThroughImmunity;
             quality += temp [0].Ranged;
             quality += temp [0].Disabler;
             quality += temp [0].Durable;
             quality += temp [0].Escape;
             quality += temp [0].Healer;
             quality += temp [0].Initiator;
             quality += temp [0].Nuker;
             quality += temp [0].Pusher;
         }
     }
     return quality;
 }
Пример #24
0
		public Team GetOnlyTeamDotaFromSQL(JToken teamId)
		{
			if (teamId == null||teamId.ToString()=="")
				return new Team();
			DBComm comm = new DBComm ();
			//using (var conn= new SQLiteConnection 
			var id = Convert.ToInt32 (teamId);
			var team = comm.Connect.Table<Team>().Where (i => i.TeamId == id).ToList();
			//Console.Out.WriteLine ("id: {0}" + " \nName: {1}", team[0].TeamId, team[0].Name);
			comm.Connect.Dispose();
			return team [0];
		}