Exemplo n.º 1
0
 public object UpdateFactsAfterExecution(RuleSetInfo rulesetInfo, Microsoft.RuleEngine.RuleEngine engine, object factsHandleIn)
 {
     if (factsHandleIn != null)
     {
         // retract the DataConnection object to clean up any rows fetched during policy execution
         engine.Retract(factsHandleIn);
     }
     return(factsHandleIn);
 }
Exemplo n.º 2
0
        public object UpdateFacts(RuleSetInfo rulesetInfo, Microsoft.RuleEngine.RuleEngine engine, object factsHandleIn)
        {
            object factsHandleOut;

            if (factsHandleIn == null)
            {
                // create the database connection since it doesn't exist
                SqlConnection  con1 = new SqlConnection("Initial Catalog=Northwind;Data Source=(local);Integrated Security=SSPI;");
                DataConnection dc1  = new DataConnection("Northwind", "PolicyValidity", con1);
                factsHandleOut = dc1;
            }
            else
            {
                // reuse the database connection previously created
                factsHandleOut = factsHandleIn;
            }

            engine.Assert(factsHandleOut);
            return(factsHandleOut);
        }
        public object UpdateFacts(RuleSetInfo rulesetInfo, Microsoft.RuleEngine.RuleEngine engine, object factsHandleIn)
        {
            object factsHandleOut;

            // The following logic asserts the required DB rows only once and always uses the the same values (cached) during the first retrieval in subsequent execution cycles
            if (factsHandleIn == null)
            {
                SqlConnection  con1 = new SqlConnection("Initial Catalog=Northwind;Data Source=(local);Integrated Security=SSPI;");
                DataConnection dc1  = new DataConnection("Northwind", "CustInfo", con1);
                engine.Assert(dc1);
                factsHandleOut = dc1;
            }

            else
            {
                factsHandleOut = factsHandleIn;
            }

            return(factsHandleOut);
        }
        public object UpdateFacts(RuleSetInfo rulesetInfo, Microsoft.RuleEngine.RuleEngine engine, object factsHandleIn)
        {
            object factsHandleOut;

            // The following logic asserts the required DB rows only once and always uses the the same values (cached) during the first retrieval in subsequent execution cycles
            if (factsHandleIn == null)
            {
                string strCmd1 = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=jinli2000";

                SqlConnection con1 = new SqlConnection(strCmd1);

                // Using data connection binding
                // DataConnection dc1 = new DataConnection("Northwind", "CustInfo", con1);

                // Using data table binding
                SqlDataAdapter dAdapt1 = new SqlDataAdapter();
                dAdapt1.TableMappings.Add("Table", "CustInfo");
                con1.Open();
                SqlCommand myCommand = new SqlCommand("SELECT * FROM CustInfo", con1);
                myCommand.CommandType = CommandType.Text;
                dAdapt1.SelectCommand = myCommand;
                DataSet ds = new DataSet("Northwind");
                dAdapt1.Fill(ds);
                TypedDataTable tdt1 = new TypedDataTable(ds.Tables["CustInfo"]);

                engine.Assert(tdt1);
                factsHandleOut = tdt1;
            }

            else
            {
                factsHandleOut = factsHandleIn;
            }

            return(factsHandleOut);
        }
Exemplo n.º 5
0
        static void Main(string[] args)
        {
            // create a ruleset
            Console.WriteLine("Creating a new ruleset ...");
            RuleSet rs = CreateRuleset("SampleRuleset");

            // save it to a file
            Console.WriteLine("Saving ruleset to " + RuleStoreFilename + " ...");
            SaveToFile(RuleStoreFilename, rs);

            // load the same ruleset from the file
            Console.WriteLine("Loading ruleset ...");
            RuleSet newRS = LoadFromFile(RuleStoreFilename, "SampleRuleset");

            // create an engine for the ruleset
            Microsoft.RuleEngine.RuleEngine engine = new Microsoft.RuleEngine.RuleEngine((newRS), false);

            //create an instance of the XML object
            XmlDocument xd1 = new XmlDocument();

            xd1.Load(@"..\..\SampleDocumentInstance.xml");
            TypedXmlDocument doc1 = new TypedXmlDocument("SampleSchema", xd1);

            // create the array of short-term facts
            object[] shortTermFacts = new object[4];
            shortTermFacts[0] = doc1;
            shortTermFacts[1] = new Microsoft.Samples.BizTalk.BusinessRulesHelloWorld1.MySampleLibrary.MySampleBusinessObject(1);
            shortTermFacts[2] = new Microsoft.Samples.BizTalk.BusinessRulesHelloWorld1.MySampleLibrary.MySampleBusinessObject(2);
            shortTermFacts[3] = new Microsoft.Samples.BizTalk.BusinessRulesHelloWorld1.MySampleLibrary.MySampleBusinessObject(3);

            try
            {
                // assert several objects
                Console.WriteLine("Asserting objects ...");
                engine.Assert(shortTermFacts);

                // now execute to see what happens
                Console.WriteLine("Executing ...");

                engine.Execute();
            }


            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

            Console.WriteLine("Press any key to finish ...");
            System.Console.Read();

            // Clean up SampleRuleStore.xml
            CleanUp();

            // there should be 2 lines output:
            //   MySampleBusinessObject -- MySampleMethod executed for object 1 with parameter 5
            //   MySampleBusinessObject -- MySampleMethod executed for object 3 with parameter 5

            //This is because:

            /*
             * The rule created programmatically within the CreateRuleset() method says:
             *
             * IF
             *
             * MySampleBusinessObject.MyValue is not equal to the value of the ID element in the XML document.
             * THEN
             *
             * Execute MySampleBusinessObject.MySampleMethod(int) with a hardcoded integer constant 5 ".
             *
             * In our case we assert 3 .NET objects with "MyValue" = 1,2, and 3 along with an XML document with ID = 1, as fact instances.
             *
             * Hence the rule fires twice for the 2 .NET property values that are != 1
             *
             */
        }
Exemplo n.º 6
0
        private static void ExecuteRulesEngine(IBaseMessage pInMsg, string rulesPolicy)
        {
            Microsoft.BizTalk.RuleEngineExtensions.RuleSetDeploymentDriver rulesDriver = new Microsoft.BizTalk.RuleEngineExtensions.RuleSetDeploymentDriver();
            SqlRuleStore sqlRuleStore = (SqlRuleStore)rulesDriver.GetRuleStore();
            RuleSetInfoCollection rsic = sqlRuleStore.GetRuleSets(rulesPolicy, RuleStore.Filter.All);
            RuleSet rs = sqlRuleStore.GetRuleSet(rsic[0]);

            Microsoft.RuleEngine.RuleEngine engine = new Microsoft.RuleEngine.RuleEngine(rs);
            engine.Assert(pInMsg);
            engine.Execute();
        }