public IHttpActionResult UpdatePlayer(PlayersAPIModels player)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
string sql = "UPDATE dbo.Players " +
$"SET FirstName = '{player.FirstName}', LastName = '{player.LastName}', NickName = '{player.NickName}',City = '{player.City}'," +
$"BirthDay = '{player.BirthDay}',IsOnline = '{player.IsOnline}',LastLogin = '******',HourGameScene ='{player.HourGameScene}',IsBanned ='{player.IsBanned}'," +
$"BannedHour = '{player.BannedHour}' " +
$"WHERE Id = '{player.Id}'";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error Update player in database, " + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
public bool InsertNewPlayer(PlayersAPIModels player)
{
using (IDbConnection cnn = new ApplicationDbContext().Database.Connection)
{
string sql = $"INSERT INTO dbo.Players(Id,FirstName,LastName,NickName,City,BirthDay)" +
$"VALUES ('{player.Id}','{player.FirstName}','{player.LastName}','{player.NickName}','{player.City}','{player.BirthDay}')";
int rows = cnn.Execute(sql);
if (rows != 1)
{
return(false);
}
else
{
return(true);
}
}
}