public List <CapeReview> GetCapeReviews(string studentId, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); var capeReviewList = new List <CapeReview>(); try { var adapter = new SqlDataAdapter(GetStudentCapeReviews, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@student_id", SqlDbType.VarChar, 20)); adapter.SelectCommand.Parameters["@student_id"].Value = studentId; var dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } for (var i = 0; i < dataSet.Tables[0].Rows.Count; i++) { var capeReview = new CapeReview { CourseScheduleId = Convert.ToInt32(dataSet.Tables[0].Rows[i]["course_schedule_id"].ToString()), Quarter = dataSet.Tables[0].Rows[i]["quarter"].ToString(), Year = dataSet.Tables[0].Rows[i]["year"].ToString(), Course = new Course { Title = dataSet.Tables[0].Rows[i]["course_title"].ToString(), Description = dataSet.Tables[0].Rows[i]["course_description"].ToString() }, Instructor = new Instructor { FirstName = dataSet.Tables[0].Rows[i]["instructor_first_name"].ToString(), LastName = dataSet.Tables[0].Rows[i]["instructor_last_name"].ToString() } }; capeReviewList.Add(capeReview); } } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(capeReviewList); }
public List <CapeCourseReview> GetCapeReviewByCourse(int course_id, ref List <string> errors) { var list = new List <CapeCourseReview>(); var conn = new SqlConnection(ConnectionString); try { var adapter = new SqlDataAdapter(GetCapeReviewByCourseProcedure, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@course_id", SqlDbType.Int)); adapter.SelectCommand.Parameters["@course_id"].Value = course_id; var dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } for (var i = 0; i < dataSet.Tables[0].Rows.Count; i++) { var cape = new CapeReview { CourseScheduleId = Convert.ToInt32(dataSet.Tables[0].Rows[i]["course_schedule_id"].ToString()), Quarter = dataSet.Tables[0].Rows[i]["quarter"].ToString(), Year = dataSet.Tables[0].Rows[i]["year"].ToString(), Course = new Course { CourseId = dataSet.Tables[0].Rows[i]["course_id"].ToString(), Title = dataSet.Tables[0].Rows[i]["course_title"].ToString(), Description = dataSet.Tables[0].Rows[i]["course_description"].ToString() }, Instructor = new Instructor { FirstName = dataSet.Tables[0].Rows[i]["instructor_first_name"].ToString(), LastName = dataSet.Tables[0].Rows[i]["instructor_last_name"].ToString() } }; var capeCourseReview = new CapeCourseReview { CapeDetail = cape, As = Convert.ToInt32(dataSet.Tables[0].Rows[i]["As"].ToString()), Bs = Convert.ToInt32(dataSet.Tables[0].Rows[i]["Bs"].ToString()), Cs = Convert.ToInt32(dataSet.Tables[0].Rows[i]["Cs"].ToString()), Ds = Convert.ToInt32(dataSet.Tables[0].Rows[i]["Ds"].ToString()), Fs = Convert.ToInt32(dataSet.Tables[0].Rows[i]["Fs"].ToString()), TotalReviews = Convert.ToInt32(dataSet.Tables[0].Rows[i]["total"].ToString()), AverageReview = Convert.ToSingle(dataSet.Tables[0].Rows[i]["avg"].ToString()) }; list.Add(capeCourseReview); } } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(list); }