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