public Character(CharacterParameters parameters)
{
_name = parameters.Name;
_experienceKRD = parameters.ExK;
_experienceOverall = parameters.ExO;
_skills = parameters.Skills;
}
public List<Character> GetCharacters()
{
List<Character> characters = new List<Character>();
SqlConnection sqlConnection = new SqlConnection(connectioString);
SqlDataReader dataReader = null;
try
{
sqlConnection.Open();
SqlCommand command = new SqlCommand(sqlSelectAll, sqlConnection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
var ignore = dataReader[0];
var charParam = new CharacterParameters((string)dataReader[1], (int)dataReader[2], (int)dataReader[3], Character.DefaultSkills());
characters.Add(new Character(charParam));
}
}
finally
{
if (dataReader != null)
{
dataReader.Close();
}
if (sqlConnection != null)
{
sqlConnection.Close();
}
}
return characters;
}