public SitePage GetByID(int _sitePageId) { SitePageDAC _sitePageComponent = new SitePageDAC(); IDataReader reader = _sitePageComponent.GetByIDSitePage(_sitePageId); SitePage _sitePage = null; while (reader.Read()) { _sitePage = new SitePage(); if (reader["SitePageId"] != DBNull.Value) { _sitePage.SitePageId = Convert.ToInt32(reader["SitePageId"]); } if (reader["SectionId"] != DBNull.Value) { _sitePage.SectionId = Convert.ToInt32(reader["SectionId"]); } if (reader["PageStatusId"] != DBNull.Value) { _sitePage.PageStatusId = Convert.ToInt32(reader["PageStatusId"]); } if (reader["SecurityAccessTypeId"] != DBNull.Value) { _sitePage.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]); } if (reader["CreatorId"] != DBNull.Value) { _sitePage.CreatorId = Convert.ToInt32(reader["CreatorId"]); } if (reader["UniquePageName"] != DBNull.Value) { _sitePage.UniquePageName = Convert.ToString(reader["UniquePageName"]); } if (reader["IsMainPage"] != DBNull.Value) { _sitePage.IsMainPage = Convert.ToBoolean(reader["IsMainPage"]); } if (reader["RowGuid"] != DBNull.Value) { _sitePage.RowGuid = new Guid(reader["RowGuid"].ToString()); } if (reader["RevisionDate"] != DBNull.Value) { _sitePage.RevisionDate = Convert.ToDateTime(reader["RevisionDate"]); } if (reader["ModifiedDate"] != DBNull.Value) { _sitePage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); } if (reader["SiteId"] != DBNull.Value) { _sitePage.SiteId = Convert.ToInt32(reader["SiteId"]); } _sitePage.NewRecord = false; } reader.Close(); return(_sitePage); }