public static EssayAnswersModel GetEssayAnswers(int crn, int semester, int year)
{
EssayAnswersModel essayAnswers = null;
SqlConnection connection = GetConnection();
string selectStatement = "EXEC EssayAnswers @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();
essayAnswers = new EssayAnswersModel();
while (reader.Read())
{
var data = new EssayAnswersModel.Data();
data.id = Convert.ToInt32(reader[0].ToString());
data.crn = Convert.ToInt32(reader["CRN"].ToString());
data.subjectCode = reader["subjectCode"].ToString();
data.courseNum = reader["courseNumber"].ToString();
data.semester = Convert.ToInt32(reader["semester"].ToString());
/*if (!reader["Block"].ToString().Equals("NULL"))
* data.block = Convert.ToInt32(reader["Block"].ToString());
*/
data.block = 0;
data.questionID = Convert.ToInt32(reader[6].ToString());
data.questionResponse = Convert.ToInt32(reader[7].ToString());
data.question = reader["Question"].ToString();
data.answer = reader["Answer"].ToString();
data.student = Convert.ToInt32(reader["student"].ToString());
essayAnswers.DATA.Add(data);
}
return(essayAnswers);
}
catch (SqlException ex)
{
return(null);
}
finally
{
connection.Close();
}
}
public static string ToJsonString(EssayAnswersModel model)
{
if (model == null)
{
return(null);
}
else
{
return(JsonConvert.SerializeObject(model));
}
}
