public static bool SetSource(Source oSource)
        {
            var oBuilder = new StringBuilder();
            oBuilder.AppendLine("REPLACE INTO Sources ");
            oBuilder.AppendLine("(SourceId, Name,NewsLink)");
            oBuilder.AppendLine("VALUES");
            oBuilder.AppendLine(
                $"({oSource.SourceId},{oSource.Name},{oSource.NewsLink})");

            if (connection != null)
            {
                var oCmd = new SQLiteCommand(oBuilder.ToString(), connection);
                return oCmd.ExecuteNonQuery() == 1;
            }

            return false;
        }
        public static List<Source> GetAllSources()
        {
            var lResult = new List<Source>();

            var oBuilder = new StringBuilder();
            oBuilder.AppendLine("SELECT ");
            oBuilder.AppendLine("SourceId, Name, NewsLink ");
            oBuilder.AppendLine("FROM ");
            oBuilder.AppendLine("Sources");

            if (connection != null)
            {
                var oCmd = new SQLiteCommand(oBuilder.ToString(), connection);
                using (var oReader = oCmd.ExecuteReader())
                {
                    while (oReader.Read())
                    {
                        var oSource = new Source(oReader.GetInt32(oReader.GetOrdinal("SourceId")), oReader["Name"]?.ToString(), oReader["NewsLink"]?.ToString());
                        lResult.Add(oSource);
                    }
                }
            }

            return lResult;
        }
 public SourceToManga(string link, Source source)
 {
     this.Link = link;
     this.Source = source;
 }