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();
}
}
}
