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