public List <ArticleTitle> GetArticlesTitles()
{
string sql = "SELECT t1.Id, t1.Title, t1.CreationDate, t2.* FROM Articles t1 "
+ "INNER JOIN ArticlesCategories t1t2 ON t1.Id=t1t2.Article_Id "
+ "INNER JOIN Categories t2 ON t2.Id=t1t2.Category_Id "
+ "ORDER BY t1.CreationDate DESC "
;
using (var connection = new SqlConnection(connectionString))
{
List <ArticleTitle> result = new List <ArticleTitle>();
connection
.Query <ArticleTitle, Category, ArticleTitle>(sql,
(_article, _category) =>
{
ArticleTitle existing = result.FirstOrDefault(x => x.Id == _article.Id);
if (existing == null)
{
_article.Categories.Add(_category);
result.Add(_article);
}
else
{
existing.Categories.Add(_category);
}
return(_article);
});
return(result);
}
}
public IHttpActionResult Articles(ArticleTitle title)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Passed information isn't valid."));
}
var da = new DataAccess();
var arts = da.GetArticles(title.Title);
if (arts == null)
{
return(NotFound());
}
// Let's convert the article objects
var articles = Mapper.MapArticle(arts);
if (articles == null)
{
throw new NotImplementedException();
}
return(Ok(articles));
}
catch (Exception ex)
{
logger.Error(ex, "Attempt to get articles from title " + title.Title + " failed: " + ex.Message);
return(BadRequest("Something went wrong while saving comment."));
}
}
public FakeArticle(ArticleTitle title)
{
_source = new FakePath(title.PlainText);
Parts = new List <ArticlePart>()
{
ArticlePart.CreateHeader(title.TextWithLineBreak)
};
}
public override int GetHashCode()
{
var toReturn =
ArticleId.GetHashCode() ^
NewsletterId.GetHashCode() ^
ArticleSequence.GetHashCode() ^
ImageFileLocation.GetHashCode() ^
ArticleType.GetHashCode() ^
ArticleTableOfContentsText.GetHashCode() ^
ArticleTitle.GetHashCode() ^
ArticleText.GetHashCode();
return(toReturn);
}
public ActionResult Index(Category?category = null)
{
if (category == null)
{
return(View("Empty"));
}
IEnumerable <ArticleTitle> articleTitles = articlesRepository.Articles
.Where(a => a.Category == category)
.ToArray()
.Select(a =>
{
ArticleTitle articleTitle = new ArticleTitle();
articleTitle.InjectFrom(a);
return(articleTitle);
});
return(View(articleTitles));
}
public void FindTitleArticle(string article)
{
var pattern = @"<Titulo>(.*)</Titulo>";
Regex rgx = new Regex(pattern, RegexOptions.Compiled | RegexOptions.IgnoreCase);
MatchCollection matches = rgx.Matches(article);
if (matches.Count > 0)
{
Match match = matches[0];
//Tratamento do titulo
ArticleTitle = match.Value;
ArticleTitle = ArticleTitle.Replace("<Titulo>", "");
ArticleTitle = ArticleTitle.Replace("</Titulo>", "");
}
}
public void EnterArticleTitle(string title)
{
ArticleTitle.SendKeys(title);
}
private HttpRequestMessage CreateSearchRequestToService(Search search)
{
try
{
HttpRequestMessage requestMessage = CreateRequestToService(HttpMethod.Post, "api/Data/" + search.Criteria);
if (search.Criteria == "Title")
{
var at = new ArticleTitle()
{
Title = search.SearchString
};
requestMessage.Content = new ObjectContent <ArticleTitle>(at, new JsonMediaTypeFormatter());
}
else if (search.Criteria == "Topic")
{
var at = new ArticleTopic()
{
Topic = search.SearchString
};
requestMessage.Content = new ObjectContent <ArticleTopic>(at, new JsonMediaTypeFormatter());
}
else if (search.Criteria == "Source")
{
var at = new ArticleSource()
{
Name = search.SearchString
};
requestMessage.Content = new ObjectContent <ArticleSource>(at, new JsonMediaTypeFormatter());
}
else if (search.Criteria == "Country")
{
var at = new ArticleCountry()
{
Country = search.SearchString
};
requestMessage.Content = new ObjectContent <ArticleCountry>(at, new JsonMediaTypeFormatter());
}
else if (search.Criteria == "Language")
{
var at = new ArticleLanguage()
{
Language = search.SearchString
};
requestMessage.Content = new ObjectContent <ArticleLanguage>(at, new JsonMediaTypeFormatter());
}
else if (search.Criteria == "Date")
{
var at = new ArticlePulished()
{
PublishedDate = Convert.ToDateTime(search.SearchString)
};
requestMessage.Content = new ObjectContent <ArticlePulished>(at, new JsonMediaTypeFormatter());
}
return(requestMessage);
}
catch (Exception ex)
{
// log the error here
logger.Error(ex.Message);
return(null);
}
}
