//public IEnumerable<KeyValuePair<int, string>> GetSpecialIdentifiers() //{ // using (var command = database.GetStoredProcCommand(StoredProcNames.InfoLib.GetInfoLibSpecialIdentifiers.Description())) // { // using (IDataReader reader = database.ExecuteReader(command)) // { // while (reader.Read()) // yield return new KeyValuePair<int, string>(reader.GetInt32(0), reader.GetString(1)); // } // } //} public InfoLibForumCallItem GetInfoLibForumCallItem() { using (var command = database.GetStoredProcCommand(StoredProcNames.InfoLib.GetInfoLibForumCall.Description())) { using (IDataReader reader = database.ExecuteReader(command)) { InfoLibForumCallItem forumCallItem = null; if (reader.Read()) { forumCallItem = new InfoLibForumCallItem(); forumCallItem.SummaryItem = new InfoLibItem() { InfoLibItemId = reader.GetInt32(0), ParentId = reader.GetInt32(1), ItemHeader = new InfoLibItem.InfoLibItemHeader() { HeaderText = reader.IsDBNull(2) ? null : reader.GetString(2), HeaderType = reader.GetInt16(3).ToEnumObject <InfoLibHeaderType>() }, ViewerScope = reader.IsDBNull(4) ? (Scope?)null : reader.GetInt16(4).ToEnumObject <Scope>() }; reader.NextResult(); if (reader.Read()) { forumCallItem.DetailedItem = new InfoLibItem() { InfoLibItemId = reader.GetInt32(0), ParentId = reader.GetInt32(1), ItemHeader = new InfoLibItem.InfoLibItemHeader() { HeaderText = reader.IsDBNull(2) ? null : reader.GetString(2), HeaderType = reader.GetInt16(3).ToEnumObject <InfoLibHeaderType>() }, ViewerScope = reader.IsDBNull(4) ? (Scope?)null : reader.GetInt16(4).ToEnumObject <Scope>() }; } } return(forumCallItem); } } }
private void InitializeView() { InfoLibForumCallItem forumCallItem = InfoLibBLL.GetInfoLibForumCallItem(); if (forumCallItem != null) { divforumCallSummaryView.Visible = true; InfoLibItem summaryItem = forumCallItem.SummaryItem; litSummaryViewContent.Text = summaryItem.ItemHeader.HeaderText; if (forumCallItem.DetailedItem != null) { hlMoreLink.Visible = true; NameValueCollection nvColl = new NameValueCollection(); nvColl.Add(QueryStringHelper.QueryStringParamNames.INFOLIB_ITEMID_INT.Description(), forumCallItem.DetailedItem.InfoLibItemId.ToString()); nvColl.Add(QueryStringHelper.QueryStringParamNames.INFOLIB_PARENTID_INT.Description(), forumCallItem.DetailedItem.ParentId.ToString()); nvColl.Add(QueryStringHelper.QueryStringParamNames.INFOLIB_SPECIAL_IDENTIFIER.Description(), InfoLibSpecialIdentifiers.Forum_call.EnumValue <int>().ToString()); hlMoreLink.NavigateUrl = InfoLibUtil.ConstructInfoLibItemNavigationUrl(nvColl); } } }