<import class="Aedra.Modele.AedraIntervalle, Modele"/>

<sql-query name="GetDefaultIntervalle" callable="true">
    <return class="Aedra.Modele.AedraIntervalle, Modele"/>
    <![CDATA[
      select
        new AedraIntervalle(sd.num_semaine, sd.exercice)
      from
        semaines_diffusion sd
      where
        ((sysdate between date_debut and date_fin )
        or (sysdate + 7 between date_debut and date_fin )
        or ((sysdate + 14 between date_debut and date_fin )))
      order
        by date_debut asc
    ]]>
  </sql-query>

namespace Aedra.Modele
{
public class AedraIntervalle
    {
        public int NumWeek { get; set; }
        public int Exercice { get; set; }

        public override bool Equals(object obj)
        {
            if (obj == null) return false;
            if (ReferenceEquals(obj,this)) return true;
           
            if (obj is AedraIntervalle)
            {
                AedraIntervalle that = (AedraIntervalle)this;
                return (that.NumWeek == NumWeek && that.Exercice == Exercice);
            }
            return false;
        }

        public override int GetHashCode()
        {
            return NumWeek.GetHashCode() + Exercice.GetHashCode();
        }

        public AedraIntervalle(int aNumWeek, int aExercice)
        {
            NumWeek = aNumWeek;
            Exercice = aExercice;
        }

    }
}