public static string ToJsonString(ScoreByCategoryModel model)
{
if (model != null)
{
return(JsonConvert.SerializeObject(model));
}
else
{
return(null);
}
}
public static ScoreByCategoryModel GetScoreByCategory(int crn, int semester, int year)
{
ScoreByCategoryModel scoreByCategory = null;
SqlConnection connection = GetConnection();
string selectStatement = "EXEC ScoreByCategory @crn, @year, @semester";
SqlCommand command = new SqlCommand(selectStatement, connection);
command.Parameters.AddWithValue("crn", crn);
command.Parameters.AddWithValue("semester", semester);
command.Parameters.AddWithValue("year", year);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
scoreByCategory = new ScoreByCategoryModel();
while (reader.Read())
{
var data = new ScoreByCategoryModel.Data();
data.Average = Convert.ToDouble(reader["Average"]);
data.StandardDev = Convert.ToDouble(reader["StandardDeviation"].ToString());
data.CategoryName = reader["CategoryName"].ToString();
data.CategoryID = Convert.ToInt32(reader["CategoryID"].ToString());
data.Questions = reader["Questions"].ToString();
scoreByCategory.DATA.Add(data);
}
return(scoreByCategory);
}
catch (SqlException ex)
{
return(null);
}
finally
{
connection.Close();
}
}