internal static Assessment Create(MySqlDataReader dr)
{
Assessment assess = new Assessment();
for (int i = 0; i < dr.VisibleFieldCount; i++)
{
if (dr.GetValue(i) == DBNull.Value)
{
continue;
}
var field = dr.GetName(i);
switch (field)
{
case "AssessmentID":
assess.asmt_id = dr.GetInt32(i);
break;
case "ActivityDescription":
assess.ActivityDescription = dr.GetString(i);
break;
case "ModifiedDate":
assess.ModifiedDate = dr.GetDateTime(i);
break;
case "ActivityType":
assess.ActivityType = dr.GetString(i);
break;
case "new_activity_name":
assess.ActivityName = dr.GetString(i);
break;
case "AssessmentName":
assess.AssessmentName = dr.GetString(i);
break;
case "passing_score":
assess.passing_score = dr.GetDecimal(i);
break;
case "RubricName":
assess.Rubric.RubricName = dr.GetString(i);
break;
}
}
assess.Rubric.Criteria.Add(RubricCriteria.Create(dr));
return(assess);
}
public static RubricCriteria Create(MySqlDataReader dr)
{
RubricCriteria criteria = new RubricCriteria();
for (int i = 0; i < dr.VisibleFieldCount; i++)
{
if (dr.GetValue(i) == DBNull.Value)
{
continue;
}
var field = dr.GetName(i);
switch (field)
{
case "RubricCriteriaLevelName":
criteria.LevelName = dr.GetString(i);
break;
case "ScoreValue":
criteria.Score = dr.GetInt32(i);
break;
case "asmt_mastery_level_id":
criteria.MasteryLevelID = dr.GetInt32(i);
break;
case "points":
criteria.Points = dr.GetDecimal(i);
break;
case "weight":
criteria.Weight = dr.GetDecimal(i);
break;
case "MasteryLevel":
criteria.MasteryLevel = dr.GetString(i);
break;
case "CriteriaName":
criteria.CriteriaName = dr.GetString(i);
break;
case "display_seq":
criteria.Sequence = dr.GetInt32(i);
break;
}
}
return(criteria);
}