using System;
using System.ComponentModel.DataAnnotations;
using System.Linq;

namespace CD67.FicheCollege.Entity
{
    /// <summary>
    /// Classe d'extension de celle d'Entity, nécessaire pour y associer les Metadata
    /// </summary>
    [MetadataType(typeof(Annee_Metadata))]
    public partial class Annee
    {
        public static int get_current_year_id()
        {
            Entities db = new Entities();
            string annee_lib;
            if (DateTime.Now.Month <= 7)
            {
                annee_lib = String.Format("{0}-{1}", DateTime.Now.Year - 1, DateTime.Now.Year);
            }
            else
            {
                annee_lib = String.Format("{0}-{1}", DateTime.Now.Year, DateTime.Now.Year + 1);
            }
            return db.Annees.Where(a => a.Libelle == annee_lib).First().Id;
        }
    }

    /// <summary>
    /// Classe contenant les DataAnnotations pour chaque champ
    /// </summary>
    public class Annee_Metadata
    {
    }
}