public IEnumerable <LeagueRequest> GetRequests(int userid) { using (var db = new MyLeaguesEntities()) { return(db.LeagueRequests.Where(x => x.UserID == userid).ToList()); } }
public IEnumerable <Game> GetGamesForUserLeague(int id) { using (var db = new MyLeaguesEntities()) { return(db.Games.Where(x => x.UserID == id || x.OpponentID == id).ToList()); } }
// GET: api/Leagues public List <League> GetLeagues() { using (var db = new MyLeaguesEntities()) { return(db.Leagues.ToList()); } }
public int GetGamesPlayedCountForUser(int id) { using (var db = new MyLeaguesEntities()) { return(db.Games.Where(x => x.UserID == id || x.OpponentID == id).Count()); } }
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(); } }
private bool LeagueExists(int id) { using (var db = new MyLeaguesEntities()) { return(db.Leagues.Count(e => e.ID == id) > 0); } }
public void AcceptRequest(int requestId) { using (var db = new MyLeaguesEntities()) { var request = db.LeagueRequests.Where(x => x.ID == requestId).FirstOrDefault(); request.IsDecided = true; AddUserToLeague(request.UserID, request.LeagueID); } }
public void LeaveLeague(int userleagueid) { using (var db = new MyLeaguesEntities()) { var userleague = db.UserLeagues.Where(x => x.ID == userleagueid).FirstOrDefault(); userleague.IsDeleted = true; db.SaveChanges(); } }
protected override void Dispose(bool disposing) { using (var db = new MyLeaguesEntities()) { if (disposing) { db.Dispose(); } base.Dispose(disposing); } }
public static User CreateAccount(User user) { using (var db = new MyLeaguesEntities()) { user.Salt = GetRandomSalt(20); user.Password = sha256_hash(user.Password + user.Salt); db.Users.Add(user); db.SaveChanges(); return(db.Users.Where(x => x.Email == user.Email).FirstOrDefault()); } }
public IEnumerable <Game> GetGamesForLeague(int id) { using (var db = new MyLeaguesEntities()) { db.Configuration.LazyLoadingEnabled = false; var query = db.Games .Where(x => x.LeagueID == id) .OrderByDescending(x => x.CreatedOn).ToList(); return(query); } }
public IHttpActionResult GetLeague(int id) { using (var db = new MyLeaguesEntities()) { League league = db.Leagues.Find(id); if (league == null) { return(NotFound()); } return(Ok(league)); } }
public IEnumerable <UserLeague> GetUserLeaguesForLeague(int id) { using (var db = new MyLeaguesEntities()) { db.Configuration.LazyLoadingEnabled = false; var query = db.UserLeagues .Include("User") .Where(x => x.LeagueID == id) .ToList(); return(query); } }
public IEnumerable <User> SearchUsers(string searchtext) { using (var db = new MyLeaguesEntities()) { db.Configuration.LazyLoadingEnabled = false; return(db.Users.Where(x => x.FirstName.Contains(searchtext) || x.LastName.Contains(searchtext) || x.Email.Contains(searchtext) || (x.FirstName + " " + x.LastName).Contains(searchtext)) .Take(10) .ToList()); } }
public void InviteUser(int userid, int inviteeid, int leagueid, string message) { using (var db = new MyLeaguesEntities()) { var request = db.LeagueRequests.Create(); request.UserID = userid; request.InviteeID = inviteeid; request.LeagueID = leagueid; request.Message = message; request.CreatedOn = DateTime.Now; request.IsDecided = false; db.LeagueRequests.Add(request); db.SaveChanges(); } }
public IHttpActionResult DeleteLeague(int id) { using (var db = new MyLeaguesEntities()) { League league = db.Leagues.Find(id); if (league == null) { return(NotFound()); } db.Leagues.Remove(league); db.SaveChanges(); return(Ok(league)); } }
public List <League> GetLeaguesForUser(int id) { using (var db = new MyLeaguesEntities()) { db.Configuration.LazyLoadingEnabled = false; var query = db.Leagues .Join(db.UserLeagues, league => league.ID, userleague => userleague.LeagueID, (league, userleague) => new { League = league, UserLeague = userleague }) .Where(x => x.UserLeague.UserID == id && x.UserLeague.IsDeleted == false) .Select(x => x.League) .Include("UserLeagues") .Include("UserLeagues.User") .Include("UserLeagues.User") .Include("UserLeagues.Games") .Include("UserLeagues.Games1") .ToList(); return(query); } }
public void CreateGame(int userid, int opponentid, int userscore, int opponentscore, int lat, int lng, int leagueid) { using (var db = new MyLeaguesEntities()) { if (userid != opponentid) { Game g = db.Games.Create(); g.UserID = userid; g.OpponentID = opponentid; g.UserScore = userscore; g.OpponentScore = opponentscore; g.Latitude = lat; g.Longitude = lng; g.LeagueID = leagueid; g.CreatedOn = DateTime.Now; db.Games.Add(g); var user = db.UserLeagues.Where(x => x.ID == userid).FirstOrDefault(); user.PointsScored += userscore; user.PointsAllowed += opponentscore; var opponent = db.UserLeagues.Where(x => x.ID == opponentid).FirstOrDefault(); opponent.PointsScored += opponentscore; opponent.PointsAllowed += userscore; if (userscore > opponentscore) { user.Wins++; opponent.Losses++; } else if (userscore == opponentscore) { user.Ties++; opponent.Ties++; } else { user.Losses++; opponent.Wins++; } db.SaveChanges(); } } }
public static User Login(string email, string password) { using (var db = new MyLeaguesEntities()) { var unverifiedUser = db.Users.Where(x => x.Email == email).FirstOrDefault(); if (unverifiedUser == null) { return(null); } string salt = db.Users.Where(x => x.Email == email).FirstOrDefault().Salt; if (salt == "") { return(null); } db.Configuration.LazyLoadingEnabled = false; string hash = sha256_hash(password + salt); User user = db.Users .Where(x => x.Email == email && x.Password == hash) .FirstOrDefault(); return(user); } }
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(); } } }