public void CreateLeague(string name, string type, int userid)
{
using (var db = new MyLeaguesEntities())
{
League l = new League();
l.LeagueName = name;
l.LeagueType = type;
l.CreatedOn = DateTime.Now;
l.IsDeleted = false;
l.MemberCount = 1;
db.Leagues.Add(l);
db.SaveChanges();
UserLeague ul = new UserLeague();
ul.UserID = userid;
ul.PointsAllowed = 0;
ul.PointsScored = 0;
ul.Wins = 0;
ul.Losses = 0;
ul.LeagueID = l.ID;
ul.IsDeleted = false;
ul.CreatedOn = DateTime.Now;
db.UserLeagues.Add(ul);
db.SaveChanges();
}
}
public async Task <IActionResult> PutUserLeague([FromRoute] int id, [FromBody] UserLeague userLeague)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userLeague.UserLeagueID)
{
return(BadRequest());
}
_context.Entry(userLeague).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserLeagueExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
// GET: UserLeagues/Create
public ActionResult Create(int id)
{
var league = _db.Leagues.Find(id);
if (league == null)
{
return(HttpNotFound());
}
ViewBag.LeagueName = league.LeagueName;
var list = _db.Users.Where(x => x.Roles != "Mailer" && x.Roles != "Admin").ToList();
foreach (var userLeague in _db.UserLeagues.Where(x => x.LeagueId == id))
{
if (list.Any(x => x.id == userLeague.UserId))
{
list.RemoveAll(x => x.id == userLeague.UserId);
}
}
ViewBag.UserId = new SelectList(list, "id", "username");
var userleague = new UserLeague()
{
LeagueId = id
};
return(View(userleague));
}
public ActionResult Edit([Bind(Include = "id,UserId,LeagueId,Roles,rowversion")] UserLeague userLeague)
{
try
{
if (ModelState.IsValid)
{
_db.Entry(userLeague).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index", new { id = userLeague.LeagueId }));
}
}
catch (DbUpdateConcurrencyException ex)
{
var entry = ex.Entries.Single();
var clientValues = (UserLeague)entry.Entity;
var databaseEntry = entry.GetDatabaseValues();
if (databaseEntry == null)
{
ModelState.AddModelError(string.Empty,
"Unable to save changes. The member was deleted by another user.");
}
else
{
var databaseValues = (UserLeague)databaseEntry.ToObject();
if (databaseValues.UserId != clientValues.UserId)
{
ModelState.AddModelError("User", "Current value: "
+ databaseValues.User.username);
}
if (databaseValues.LeagueId != clientValues.LeagueId)
{
ModelState.AddModelError("League", "Current value: "
+ databaseValues.League.LeagueName);
}
if (databaseValues.Roles != clientValues.Roles)
{
ModelState.AddModelError("Roles", "Current value: "
+ databaseValues.Roles);
}
ModelState.AddModelError(string.Empty, "The record you attempted to edit "
+ "was modified by another user after you got the original value. The "
+ "edit operation was canceled and the current values in the database "
+ "have been displayed. If you still want to edit this record, click "
+ "the Save button again. Otherwise click the Back to List hyperlink.");
userLeague.rowversion = databaseValues.rowversion;
}
}
catch (Exception dex)
{
//Log the error (uncomment dex variable name and add a line here to write a log.)
ModelState.AddModelError("",
"Unable to save changes. Try again, and if the problem persists, see your system administrator.");
ErrorSignal.FromCurrentContext().Raise(dex);
}
return(View(userLeague));
}
public async Task <bool> SetActiveLeague([FromBody] UserLeague league)
{
var status = await _lrepo.UpdateAsync(ApiHelper.LeagueApiSetActivePath, league);
if (status)
{
return(true);
}
return(false);
}
public async Task <IActionResult> PostUserLeague([FromBody] LeagueUserViewModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//HttpContext.User
var userId = _caller.Claims.Single(c => c.Type == "id");
var appuser = await _context.AppUser.Include(c => c.IdentityUser).SingleAsync(c => c.IdentityUser.Id == userId.Value);
bool exists = false;
var checkLeague = _context.UserLeagues.ToList();
var league = _context.Leagues.ToList();
UserLeague userLeague = new UserLeague();
Team userTeam = new Team();
userTeam.TeamName = model.teamName;
userLeague.LeagueForeignKey = model.leagueId;
userLeague.AppUserForeignKey = appuser.Id;
foreach (UserLeague CL in checkLeague)
{
if (CL.LeagueForeignKey == userLeague.LeagueForeignKey && CL.AppUserForeignKey == userLeague.AppUserForeignKey)
{
exists = true;
}
}
if (exists == false)
{
foreach (League L in league)
{
if (userLeague.LeagueForeignKey == L.LeagueId)
{
L.userCount += 1;
_context.Entry(L).State = EntityState.Modified;
}
}
var team = _context.Teams.Add(userTeam).Entity;
userLeague.Team = team;
userLeague.TeamForeignKey = team.TeamID;
_context.UserLeagues.Add(userLeague);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUserLeague", new { id = userLeague.UserLeagueID }, userLeague));
}
else
{
return(BadRequest("User Already in League"));
}
}
public IHttpActionResult GetUserLeague(int id)
{
UserLeague userLeague = db.UserLeagues.Find(id);
if (userLeague == null)
{
return(NotFound());
}
return(Ok(userLeague));
}
public bool SetActiveLeague(UserLeague league)
{
var inactiveLeagues = _db.UserLeague.Where(x => x.UserId == league.UserId && x.LeagueId != league.LeagueId).ToList();
inactiveLeagues.ForEach(a => a.ActiveFlag = false);
_db.SaveChanges();
league.ActiveFlag = true;
_db.UserLeague.Update(league);
return(Save());
}
public IHttpActionResult PostUserLeague(UserLeague userLeague)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.UserLeagues.Add(userLeague);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = userLeague.ID }, userLeague));
}
public IHttpActionResult DeleteUserLeague(int id)
{
UserLeague userLeague = db.UserLeagues.Find(id);
if (userLeague == null)
{
return(NotFound());
}
userLeague.IsDeleted = true;
db.SaveChanges();
return(Ok(userLeague));
}
// GET: UserLeagues/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserLeague userLeague = _db.UserLeagues.Find(id);
if (userLeague == null)
{
return(HttpNotFound());
}
ViewBag.LeagueName = userLeague.League.LeagueName;
return(View(userLeague));
}
public ActionResult Create([Bind(Include = "id,UserId,LeagueId,Roles,rowversion")] UserLeague userLeague)
{
if (ModelState.IsValid)
{
_db.UserLeagues.Add(userLeague);
try
{
_db.SaveChanges();
return(RedirectToAction("Index", new { id = userLeague.LeagueId }));
}
catch (System.Data.Entity.Infrastructure.DbUpdateException e)
{
ErrorSignal.FromCurrentContext().Raise(e);
Exception ex = e;
while (ex.InnerException != null)
{
ex = ex.InnerException;
}
ModelState.AddModelError(string.Empty, ex.Message);
}
catch (Exception e)
{
ErrorSignal.FromCurrentContext().Raise(e);
ModelState.AddModelError(string.Empty, "Insert failed");
}
}
var list = _db.Users.Where(x => x.Roles != "Mailer" || x.Roles != "Admin").ToList();
foreach (var item in _db.UserLeagues.Where(x => x.LeagueId == userLeague.LeagueId))
{
if (list.Any(x => x.id == item.UserId))
{
list.RemoveAll(x => x.id == item.UserId);
}
}
ViewBag.UserId = new SelectList(list, "id", "username");
var league = _db.Leagues.Find(userLeague.LeagueId);
ViewBag.LeagueName = league.LeagueName;
return(View(userLeague));
}
public async Task <ActionResult <UserLeague> > PostUserLeague(UserLeague userLeague)
{
_context.UserLeagues.Add(userLeague);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (UserLeagueExists(userLeague.UserId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetUserLeague", new { id = userLeague.UserId }, userLeague));
}
public bool AddPlayerToLeague(int id)
{
using (var ctx = new ApplicationDbContext())
{
var league = ctx.Leagues.Find(id);
if (league == null)
{
return(false);
}
var query =
ctx
.UserLeagues
.Where(e => e.LeagueId == league.LeagueId && e.UserId == _userId.ToString());
var query2 =
ctx
.UserLeagues
.Where(e => e.LeagueId == league.LeagueId);
var howManyPlayers = query2.Count();
if (query.Count() == 0)
{
var entity = new UserLeague()
{
LeagueId = id,
UserId = _userId.ToString(),
Ranking = howManyPlayers + 1,
IdHash = _userId.ToString().GetHashCode()
};
ctx.UserLeagues.Add(entity);
return(ctx.SaveChanges() == 1);
}
return(false);
}
}
public void AddUserToLeague(int userid, int leagueid)
{
using (var db = new MyLeaguesEntities())
{
if (db.UserLeagues.Where(x => x.UserID == userid && x.LeagueID == leagueid).Count() == 0)
{
UserLeague ul = new UserLeague();
ul.UserID = userid;
ul.PointsAllowed = 0;
ul.PointsScored = 0;
ul.Wins = 0;
ul.Losses = 0;
ul.LeagueID = leagueid;
ul.IsDeleted = false;
ul.CreatedOn = DateTime.Now;
db.UserLeagues.Add(ul);
League l = db.Leagues.Where(x => x.ID == leagueid).FirstOrDefault();
l.MemberCount++;
db.SaveChanges();
}
}
}
public async Task <IActionResult> get()
{
var userLeagues = _context.UserLeagues.ToList();
var playerTeams = _context.PlayerTeam.ToList();
var players = _context.Players.ToList();
var teams = _context.Teams.ToList();
var leagues = _context.Leagues.ToList();
var users = _context.AppUser.ToList();
UserLeague userInLeagues = new UserLeague();
DashboardViewModel dvm = new DashboardViewModel();
PlayerTeamsViewModel ptvm = new PlayerTeamsViewModel();
ptvm.players = new List <Player>();
ptvm.scoreSoFar = 0;
dvm.teams = new List <PlayerTeamsViewModel>();
List <DashboardViewModel> dvmList = new List <DashboardViewModel>();
foreach (League L in leagues)
{
if (L.Active == true)
{
dvm.leagueName = L.LeagueName;
dvm.leagueID = L.LeagueId;
foreach (UserLeague UL in userLeagues)
{
if (UL.LeagueForeignKey == dvm.leagueID)
{
foreach (AppUser AU in users)
{
if (UL.AppUserForeignKey == AU.Id)
{
ptvm.userName = AU.FullName;
}
}
ptvm.teamID = UL.TeamForeignKey;
foreach (Team T in teams)
{
if (ptvm.teamID == T.TeamID)
{
ptvm.teamName = T.TeamName;
}
}
foreach (PlayerTeam PT in playerTeams)
{
if (ptvm.teamID == PT.TeamForeignKey)
{
foreach (Player P in players)
{
if (PT.PlayerForeignKey == P.PlayerID)
{
int playerscore = 0;
//Calculate their score so far in the tournament.
if (P.RoundOne != 0 && P.RoundTwo == 0 && P.RoundThree == 0 && P.RoundFour == 0)
{
playerscore += P.RoundOne - 72;
}
else if (P.RoundOne != 0 && P.RoundTwo != 0 && P.RoundThree == 0 && P.RoundFour == 0)
{
playerscore += P.RoundOne + P.RoundTwo - 144;
}
else if (P.RoundOne != 0 && P.RoundTwo != 0 && P.RoundThree != 0 && P.RoundFour == 0)
{
playerscore += P.RoundOne + P.RoundTwo + P.RoundThree - 216;
}
else if (P.RoundOne != 0 && P.RoundTwo != 0 && P.RoundThree != 0 && P.RoundFour != 0)
{
playerscore += P.RoundOne + P.RoundTwo + P.RoundThree + P.RoundFour - 288;
}
else
{
playerscore = 0;
}
ptvm.scoreSoFar += playerscore;
ptvm.players.Add(P);
}
}
}
}
}
if (ptvm.teamName != null)
{
dvm.teams.Add(ptvm);
ptvm = new PlayerTeamsViewModel();
ptvm.players = new List <Player>();
ptvm.scoreSoFar = 0;
}
}
dvm.teams = dvm.teams.OrderBy(p => p.scoreSoFar).ToList();
dvmList.Add(dvm);
dvm = new DashboardViewModel();
dvm.teams = new List <PlayerTeamsViewModel>();
}
}
return(Ok(dvmList));
}
public async Task <IActionResult> GetTournaments()
{
var userLeagues = _context.UserLeagues.ToList();
var tournaments = _context.Tournaments.ToList();
var players = _context.Players.ToList();
var teams = _context.Teams.ToList();
var leagues = _context.Leagues.ToList();
var users = _context.AppUser.ToList();
var ulttList = _context.UserLeagueTeamTournaments.ToList();
UserLeague userInLeagues = new UserLeague();
PastTournamentViewModel tournVM = new PastTournamentViewModel();
TourneyLeagueViewModel tlvm = new TourneyLeagueViewModel();
tlvm.teams = new List <TourneyTeamViewModel>();
TourneyTeamViewModel ttvm = new TourneyTeamViewModel();
tournVM.leagues = new List <TourneyLeagueViewModel>();
List <PastTournamentViewModel> tournVMList = new List <PastTournamentViewModel>();
foreach (Tournament T in tournaments)
{
tournVM.tournamentName = T.TournamentName;
tournVM.tournamentID = T.TournamentID;
foreach (League L in leagues)
{
tlvm.leagueName = L.LeagueName;
tlvm.leagueID = L.LeagueId;
foreach (UserLeague UL in userLeagues)
{
if (UL.LeagueForeignKey == L.LeagueId)
{
foreach (UserLeagueTeamTournament ULTT in ulttList)
{
foreach (AppUser AU in users)
{
if (UL.AppUserForeignKey == AU.Id)
{
ttvm.userName = AU.FullName;
}
}
if (ULTT.UserLeagueForeignKey == UL.UserLeagueID && ULTT.TournamentForeignKey == tournVM.tournamentID)
{
foreach (Team Te in teams)
{
if (Te.TeamID == ULTT.TeamForeignKey)
{
ttvm.team = Te.TeamName;
ttvm.teamID = Te.TeamID;
ttvm.finalScore = ULTT.TournamentScore;
tlvm.teams.Add(ttvm);
ttvm = new TourneyTeamViewModel();
}
}
}
}
}
}
tlvm.teams = tlvm.teams.OrderBy(score => score.finalScore).ToList();
if (tlvm.teams.Count != 0)
{
tournVM.leagues.Add(tlvm);
}
tlvm = new TourneyLeagueViewModel();
tlvm.teams = new List <TourneyTeamViewModel>();
}
if (tournVM.leagues.Count != 0)
{
tournVMList.Add(tournVM);
}
tournVM = new PastTournamentViewModel();
tournVM.leagues = new List <TourneyLeagueViewModel>();
}
return(Ok(tournVMList));
}
public async Task <IActionResult> GetTeam()
{
var userId = _caller.Claims.Single(c => c.Type == "id");
var appuser = await _context.AppUser.Include(c => c.IdentityUser).SingleAsync(c => c.IdentityUser.Id == userId.Value);
var userLeagues = _context.UserLeagues.ToList();
var playerTeams = _context.PlayerTeam.ToList();
var players = _context.Players.ToList();
var teams = _context.Teams.ToList();
var leagues = _context.Leagues.ToList();
UserLeague userInLeagues = new UserLeague();
PlayerTeamsViewModel ptvm = new PlayerTeamsViewModel();
ptvm.players = new List <Player>();
List <PlayerTeamsViewModel> ptvmList = new List <PlayerTeamsViewModel>();
foreach (UserLeague UL in userLeagues)
{
if (UL.AppUserForeignKey == appuser.Id)
{
userInLeagues = UL;
foreach (League L in leagues)
{
if (userInLeagues.LeagueForeignKey == L.LeagueId)
{
ptvm.leagueName = L.LeagueName;
}
}
foreach (Team T in teams)
{
if (T.TeamID == UL.TeamForeignKey)
{
ptvm.teamName = T.TeamName;
ptvm.teamID = T.TeamID;
}
}
foreach (PlayerTeam PT in playerTeams)
{
if (userInLeagues.TeamForeignKey == PT.TeamForeignKey)
{
foreach (Player P in players)
{
if (P.PlayerID == PT.PlayerForeignKey)
{
ptvm.players.Add(P);
}
}
}
}
ptvmList.Add(ptvm);
ptvm = new PlayerTeamsViewModel();
ptvm.players = new List <Player>();
}
}
return(Ok(ptvmList));
}