using System;
using System.Linq;
using MySql.Data.MySqlClient;
using PetaPoco;

namespace Sony.Filtr.Contracts.Entities.Genre
{
    [Serializable]
    [TableName("tblGenre")]
    [PrimaryKey("intID")]
    [ExplicitColumns]
    public class Genre
    {
        public Genre()
        {

        }
        
        public Genre(MySqlDataReader reader)
        {
            ID = reader.GetInt32(0);
            ApplicationID = reader.GetInt32(1);
            Name = reader.GetString(2);
            LastFMTag = reader.GetString(3);
            Active = reader.GetBoolean(4);
            GenreCategoryID = reader.GetInt32(5);
        }

        [Column("intID")]
        public int ID { get; set; }

        [Column("blnActive")]
        public bool Active { get; set; }

        [Column("strName")]
        public string Name { get; set; }

        [Column("intApplicationInstanceID")]
        public int ApplicationID { get; set; }

        [Column("strLastFmTag")]
        public string LastFMTag { get; set; }

        [Column("intCategoryID")]
        public int GenreCategoryID { get; set; }
    }
}