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