public ActionResult ExportToExcel(int?leagueId, int?teamId, int?currentLeagueId, int?seasonId, FormCollection form) { var xlsService = new ExcelGameService(); var gameIds = Session["GameIds"] != null ? (int[])Session["GameIds"] : new int[] { }; var games = new List <ExcelGameDto>(); bool isBasketBallOrWaterPolo = false; if (leagueId.HasValue) { isBasketBallOrWaterPolo = leagueRepo.IsBasketBallOrWaterPoloLeague(leagueId.Value); games = xlsService.GetLeagueGames(leagueId.Value, gameIds).ToList(); } else if (teamId.HasValue) { if (!seasonId.HasValue) { seasonId = teamRepo.GetSeasonIdByTeamId(teamId.Value, DateTime.Now); } isBasketBallOrWaterPolo = seasonsRepository.IsBasketBallOrWaterPoloSeason(seasonId.Value); if (currentLeagueId.HasValue) { games = xlsService.GetTeamGames(teamId.Value, currentLeagueId.Value, gameIds, seasonId).ToList(); } else { games = xlsService.GetTeamGames(teamId.Value, gameIds, seasonId).ToList(); } } return(ToExcel(games, isBasketBallOrWaterPolo)); }
public ActionResult ExportToExcelUnion(List <int> leaguesId, int sortType, int seasonId) { leaguesId = (List <int>)Session["LeaguesIds"]; var xlsService = new ExcelGameService(); bool isBasketBallOrWaterPolo = false; var games = new List <ExcelGameDto>(); foreach (var leagueId in leaguesId) { games.AddRange(xlsService.GetLeagueGames(leagueId, seasonId)); } if (games?.Count() > 0) { isBasketBallOrWaterPolo = gamesRepo.IsBasketBallOrWaterPoloGameCycle(games[0].GameId); } if (sortType == 1) { games = games.OrderBy(x => x.Date).ToList(); } if (sortType == 2) { games = games.OrderBy(x => x.Auditorium).ToList(); } return(ToExcel(games, isBasketBallOrWaterPolo)); }
public ActionResult ExportToExcel(int?leagueId, int?teamId, int?currentLeagueId, int?seasonId, int dateFilterType = Schedules.DateFilterPeriod.All, DateTime?dateFrom = null, DateTime?dateTo = null) { var xlsService = new ExcelGameService(); bool userIsEditor = User.IsInAnyRole(AppRole.Admins, AppRole.Editors, AppRole.Workers); var games = new List <ExcelGameDto>(); bool isBasketBallOrWaterPolo = false; if (leagueId.HasValue) { isBasketBallOrWaterPolo = leagueRepo.IsBasketBallOrWaterPoloLeague(leagueId.Value); switch (dateFilterType) { case Schedules.DateFilterPeriod.BeginningOfMonth: games = xlsService.GetLeagueGames(leagueId.Value, userIsEditor, Schedules.FirstDayOfMonth, null).ToList(); break; case Schedules.DateFilterPeriod.Ranged: games = xlsService.GetLeagueGames(leagueId.Value, userIsEditor, dateFrom, dateTo).ToList(); break; default: games = xlsService.GetLeagueGames(leagueId.Value, userIsEditor, null, null).ToList(); break; } } else if (teamId.HasValue) { if (!seasonId.HasValue) { seasonId = teamRepo.GetSeasonIdByTeamId(teamId.Value, DateTime.Now); } isBasketBallOrWaterPolo = seasonsRepository.IsBasketBallOrWaterPoloSeason(seasonId.Value); if (currentLeagueId.HasValue) { games = xlsService.GetTeamGames(teamId.Value, currentLeagueId.Value, seasonId).ToList(); } else { games = xlsService.GetTeamGames(teamId.Value, seasonId).ToList(); } } return(ToExcel(games, isBasketBallOrWaterPolo)); }