<query name="Fairs.GetOngoing">from Fair where starting_date <= ? and end_date >= ?</query>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
   <class name="vcf.code.entites.Fair,vcf" table="vcfFairs">

      <id name="Code" column="code" type="Int32" unsaved-value="0">
         <generator class="native"/>
      </id>
      <bag name="Stands" inverse="true" lazy="false" >
         <key column="fair_code" />
         <one-to-many class="vcf.code.entites.Stand,vcf" />
      </bag>
      <property column="starting_date" type="DateTime" name="StartingDate" not-null="true" />
      <property column="end_date" type="DateTime" name="EndDate" not-null="true" />
      <property column="title" type="String" name="Title" not-null="true" length="50" />
      <property column="description" type="String" name="Description" not-null="true" length="1500" />
      <property column="sponsor_code" type="Int32" name="SponsorCode" />   
   </class>
   
   <query name="Fair.GetAll">from Fair order by starting_date</query>
   
   <query name="Fair.GetAttending">select fair from Fair fair inner join fair.Stands stands where stands.Exhibitor.VcfUser.Id = ?</query>
   
   <query name="Fair.GetNotAttending">
   from Fair fair
   where not exists( select stand from Stand stand where stand.Fair.Code = fair.id and
   stand.Exhibitor.VcfUser.id = ?)
   </query>
   
   <query name="Fairs.GetOngoing">from Fair where starting_date <= ? and end_date >= ?</query>
   <query name="Fairs.GetFuture">from Fair where starting_date > ? and end_date > ?</query>
   <query name="Fairs.GetPast">from Fair where starting_date < ? and end_date < ?</query>
   
</hibernate-mapping>