CREATE OR REPLACE VIEW public."OCTRencodees" AS 
 SELECT documents.num_document_cadastre AS no_octr,
    documents.minute,
    documents.date_minute,
    documents.ag,
    documents.matricule_ag
   FROM documents
  WHERE documents.type_document::text = 'OCTR'::text
  GROUP BY documents.num_document_cadastre, documents.minute, documents.date_minute, documents.ag, documents.matricule_ag
  ORDER BY documents.num_document_cadastre;

ALTER TABLE public."OCTRencodees"
  OWNER TO jmdeneyer;
COMMENT ON VIEW public."OCTRencodees"
  IS 'Donne la liste des OCTR encodées';

public static MTObservableCollection<MinuteDocument> ListeOCTRencodés()
        {
            NpgsqlConnection conn = new NpgsqlConnection(Properties.Settings.Default.PostGISconnexionString);
            MTObservableCollection<MinuteDocument> listeOCTR = new MTObservableCollection<MinuteDocument>();
            string listeOCTRencodéssql = @"SELECT * FROM OCTRencodees;";
            NpgsqlCommand listeOCTRencodéscommand = new NpgsqlCommand(listeOCTRencodéssql, conn);
            NpgsqlDataReader listeOCTRencodésdr;

            try
            {
                conn.Open();
                using (listeOCTRencodésdr = listeOCTRencodéscommand.ExecuteReader())
                {
                    while (listeOCTRencodésdr.Read())
                    {
                        MinuteDocument octr = new MinuteDocument();
                        int noMandat = 0, noMatricule = 0;
                        DateTime dateMinute = new DateTime();
                        if (int.TryParse(listeOCTRencodésdr["no_octr"].ToString(), out noMandat))
                            octr.Numero = noMandat;
                        if (int.TryParse(listeOCTRencodésdr["matricule_ag"].ToString(), out noMatricule))
                            octr.Matricule = noMatricule;
                        if (DateTime.TryParse(listeOCTRencodésdr["date_minute"].ToString(), out dateMinute))
                            octr.DateMinute = dateMinute;
                        octr.Minute = listeOCTRencodésdr["minute"].ToString();
                        octr.AG = listeOCTRencodésdr["ag"].ToString();
                        listeOCTR.Add(octr);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("la lecture des OCTR encodées a engendré l'erreur suivante.Message : " + ex.Message, ex);
    }
            finally
            {
                conn.Close();
            }
            if (listeOCTR.Count > 0)
                return listeOCTR;
            return null;
        }