using System.Collections.Generic;
using System.Linq;
using PetaPoco.Business;
using Sony.Filtr.Contracts.Entities;

namespace Sony.Filtr.Core
{
    public class StarredContentManager
    {
        public StarredContent AddStarredContent(StarredContent starredContent)
        {
            var id = PetaPocoRepository.Instance.Insert(starredContent);
            starredContent.Id = id;
            return starredContent;
        }

        public List<StarredContent> GetStarredContent(string userId)
        {
            return PetaPocoRepository.Instance.Fetch<StarredContent>("WHERE UserId=@0", userId);
        }

        public bool HasStarredContent(string userId, string contentUri)
        {
            var existingContent = PetaPocoRepository.Instance.SingleOrDefaultWithSql<StarredContent>("WHERE UserId=@0 AND Uri=@1", userId, contentUri);
            return existingContent != null;
        }

        public void RemoveStarredContent(string userId, string contentUri)
        {
            PetaPocoRepository.Instance.Delete<StarredContent>("WHERE UserId=@0 AND Uri=@1", userId, contentUri);
        }

    }
}