public int CreateForumUser()
{
ForumUser user = new ForumUser();
user.WhenCreated = DateTime.UtcNow;
dbContext.ForumUser.Add(user);
dbContext.SaveChanges();
return(user.ForumUserID);
}
public int CreateGameUser()
{
GameUser user = new GameUser();
user.WhenCreated = DateTime.UtcNow;
user.GameScore = 0;
dbContext.GameUser.Add(user);
dbContext.SaveChanges();
return(user.GameUserID);
}
public int CreateAppException(Exception e)
{
var appException = new AppException
{
Message = e.Message,
StackTrace = e.StackTrace,
ExceptionString = e.ToString(),
WhenCreated = DateTime.UtcNow
};
context.AppException.Add(appException);
context.SaveChanges();
return(appException.AppExceptionID);
}
public int CreateUserLogin(CreateUserLogin user, string passwordSalt, string passwordHash, int forumUserID, int gameUserID)
{
UserLogin insertUser = new UserLogin()
{
Username = user.Username,
Email = user.Email,
PasswordSalt = passwordSalt,
PasswordHash = passwordHash,
ForumUserID = forumUserID,
GameUserID = gameUserID
};
insertUser.WhenCreated = DateTime.UtcNow;
dbContext.UserLogin.Add(insertUser);
dbContext.SaveChanges();
return(insertUser.UserLoginID);
}
public Task UpdateGameScores(List <ClaimsPrincipal> userRankings, List <int> rankingScores)
{
return(Task.Run(() =>
{
using (var db = new CallCheatOnlineContext())
{
for (int i = 0; i < userRankings.Count; i++)
{
var gameUserID = db
.UserLogin
.Where((v) => v.UserLoginID == userRankings.ElementAt(i).GetUserLoginID())
.First()
.GameUserID;
var gameUser = db
.GameUser
.Where((v) => v.GameUserID == gameUserID)
.FirstOrDefault();
gameUser.GameScore = gameUser.GameScore + rankingScores.ElementAt(i);
db.SaveChanges();
}
}
}));
}
