public int UpdateGameNumofPlayers(int gid, int nop)
{
var cont = new SeniorLinqDataContext();
var query = (from game in cont.Games where game.GID == gid select game).SingleOrDefault();
if (query != null)
{
var res = (from game in cont.Games where game.GID == gid select game).SingleOrDefault();
var gamesample = (from gf in cont.GameFrames where res.Title == gf.Title select gf).SingleOrDefault();
var gfcheck = (from gf in cont.GameFrames where res.Title == gf.Title select gf).SingleOrDefault();//res.NPlayers >= gf.MinPlayers && res.NPlayers <= gf.MaxPlayers select gf).SingleOrDefault();
if (gfcheck != null && nop >= gfcheck.MinPlayers && nop <= gfcheck.MaxPlayers)
{
query.NPlayers = nop;
cont.SubmitChanges();
if (res.Title == query.Title)
{
return(1);
}
}
}
return(-1);
}//checked
public List <int> RetreivePlayerGames(string username)//returns null if no games/players were found//a list of all Gids associated to this player when successful//checked
{
var cont = new SeniorLinqDataContext();
var usercheck = (from user in cont.Users where user.Username == username select user).SingleOrDefault();
if (usercheck == null)
{
return(null);
}
var query = (from games in cont.Gameplayers where games.Username == username select games).ToList();//returns all games with associated username
if (query == null)
{
return(null);
}
List <int> Gids = new List <int>();
for (int i = 0; i < query.Count(); i++)
{
Gids.Add(query[i].GID);
}
return(Gids);
}
//public int UpdateGamePlayer(int gameplayerid)
//{
// throw new NotImplementedException();
//}
//public int UpdateGFStrategy(int gfstrategyid)
//{
// throw new NotImplementedException();
//}
//public int UpdateNashPointProfile(int NPID)
//{
// throw new NotImplementedException();
//}
//public int UpdateNPPayoff(int payoffid)
//{
// throw new NotImplementedException();
//}
//public int UpdateNPStrategy(int npstrategyid)
//{
// throw new NotImplementedException();
//}
public int UpdateUser(string username, string password) //returns 1 on success // -2 if the user was not found // -1 on failure//checked
{
var cont = new SeniorLinqDataContext();
var query = (from user in cont.Users where user.Username == username select user).SingleOrDefault();
var temp = new UserModel();
if (query != null)
{
query.Password = password;
cont.SubmitChanges();
}
else
{
return(-2);
}
var query2 = (from user in cont.Users where user.Username == username select user).SingleOrDefault();
if (query2.Password == password)
{
return(1);
}
return(-1);
}
public List <GameFrameModel> RetreiveAllGameFrames()// returns a list of all gameframes // null if the list is empty//checked
{
var cont = new SeniorLinqDataContext();
var query = (from gfs in cont.GameFrames select gfs).ToList();
if (query == null)
{
return(null);
}
List <GameFrameModel> gfmodels = new List <GameFrameModel>();
for (int i = 0; i < query.Count; i++)
{
gfmodels.Add(new GameFrameModel());
gfmodels[gfmodels.Count - 1].Title = query[i].Title;
gfmodels[gfmodels.Count - 1].MinPlayers = query[i].MinPlayers;
gfmodels[gfmodels.Count - 1].MaxPlayers = query[i].MaxPlayers;
gfmodels[gfmodels.Count - 1].MaxStrategies = query[i].MaxStrategies;
gfmodels[gfmodels.Count - 1].MinStrategies = query[i].MinStrategies;
}
return(gfmodels);
}
public List <GameFrameModel> GameByNumPlayer(int nop)
{
var cont = new SeniorLinqDataContext();
List <GameFrameModel> gameframemodels = new List <GameFrameModel>();
if (nop < 4)
{
var query = (from gf in cont.GameFrames where gf.MinPlayers == gf.MaxPlayers && gf.MinPlayers == nop select gf).ToList();// all gameframes with nop players
List <GameFrameModel> gamemodels = new List <GameFrameModel>();
for (int i = 0; i < query.Count; i++)
{
GameFrameModel Model1 = new GameFrameModel();
Model1.Title = query[i].Title;
Model1.MaxPlayers = query[i].MaxPlayers;
Model1.MaxStrategies = query[i].MaxStrategies;
Model1.MinPlayers = query[i].MinPlayers;
Model1.MinStrategies = query[i].MinStrategies;
gameframemodels.Add(Model1);
}
}
else
{
var query = (from gf in cont.GameFrames where gf.MaxPlayers > 3 select gf).ToList();//all N gameframes
for (int i = 0; i < query.Count; i++)
{
GameFrameModel Model1 = new GameFrameModel();
Model1.Title = query[i].Title;
Model1.MaxPlayers = query[i].MaxPlayers;
Model1.MaxStrategies = query[i].MaxStrategies;
Model1.MinPlayers = query[i].MinPlayers;
Model1.MinStrategies = query[i].MinStrategies;
gameframemodels.Add(Model1);
}
}
return(gameframemodels);
}
