public void deletePlayer(int playerId, TableNames table)
{
string query =
$"delete from {table.ToString()} where NAME = (select NAME from " +
$"{table.ToString()} limit 1 offset {playerId.ToString()})";
sqlDB.ExecuteNonQuery(query);
}
public void addData(PlayerDTO playerDTO, TableNames table)
{
string query =
$"insert into {table.ToString()} values(\'{playerDTO.PlayerName}\',{(int)playerDTO.JOB},{playerDTO.HP},{playerDTO.MP},{playerDTO.STR}," +
$"{playerDTO.DEF},{playerDTO.AGI},{playerDTO.LUCK},\'{playerDTO.CreateDay}\')";
sqlDB.ExecuteNonQuery(query);
}
public void InsertOnSubmit(TableNames entityName, object entity)
{
this.AddObject(entityName.ToString(), entity);
}
public void InsertOnSubmit(TableNames entityName, object entity)
{
this.AddObject(entityName.ToString(), entity);
}
