static MeasureTypes()
{
Predictor = new MeasureTypes {
Id = 1, Value = "Predictor", Display = "Predictor (independent variable)"
};
Outcome = new MeasureTypes {
Id = 2, Value = "Outcome", Display = "Outcome (dependent variable)"
};
}
public static IEnumerable<Measure> GetMeasures(MeasureTypes type)
{
var sql = "SELECT Id, MeasureName, DataType, MeasureType FROM Measures WHERE MeasureType = @MeasureType;";
using (var conn = GetConnection ()) {
conn.Open ();
using (var cmd = conn.CreateCommand ()) {
cmd.CommandText = sql;
cmd.Parameters.AddWithValue ("@MeasureType", type.Id);
using (var reader = cmd.ExecuteReader ()) {
while (reader.Read ()) {
yield return MeasureFromReader(reader);
}
}
}
}
}
static MeasureTypes()
{
Predictor = new MeasureTypes { Id = 1, Value = "Predictor", Display = "Predictor (independent variable)" };
Outcome = new MeasureTypes { Id = 2, Value = "Outcome", Display = "Outcome (dependent variable)" };
}
protected Measure(DataTypes datatype, string name, MeasureTypes type)
{
DataType = datatype;
MeasureName = name;
MeasureType = type;
}
protected Measure(DataTypes datatype, string name, MeasureTypes type)
{
DataType = datatype;
MeasureName = name;
MeasureType = type;
}
public static IList<Measure> GetMeasures(MeasureTypes type)
{
return new List<Measure>(MeasureRepository.GetMeasures(type));
}
