private void LoadControl()
{
SliderTopic result = new SliderTopic();
TabTopicDisplayCollection listTabTopicDisplay = TabTopicDisplayCollection.GetTabTopicDisplayCollection();
var sliderTopic = listTabTopicDisplay.Where(item => item.DataId == Portlet.PortletInstance.Id).FirstOrDefault();
string topicid1;
string topicid2;
if (sliderTopic != null)
{
result.TopicId1 = sliderTopic.TopicId;
topicid1 = result.TopicId1.ToString();
Topic topic = TopicCollection.GetTopic(topicid1 != "" ? topicid1 : "");
result.TopicName1 = topic.Name;
result.SliderArticleList = ArticleCollection.GetArticleCollection(sliderTopic.TopicId.ToString(), 0, sliderTopic.NumberDisplay);
result.SliderArticleList.ForEach(d => d.Name = d.GetDescription().Replace("\"", "\\\""));
}
var secondTopic = listTabTopicDisplay.Where(item => item.DataId == Portlet.PortletInstance.Id).Skip(1).Take(1).SingleOrDefault();
if (secondTopic != null)
{
result.TopicId2 = secondTopic.TopicId;
topicid2 = result.TopicId2.ToString();
Topic topic = TopicCollection.GetTopic(topicid2 != "" ? topicid2 : "");
result.TopicName2 = topic.Name;
result.SecondArticleList = ArticleCollection.GetArticleCollection(secondTopic.TopicId.ToString(), 0, secondTopic.NumberDisplay).Take(3).ToList();
}
var js = new JavaScriptSerializer();
ListArticle = js.Serialize(result);
}
private void LoadData()
{
Object topicGuid = null;
int numberOfArticlesDisplay = 0;
using (
SqlConnection con =
new SqlConnection(
System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"]
.ConnectionString))
{
SqlCommand com = new SqlCommand();
com.Connection = con;
con.Open();
com.CommandType = System.Data.CommandType.Text;
com.Parameters.AddWithValue("@dataId", Portlet.PortletInstance.Id);
com.CommandText = "select TopicId,NumberOfArticlesDisplay From PortletTopicDisplay Where DataId=@dataId";
SqlDataReader reader = com.ExecuteReader();
if (reader.Read())
{
topicGuid = (Guid)reader["TopicId"];
numberOfArticlesDisplay = int.Parse(reader["NumberOfArticlesDisplay"].ToString());
}
}
if (topicGuid == null)
{
return;
}
CMS.Topic topicDisplay = CMS.Topic.GetTopic(topicGuid.ToString());
SliderTopic result = new SliderTopic();
if (topicDisplay != null)
{
//thay đổi ngày 6/5/2014
CMS.ArticleCollection arList = CMS.ArticleCollection.GetArticleCollectionPublish(topicDisplay);
CMS.ArticleCollection arListHang = CMS.ArticleCollection.GetArticleCollectionPublishHang(topicDisplay);
IEnumerable <CMS.Article> iArt1 = arList.Where(a => !arListHang.Contains(a)).Take(numberOfArticlesDisplay - arListHang.Count());
foreach (var item in iArt1)
{
arListHang.Add(item);
}
var js = new JavaScriptSerializer();
Dictionary <string, object> resultDic = new Dictionary <string, object>();
resultDic["ResultList"] = arListHang;
resultDic["TopicId"] = topicDisplay.Id;
resultDic["TopicName"] = topicDisplay.Name;
ListArticle = js.Serialize(resultDic);
//rptArticleRelation.DataSource = arListHang;
//rptArticleRelation.DataBind();
}
}
