Ejemplo n.º 1
0
        public void RemoveLink(Link link)
        {
            if (link == null)
                throw new ArgumentNullException("link");

            if (!links.Contains(link))
                return;

            links.Remove(link);
        }
Ejemplo n.º 2
0
        public void AddLink(Link link)
        {
            if (link == null)
                throw new ArgumentNullException("link");

            if (links.Contains(link))
                return;

            links.Add(link);
        }
Ejemplo n.º 3
0
        private void SaveArtistLink(Artist artist, Link link)
        {
            if (artist == null || link == null)
                return;

            var artistId = cache.GetArtistId(artist);
            if (artistId == 0)
                return;

            var id = cache.GetArtistLinkId(link);

            if (id > 0)
            {
                database.UpdateArtistLink(connection, link, id, artistId);
            }
            else
            {
                id = database.InsertArtistLink(connection, link, artistId);
                cache.Add(id, artist, link);
            }
        }
Ejemplo n.º 4
0
        public void Add(uint id, Artist artist, Link link)
        {
            if (artistLinksById.ContainsKey(id))
                return;

            var artistId = GetArtistId(artist);
            if (artistId == 0)
                return;

            artistLinksById.Add(id, link);

            if (linksByArtistId.ContainsKey(artistId))
            {
                if (linksByArtistId[artistId].Contains(link))
                    return;

                linksByArtistId[artistId].Add(link);
            }
            else
                linksByArtistId[artistId] = new List<Link> { link };
        }
Ejemplo n.º 5
0
        private void LoadArtistLinks(IDbConnection connection, GlobalCache cache)
        {
            var command = GetCommand(connection, "select * from ArtistLink;");
            using (var reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    var id = (uint)reader.GetInt64(0);
                    var artist = cache.GetArtist((uint)reader.GetInt64(1));
                    var name = reader.GetString(2);
                    var relationship = (Relationship)reader.GetInt32(3);
                    var source = (Source)reader.GetInt32(4);
                    var target = reader.GetString(5);

                    if (artist == null)
                        continue;

                    var link = new Link(name, relationship, source, target);
                    cache.Add(id, artist, link);
                    artist.AddLink(link);
                }
            }
        }
Ejemplo n.º 6
0
        private void SaveWorkLink(Work work, Link link)
        {
            if (work == null || link == null)
                return;

            var workId = cache.GetWorkId(work);
            if (workId == 0)
                return;

            var id = cache.GetWorkLinkId(link);

            if (id > 0)
            {
                database.UpdateWorkLink(connection, link, id, workId);
            }
            else
            {
                id = database.InsertWorkLink(connection, link, workId);
                cache.Add(id, work, link);
            }
        }
Ejemplo n.º 7
0
        public void Add(uint id, Work work, Link link)
        {
            if (workLinksById.ContainsKey(id))
                return;

            var workId = GetWorkId(work);
            if (workId == 0)
                return;

            workLinksById.Add(id, link);

            if (linksByWorkId.ContainsKey(workId))
            {
                if (linksByWorkId[workId].Contains(link))
                    return;

                linksByWorkId[workId].Add(link);
            }
            else
                linksByWorkId[workId] = new List<Link> { link };
        }
Ejemplo n.º 8
0
        public uint GetWorkLinkId(Link link)
        {
            if (link == null)
                return 0;

            return workLinksById.Where(x => x.Value == link).FirstOrDefault().Key;
        }
Ejemplo n.º 9
0
        public void Remove(Work work, Link link)
        {
            var id = GetWorkLinkId(link);
            if (id == 0)
                return;

            if (!workLinksById.ContainsKey(id))
                return;

            var workId = GetWorkId(work);
            if (linksByWorkId.ContainsKey(workId))
            {
                if (linksByWorkId[workId].Contains(link))
                    linksByWorkId[workId].Remove(link);
            }

            workLinksById.Remove(id);
        }
Ejemplo n.º 10
0
        public void Remove(Artist artist, Link link)
        {
            var id = GetArtistLinkId(link);
            if (id == 0)
                return;

            if (!artistLinksById.ContainsKey(id))
                return;

            var artistId = GetArtistId(artist);
            if (linksByArtistId.ContainsKey(artistId))
            {
                if (linksByArtistId[artistId].Contains(link))
                    linksByArtistId[artistId].Remove(link);
            }

            artistLinksById.Remove(id);
        }
Ejemplo n.º 11
0
        public void UpdateWorkLink(IDbConnection connection, Link link, uint id, uint workId)
        {
            if (!link.IsChanged)
                return;

            var command = connection.CreateCommand();
            AddParameter(command, "@Work", workId);
            AddParameter(command, "@Name", link.Name);
            AddParameter(command, "@Relationship", (ushort)link.Relationship);
            AddParameter(command, "@Source", (ushort)link.Source);
            AddParameter(command, "@Target", link.Target);
            AddParameter(command, "@Id", id);
            command.CommandText = "update WorkLink set Work = @Work, Name = @Name, Relationship = @Relationship, Source = @Source, Target = @Target where Id = @Id;";
            command.ExecuteNonQuery();
        }
Ejemplo n.º 12
0
        public uint InsertWorkLink(IDbConnection connection, Link link, uint workId)
        {
            var command = connection.CreateCommand();
            AddParameter(command, "@Work", workId);
            AddParameter(command, "@Name", link.Name);
            AddParameter(command, "@Relationship", (ushort)link.Relationship);
            AddParameter(command, "@Source", (ushort)link.Source);
            AddParameter(command, "@Target", link.Target);
            command.CommandText = "insert into WorkLink (Work, Name, Relationship, Source, Target) values (@Work, @Name, @Relationship, @Source, @Target); select last_insert_rowid();";
            var result = command.ExecuteScalar();

            uint id = 0;
            return (result != null && uint.TryParse(result.ToString(), out id)) ? id : 0;
        }