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

namespace Sony.Filtr.Core.Releases
{
    public class ReleaseFactory
    {
        internal void SetReleases(IEnumerable<Release> releases, Application application)
        {
            var petaPocoDb = PetaPocoRepository.Instance.Db;
            using (var tr = petaPocoDb.GetTransaction())
            {
                petaPocoDb.Delete<Release>("WHERE intApplicationID=@0", application.ID);
                foreach (var release in releases)
                {
                    petaPocoDb.Insert(release);
                }

                tr.Complete();
            }
        }

        internal List<Release> GetReleases(Application app)
        {
            if (app == null)
                return PetaPocoRepository.ReadOnlyInstance.Fetch<Release>();
            else
                return PetaPocoRepository.ReadOnlyInstance.Fetch<Release>("WHERE intApplicationID=@0", app.ID);
        }
    }
}