public IList<Core.Business.Filter> GetAllFilter()
{
IList<Core.Business.Filter> filterlist = new List<Core.Business.Filter>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllFilter);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Filter filter = new Core.Business.Filter();
if (!reader.IsDBNull(0)) filter.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) filter.Name = reader.GetString(1);
filter.MarkOld();
filterlist.Add(filter);
}
reader.Close();
}
return filterlist;
}
public Core.Business.Filter Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectFilter);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Filter filter = new Core.Business.Filter();
if (!reader.IsDBNull(0)) filter.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) filter.Name = reader.GetString(1);
reader.Close();
return filter;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
