/// <summary>
        /// get an instance of object
        /// </summary>
        /// <param name="myID"></param>
        public a_agenda_cat getObjecta_agenda_cat(System.Int32 myID)
        {
            a_agenda_cat mya_agenda_cat = new a_agenda_cat();
            CnxBase      myBase         = new CnxBase();
            string       reqSQL         = "SELECT id_cat,nombre,ref_espacial,tabla,orden FROM a_agenda_cat WHERE (id_cat=" + myID + ")";

            try
            {
                NpgsqlConnection myConn    = myBase.OpenConnection(myBase.cnxString);
                NpgsqlCommand    myCommand = new NpgsqlCommand(reqSQL, myConn);
                NpgsqlDataReader myReader  = myCommand.ExecuteReader();
                if (myReader.Read())
                {
                    mya_agenda_cat.id_cat       = Convert.ToInt32(myReader[0]);
                    mya_agenda_cat.nombre       = myReader[1].ToString();
                    mya_agenda_cat.ref_espacial = Convert.ToBoolean(myReader[2]);
                    mya_agenda_cat.tabla        = myReader[3].ToString();
                    mya_agenda_cat.orden        = Convert.ToInt32(myReader[4]);
                }
                myBase.CloseConnection(myConn);
            }
            catch (Exception myErr)
            {
                throw (new Exception(myErr.ToString() + reqSQL));
            }
            return(mya_agenda_cat);
        }
        /// <summary>
        /// modify a record
        /// </summary>
        public void Update(a_agenda_cat mya_agenda_cat)
        {
            CnxBase myBase = new CnxBase();
            string  reqSQL = "UPDATE a_agenda_cat SET id_cat=" + mya_agenda_cat.id_cat + ",nombre='" + mya_agenda_cat.nombre + "',ref_espacial=" + mya_agenda_cat.ref_espacial + ",tabla='" + mya_agenda_cat.tabla + "',orden=" + mya_agenda_cat.orden + " WHERE (id_cat=" + mya_agenda_cat.id_cat + ")";

            try
            {
                NpgsqlConnection myConn    = myBase.OpenConnection(myBase.cnxString);
                NpgsqlCommand    myCommand = new NpgsqlCommand(reqSQL, myConn);
                myCommand.ExecuteNonQuery();
                myBase.CloseConnection(myConn);
            }
            catch (Exception myErr)
            {
                throw (new Exception(myErr.ToString() + reqSQL));
            }
        }
        /// <summary>
        /// add a record
        /// </summary>
        /// <param name="myID"></param>
        public void Insert(a_agenda_cat mya_agenda_cat)
        {
            CnxBase myBase = new CnxBase();
            string  reqSQL = "INSERT INTO a_agenda_cat (nombre,ref_espacial,tabla,orden) VALUES ('" + mya_agenda_cat.nombre + "'," + mya_agenda_cat.ref_espacial + ",'" + mya_agenda_cat.tabla + "'," + mya_agenda_cat.orden + ")";

            try
            {
                NpgsqlConnection myConn    = myBase.OpenConnection(myBase.cnxString);
                NpgsqlCommand    myCommand = new NpgsqlCommand(reqSQL, myConn);
                myCommand.ExecuteNonQuery();
                myBase.CloseConnection(myConn);
            }
            catch (Exception myErr)
            {
                throw (new Exception(myErr.ToString() + reqSQL));
            }
        }