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

namespace Sony.Filtr.Core.Seasons
{
    public class SeasonFactory
    {
        internal List<Season> GetSeasons(Application application)
        {
            return PetaPocoRepository.ReadOnlyInstance.Fetch<Season>("WHERE applicationId=@0", application.ID);
        }

        internal Season AddSeason(Season season)
        {
            var insertedId = PetaPocoRepository.Instance.Insert(season);
            season.Id = insertedId;
            return season;
        }

        internal void UpdateSeason(Season season)
        {
            PetaPocoRepository.Instance.Update(season);
        }

        internal void DeleteSeason(Season season)
        {
            PetaPocoRepository.Instance.Delete<Season>(season);
        }

        internal Season GetSeasons(int id)
        {
            return PetaPocoRepository.ReadOnlyInstance.SingleOrDefault<Season>(id);
        }
    }
}