/* public string FranchisesDataString { get; set; } public string TeamsResultsDataString { get; set; } public string TeamsDrillDownDataString { get; set; } */ public async Task<bool> LoadFranchisesDataAsync(string cachedJson = "") { List<FranchiseModel> franchises; if (string.IsNullOrEmpty(cachedJson)) { var dataContext = new DataContext(); var svcResult = string.Empty; svcResult = await dataContext.GetFranchisesAsync(); if (svcResult == null) { return false; } //no results message //FranchisesDataString = svcResult; franchises = JsonConvert.DeserializeObject<List<FranchiseModel>>(svcResult); } else { franchises = JsonConvert.DeserializeObject<List<FranchiseModel>>(cachedJson); } var groupedItems = from franchise in franchises orderby franchise.Location select new TeamsFranchisesViewModel { FirstLetter = franchise.Location.Substring(0, 1), LineOne = franchise.GetDisplayName(), LineTwo = franchise.GetDetail(), TeamId = franchise.RetroId, Location = franchise.Location } into list group list by list.FirstLetter into listByYear select new KeyedList<string, TeamsFranchisesViewModel>(listByYear); if (FranchiseList.Count <= 0) { foreach (var franchise in franchises) { FranchiseList.Add(new TeamsFranchisesViewModel() { LineOne = franchise.GetDisplayName(), LineTwo = franchise.GetDetail(), TeamId = franchise.RetroId, Location = franchise.Location }); } } FranchiseItems.Clear(); foreach (var viewModelItem in groupedItems) { FranchiseItems.Add(viewModelItem); } return true; }
public async Task<bool> LoadTeamDrillDownDataAsync(TeamsContextViewModel context, string cachedJson = "") { List<TeamsDrillDownModel> items; if (string.IsNullOrEmpty(cachedJson)) { var dataContext = new DataContext(); var svcResult = string.Empty; svcResult = await dataContext.GetTeamDrillDownAsync(context.SelectedTeamId, context.SelectedOpponentId, context.SelectedYearId); if (svcResult == null) { return false; } //no results message //TeamsDrillDownDataString = svcResult; items = JsonConvert.DeserializeObject<List<TeamsDrillDownModel>>(svcResult); } else { items = JsonConvert.DeserializeObject<List<TeamsDrillDownModel>>(cachedJson); } var groupedItems = from item in items orderby item.GameDate descending select new TeamsDrillDownViewModel { GameDate = item.GameDate, Team = item.Team, Opponent = item.Opponent, Win = item.Win, Loss = item.Loss, RunsFor = item.RunsFor, RunsAgainst = item.RunsAgainst } into list group list by list.GameDate into listByYear select new KeyedList<string, TeamsDrillDownViewModel>(listByYear); TeamDrillDownItems.Clear(); foreach (var viewModelItem in groupedItems) { TeamDrillDownItems.Add(viewModelItem); } return true; }
public async Task<bool> LoadPlayerDrillDownDataAsync(PlayersContextViewModel context, string cachedJson = "") { List<PlayersDrillDownModel> items; if (string.IsNullOrEmpty(cachedJson)) { var dataContext = new DataContext(); var svcResult = string.Empty; svcResult = await dataContext.GetPlayerDrillDownAsync(context.SelectedBatterId, context.SelectedPitcherId, context.SelectedGameYear); if (svcResult == null) { return false; } //no results message //PlayersDrillDownDataString = svcResult; items = JsonConvert.DeserializeObject<List<PlayersDrillDownModel>>(svcResult); } else { items = JsonConvert.DeserializeObject<List<PlayersDrillDownModel>>(cachedJson); } var groupedItems = from item in items orderby item.GameDate descending select new PlayersDrillDownViewModel { GameDate = item.GameDate, AtBat = item.AtBat, Hit = item.Hit, Walks = item.Walks, SecondBase = item.SecondBase, ThirdBase = item.ThirdBase, HomeRun = item.HomeRun, RunBattedIn = item.RunBattedIn, StrikeOut = item.StrikeOut, Average = item.Average.ToString("N3", CultureInfo.InvariantCulture).TrimStart('0') } into list group list by list.GameDate into listByYear select new KeyedList<string, PlayersDrillDownViewModel>(listByYear); PlayerDrillDownItems.Clear(); foreach (var viewModelItem in groupedItems) { PlayerDrillDownItems.Add(viewModelItem); } return true; }
public async Task<bool> LoadPitcherDataAsync(PlayersContextViewModel context, string cachedJson = "") { List<PitcherModel> pitchers; if (string.IsNullOrEmpty(cachedJson)) { var dataContext = new DataContext(); var svcResult = string.Empty; svcResult = await dataContext.GetPitchersAsync(context.SelectedBatterId, context.SelectedYearId); if (svcResult == null) { return false; } //no results message //PitchersDataString = svcResult; pitchers = JsonConvert.DeserializeObject<List<PitcherModel>>(svcResult); } else { pitchers = JsonConvert.DeserializeObject<List<PitcherModel>>(cachedJson); } var groupedItems = from pitcher in pitchers orderby pitcher.FirstName select new PlayersPitchersViewModel { FirstLetter = pitcher.FirstName.Substring(0, 1), LineOne = pitcher.GetDisplayName(), PitcherId = pitcher.RetroId } into list group list by list.FirstLetter into listByYear select new KeyedList<string, PlayersPitchersViewModel>(listByYear); PitcherItems.Clear(); foreach (var viewModelItem in groupedItems) { PitcherItems.Add(viewModelItem); } return true; }
public async Task<bool> LoadTeamDataAsync(PlayersContextViewModel context, string cachedJson = "") { List<TeamModel> teams; if (string.IsNullOrEmpty(cachedJson)) { var dataContext = new DataContext(); var svcResult = string.Empty; svcResult = await dataContext.GetTeamsAsync(context.SelectedYearId); if (svcResult == null) { return false; } //no results message //TeamsDataString = svcResult; teams = JsonConvert.DeserializeObject<List<TeamModel>>(svcResult); } else { teams = JsonConvert.DeserializeObject<List<TeamModel>>(cachedJson); } var groupedItems = from team in teams orderby team.Location select new PlayersTeamsViewModel { FirstLetter = team.Location.Substring(0, 1), LineOne = team.GetDisplayName(), LineTwo = team.GetDetail(), TeamId = team.TeamId } into list group list by list.FirstLetter into listByYear select new KeyedList<string, PlayersTeamsViewModel>(listByYear); TeamItems.Clear(); foreach (var viewModelItem in groupedItems) { TeamItems.Add(viewModelItem); } return true; }
/* public string YearsDataString { get; set; } public string TeamsDataString { get; set; } public string BattersDataString { get; set; } public string PitchersDataString { get; set; } public string PlayersResultsDataString { get; set; } public string PlayersDrillDownDataString { get; set; } */ public async Task<bool> LoadYearDataAsync(PlayersContextViewModel context, string cachedJson = "") { List<YearModel> years; if (string.IsNullOrEmpty(cachedJson)) { var dataContext = new DataContext(); var svcResult = string.Empty; svcResult = await dataContext.GetYearsAsync(); if (svcResult == null) { return false; } //no results message //YearsDataString = svcResult; years = JsonConvert.DeserializeObject<List<YearModel>>(svcResult); } else { years = JsonConvert.DeserializeObject<List<YearModel>>(cachedJson); } YearItems.Clear(); foreach (var year in years) { this.YearItems.Add(new PlayersYearsViewModel() { LineOne = year.Id.ToString(CultureInfo.CurrentCulture) }); } return true; }