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(); } }