using System.Collections.Generic;
using MySql.Data.MySqlClient;
using PetaPoco.Business;
using Sony.Filtr.Contracts.Entities;
using Sony.Filtr.Contracts.Entities.Genre;
using Sony.Filtr.Database;

namespace Sony.Filtr.Core.Genres
{
    public class GenreFactory
    {
        internal void DeleteGenre(Genre genre)
        {
            using (MySqlConnection conn = DatabaseHandler.GetOpenConnection())
            {               
                MySqlCommand cmd = new MySqlCommand("DELETE FROM tblGenre WHERE intID=@intID", conn);
                cmd.Parameters.AddWithValue("@intID", genre.ID);
                cmd.ExecuteNonQuery();
            }
        }

        internal List<Genre> GetGenres(Application application)
        {
            if (application == null)
                return PetaPocoRepository.Instance.Fetch<Genre>();
            else 
                return PetaPocoRepository.Instance.Fetch<Genre>("WHERE intApplicationInstanceID=@0", application.ID);
        }

        internal Genre SaveGenre(Genre genre)
        {
            return PetaPocoRepository.Instance.Upsert(genre);
        }
        
        internal List<GenreCategory> GetGenreCategories()
        {
            return PetaPocoRepository.Instance.Fetch<GenreCategory>("WHERE intApplicationID=@0", 1);
        }

        internal GenreCategory SaveGenreCategory(GenreCategory genreCategory)
        {
            return PetaPocoRepository.Instance.Upsert(genreCategory);
        }

        internal void DeleteGenreCategory(GenreCategory genreCategory)
        {
            PetaPocoRepository.Instance.Delete<GenreCategory>(genreCategory);
        }

        internal GenreCategory GetGenreCategory(int id)
        {
            return PetaPocoRepository.Instance.Single<GenreCategory>(id);
        }
    }
}