//------------------------------------------------------------------------------------------------------------------------------// List <VenueData> CreateVenues(LitJson.JsonData json) { List <VenueData> venues = new List <VenueData> (); var venuesJ = json["response"]["groups"][0]["items"]; for (int i = 0; i < venuesJ.Count; i++) { var venueJ = venuesJ[i]["venue"]; VenueData data = new VenueData(); data.id = (string)venueJ["id"]; data.title = (string)venueJ["name"]; try{ data.photo_prefix = (string)venueJ["featuredPhotos"]["items"][0]["prefix"]; data.photo_suffix = (string)venueJ["featuredPhotos"]["items"][0]["suffix"]; }catch (System.Exception e) { Debug.Log(e); } venues.Add(data); } return(venues); }
public void LoadData(CityData _city, CategoryData _category, VenueData _venue) { city = _city; category = _category; venue = _venue; // APIもしくはローカルキャッシュからサムネイルを取得 LoadVenuePhoto(); }
public bool VenueRegister(VenueData v) { bool result = true; int pass = db.usp_RegisterVenue(v.VenueName, v.VenueAddress, v.VenueCity, v.VenueState, v.VenueZipCode, v.VenuePhone, v.VenueEmail, v.VenueWebPage, v.VenueAgeRestriction, v.VenueLoginUserName, v.VenueLoginPasswordPlain); if (pass == -1) { result = false; } return(result); }
public Venue(int VenueID) { if (venueCache.Get("venue" + VenueID) == null) { _data = myDAO.GetVenueData(VenueID); venueCache.Insert("venue" + VenueID, _data, new TimeSpan(24, 0, 0)); } else { _data = (VenueData)venueCache.Get("venue" + VenueID); } }
//------------------------------------------------------------------------------------------------------------------------------// public void LoadData(CityData city, CategoryData category, VenueData venue) { TextMesh[] texts = transform.GetComponentsInChildren <TextMesh> (); foreach (TextMesh text in texts) { text.text = ""; } // 基本データを読み込む transform.FindChild("Info/Venue").GetComponent <TextMesh>().text = venue.title; transform.FindChild("Info/City-Category").GetComponent <TextMesh>().text = city.title + " : [ " + category.title + " ]"; // サムネイルを読み込む transform.FindChild("Venue").GetComponent <Venue>().ClearData(); transform.FindChild("Venue").GetComponent <Venue>().LoadData(city, category, venue); // API経由で詳細データを読み込む FourSquareAPI.Instance.LoadVenueInfo(venue.id, OnLoadData); }
public Geoposition(Geocoordinate coordinate, CivicAddress civicAddress = null, VenueData venueData = null) { CivicAddress = civicAddress; Coordinate = coordinate; VenueData = venueData; }
public void PushVenueScreen(CityData city, CategoryData category, VenueData venue) { //べニュー詳細スクリーンをロードする venueScreen.GetComponent <VenueScreen> ().LoadData(city, category, venue); base.PushScreen(venueScreen); }
private Venue(VenueData data) { _data = data; }
public static void doIt(string sched) { Schedule schedule = new Schedule(sched); // ***********PAUL CHANGE SQL STRING TO PARAMETERIZED COMMAND!!!******* // https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.parameters?redirectedfrom=MSDN&view=netframework-4.7.2#System_Data_SqlClient_SqlCommand_Parameters //--------------------------------------------------- // Insert the SCHEDULE into the DB int scheduleID = ScheduleData.InsertSchedule(schedule); int i = 0; //--------------------------------------------------- //--------------------------------------------------- // Insert the list of GAMEs into the DB // INCLUDES: Insert the TEAMs (insert the CONFERENCE, DIVISION, VENUE), VENUE, list of PERIODs, BOXSCOREs(insert the TEAMGAMESTATS(insert the PERSON/coach, list of PLAYERGAMESTATS), list of PERSON/officials), list of PLAYERs, list of GAMEEVENTs(insert TEAMs, list of PLAYERs), GAMECONTENT) if (Convert.ToInt16(schedule.totalGames) > 0) { foreach (Game g in schedule.games) { i = GameData.InsertGame(g, scheduleID); //--------------------------------------------------- // Insert the Home and Away TEAMs into the DB // INCLUDES: Insert the VENUE, list of PERIODs, BOXSCOREs(insert the TEAMGAMESTATS(insert the PERSON/coach, list of PLAYERGAMESTATS), list of PERSON/officials), list of PLAYERs, list of GAMEEVENTs(insert TEAMs, list of PLAYERs), GAMECONTENT) // Insert the Coach (PERSON) for each team if (!(g.gameBoxScore.homeTeamStats.coach is null)) { i = PersonData.InsertPerson(g.gameBoxScore.homeTeamStats.coach); } if (!(g.gameBoxScore.awayTeamStats.coach is null)) { i = PersonData.InsertPerson(g.gameBoxScore.awayTeamStats.coach); } // Insert the game VENUE if (!(g.gameVenue is null)) { i = VenueData.InsertVenue(g.gameVenue); } // Insert the game Officials (PERSON) if (!(g.gameBoxScore.officials is null)) { foreach (Person p in g.gameBoxScore.officials) { i = PersonData.InsertPerson(p); // Insert officials list to the cross reference table (tblGameOfficials) i = PersonData.InsertGameOfficials(g.gameID, p.personId); } } // Insert the Home Team: i = TeamData.InsertTeam(g.homeTeam); i = TeamData.InsertTeam(g.awayTeam); // Insert the CONFERENCE of each team: i = ConferenceData.InsertConference(g.homeTeam.teamConference); i = ConferenceData.InsertConference(g.awayTeam.teamConference); //Insert the DIVISION of each team: if (!(g.homeTeam.teamDivision is null)) { i = DivisionData.InsertDivision(g.homeTeam.teamDivision); } if (!(g.awayTeam.teamDivision is null)) { i = DivisionData.InsertDivision(g.awayTeam.teamDivision); } //Insert the PERIODs of the Game if (!(g.periodData is null)) { foreach (Period p in g.periodData) { i = PeriodData.InsertPeriod(p); } } // Insert the details and stats for each home PLAYER if (!(g.gameBoxScore.homeTeamStats.teamPlayers is null)) { foreach (PlayerGameStats homepgs in g.gameBoxScore.homeTeamStats.teamPlayers) { i = PlayerData.InsertPlayer(homepgs); i = PlayerGameStatsData.InsertPlayerGameStats(homepgs, g.gameID); } } // Insert the details and stats for each away PLAYER if (!(g.gameBoxScore.awayTeamStats.teamPlayers is null)) { foreach (PlayerGameStats awaypgs in g.gameBoxScore.awayTeamStats.teamPlayers) { i = PlayerData.InsertPlayer(awaypgs); i = PlayerGameStatsData.InsertPlayerGameStats(awaypgs, g.gameID); } } // Insert the GAMEEVENTS for the game if (!(g.gameEvents is null)) { foreach (GameEvent ge in g.gameEvents) { i = GameEventData.InsertGameEvent(ge, g.gameID); } } //--------------------------------------------------- } } }