public IList<TeacherClass> Fill(ClassInfo classInfo)
{
if (classInfo == null)
{
return null;
}
IList<Core.Business.TeacherClass> teacherClasslist = new List<Core.Business.TeacherClass>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ClassCode", SqlDbType.NVarChar, classInfo.ClassCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillTeacherClassByClassInfo);
if (reader != null)
{
while (reader.Read())
{
Core.Business.TeacherClass teacherClass = new Core.Business.TeacherClass();
if (!reader.IsDBNull(0)) teacherClass.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherClass.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherClass.ClassCode = reader.GetString(2);
if (!reader.IsDBNull(3)) teacherClass.IsState = reader.GetBoolean(3);
teacherClass.MarkOld();
teacherClasslist.Add(teacherClass);
}
reader.Close();
}
return teacherClasslist;
}
public IList<TeacherClass> Fill(string queryParam)
{
if (string.IsNullOrEmpty(queryParam))
return this.GetAllTeacherClass();
IList<Core.Business.TeacherClass> teacherClasslist = new List<Core.Business.TeacherClass>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillTeacherClass + queryParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.TeacherClass teacherClass = new Core.Business.TeacherClass();
if (!reader.IsDBNull(0)) teacherClass.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherClass.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherClass.ClassCode = reader.GetString(2);
if (!reader.IsDBNull(3)) teacherClass.IsState = reader.GetBoolean(3);
teacherClass.MarkOld();
teacherClasslist.Add(teacherClass);
}
reader.Close();
}
return teacherClasslist;
}
public Core.Business.TeacherClass Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTeacherClass);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.TeacherClass teacherClass = new Core.Business.TeacherClass();
if (!reader.IsDBNull(0)) teacherClass.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherClass.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherClass.ClassCode = reader.GetString(2);
if (!reader.IsDBNull(3)) teacherClass.IsState = reader.GetBoolean(3);
reader.Close();
return teacherClass;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
//public TeacherClass GetByCode(string code)
//{
// SqlServerUtility sql = new SqlServerUtility();
// sql.AddParameter("@TeacherCode", SqlDbType.VarChar, code);
// SqlDataReader reader = sql.ExecuteSqlReader(SqlGetTeacherClassByCode);
// if (reader != null && !reader.IsClosed && reader.Read())
// {
// Core.Business.TeacherClass teacherClass = new Core.Business.TeacherClass();
// if (!reader.IsDBNull(0)) teacherClass.Id = reader.GetInt32(0);
// if (!reader.IsDBNull(1)) teacherClass.TeacherCode = reader.GetString(1);
// if (!reader.IsDBNull(2)) teacherClass.ClassCode = reader.GetString(2);
// if (!reader.IsDBNull(3)) teacherClass.IsState = reader.GetBoolean(3);
// teacherClass.MarkOld();
// reader.Close();
// return teacherClass;
// }
// else
// {
// if (reader != null && !reader.IsClosed)
// reader.Close();
// return null;
// }
//}
public IList<TeacherClass> GetListByQuery(string teacherCode, bool isState)
{
IList<Core.Business.TeacherClass> teacherClasslist = new List<Core.Business.TeacherClass>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@TeacherCode", SqlDbType.VarChar, teacherCode);
sql.AddParameter("@IsState", SqlDbType.Bit, isState);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetTeacherClassQuery);
if (reader != null)
{
while (reader.Read())
{
Core.Business.TeacherClass teacherClass = new Core.Business.TeacherClass();
if (!reader.IsDBNull(0)) teacherClass.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacherClass.TeacherCode = reader.GetString(1);
if (!reader.IsDBNull(2)) teacherClass.ClassCode = reader.GetString(2);
if (!reader.IsDBNull(3)) teacherClass.IsState = reader.GetBoolean(3);
teacherClass.MarkOld();
teacherClasslist.Add(teacherClass);
}
reader.Close();
}
return teacherClasslist;
}
