public void DeleteDatabase()
{
using (var context = new DatabaseORM())
{
context.Database.Delete();
}
}
public bool DeleteUser(string username)
{
using (var context = new DatabaseORM())
{
UserEntity user = null;
UserStatisticsEntity userStatistics = null;
foreach (UserEntity u in context.Users)
{
if (u.Username.Equals(username))
{
user = u;
}
}
foreach (UserStatisticsEntity us in context.UserStatistics)
{
if (us.Username.Equals(username))
{
userStatistics = us;
}
}
if (user != null && userStatistics != null)
{
context.Users.Remove(user);
context.SaveChanges();
context.UserStatistics.Remove(userStatistics);
context.SaveChanges();
return(true);
}
}
return(false);
}
public UserStatisticsEntity GetUserStats(string username)
{
using (var context = new DatabaseORM())
{
UserStatisticsEntity userstats = context.UserStatistics.Find(username);
return(userstats);
}
}
public void DeleteAllData()
{
using (var context = new DatabaseORM())
{
context.UserStatistics.RemoveRange(context.UserStatistics);
context.Users.RemoveRange(context.Users);
context.GameLogs.RemoveRange(context.GameLogs);
context.SaveChanges();
}
}
public bool AddGameLog(int gameID, string serial)
{
using (var context = new DatabaseORM())
{
context.GameLogs.Add(new GamelogsEntity()
{
GameID = gameID, GameLogSerial = serial
});
context.SaveChanges();
return(true);
}
}
public List <GamelogsEntity> GetListOfGameLogs()
{
var gameLogsList = new List <GamelogsEntity>();
using (var context = new DatabaseORM())
{
foreach (GamelogsEntity gl in context.GameLogs)
{
gameLogsList.Add(gl);
}
}
return(gameLogsList);
}
public List <UserStatisticsEntity> GetAllUserStatistics()
{
var userStats = new List <UserStatisticsEntity>();
using (var context = new DatabaseORM())
{
foreach (UserStatisticsEntity us in context.UserStatistics)
{
userStats.Add(us);
}
}
return(userStats);
}
public List <UserEntity> GetRegisteredUsers()
{
var users = new List <UserEntity>();
using (var context = new DatabaseORM())
{
foreach (UserEntity u in context.Users)
{
users.Add(u);
}
}
return(users);
}
public GamelogsEntity GetGameLog(int gameID)
{
using (var context = new DatabaseORM())
{
foreach (GamelogsEntity gl in context.GameLogs)
{
Console.WriteLine(gl.GameID);
if (gl.GameID == gameID)
{
return(gl);
}
}
}
return(null);
}
public bool DeleteGameLog(int gameID)
{
using (var context = new DatabaseORM())
{
GamelogsEntity gl = context.GameLogs.Single(gamelog => gamelog.GameID == gameID);
if (gl != null)
{
context.GameLogs.Remove(gl);
context.SaveChanges();
return(true);
}
Console.WriteLine("it was null????");
}
return(false);
}
public UserEntity GetUser(string username)
{
UserEntity user = new UserEntity();
using (var context = new DatabaseORM())
{
foreach (UserEntity u in context.Users)
{
if (u.Username.Equals(username))
{
user = u;
return(user);
}
}
}
return(null);
}
public bool UpdateUserLeague(string username, int newLeagueID)
{
using (var context = new DatabaseORM())
{
UserEntity updatedUser = new UserEntity();
var original = context.Users.Find(username);
if (original != null)
{
updatedUser.Username = original.Username;
updatedUser.Password = original.Password;
updatedUser.Email = original.Email;
updatedUser.Money = original.Money;
updatedUser.LeagueId = newLeagueID;
context.Entry(original).CurrentValues.SetValues(updatedUser);
context.SaveChanges();
return(true);
}
}
return(false);
}
public bool EditUser(string username, string password, string email, int money)
{
using (var context = new DatabaseORM())
{
UserEntity updatedUser = new UserEntity();
var original = context.Users.Find(username);
if (original != null)
{
updatedUser.Username = username;
updatedUser.Password = password;
updatedUser.Email = email;
updatedUser.Money = money;
updatedUser.LeagueId = original.LeagueId;
context.Entry(original).CurrentValues.SetValues(updatedUser);
context.SaveChanges();
return(true);
}
}
return(false);
}
public bool AddUser(string username, string password, string email, int money, int leagueID)
{
using (var context = new DatabaseORM())
{
context.Users.Add(new UserEntity()
{
Username = username, Password = password, Email = email, Money = money, LeagueId = leagueID
});
context.UserStatistics.Add(new UserStatisticsEntity()
{
Username = username,
AvgCashGain = 0,
AvgGrossProfit = 0,
HighestCashGain = 0,
NumOfGames = 0,
Points = 0,
TotalGrossProfit = 0
});
context.SaveChanges();
}
return(true);
}
public bool UpdateUserStats(string username, int points, int numOfGames, int totalGrossProfit, int highestCashGain, int avgGrossProfit, int avgCashGain)
{
using (var context = new DatabaseORM())
{
UserStatisticsEntity updatedUserStats = new UserStatisticsEntity();
var original = context.UserStatistics.Find(username);
if (original != null)
{
updatedUserStats.Username = username;
updatedUserStats.Points = points;
updatedUserStats.NumOfGames = numOfGames;
updatedUserStats.TotalGrossProfit = totalGrossProfit;
updatedUserStats.HighestCashGain = highestCashGain;
updatedUserStats.AvgGrossProfit = avgGrossProfit;
updatedUserStats.AvgCashGain = avgCashGain;
context.Entry(original).CurrentValues.SetValues(updatedUserStats);
context.SaveChanges();
return(true);
}
}
return(false);
}