public IList<CY.GFive.Core.Business.AcademicYear> GetAllAcademicYearBefore(DateTime dt)
{
IList<Core.Business.AcademicYear> academicYearlist = new List<Core.Business.AcademicYear>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Date", SqlDbType.DateTime, dt);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllAcademicYearBefore);
if (reader != null)
{
while (reader.Read())
{
Core.Business.AcademicYear academicYear = new Core.Business.AcademicYear();
if (!reader.IsDBNull(0)) academicYear.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) academicYear.Name = reader.GetString(1);
if (!reader.IsDBNull(2)) academicYear.Description = reader.GetString(2);
academicYear.MarkOld();
academicYearlist.Add(academicYear);
}
reader.Close();
}
return academicYearlist;
}
public AcademicYear GetById(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectAcademicYear);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.AcademicYear academicYear = new Core.Business.AcademicYear();
if (!reader.IsDBNull(0)) academicYear.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) academicYear.Name = reader.GetString(1);
if (!reader.IsDBNull(2)) academicYear.Description = reader.GetString(2);
reader.Close();
return academicYear;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public AcademicYear Select(string yearName)
{
if (string.IsNullOrEmpty(yearName))
{
return null;
}
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, yearName);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectAcademicYearByName);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.AcademicYear academicYear = new Core.Business.AcademicYear();
if (!reader.IsDBNull(0)) academicYear.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) academicYear.Name = reader.GetString(1);
if (!reader.IsDBNull(2)) academicYear.Description = reader.GetString(2);
reader.Close();
academicYear.MarkOld();
return academicYear;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
