?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DirGest" namespace="DirGest.Model">
  <class name="Assegnazione" table="assegnazioni">
    <id name="id" column="id" type="int" unsaved-value="0">
      <generator class="native" />
    </id>
    <version name="version" column="version" type="Int32"/>
    <many-to-one name="commessa" column="commessa" class="Commessa" not-null="true" cascade="none" fetch="select" />
    <many-to-one name="articolo" column="articolo" class="Articolo" not-null="true" cascade="none" fetch="select" />
    <many-to-one name="utente" column="utente" class="Utente" not-null="true" cascade="none" fetch="select" />
    <property name="quantita" column="quantita" type="decimal" not-null="true" />
    <property name="dtInserimento" column="dtInserimento" type="DateTime" not-null="true" insert="false" update ="false" />
    <property name="prezzoAcquisto" column="prezzoAcquisto" type="decimal" not-null="true" />
    <property name="prezzoFattura" column="prezzoFattura" type="decimal" />
  </class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DirGest" namespace="DirGest.Model">
  <class name="Commessa" table="commesse">
    <id name="id" column="id" type="int" unsaved-value="0">
      <generator class="native" />
    </id>
    <version name="version" column="version" type="Int32"/>
    <many-to-one name="cliente" column="cliente" class="Cliente" not-null="true" cascade="none" fetch="select" lazy="false" />
    <property name="data" column="data" type="DateTime" not-null="true" />
    <property name="numProgressivo" column="numProgressivo" type="Int32" not-null="true" />
    <property name="etichettaProgressivo" column="etichettaProgressivo" type="string" not-null="true" />
    <property name="descrizione" column="descrizione" type="string" />
    <many-to-one name="stato" column="stato" class="StatoCommessa" not-null="true" cascade="none" fetch="join" lazy="false" />
    <property name="conTrasferta" column="conTrasferta" type="boolean" not-null="true" />
    <property name="speseFisse" column="speseFisse" type="decimal" not-null="true" />
    <property name="speseNoleggi" column="speseNoleggi" type="decimal" not-null="true" />
    <property name="descrizioneNoleggi" column="descrizioneNoleggi" type="string" />
    <property name="altreSpese" column="altreSpese" type="decimal" not-null="true" />
    <property name="descrizioneAltreSpese" column="descrizioneAltreSpese" type="string" />
    <bag name="assegnazioni" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="Assegnazione" />
    </bag>
    <bag name="missioni" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="Missione" />
    </bag>
    <bag name="costiQualificaCommessa" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="CostoQualificaCommessa" />
    </bag>
  </class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DirGest" namespace="DirGest.Model">
  <class name="Utente" table="utenti">
    <id name="id" column="id" type="int" unsaved-value="0">
      <generator class="native" />
    </id>
    <version name="version" column="version" type="Int32"/>
    <property name="cognome" column="cognome" type="string" not-null="true" />
    <property name="nome" column="nome" type="string" not-null="true" />
    <many-to-one name="qualifica" column="qualifica" class="Qualifica" cascade="none" fetch="join" lazy="false" />
    <property name="user" column="user" type="string" not-null="true" unique="true"/>
    <property name="password" column="password" type="string" not-null="true" />
    <property name="badgeId" column="badgeId" type="string" unique="true"/>
    <property name="isAmministrativo" column="isAmministrativo" type="boolean" />
    <property name="isOperaio" column="isOperaio" type="boolean" />
    <property name="isSuperuser" column="isSuperuser" type="boolean" />
    <property name="attivo" column="attivo" type="boolean" />
    <bag name="dettagliMissione" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="DettaglioMissione" />
    </bag>
    <bag name="movimentiAttrezzi" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="MovimentoAttrezzo" />
    </bag>
    <bag name="presenze" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="Presenza" />
    </bag>
    <bag name="cartellini" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="Cartellino" />
    </bag>
    <bag name="assegnazioni" cascade="all" lazy="true" inverse="true">
      <key column="id" />
      <one-to-many class="Assegnazione" />
    </bag>       
  </class>
</hibernate-mapping>