public Article GetArticleById(String id)
{
Article article = new Article();
if (id.Length > 6)
{
IStoryRepository blogRepo = new BloggerRepository(System.Configuration.ConfigurationManager.AppSettings["blogger_access_token"]);
article = blogRepo.GetArticleById(id);
}
else
{
IStoryRepository newsRepo = new NewsRepository();
article = newsRepo.GetArticleById(id);
}
Context.Response.AddHeader("Access-Control-Allow-Origin", "*");
Context.Response.AddHeader("Access-Control-Allow-Headers", "Content-Type");
return article;
}
public Article GetArticleById(String Id)
{
_getBodyContent = true;
Article article = new Article();
String sql = "SELECT TOP 1 ID, TYPE_ID, TIME_START, TIME_END, HEADLINE, BODY, LINK, IMAGE_NAME, OTHER_CATEGORY FROM NEWS WHERE ID = @Id";
SqlConnection conn = new DBConnection().GetConnection("");
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@Id", System.Data.SqlDbType.Int)).Value = Convert.ToInt64(Id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
String otherCategories = "";
if (!String.IsNullOrEmpty(reader["ID"].ToString()))
{
article.Id = reader["ID"].ToString();
}
if (!String.IsNullOrEmpty(reader["TIME_START"].ToString()))
{
article.DatePublished = (DateTime)reader["TIME_START"];
}
article.Disabled = false;
if (!String.IsNullOrEmpty(reader["TIME_END"].ToString()))
{
article.DateDisabled = (DateTime)reader["TIME_END"];
if (article.DateDisabled <= DateTime.Now)
{
article.Disabled = true;
}
}
if (!String.IsNullOrEmpty(reader["HEADLINE"].ToString()))
{
article.Title = (String)reader["HEADLINE"];
}
if (!String.IsNullOrEmpty(reader["BODY"].ToString()))
{
article.Body = (String)reader["BODY"];
}
if (!String.IsNullOrEmpty(reader["LINK"].ToString()))
{
article.Link = (String)reader["LINK"];
}
if (!String.IsNullOrEmpty(reader["IMAGE_NAME"].ToString()))
{
article.Image = (String)reader["IMAGE_NAME"];
}
if (!String.IsNullOrEmpty(reader["OTHER_CATEGORY"].ToString()))
{
otherCategories = (String)reader["OTHER_CATEGORY"];
}
if (!String.IsNullOrEmpty(reader["TYPE_ID"].ToString()))
{
String tempTypeId = reader["TYPE_ID"].ToString();
if (otherCategories.IndexOf(tempTypeId)<0)
{
otherCategories += "~" + tempTypeId;
}
}
if (!String.IsNullOrEmpty(otherCategories))
{
article.Tags = GetNewsTypeNameById(otherCategories);
}
article.ArticleType = "news";
}
}
reader.Close();
cmd.Dispose();
conn.Close();
conn.Dispose();
return article;
}
public List<Article> SearchByType(String typeName, Boolean onlyActive, Int32 numberOfArticles=0)
{
Int16 typeId = GetNewsTypeIdByName(typeName);
List<Article> articles = new List<Article>();
StringBuilder sql = new StringBuilder();
sql.Append("SELECT");
if (numberOfArticles > 0)
{
sql.Append(" TOP " + numberOfArticles);
}
sql.Append(" ID, TYPE_ID, TIME_START, TIME_END, HEADLINE, BODY, LINK, IMAGE_NAME, OTHER_CATEGORY FROM NEWS");
if (onlyActive)
{
sql.Append(" WHERE (TIME_START IS Null OR TIME_START <= '" + DateTime.Now + "') AND (TIME_END IS Null OR TIME_END >= '" + DateTime.Now + "')");
}
if (onlyActive)
{
sql.Append(" AND");
}
else
{
sql.Append(" WHERE");
}
sql.Append(" (TYPE_ID = @typeId OR OTHER_CATEGORY LIKE @type)");
sql.Append(" ORDER BY TIME_START DESC");
SqlConnection conn = new DBConnection().GetConnection("");
conn.Open();
SqlCommand cmd = new SqlCommand(sql.ToString(), conn);
cmd.Parameters.Add(new SqlParameter("@typeId", System.Data.SqlDbType.Int)).Value = typeId;
cmd.Parameters.Add(new SqlParameter("@type", System.Data.SqlDbType.VarChar, 255)).Value = "%" + typeId.ToString() + "%";
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Article article = new Article();
String otherCategories = "";
if (!String.IsNullOrEmpty(reader["ID"].ToString()))
{
article.Id = reader["ID"].ToString();
}
if (!String.IsNullOrEmpty(reader["TIME_START"].ToString()))
{
article.DatePublished = (DateTime)reader["TIME_START"];
}
article.Disabled = false;
if (!String.IsNullOrEmpty(reader["TIME_END"].ToString()))
{
article.DateDisabled = (DateTime)reader["TIME_END"];
if (article.DateDisabled <= DateTime.Now)
{
article.Disabled = true;
}
}
if (!String.IsNullOrEmpty(reader["HEADLINE"].ToString()))
{
article.Title = (String)reader["HEADLINE"];
}
if (!String.IsNullOrEmpty(reader["BODY"].ToString()))
{
article.Body = (String)reader["BODY"];
}
if (!String.IsNullOrEmpty(reader["LINK"].ToString()))
{
article.Link = (String)reader["LINK"];
}
if (!String.IsNullOrEmpty(reader["IMAGE_NAME"].ToString()))
{
article.Image = (String)reader["IMAGE_NAME"];
}
if (!String.IsNullOrEmpty(reader["OTHER_CATEGORY"].ToString()))
{
otherCategories = (String)reader["OTHER_CATEGORY"];
}
if (!String.IsNullOrEmpty(reader["TYPE_ID"].ToString()))
{
otherCategories += "~" + reader["TYPE_ID"].ToString();
}
if (!String.IsNullOrEmpty(otherCategories))
{
article.Tags = GetNewsTypeNameById(otherCategories);
}
article.ArticleType = "news";
articles.Add(article);
}
}
reader.Close();
cmd.Dispose();
conn.Close();
conn.Dispose();
return articles;
}
private void ProcessFeed(String feed)
{
String nextToken = "";
if (!String.IsNullOrEmpty(feed)) {
BloggerPosts bloggerPosts = new JavaScriptSerializer().Deserialize<BloggerPosts>(feed);
if (bloggerPosts.items != null)
{
if (bloggerPosts.items.Count() > 0)
{
if (!String.IsNullOrEmpty(bloggerPosts.nextPageToken))
{
nextToken = bloggerPosts.nextPageToken;
}
else
{
nextToken = "";
}
foreach (BloggerPost post in bloggerPosts.items)
{
try
{
Article newArticle = new Article();
newArticle.ArticleType = "blogger";
newArticle.Body = post.content;
newArticle.DatePublished = Convert.ToDateTime(post.published); ;
newArticle.Id = post.id;
newArticle.Tags = post.labels.ToList();
newArticle.Title = post.title;
_allArticles.Add(newArticle);
}
catch
{
//dont add
}
}
}
} else {
BloggerPost bloggerPost = new JavaScriptSerializer().Deserialize<BloggerPost>(feed);
try
{
Article newArticle = new Article();
newArticle.ArticleType = "blogger";
newArticle.Body = bloggerPost.content;
newArticle.DatePublished = Convert.ToDateTime(bloggerPost.published); ;
newArticle.Id = bloggerPost.id;
newArticle.Tags = bloggerPost.labels.ToList();
newArticle.Title = bloggerPost.title;
_allArticles.Add(newArticle);
}
catch
{
//dont add
}
}
}
//To DO - nextToken is returnig the same value on mutilep request. Do search for SSU
if (!String.IsNullOrEmpty(nextToken) && !String.IsNullOrEmpty(_feedURL))
{
ProcessFeed(GetFeed(_feedURL + "&pageToken=" + nextToken));
}
}