Click here to Skip to main content
15,892,298 members
Articles / Desktop Programming / WPF

Custom Rule Engine in WPF - MVVM

Rate me:
Please Sign up or sign in to vote.
4.98/5 (18 votes)
11 Sep 2010CPOL8 min read 75.2K   1.3K   95  
Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.
-----------------------------------------------------------------Stored Procedure----------------------------------------------------------------------------------
CREATE PROCEDURE dbo.SelectRules
@screenID INT
AS
	SELECT        CD.ScreenID, CD.ResultText, R.CodeLHS, R.Operator, R.ValueRHS, R.Source,RGR.RuleGroupID, RGR.RuleJoinOperator, RGR.RuleSeqNum, RGGR.RuleGroupJoinOperator, 
                         RGGR.RuleGroupSeqNum, R.RuleDescription
FROM            CountryDetails AS CD INNER JOIN
                         RulesGroupGroupingRelations AS RGGR ON CD.RuleGroupGroupingID = RGGR.RuleGroupGroupingID INNER JOIN
                         RulesGroupRelations AS RGR ON RGGR.RuleGroupID = RGR.RuleGroupID INNER JOIN
                         Rules AS R ON R.RuleID = RGR.RuleID WHERE CD.ScreenID = @screenID 
ORDER BY RGGR.RuleGroupGroupingID, RGGR.RuleGroupSeqNum, RGR.RuleGroupID, RGR.RuleSeqNum 

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior) CA-CIB
Singapore Singapore
I am a .Net developer, currently working in Singapore worked wiith Societe Generale Global Solution Centre, Bangalore and was previously with Cognizant.I have more than 8 years of .Net experience in BFSI domain. I am an experienced developer in C#, VB.Net, Silverlight, WPF, WCF, LINQ, Entity Framework, SSIS, NHibernate, ASP.Net and SQL Server.

Comments and Discussions