private static DialData FillDialSpecialAbilities(DialData dial, Guid id) { SqlConnection connection = MageKnightDataDB.GetConnection(); string selectStatement = "SELECT Speed, Attack, Defense, Damage, [Index] " + "FROM ClickAbilities " + "WHERE Id = @Id"; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.Parameters.AddWithValue("@Id", id); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); while (reader.Read()) { int index = Int32.Parse(reader["Index"].ToString()); ClickData click = dial.Clicks.First(x => x.Index == index); click.Speed.Ability = reader["Speed"].ToString(); click.Attack.Ability = reader["Attack"].ToString(); click.Defense.Ability = reader["Defense"].ToString(); click.Damage.Ability = reader["Damage"].ToString(); } return(dial); } catch (Exception ex) { MessageBox.Show($"something is wrong GetMageKnight:{ex.ToString()}"); } return(null); }
private static DialData GetDialStats(MageData data) { SqlConnection connection = MageKnightDataDB.GetConnection(); string selectStatement = "SELECT Speed, Attack, Defense, Damage, [Index] " + "FROM ClickValues " + "WHERE Id = @Id"; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.Parameters.AddWithValue("@Id", data.Id); DialData dial = new DialData(data); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(); while (reader.Read()) { StatData speed = new StatData(StatType.Speed); StatData attack = new StatData(StatType.Attack); StatData defense = new StatData(StatType.Defense); StatData damage = new StatData(StatType.Damage); speed.Value = Int32.Parse(reader["Speed"].ToString()); attack.Value = Int32.Parse(reader["Attack"].ToString()); defense.Value = Int32.Parse(reader["Defense"].ToString()); damage.Value = Int32.Parse(reader["Damage"].ToString()); int index = Int32.Parse(reader["Index"].ToString()); ClickData click = new ClickData(speed, attack, defense, damage, index); dial.Clicks.Add(click); } connection.Close(); return(FillDialSpecialAbilities(dial, data.Id)); } catch (Exception ex) { MessageBox.Show($"something is wrong GetMageKnight:{ex.ToString()}"); } return(null); }