public ActionResult Index()
{
string user = User.Identity.GetUserId();
var tournaments = new TournamentsContext();
List<TournamentWithUserInfo> listOfTournaments =
tournaments.Database.SqlQuery<TournamentWithUserInfo>("TournamentsWithUserInfo @User", new SqlParameter("User", (user != null) ? user : "")).ToList();
//List<Tournament> listOfTournaments = tournaments.Tournament.ToList();
ViewBag.Signed = User.Identity.GetUserId();
return View(listOfTournaments);
}
public ActionResult MyTournaments()
{
var CurrentUserId = User.Identity.GetUserId();
var tournamentContext = new TournamentsContext();
List<Tournament> organizedTournaments = tournamentContext.Tournament.Where(t => t.OrganizerId == CurrentUserId).ToList();
var registrationContext = new RegistrationContext();
var registredTo = registrationContext.Registration.Where(r => r.UserId == CurrentUserId).ToList();
var participateTournaments = new List<Tournament>();
foreach (var reg in registredTo)
{
var tourn = tournamentContext.Tournament.Single(t => t.Id == reg.TournamentId);
participateTournaments.Add(tourn);
}
ViewBag.CountOrg = organizedTournaments.Count();
ViewBag.CountPart = participateTournaments.Count();
var tuple = new Tuple<List<Tournament>, List<Tournament>>(organizedTournaments, participateTournaments);
return View(tuple);
}
private Tournament ForDetails(string currentUser, int tournamentId)
{
var tournamentsContext = new TournamentsContext();
var tournament = tournamentsContext.Tournament.Single(t => t.Id == tournamentId);
ViewBag.tournamentId = tournament.Id;
var groupsContext = new GroupsContext();
var tournamentGroups = groupsContext.Groups.Where(g => g.IdTournament == tournament.Id).ToList();
ViewBag.Groups = tournamentGroups;
List<GroupWithUsers> allUsersInTournament = AllUsersInTournament(tournament.Id, tournamentGroups);
allUsersInTournament.Sort();
ViewBag.AllUsersInTournament = allUsersInTournament;
SelectList selectList = new SelectList(GetItemsForDropDownList(tournamentGroups), "Value", "Text");
ViewBag.SelectList = selectList;
ViewBag.InTournament = CurrentUserInTournament(tournament.Id, currentUser);
ViewBag.Paid = DidPay(tournamentId, currentUser);
ViewBag.IsAdmin = (currentUser == tournament.OrganizerId) ? true : false;
return tournament;
}
public ActionResult Create(Tournament tournament)
{
try
{
tournament.OrganizerId = User.Identity.GetUserId();
var tournamentContext = new TournamentsContext();
tournamentContext.Tournament.Add(tournament);
tournamentContext.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
