public IActionResult Index(string activeConf = "all",
string activeDiv = "all")
{
var data = new TeamListViewModel
{
ActiveConf = activeConf,
ActiveDiv = activeDiv,
Conferences = context.Conferences.ToList(),
Divisions = context.Divisions.ToList()
};
IQueryable <Team> query = context.Teams;
if (activeConf != "all")
{
query = query.Where(
t => t.Conference.ConferenceID.ToLower() == activeConf.ToLower());
}
if (activeDiv != "all")
{
query = query.Where(
t => t.Division.DivisionID.ToLower() == activeDiv.ToLower());
}
data.Teams = query.ToList();
return(View(data));
}
public ActionResult Admin(int groupid)
{
//var teams = unitOfWork.TeamRepository.GetTeamsByGroup(groupid).ToList();
var group = unitOfWork.GroupRepository.GetByID(groupid);
var allteams = unitOfWork.TeamRepository.Get(filter: t => t.Status == Status.Active).ToList();
var teams = allteams.FindAll(t => t.CompTeams.Any(ct => ct.Competititon == groupid));
List <Teams> availableTeams = null;
if (group.Playoff == 1)
{
availableTeams = allteams.FindAll(t => t.CompTeams.Any(ct => ct.Groups.Competitions.ID == group.Competitions.ID));
}
else
{
availableTeams = allteams.FindAll(t => t.CompTeams.All(ct => ct.Groups.Competitions.Status == Status.Inactive) || t.CompTeams == null && t.CompTeams.All(ct => ct.Competititon != groupid));
}
TeamListViewModel model = new TeamListViewModel()
{
group = group,
teams = teams,
teams2join = availableTeams,
fixtures = unitOfWork.FixtureRepository.Get(filter: f => f.Group == groupid).GroupBy(f => f.Round)
};
return(View(model));
}
public async Task <IActionResult> Index()
{
var currentUser = await GetCurrentUserAsync();
TeamListViewModel viewModel = new TeamListViewModel();
viewModel.CurrentUser = currentUser;
viewModel.TeamList = await(
from t in _context.Team
join au in _context.ApplicationUsers on t.CaptainId equals au.Id into sub
from subq in sub.DefaultIfEmpty()
select new TeamDetailsViewModel
{
Team = new Team
{
Id = t.Id,
Name = t.Name,
DateCreated = t.DateCreated,
CaptainId = t.CaptainId
},
TeamCaptainFirstName = subq.FirstName,
TeamCaptainLastName = subq.LastName,
Wins = _context.Game.Where(g => (g.TeamAId == t.Id && g.TeamAScore > g.TeamBScore) || (g.TeamBId == t.Id && g.TeamBScore > g.TeamAScore)).Count(),
Losses = _context.Game.Where(g => (g.TeamAId == t.Id && g.TeamAScore < g.TeamBScore) || (g.TeamBId == t.Id && g.TeamBScore < g.TeamAScore)).Count(),
Ties = _context.Game.Where(g => (g.TeamAId == t.Id || g.TeamBId == t.Id) && (g.TeamAScore == g.TeamBScore && g.TeamAScore != null && g.TeamBScore != null)).Count()
}).OrderByDescending(t => t.RankingScore).ToListAsync();
return(View(viewModel));
}
public IActionResult Index(string activeConf = "all", string activeDiv = "all")
{
var session = new NFLSession(HttpContext.Session);
session.SetActiveConf(activeConf);
session.SetActiveDiv(activeDiv);
var model = new TeamListViewModel
{
ActiveConf = activeConf,
ActiveDiv = activeDiv,
Conferences = context.Conferences.ToList(),
Divisions = context.Divisions.ToList()
};
IQueryable <Team> query = context.Teams;
if (activeConf != "all")
{
query = query.Where(
t => t.Conference.ConferenceID.ToLower() == activeConf.ToLower());
}
if (activeDiv != "all")
{
query = query.Where(
t => t.Division.DivisionID.ToLower() == activeDiv.ToLower());
}
model.Teams = query.ToList();
return(View(model));
}
public RedirectToActionResult Change(TeamListViewModel model)
{
var session = new NFLSession(HttpContext.Session);
session.SetName(model.UserName);
return(RedirectToAction("Index", "Home", new { ActiveConf = session.GetActiveConf(), ActiveDiv = session.GetActiveDiv() }));
}
public IActionResult List()
{
var teamListViewModel = new TeamListViewModel();
teamListViewModel.CurrentLeague = "Champions League";
teamListViewModel.Teams = _teamsRepository.GetAllTeams();
return(View(teamListViewModel));
}
public List <PouleListViewModel> GetPoules(int seasonId, int categoryId, int regionId)
{
List <PouleListViewModel> poules = new List <PouleListViewModel>();
PouleListViewModel poule = new PouleListViewModel();
poule.id = -1;
using (OleDbCommand cmd = new OleDbCommand(
"SELECT Poule.id, poule_name, class_name, strength, Team.id AS team_id, club_name, team_number, class_level" +
" FROM Poule, Class, Team, Club" +
" WHERE Poule.class_id=Class.id" +
" AND Poule.id=Team.poule_id" +
" AND Team.club_id=Club.id" +
" AND season_id=" + seasonId +
" AND poule_category=" + categoryId +
" AND region_id=" + regionId +
" ORDER BY class_level ASC, class_name ASC, poule_name ASC, club_name ASC, team_number ASC", db))
using (OleDbDataReader dbReader = cmd.ExecuteReader())
{
int _pouleId = dbReader.GetOrdinal("id");
int _pouleName = dbReader.GetOrdinal("poule_name");
int _className = dbReader.GetOrdinal("class_name");
int _strength = dbReader.GetOrdinal("strength");
int _teamId = dbReader.GetOrdinal("team_id");
int _clubName = dbReader.GetOrdinal("club_name");
int _teamNumber = dbReader.GetOrdinal("team_number");
int _classLevel = dbReader.GetOrdinal("class_level");
while (dbReader.Read())
{
int pouleId = dbReader.GetInt32(_pouleId);
if (poule.id != pouleId)
{
poule = new PouleListViewModel();
poule.id = pouleId;
poule.pouleName = dbReader.GetString(_pouleName);
poule.className = dbReader.GetString(_className);
poule.strength = dbReader.GetInt32(_strength);
poule.classLevel = dbReader.GetInt32(_classLevel);
poule.teams = new List <TeamListViewModel>();
poules.Add(poule);
}
var team = new TeamListViewModel();
team.teamId = dbReader.GetInt32(_teamId);
team.clubName = dbReader.GetString(_clubName);
team.teamNumber = dbReader.GetInt32(_teamNumber);
poule.teams.Add(team);
}
}
return(poules);
}
public ActionResult Index()
{
var model = new TeamListViewModel()
{
teams = unitOfWork.TeamRepository.GetTeams().ToList()
};
return(View(model));
}
public ClubViewModel GetClubViewById(int id)
{
var clubView = Database.Instance.clubRepository.GetClubById(id);
if (clubView == null)
{
return(null);
}
clubView.clubNames = new List <string>();
List <int> clubIds = new List <int>();
if (!String.IsNullOrEmpty(clubView.website))
{
var clubs = Database.Instance.clubRepository.GetClubsWithWebsite(clubView.website);
foreach (var club in clubs)
{
clubView.clubNames.Add(club.clubName);
clubIds.Add(club.id);
}
}
else
{
clubIds.Add(id);
}
clubView.seasons = Database.Instance.clubRepository.GetClubsSeasons(clubIds);
List <int> seasonIds = clubView.seasons.Select(c => c.seasonId).ToList();
var teams = Database.Instance.teamRepository.GetTeamsByClubAndSeason(clubIds, seasonIds);
TeamListViewModel previousTeam = null;
foreach (var team in teams)
{
if (previousTeam == null ||
previousTeam.seasonId != team.seasonId ||
!(previousTeam.teamNumber == team.teamNumber &&
previousTeam.pouleCategory == team.pouleCategory &&
previousTeam.regionName.Equals(team.regionName) &&
previousTeam.className.Equals(team.className)))
{
previousTeam = team;
clubView.seasons.First(s => s.seasonId == team.seasonId).teams++;
}
}
var players = Database.Instance.playerRepository.GetPlayersFromClubs(clubIds);
clubView.playerCount = players.Count;
return(clubView);
}
public TeamListViewPage(ObservableCollection <Team> team)
{
InitializeComponent();
var viewModel = new TeamListViewModel();
viewModel.Navigation = this.Navigation;
viewModel.Message = this;
BindingContext = viewModel;
}
public TeamListViewPage()
{
InitializeComponent();
var viewModel = new TeamListViewModel();
viewModel.Message = this;
viewModel.Navigation = this.Navigation;
BindingContext = viewModel;
}
public async Task <IActionResult> Index()
{
var teams = await _unitOfWork.Teams.GetTeams();
var viewModel = new TeamListViewModel
{
Teams = _mapper.Map <IEnumerable <Team>, IEnumerable <TeamInfoViewModel> >(teams),
};
return(View(viewModel));
}
public IActionResult Index()
{
var session = new NFLSession(HttpContext.Session);
var model = new TeamListViewModel
{
ActiveConference = session.GetActiveConference(),
ActiveDivision = session.GetActiveDivision(),
Teams = session.GetTeams()
};
return(View(model));
}
public ViewResult Index()
{
var session = new NFLSession(HttpContext.Session);
var model = new TeamListViewModel
{
ActiveConf = session.GetActiveConf(),
ActiveDiv = session.GetActiveDiv(),
Teams = session.GetMyTeams()
};
return(View(model));
}
public ActionResult Group(int groupid)
{
TeamListViewModel model = new TeamListViewModel()
{
group = unitOfWork.GroupRepository.GetByID(groupid),
//teams = unitOfWork.TeamRepository.GetTeamsByGroup(groupid).ToList(),
table = unitOfWork.GroupTableRepository.Get(filter: gt => gt.ID == groupid).OrderBy(gt => gt.Poradi).ToList(),
fixtures = unitOfWork.FixtureRepository.Get(filter: f => f.Group == groupid).GroupBy(f => f.Round)
};
return(View(model));
}
public ActionResult ListTeams()
{
using (var db = new BettingSystemDbContext())
{
TeamListViewModel teams = new TeamListViewModel
{
Teams = db.Teams.ToList()
};
return(View(teams));
}
}
public IActionResult TeamList()
{
var userid = userManager.GetUserId(HttpContext.User);
TeamListViewModel teamListViewModel = new TeamListViewModel
{
User = userManager.Users.FirstOrDefault(u => u.Id == userid),
AllUsers = from m in userManager.Users where m.Id != userid select m,
};
return(View(teamListViewModel));
}
public MainWindowViewModel()
{
_teamListViewModel = ContainerHelper.Container.Resolve <TeamListViewModel>();
_teamAddEditViewModel = ContainerHelper.Container.Resolve <TeamAddEditViewModel>();
_scorerListViewModel = ContainerHelper.Container.Resolve <ScorerListViewModel>();
_scorerAddEditViewModel = ContainerHelper.Container.Resolve <ScorerAddEditViewModel>();
_scorerSetTeamsViewModel = ContainerHelper.Container.Resolve <ScorerSetTeamsViewModel>();
_loginViewModel = ContainerHelper.Container.Resolve <LoginViewModel>();
_startSessionViewModel = ContainerHelper.Container.Resolve <StartSessionViewModel>();
_saveSessionConfigViewModel = ContainerHelper.Container.Resolve <SaveSessionConfigViewModel>();
_loadConfigViewModel = ContainerHelper.Container.Resolve <LoadConfigViewModel>();
_deleteBadSessionViewModel = ContainerHelper.Container.Resolve <DeleteBadSessionViewModel>();
_sessionStartConfirmViewModel = ContainerHelper.Container.Resolve <SessionStartConfirmViewModel>();
_loadGameViewModel = ContainerHelper.Container.Resolve <LoadGameViewModel>();
_reportsListViewModel = ContainerHelper.Container.Resolve <ReportsListViewModel>();
_currentViewModel = _loginViewModel;
NavCommand = new RelayCommand <string>(OnNav);
_teamListViewModel.AddTeamRequested += NavToAddTeam;
_teamListViewModel.EditTeamRequested += NavToEditTeam;
_teamAddEditViewModel.Done += NavToTeamList;
_scorerListViewModel.AddScorerRequested += NavToAddScorer;
_scorerListViewModel.EditScorerRequested += NavToEditScorer;
_scorerListViewModel.AssociateTeamsRequested += NavToAssociateTeamsWithScorer;
_scorerAddEditViewModel.Done += NavToScorerList;
_scorerAddEditViewModel.AssociateTeamsRequested += NavToAssociateTeamsWithScorer;
_scorerSetTeamsViewModel.Done += NavToScorerList;
_startSessionViewModel.Done += NavToLogin;
_startSessionViewModel.LoadConfigRequested += NavToLoadConfig;
_startSessionViewModel.SaveConfigRequested += NavToSaveConfig;
_startSessionViewModel.StartSessionRequested += NavToConfirmSession;
_saveSessionConfigViewModel.Done += NavToLogin;
_loadConfigViewModel.Done += NavToLogin;
_loadConfigViewModel.UseConfigRequested += NavToConfirmSession;
_loadConfigViewModel.FailedLoadError += NavToBadSession;
_deleteBadSessionViewModel.Done += NavToLogin;
_sessionStartConfirmViewModel.Done += NavToLogin;
_sessionStartConfirmViewModel.StartSessionRequested += OpenScoringWindow;
_loadGameViewModel.StartGameRequested += LoadScoringWindow;
_loadGameViewModel.FailedLoadError += NavToBadSession;
_loadGameViewModel.Done += NavToLogin;
_reportsListViewModel.Done += NavToLogin;
}
public IActionResult Index(string activeConf = "all", string activeDiv = "all")
{
var session = new NFLSession(HttpContext.Session);
session.SetActiveConf(activeConf);
session.SetActiveDiv(activeDiv);
int?count = session.GetMyTeamCount();
if (count == null)
{
var cookies = new NFLCookies(Request.Cookies);
string[] ids = cookies.GetMyTeamsIDs();
List <Team> myteams = new List <Team>();
if (ids.Length > 0)
{
myteams = context.Teams
.Include(c => c.Conference)
.Include(d => d.Division)
.Where(t => ids.Contains(t.TeamID))
.ToList();
}
session.SetMyTeams(myteams);
}
var data = new TeamListViewModel
{
ActiveConf = activeConf,
ActiveDiv = activeDiv,
Conferences = context.Conferences.ToList(),
Divisions = context.Divisions.ToList()
};
IQueryable <Team> query = context.Teams;
if (activeConf != "all")
{
query = query.Where(t => t.Conference.ConferenceID.ToLower() == activeConf.ToLower());
}
if (activeDiv != "all")
{
query = query.Where(t => t.Division.DivisionID.ToLower() == activeDiv.ToLower());
}
data.Teams = query.ToList();
return(View(data));
}
public TeamListPage()
{
MessagingCenter.Subscribe <EditTeamPage>(this, "TeamEdited", (sender) => {
RefreshPage();
});
ViewModel = new TeamListViewModel();
ViewModel.FillTeams();
BindingContext = this;
InitializeComponent();
}
public IActionResult Index(string activeConf = "all", string activeDiv = "all")
{
var session = new NFLSession(HttpContext.Session);
session.SetActiveConference(activeConf);
session.SetActiveDivision(activeDiv);
int?count = session.GetTeamCount();
if (count == null)
{
var cookies = new NFLCookies(Request.Cookies);
string[] ids = cookies.GetTeamsIds();
List <Team> myTeams = new List <Team>();
if (ids.Length > 0)
{
myTeams = _ctx.Teams.Include(c => c.Conference)
.Include(d => d.Division)
.Where(t => ids.Contains(t.TeamID))
.ToList();
}
//this preserves the state of the cookies even after the browser has been closed...as long as it doesn't exceed 10days
session.SetTeams(myTeams);
}
var data = new TeamListViewModel
{
ActiveConference = activeConf,
ActiveDivision = activeDiv,
Conferences = _ctx.Conferences.ToList(),
Divisions = _ctx.Divisions.ToList()
};
IEnumerable <Team> query = _ctx.Teams;
if (activeConf != "all")
{
query = query.Where(t => t.Conference.ConferenceID.ToLower() == activeConf.ToLower());
}
if (activeDiv != "all")
{
query = query.Where(d => d.Division.DivisionID.ToLower() == activeDiv.ToLower());
}
data.Teams = query.ToList();
return(View(data));
}
//[Permission("幻灯片管理_删除幻灯片")]
public async Task <ActionResult> TeamList(string mobile, long?teamLevel, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
var res = await userService.GetModelTeamListAsync(mobile, teamLevel, keyword, startTime, endTime, pageIndex, pageSize);
TeamListViewModel model = new TeamListViewModel();
model.PageCount = res.PageCount;
model.TotalCount = res.TotalCount;
model.Members = res.Members;
model.TeamLevels = MyEnumHelper.GetEnumList <TeamLevelEnum>();
model.TeamLeader = res.TeamLeader;
return(Json(new AjaxResult {
Status = 1, Data = model
}));
}
public IActionResult Index(string activeConference = "all", string activeDivision = "all")
{
//Save to session
var session = new NFLSession(HttpContext.Session);
session.SetActiveConference(activeConference);
session.SetActiveDivision(activeDivision);
//Create cookie
int?teamCount = session.GetMyTeamCount();
if (teamCount == null)
{
var cookies = new NFLCookies(Request.Cookies);
string[] ids = cookies.GetMyTeamIds();
List <Team> myTeams = new List <Team>();
if (ids.Length > 0)
{
myTeams = context.Teams.Include(c => c.Conference).Include(d => d.Division).Where(t => ids.Contains(t.TeamID)).ToList();
session.SetMyTeams(myTeams);
}
}
var data = new TeamListViewModel {
ActiveConference = activeConference,
ActiveDivision = activeDivision,
Conferences = context.Conferences.ToList(),
Divsisions = context.Divisions.ToList()
};
IQueryable <Team> query = context.Teams;
if (activeConference != "all")
{
query = query.Where(t => t.Conference.ConferenceID.ToLower() == activeConference.ToLower());
}
if (activeDivision != "all")
{
query = query.Where(d => d.Division.DivisionID.ToLower() == activeDivision.ToLower());
}
data.Teams = query.ToList();
return(View(data));
}
public RedirectToActionResult TeamList(TeamListViewModel model)
{
var userid = userManager.GetUserId(HttpContext.User);
//var id = model.User.Id;
if (ModelState.IsValid)
{
var currentUser = userManager.Users.FirstOrDefault(u => u.Id == userid);
var selectedUser = userManager.Users.FirstOrDefault(u => u.Id == model.User.Id);
//currentUser.Team = new List<ApplicationUser>();
//model.MyTeam.Add(selectedUser);
currentUser.Team.Add(selectedUser);
}
return(RedirectToAction("teamlist", "community"));
}
public ActionResult Index(int?page, string qry, string sort, string disable, int?city, int?area)
{
TeamListViewModel model = new TeamListViewModel();
model.Filter.CurrentPage = page ?? 1;
model.Filter.QueryString = qry ?? string.Empty;
model.Filter.SortColumn = sort ?? string.Empty;
model.Filter.Disable = disable ?? string.Empty;
model.Filter.CityID = city;
model.Filter.AreaID = area;
model.Filter.DoPagination = false;
TeamModule mdu = new TeamModule();
model.Result = mdu.DoGetList(model.Filter);
TempData["CityData"] = mdu.GetCityData();
return(View("Team", model));
}
public IActionResult Index(TeamListViewModel model)
{
model.Conferences = context.Conferences.ToList();
model.Divisions = context.Divisions.ToList();
var session = new NFLSession(HttpContext.Session);
session.SetActiveConf(model.ActiveConf);
session.SetActiveDiv(model.ActiveDiv);
// if no count value in session, use data in cookie to restore fave teams in session
int?count = session.GetMyTeamCount();
if (count == null)
{
var cookies = new NFLCookies(HttpContext.Request.Cookies);
string[] ids = cookies.GetMyTeamIds();
List <Team> myteams = new List <Team>();
if (ids.Length > 0)
{
myteams = context.Teams.Include(t => t.Conference)
.Include(t => t.Division)
.Where(t => ids.Contains(t.TeamID)).ToList();
}
session.SetMyTeams(myteams);
}
IQueryable <Team> query = context.Teams;
if (model.ActiveConf != "all")
{
query = query.Where(
t => t.Conference.ConferenceID.ToLower() == model.ActiveConf.ToLower());
}
if (model.ActiveDiv != "all")
{
query = query.Where(
t => t.Division.DivisionID.ToLower() == model.ActiveDiv.ToLower());
}
model.Teams = query.ToList();
return(View(model));
}
// GET: Fixture
public ActionResult Index(int?groupid)
{
Groups group = unitOfWork.GroupRepository.GetByID((int)groupid);
if (group == null)
{
AddApplicationMessage("Skupina s tímto ID neexistuje", MessageSeverity.Danger);
return(RedirectToAction("Index", "Competitions"));
}
var fixtures = unitOfWork.FixtureRepository.Get(filter: f => f.Group == groupid).GroupBy(f => f.Round);
var model = new TeamListViewModel()
{
fixtures = fixtures,
group = unitOfWork.GroupRepository.GetByID(groupid)
};
return(View(model));
}
public async Task <IActionResult> Index(
CancellationToken cancellationToken = default)
{
try
{
SERVICES.Team[] teams = await _teamService.GetRankedTeamsAsync();
var model = new TeamListViewModel();
model.Teams = teams
.Select(x => _mapper.Map <TeamViewModel>(x))
.ToArray();
return(View(model));
}
catch (Exception ex)
{
return(this.HandleException(ex, message: ex.Message, logger: _logger));
}
}
// GET: Teams
public ActionResult Index(string search, int?sportId)
{
var teams = Teams_db.GetList(x => x.Sport);
var sports = Sports_db.GetList();
if (!string.IsNullOrEmpty(search))
{
teams = teams.Where(s => s.Name.ToLower().Contains(search) || s.Sport.Name.ToLower().Contains(search)).ToList();
}
if (sportId != null)
{
teams = teams.Where(s => s.SportId == sportId).ToList();
}
var viewModel = new TeamListViewModel()
{
Teams = teams,
Sports = new SelectList(sports, "Id", "Name")
};
return(View(viewModel));
}
public ActionResult TeamList()
{
var ds = Sitecore.Context.Database.GetItem(RenderingContext.CurrentOrNull.Rendering.DataSource);
if (ds == null || ds.TemplateID.ToString() != Constants.Templates.TeamList.TemplateId)
{
return(View());
}
var viewModel = new TeamListViewModel()
{
Title = ds[Constants.Templates.TeamList.Title],
Teams = new List <Team>()
};
foreach (Item child in ds.Axes.GetDescendants())
{
if (child.TemplateID.ToString() == Hackathon.Foundation.Teams.Constants.Templates.Team.TemplateId)
{
viewModel.Teams.Add(_teamsRepository.GetTeamFromItem(child));
}
}
return(View(viewModel));
}
