internal static void MapDataReaderToContentDto(SQLiteDataReader dataReader, out ContentDto contentDto)
{
contentDto = new ContentDto();
contentDto.ContentId = dataReader.GetInt64((int) ContentDao.ContentsField.ContentId);
contentDto.UrlId = dataReader.GetInt64((int) ContentDao.ContentsField.UrlId);
contentDto.ContentType = (ContentTypesEnum) dataReader.GetInt64((int) ContentDao.ContentsField.ContentType);
contentDto.Element = dataReader.GetString((int) ContentDao.ContentsField.Element);
contentDto.Element = HttpUtility.UrlDecode(contentDto.Element);
contentDto.Line = dataReader.GetInt64((int) ContentDao.ContentsField.Line);
contentDto.LinePosition = dataReader.GetInt64((int) ContentDao.ContentsField.LinePosition);
}
private static ContentDto[] GetContent(WebPageParsing webPageParsing)
{
var content = new List <ContentDto>();
var webPageContent = webPageParsing.GetTitle();
var contentDto = new ContentDto
{
Element = webPageContent.Element,
Line = webPageContent.Line,
LinePosition = webPageContent.LinePosition
};
content.Add(contentDto);
return content.ToArray();
}
internal void InsertOrUpdateContent(ContentDto contentDto)
{
string sqlStatement;
if (contentDto.ContentId.HasValue)
{
sqlStatement = String.Format("INSERT OR REPLACE INTO Contents (content_id, url_id, content_type, element, line, line_position) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')",
contentDto.ContentId, contentDto.UrlId, contentDto.ContentTypeRawInt, HttpUtility.UrlEncode(contentDto.Element),
contentDto.Line, contentDto.LinePosition);
ExecuteSqlCommand(sqlStatement);
}
else
{
sqlStatement = String.Format("INSERT OR REPLACE INTO Contents (url_id, content_type, element, line, line_position) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')",
contentDto.UrlId, contentDto.ContentTypeRawInt, HttpUtility.UrlEncode(contentDto.Element), contentDto.Line,
contentDto.LinePosition);
ExecuteSqlCommand(sqlStatement);
contentDto.ContentId = GetLastInsertedRowId();
}
}