public async Task <IActionResult> Edit(string id, [Bind("Id,UserId,GameRoomId")] GameUserModel gameUserModel)
{
if (id != gameUserModel.UserId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
await gameRepo.UpdateGameUserAsync(gameUserModel);
}
catch (DbUpdateConcurrencyException)
{
if (null == gameRepo.FindGameUser(gameUserModel.UserId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(gameUserModel));
}
public async Task <IActionResult> PutGameUserModel(int id, GameUserModel gameUserModel)
{
if (id != gameUserModel.Id)
{
return(BadRequest());
}
_context.Entry(gameUserModel).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GameUserModelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <GameUserModel> > PostGameUserModel(GameUserModel gameUserModel)
{
_context.GameUser.Add(gameUserModel);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetGameUserModel", new { id = gameUserModel.Id }, gameUserModel));
}
public static int UpdateUserBalance(float balance, string id)
{
GameUserModel user = new GameUserModel
{
Balance = balance
};
string sql = @"update dbo.GameUsers set Balance += @Balance where UserId ='" + id + "';";
return(SqlDataAccess.UpdateUser(sql, user));
}
public async Task <IActionResult> Create([Bind("Id,UserId,GameRoomId")] GameUserModel gameUserModel)
{
if (ModelState.IsValid)
{
await gameRepo.CreateGameUserAsync(gameUserModel);
return(RedirectToAction(nameof(Index)));
}
return(View(gameUserModel));
}
public static int UpdateUser(string fname, string lname, int age, string id)
{
GameUserModel user = new GameUserModel
{
Fname = fname,
Lname = lname,
Age = age
};
string sql = @"update dbo.GameUsers set fname = @Fname, lname = @Lname, Age = @Age where UserId ='" + id + "';";
return(SqlDataAccess.UpdateUser(sql, user));
}
public string CreateGameUser(string username)
{
GameUserModel newUser = new GameUserModel
{
Username = username
};
db.GameUser.Add(newUser);
db.SaveChanges();
return(newUser.UserId);
}
public GameUserModel CreateGameUser(int gameRoomId = 0)
{
GameUserModel newGameUser = new GameUserModel
{
UserId = MakeGameUserId(),
GameRoomId = gameRoomId
};
db.Add(newGameUser);
db.SaveChanges();
return(newGameUser);
}
public static bool CheckBalance(string id)
{
string sql = @"select Balance from dbo.GameUsers where UserId = '" + id + "';";
GameUserModel user = SqlDataAccess.LoadSingleData <GameUserModel>(sql);
if (user.Balance >= 10)
{
return(true);
}
else
{
return(false);
}
}
public string Create()
{
GameUserModel newUser = new GameUserModel();
while (true)
{
newUser.UserId = Guid.NewGuid().ToString();
var find = _context.Find <GameUserModel>(newUser.UserId);
if (null == find)
{
_context.Add(newUser);
_context.SaveChanges();
break;
}
}
return(newUser.UserId);
}
public async Task DeleteGameUserAsync(GameUserModel gameUserModel)
{
db.GameUser.Remove(gameUserModel);
await db.SaveChangesAsync();
}
public void DeleteGameUser(GameUserModel gameUser)
{
DeleteGameUserAsync(gameUser).GetAwaiter().GetResult();
}
public async Task UpdateGameUserAsync(GameUserModel gameUserModel)
{
db.Add(gameUserModel);
await db.SaveChangesAsync();
}
