public IList<CY.GFive.Core.Business.TeacherCourse> Fill(Course course)
{
if (course == null)
return null;
IList<Core.Business.TeacherCourse> teacherCourselist = new List<Core.Business.TeacherCourse>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@CourseCode", SqlDbType.NVarChar, course.Code, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillCourseList);
if (reader != null)
{
while (reader.Read())
{
Core.Business.TeacherCourse teacherCourse = new Core.Business.TeacherCourse();
if (!reader.IsDBNull(0)) teacherCourse.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherCourse.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherCourse.CourseCode = reader.GetString(2);
teacherCourse.MarkOld();
teacherCourselist.Add(teacherCourse);
}
reader.Close();
}
return teacherCourselist;
}
public IList<Core.Business.TeacherCourse> GetAllTeacherCourse()
{
IList<Core.Business.TeacherCourse> teacherCourselist = new List<Core.Business.TeacherCourse>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTeacherCourse);
if (reader != null)
{
while (reader.Read())
{
Core.Business.TeacherCourse teacherCourse = new Core.Business.TeacherCourse();
if (!reader.IsDBNull(0)) teacherCourse.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherCourse.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherCourse.CourseCode = reader.GetString(2);
teacherCourse.MarkOld();
teacherCourselist.Add(teacherCourse);
}
reader.Close();
}
return teacherCourselist;
}
public IList<TeacherCourse> SelectByTeacher(string teacherCode)
{
IList<Core.Business.TeacherCourse> teacherCourselist = new List<Core.Business.TeacherCourse>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@teacherCode",SqlDbType.NVarChar,teacherCode);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectByTeacher);
if (reader != null)
{
while (reader.Read())
{
Core.Business.TeacherCourse teacherCourse = new Core.Business.TeacherCourse();
if (!reader.IsDBNull(0)) teacherCourse.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherCourse.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherCourse.CourseCode = reader.GetString(2);
teacherCourse.MarkOld();
teacherCourselist.Add(teacherCourse);
}
reader.Close();
}
return teacherCourselist;
}
public Core.Business.TeacherCourse Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTeacherCourse);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.TeacherCourse teacherCourse = new Core.Business.TeacherCourse();
if (!reader.IsDBNull(0)) teacherCourse.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherCourse.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherCourse.CourseCode = reader.GetString(2);
reader.Close();
return teacherCourse;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
