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