using System;
using System.Collections.Generic;
using Castle.ActiveRecord;
using Castle.Components;
using System.Linq;
using System.Text;
using Castle.ActiveRecord.Queries;
using NHibernate;

namespace YPlaylist.BusinessLogic
{
    [ActiveRecord]
    class Lable : ActiveRecordBase<Lable>
    {
        private int LableID;
        private string LableName;

        public Lable()
        {
        }

        public Lable(string LableName)
        {
            this.LableName = LableName;
        }

        [PrimaryKey]
        private int lableID
        {
            get { return LableID; }
            set { LableID = value; }
        }

        [Property]
        private string lableName
        {
            get { return LableName; }
            set { LableName = value; }
        }

        public static Lable[] ReturnAllLableNames()
        {
            SimpleQuery<Lable> q = new SimpleQuery<Lable>(typeof(Lable), @"
            Select LableName
            from Lable 
            ");
            return q.Execute();
        }


        internal static Lable[] ExecuteQuery()
        {
            throw new NotImplementedException();
        }
    }
}