示例#1
0
        public override int create(CPays obj)
        {
            OracleCommand req = new OracleCommand();

            req.Connection  = _connex;
            req.CommandText = "insert into pays (id, nom) values (:id, :nom)";

            int id = (int)CSequence.getNextValue("PAYS", base._connex.ConnectionString);

            OracleParameter pId  = new OracleParameter("id", id);
            OracleParameter pNom = new OracleParameter("nom", obj.Nom);

            req.Parameters.Add(pId);
            req.Parameters.Add(pNom);
            req.ExecuteNonQuery();
            return(id);
        }
示例#2
0
        public override int create(CVille obj)
        {
            OracleCommand req = new OracleCommand();

            req.Connection  = _connex;
            req.CommandText = "insert into ville (code_postal, nom, numero_departement) values (:code_postal, :nom, :numero_departement)";

            int code_postal = (int)CSequence.getNextValue("VILLE", base._connex.ConnectionString);

            OracleParameter pCode_Postal        = new OracleParameter("code_postal", code_postal);
            OracleParameter pNom                = new OracleParameter("nom", obj.Nom);
            OracleParameter pNumero_Departement = new OracleParameter("numero_departement", obj.Numero_Departement);


            req.Parameters.Add(pCode_Postal);
            req.Parameters.Add(pNom);
            req.Parameters.Add(pNumero_Departement);
            req.ExecuteNonQuery();
            return(code_postal);
        }
示例#3
0
        public override int create(CDepartement obj)
        {
            OracleCommand req = new OracleCommand();

            req.Connection  = _connex;
            req.CommandText = "insert into departement (numero, nom, id_region) values (:numero, :nom, :id_region)";

            int numero = (int)CSequence.getNextValue("DEPARTEMENT", base._connex.ConnectionString);

            OracleParameter pId        = new OracleParameter("numero", numero);
            OracleParameter pNom       = new OracleParameter("nom", obj.Nom);
            OracleParameter pId_Region = new OracleParameter("id_region", obj.Id_Region);


            req.Parameters.Add(pId);
            req.Parameters.Add(pNom);
            req.Parameters.Add(pId_Region);
            req.ExecuteNonQuery();
            return(numero);
        }
示例#4
0
        public override int create(CRubrique obj)
        {
            OracleCommand req = new OracleCommand();

            req.Connection  = _connex;
            req.CommandText = "INSERT INTO RUBRIQUE (id, nom, description, id_parent) values (:id, :nom, :description, :id_parent)";

            int id = (int)CSequence.getNextValue("RUBRIQUE", base._connex.ConnectionString);

            OracleParameter pId       = new OracleParameter("id", id);
            OracleParameter pNom      = new OracleParameter("nom", obj.Nom);
            OracleParameter pDesc     = new OracleParameter("description", obj.Description);
            OracleParameter pIdParent = new OracleParameter("id_parent", obj.IDParent);

            req.Parameters.Add(pId);
            req.Parameters.Add(pNom);
            req.Parameters.Add(pDesc);
            req.Parameters.Add(pIdParent);

            req.ExecuteNonQuery();
            return(id);
        }