public IList<Core.Business.JuryArrange> GetAllJuryArrange() { IList<Core.Business.JuryArrange> juryArrangelist = new List<Core.Business.JuryArrange>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllJuryArrange); if(reader != null) { while(reader.Read()) { Core.Business.JuryArrange juryArrange = new Core.Business.JuryArrange(); if (!reader.IsDBNull(0)) juryArrange.Id = reader.GetInt32(0); juryArrange.MarkOld(); juryArrangelist.Add(juryArrange); } reader.Close(); } return juryArrangelist; }
public Core.Business.JuryArrange Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectJuryArrange); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.JuryArrange juryArrange = new Core.Business.JuryArrange(); if (!reader.IsDBNull(0)) juryArrange.Id = reader.GetInt32(0); reader.Close(); return juryArrange; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }