public static List<Manga> GetAllMangas()
{
var lResult = new List<Manga>();
var oBuilder = new StringBuilder();
oBuilder.AppendLine("SELECT ");
oBuilder.AppendLine("sTitle, sDesc, iRating, sImageLink, bStarred ");
oBuilder.AppendLine("FROM ");
oBuilder.AppendLine("Mangas");
if (connection != null)
{
var oCmd = new SQLiteCommand(oBuilder.ToString(), connection);
using (var oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
var oManga = new Manga();
oManga.Title = oReader["sTitle"]?.ToString();
oManga.SetDescription(oReader["sDesc"]?.ToString());
oManga.Rating = Convert.ToInt32(oReader["iRating"]);
oManga.ImageSource = HelperClass.CreateUrl(oReader["sImageLink"]?.ToString());
oManga.IsFavorit = oReader.GetBoolean(oReader.GetOrdinal("bStarred"));
lResult.Add(oManga);
}
}
}
return lResult;
}
public static void GetManga(int iMangaId, ref Manga oManga)
{
var oBuilder = new StringBuilder();
oBuilder.AppendLine("SELECT ");
oBuilder.AppendLine("sTitle, sDesc, iRating, sImageLink, bStarred ");
oBuilder.AppendLine("FROM ");
oBuilder.AppendLine("Mangas");
oBuilder.AppendLine("WHERE ");
oBuilder.AppendLine($"iMangaId = {iMangaId} ");
if (connection != null)
{
var oCmd = new SQLiteCommand(oBuilder.ToString(), connection);
using (var oReader = oCmd.ExecuteReader())
{
if (oReader.Read())
{
oManga.Id = iMangaId;
oManga.Title = oReader["sTitle"]?.ToString();
oManga.SetDescription(oReader["sDesc"]?.ToString());
oManga.Rating = Convert.ToInt32(oReader["iRating"]);
oManga.ImageSource = HelperClass.CreateUrl(oReader["sImageLink"]?.ToString());
oManga.IsFavorit = oReader.GetBoolean(oReader.GetOrdinal("bStarred"));
}
}
}
}
private static void GetDescription(Manga manga, HtmlNode divNode)
{
var node = divNode.SelectNodes(".//a[name(parent::*)='span']").LastOrDefault();
if (node != null)
manga.SetDescription(node.InnerText);
}