public IList<Core.Business.DocumentAttach> GetAllDocumentAttach()
{
IList<Core.Business.DocumentAttach> documentAttachlist = new List<Core.Business.DocumentAttach>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllDocumentAttach);
if (reader != null)
{
while (reader.Read())
{
Core.Business.DocumentAttach documentAttach = new Core.Business.DocumentAttach();
if (!reader.IsDBNull(0)) documentAttach.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) documentAttach.Url = reader.GetString(1);
documentAttach.MarkOld();
documentAttachlist.Add(documentAttach);
}
reader.Close();
}
return documentAttachlist;
}
public Core.Business.DocumentAttach Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectDocumentAttach);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.DocumentAttach documentAttach = new Core.Business.DocumentAttach();
if (!reader.IsDBNull(0)) documentAttach.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) documentAttach.Url = reader.GetString(1);
reader.Close();
return documentAttach;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
