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

namespace Sony.Filtr.Applications
{
    public class ApplicationFactory
    {
        public List<Application> GetApplications()
        {
            return PetaPocoRepository.ReadOnlyInstance.Fetch<Application>();
        }

        internal void UpdateApplication(Application app)
        {
            IEnumerable<string> updateColumns =  new List<string>()
            {
                "strLanguageID",
                "strSpotifyRegionID",
                "strName",
                "blnActive",
                "strGACountryName",
                "blnWorkout",
                "blnIncludeOtherPlaylists",
                "strDefaultService",
                "strServiceList",
            };
            PetaPocoRepository.Instance.Update(app, updateColumns);
        }

        internal Application InsertApplication(Application app)
        {
            var id = PetaPocoRepository.Instance.Insert(app);
            app.ID = id;
            return app;
        }

        internal void RemoveApplication(Application app)
        {
            PetaPocoRepository.Instance.Delete<Application>(app.ID);
        }

        internal List<string> GetApplicationMarkets(Application app)
        {
            return PetaPocoRepository.ReadOnlyInstance.Fetch<string>("SELECT Region FROM tblMarketRegion WHERE ApplicationInstanceId = @0", app.ID);
        }
    }
}