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