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