public static string ToJsonString(QuestionDetailsModel model)
{
if (model != null)
{
return(JsonConvert.SerializeObject(model));
}
else
{
return(null);
}
}
public static QuestionDetailsModel GetQuestionDetails(int crn, int semester, int year, int questionID)
{
QuestionDetailsModel questionDetails = null;
SqlConnection connection = GetConnection();
string selectStatement = "EXEC QuestionDetails @crn, @semester, @year, @questionID";
SqlCommand command = new SqlCommand(selectStatement, connection);
command.Parameters.AddWithValue("crn", crn);
command.Parameters.AddWithValue("semester", semester);
command.Parameters.AddWithValue("year", year);
command.Parameters.AddWithValue("questionID", questionID);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
questionDetails = new QuestionDetailsModel();
while (reader.Read())
{
var data = new QuestionDetailsModel.Data();
data.Text = reader["text"].ToString();
data.InstructorID = Convert.ToInt32(reader["instructorID"].ToString());
data.SubjectCode = reader["subjectcode"].ToString();
data.Semester = Convert.ToInt32(reader["semester"].ToString());
data.Year = Convert.ToInt32(reader["year"].ToString());
double test = 0;
if (Double.TryParse(reader["PersonalFiveYearAverageSA"].ToString(), out test))
{
data.PersonalFiveYearAverageSA = Convert.ToDouble(reader["PersonalFiveYearAverageSA"].ToString());
}
if (Double.TryParse(reader["PersonalFiveYearAverageA"].ToString(), out test))
{
data.PersonalFiveYearAverageA = Convert.ToDouble(reader["PersonalFiveYearAverageA"].ToString());
}
if (Double.TryParse(reader["PersonalFiveYearAverageN"].ToString(), out test))
{
data.PersonalFiveYearAverageN = Convert.ToDouble(reader["PersonalFiveYearAverageN"].ToString());
}
if (Double.TryParse(reader["PersonalFiveYearAverageD"].ToString(), out test))
{
data.PersonalFiveYearAverageD = Convert.ToDouble(reader["PersonalFiveYearAverageD"].ToString());
}
if (Double.TryParse(reader["PersonalFiveYearAverageSD"].ToString(), out test))
{
data.PersonalFiveYearAverageSD = Convert.ToDouble(reader["PersonalFiveYearAverageSD"].ToString());
}
if (Double.TryParse(reader["PersonalFiveYearAverageNA"].ToString(), out test))
{
data.PersonalFiveYearAverageNA = Convert.ToDouble(reader["PersonalFiveYearAverageNA"].ToString());
}
if (Double.TryParse(reader["PersonalFiveYearAverageTotal"].ToString(), out test))
{
data.PersonalFiveYearAverageTotal = Convert.ToDouble(reader["PersonalFiveYearAverageTotal"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageSA"].ToString(), out test))
{
data.PersonalSemesterAverageSA = Convert.ToDouble(reader["PersonalSemesterAverageSA"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageA"].ToString(), out test))
{
data.PersonalSemesterAverageA = Convert.ToDouble(reader["PersonalSemesterAverageA"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageN"].ToString(), out test))
{
data.PersonalSemesterAverageN = Convert.ToDouble(reader["PersonalSemesterAverageN"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageD"].ToString(), out test))
{
data.PersonalSemesterAverageD = Convert.ToDouble(reader["PersonalSemesterAverageD"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageSD"].ToString(), out test))
{
data.PersonalSemesterAverageSD = Convert.ToDouble(reader["PersonalSemesterAverageSD"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageNA"].ToString(), out test))
{
data.PersonalSemesterAverageNA = Convert.ToDouble(reader["PersonalSemesterAverageNA"].ToString());
}
if (Double.TryParse(reader["PersonalSemesterAverageTotal"].ToString(), out test))
{
data.PersonalSemesterAverageTotal = Convert.ToDouble(reader["PersonalSemesterAverageTotal"].ToString());
}
if (Double.TryParse(reader["DptFiveYearCourseAverageSA"].ToString(), out test))
{
data.DptFiveYearCourseAverageSA = Convert.ToDouble(reader["DptFiveYearCourseAverageSA"].ToString());
}
if (Double.TryParse(reader["DptFiveYearCourseAverageA"].ToString(), out test))
{
data.DptFiveYearCourseAverageA = Convert.ToDouble(reader["DptFiveYearCourseAverageA"].ToString());
}
if (Double.TryParse(reader["DptFiveYearCourseAverageN"].ToString(), out test))
{
data.DptFiveYearCourseAverageN = Convert.ToDouble(reader["DptFiveYearCourseAverageN"].ToString());
}
if (Double.TryParse(reader["DptFiveYearCourseAverageD"].ToString(), out test))
{
data.DptFiveYearCourseAverageD = Convert.ToDouble(reader["DptFiveYearCourseAverageD"].ToString());
}
if (Double.TryParse(reader["DptFiveYearCourseAverageSD"].ToString(), out test))
{
data.DptFiveYearCourseAverageSD = Convert.ToDouble(reader["DptFiveYearCourseAverageSD"].ToString());
}
if (Double.TryParse(reader["DptFiveYearCourseAverageNA"].ToString(), out test))
{
data.DptFiveYearCourseAverageNA = Convert.ToDouble(reader["DptFiveYearCourseAverageNA"]);
}
if (Double.TryParse(reader["DptFiveYearCourseAverageTotal"].ToString(), out test))
{
data.DptFiveYearCourseAverageTotal = Convert.ToDouble(reader["DptFiveYearCourseAverageTotal"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageSA"].ToString(), out test))
{
data.DptSemesterAverageSA = Convert.ToDouble(reader["DptSemesterAverageSA"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageA"].ToString(), out test))
{
data.DptSemesterAverageA = Convert.ToDouble(reader["DptSemesterAverageA"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageN"].ToString(), out test))
{
data.DptSemesterAverageN = Convert.ToDouble(reader["DptSemesterAverageN"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageD"].ToString(), out test))
{
data.DptSemesterAverageD = Convert.ToDouble(reader["DptSemesterAverageD"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageSD"].ToString(), out test))
{
data.DptSemesterAverageSD = Convert.ToDouble(reader["DptSemesterAverageSD"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageNA"].ToString(), out test))
{
data.DptSemesterAverageNA = Convert.ToDouble(reader["DptSemesterAverageNA"].ToString());
}
if (Double.TryParse(reader["DptSemesterAverageTotal"].ToString(), out test))
{
data.DptSemesterAverageTotal = Convert.ToDouble(reader["DptSemesterAverageTotal"].ToString());
}
questionDetails.DATA.Add(data);
}
return(questionDetails);
}
catch (SqlException ex)
{
return(null);
}
finally
{
connection.Close();
}
}
