public string GetTeamData(string triCode) { PlayoffTeam team = new PlayoffTeam(); try { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { var t = db.Teams.Where(n => n.DtvTricode.Equals(triCode)); foreach (var team1 in t) { team.TriCode = team1.DtvTricode; } } } catch (Exception e) { Console.WriteLine(e); } return(team.TriCode); }
public Injuries GetTeamData(string tricode) { Injuries injured = new Injuries(); try { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { var t = db.Teams.Where(n => n.DtvTricode.Equals(tricode)); foreach (var team1 in t) { injured.Logo = team1.DtvTricode; } } } catch (Exception e) { Console.WriteLine(e); } return(injured); }
public HomeSponsorPick LoadHomeTeam(string name) { HomeSponsorPick homeSponsorPick = new HomeSponsorPick(); try { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { var team = db.Teams.Where(t => t.TeamName == name); foreach (var t in team) { homeSponsorPick.CityName = t.City; homeSponsorPick.TeamLogo = t.DtvTricode; homeSponsorPick.TeamName = t.TeamName; } } } catch (Exception e) { Console.WriteLine(e); } return(homeSponsorPick); }
public AwaySponsorPick LoadAwayTeam(string name) { AwaySponsorPick awaySponsorPick = new AwaySponsorPick(); try { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { var team = db.Teams.Where(t => t.TeamName.Equals(name)); foreach (var t in team) { awaySponsorPick.CityName = t.City; awaySponsorPick.TeamLogo = t.DtvTricode; awaySponsorPick.TeamName = t.TeamName; } } } catch (Exception e) { Console.WriteLine(e); } return(awaySponsorPick); }
public string SetMap(CoreTeams selectedAwayTeams, CoreTeams selectedHomeTeams, string weatherId, string desc, string temp, string input) { StringBuilder mapString = new StringBuilder(); Team tempAway = null, tempHome = null, realAway = null, realHome = null; try { if (!selectedAwayTeams.Tricode.Equals("") && !selectedHomeTeams.Tricode.Equals("")) { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { List <Team> AllTeams = db.Teams.Where(t => t.TeamName != null).OrderBy(n => n.TeamName).ToList(); foreach (var team in AllTeams) { if (team.DtvTricode.Equals(selectedAwayTeams.Tricode)) { tempAway = team; } if (team.DtvTricode.Equals(selectedHomeTeams.Tricode)) { tempHome = team; } } if (tempHome != null && !tempHome.TeamName.Equals(selectedHomeTeams.Name.Trim())) { realHome = AllTeams.FirstOrDefault(n => n.TeamName.Equals(selectedHomeTeams.Name.Trim())); if (realHome != null) { mapString.Append(realHome.DtvTricode); mapString.Append(","); } else { box = MessageBox.Show(String.Format("{0} has been spelled wrong.", selectedHomeTeams.Name), "Misspelled Team Name", MessageBoxButton.OK); mapString.Append(""); mapString.Append(","); } } else { mapString.Append(selectedHomeTeams.Tricode); mapString.Append(","); } if (tempAway != null && !tempAway.TeamName.Equals(selectedAwayTeams.Name.Trim())) { realAway = AllTeams.FirstOrDefault(n => n.TeamName.Equals(selectedAwayTeams.Name.Trim())); if (realAway != null) { mapString.Append(realAway.DtvTricode); mapString.Append(","); } else { box = MessageBox.Show(String.Format("{0} has been spelled wrong.", selectedAwayTeams.Name), "Misspelled Team Name", MessageBoxButton.OK); mapString.Append(""); mapString.Append(","); } } else { mapString.Append(selectedAwayTeams.Tricode); mapString.Append(","); } } mapString.Append(weatherId.Equals("0") ? "" : weatherId); mapString.Append(","); mapString.Append(desc); mapString.Append(","); mapString.Append(temp); mapString.Append(","); mapString.Append(selectedHomeTeams.Stadium); if (input != null && !input.Equals("")) { string[] inputs = input.Split('-'); mapString.Append(","); mapString.Append(inputs[0]); mapString.Append(","); mapString.Append(inputs[1].Equals("EARLY") ? "0" : "1"); } else { mapString.Append(","); mapString.Append("0"); mapString.Append(","); mapString.Append("0"); } mapString.Append("|"); } } catch (Exception e) { Console.WriteLine(e); } return(mapString.ToString()); }
// NFL GETTY AND ACTION SHOTS\ public List <TopPassers> LoadPassers() { List <TopPassers> passers = new List <TopPassers>(); tri = ""; try { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { CurrentWeek cw = db.CurrentWeeks.FirstOrDefault(); //List<GamePasser> gamePassers = db.GamePassers.Where(g => g.GameKey != null).ToList(); List <GetWeekFantasyPassingLeaders_Result> gamePassers = db.GetWeekFantasyPassingLeaders(cw.Season, cw.SeasonType, cw.Week).ToList(); for (int i = 0; i < gamePassers.Count && i < 5; i++) { tri = gamePassers[i].Tricode.ToUpper(); _pic = String.Format("{0}_{1}_{2}_Action.png", gamePassers[i].Tricode.ToUpper(), gamePassers[i].LastName.ToUpper(), gamePassers[i].FirstName.ToUpper()); foreach (var key in diffTri) { if (tri.Equals(key.Value)) { tri = realTri[key.Key]; _pic = String.Format("{0}_{1}_{2}_Action.png", tri.ToUpper(), gamePassers[i].LastName.ToUpper(), gamePassers[i].FirstName.ToUpper()); } } _path = String.Format(@"U:\NFL GETTY AND ACTION SHOTS\{0}", _pic); if (!File.Exists(_path)) { _pic = String.Format(@"U:\RedZone\Headshots\{0}\{1}_{2}_{3}_B.png", tri, tri, gamePassers[i].LastName.ToUpper(), gamePassers[i].FirstName.ToUpper()); } else { _pic = String.Format(@"U:\NFL GETTY AND ACTION SHOTS\{0}_{1}_{2}_Action.png", tri, gamePassers[i].LastName.ToUpper(), gamePassers[i].FirstName.ToUpper()); } _name = String.Format("{0}, {1}", gamePassers[i].LastName, gamePassers[i].FirstName); passers.Add(new TopPassers { Picture = _pic, Name = _name, Tricode = tri, Position = gamePassers[i].Position, Completions = gamePassers[i].Completions.ToString(), Attempts = gamePassers[i].Attempts.ToString(), Yards = gamePassers[i].Yards.ToString(), Touchdowns = gamePassers[i].Touchdowns.ToString(), Interceptions = gamePassers[i].Interceptions.ToString(), CompletionPCT = gamePassers[i].CompletionPct, Average = gamePassers[i].YardsPerAttempt, Long = gamePassers[i].Long.ToString() }); } //passers.AddRange(game.Select(dtvGame => new TopPassers() // { // Picture = dtvGame.Channel, // Name = dtvGame.DtvTricodeAway, // Position = dtvGame.DtvTricodeHome, // Stats = dtvGame.GameDate // })); } } catch (Exception e) { //NotificationManager.Push("Error", "There was an error reading the database"); Console.WriteLine(e.ToString()); } return(passers); }
public void SetLiveVideos(string groupNum, string weekNumber, ObservableCollection <string> selectedInput, ObservableCollection <CoreTeams> home, ObservableCollection <CoreTeams> away) { StringBuilder teamStr = new StringBuilder(); Team tempAway = null, tempHome = null, realAway = null, realHome = null; Dictionary <int, string> teams = new Dictionary <int, string>(); string tempTeam = ""; for (int i = 0; i < selectedInput.Count; i++) { if (groupNum != null) { if (selectedInput[i] != null) { if (selectedInput[i].EndsWith(groupNum)) { using (DtvRedZoneEntities db = new DtvRedZoneEntities()) { List <Team> AllTeams = db.Teams.Where(t => t.TeamName != null).OrderBy(n => n.TeamName).ToList(); foreach (var team in AllTeams) { if (team.DtvTricode.Equals(away[i].Tricode)) { tempAway = team; } if (team.DtvTricode.Equals(home[i].Tricode)) { tempHome = team; } } if (tempHome != null && !tempHome.TeamName.Equals(home[i].Name.Trim())) { realHome = AllTeams.FirstOrDefault(n => n.TeamName.Equals(home[i].Name.Trim())); //teamStr.Append(realHome.DtvTricode); //teamStr.Append(","); tempTeam += realHome.DtvTricode; tempTeam += ","; } else { //teamStr.Append(home[i].Tricode); //teamStr.Append(","); tempTeam += home[i].Tricode; tempTeam += ","; } if (tempAway != null && !tempAway.TeamName.Equals(away[i].Name.Trim())) { realAway = AllTeams.FirstOrDefault(n => n.TeamName.Equals(away[i].Name.Trim())); //teamStr.Append(realAway.DtvTricode); tempTeam += realAway.DtvTricode; } else { //teamStr.Append(away[i].Tricode); tempTeam += away[i].Tricode; } } //teamStr.Append("|"); tempTeam += "|"; teams.Add(int.Parse(selectedInput[i][0].ToString()), tempTeam); tempTeam = ""; } } } } var sortedDict = (from entry in teams orderby entry.Key ascending select entry).ToDictionary(k => k.Key, v => v.Value); foreach (var pair in sortedDict) { teamStr.Append(pair.Value); } CurrentSession.VizEngine.Invoke("SetVideoData \"" + String.Format("{0}|{1}", weekNumber, teamStr) + "\""); CurrentSession.IPad.Invoke(String.Format("{0}4 {1}|{2}{3}", "\r\n", weekNumber, teamStr, "\r\n")); }