Ejemplo n.º 1
0
 public void AddHistoryEntry(Song song)
 {
     var cmdHistoryInsert = new SQLiteCommand("INSERT INTO history (id, title, time) VALUES ((SELECT max(id) FROM history) + 1, @title, @time)", this.connection);
     cmdHistoryInsert.Parameters.AddWithValue("@title", song.title);
     cmdHistoryInsert.Parameters.AddWithValue("@time", GetUnixTime());
     cmdHistoryInsert.ExecuteNonQuery();
 }
Ejemplo n.º 2
0
        public static Song CreateFromTitle(string title)
        {
            try
            {
                Regex titleRegex = new Regex(Database.Instance.GetKv("song_title_regex", @"(.*?)\s\-\s(.*)"), RegexOptions.IgnoreCase | RegexOptions.Singleline);
                Match titleMatch = titleRegex.Match(title);

                if (titleMatch.Success && titleMatch.Groups.Count == 3)
                {
                    var songAuthor = titleMatch.Groups[1].Value;
                    var songName = titleMatch.Groups[2].Value;

                    var instance = new Song();
                    instance.author = songAuthor;
                    instance.name = songName;
                    instance.title = title;
                    return instance;
                }
            }
            catch (Exception)
            {
                return null;
            }

            return null;
        }
 public SongStat(Song song)
 {
     this.song = song;
     this.occurrencesTitle = 0;
     this.occurrencesTitlePercent = 0;
     this.occurrencesAuthor = 0;
     this.occurrencesAuthorPercent = 0;
 }