public IList<Core.Business.FolderDesc> GetAllFolderDesc()
{
IList<Core.Business.FolderDesc> folderDesclist = new List<Core.Business.FolderDesc>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllFolderDesc);
if (reader != null)
{
while (reader.Read())
{
Core.Business.FolderDesc folderDesc = new Core.Business.FolderDesc();
if (!reader.IsDBNull(0)) folderDesc.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) folderDesc.EventInfo = reader.GetInt32(1);
if (!reader.IsDBNull(2)) folderDesc.StartDate = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) folderDesc.EndDate = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) folderDesc.KeyWord = reader.GetString(4);
if (!reader.IsDBNull(5)) folderDesc.Photographer = reader.GetString(5);
if (!reader.IsDBNull(6)) folderDesc.Leader = reader.GetString(6);
if (!reader.IsDBNull(7)) folderDesc.OtherLeader = reader.GetString(7);
if (!reader.IsDBNull(8)) folderDesc.Guest = reader.GetString(8);
if (!reader.IsDBNull(9)) folderDesc.InnerLocation = reader.GetString(9);
if (!reader.IsDBNull(10)) folderDesc.OuterLocation = reader.GetString(10);
if (!reader.IsDBNull(11)) folderDesc.EventDesc = reader.GetString(11);
folderDesc.MarkOld();
folderDesclist.Add(folderDesc);
}
reader.Close();
}
return folderDesclist;
}
public Core.Business.FolderDesc Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectFolderDesc);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.FolderDesc folderDesc = new Core.Business.FolderDesc();
if (!reader.IsDBNull(0)) folderDesc.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) folderDesc.EventInfo = reader.GetInt32(1);
if (!reader.IsDBNull(2)) folderDesc.StartDate = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) folderDesc.EndDate = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) folderDesc.KeyWord = reader.GetString(4);
if (!reader.IsDBNull(5)) folderDesc.Photographer = reader.GetString(5);
if (!reader.IsDBNull(6)) folderDesc.Leader = reader.GetString(6);
if (!reader.IsDBNull(7)) folderDesc.OtherLeader = reader.GetString(7);
if (!reader.IsDBNull(8)) folderDesc.Guest = reader.GetString(8);
if (!reader.IsDBNull(9)) folderDesc.InnerLocation = reader.GetString(9);
if (!reader.IsDBNull(10)) folderDesc.OuterLocation = reader.GetString(10);
if (!reader.IsDBNull(11)) folderDesc.EventDesc = reader.GetString(11);
reader.Close();
EventInfoProvider provider = new EventInfoProvider();
folderDesc.EventInfoEntity = provider.Select(folderDesc.EventInfo);
return folderDesc;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
