public SkillDefinitionDto(SkillDefinition skillDefinition)
{
Id = skillDefinition.Id;
Name = skillDefinition.Name;
Value = new RangeDto<decimal>(skillDefinition.Value);
IsMandatory = skillDefinition.IsMandatory;
}
public static IEnumerable<SkillDefinition> GetDBSkillDefinitions(string connectionString)
{
var output = new List<SkillDefinition>();
using (var connection = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("SELECT * FROM dbo.BZ_Skill_Definition", connection);
connection.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var definition = new SkillDefinition
{
Id = (byte)reader.GetInt("Id"),
Name = reader.GetString("Name"),
IsMandatory = reader.GetBoolean("IsMandatory"),
Value = new Range<decimal>(reader.GetDecimal("Minimum"), reader.GetDecimal("Maximum"))
};
output.Add(definition);
}
}
}
return output;
}
