IXapEvaluationService IXapValidationProvider.LoadRules <T>(T obj, string ruleType)
{
IXapDataProvider db = null;
IXapRuleSet ruleSet = null;
IXapRule rule = null;
try {
string dbEnvironment = string.Empty;
string lobName = string.Empty;
string componentName = string.Empty;
string ruleDependents = string.Empty;
GetDbContext <T>(obj, out dbEnvironment, out lobName, out componentName);
db = DbFactory.Instance.Db(dbEnvironment, lobName, "CORE.SelectRules");
XapDataReader dr = db.AddParameter(DbFactory.Instance.DbParameter("RuleType", ruleType))
.AddParameter(DbFactory.Instance.DbParameter("LobName", lobName))
.AddParameter(DbFactory.Instance.DbParameter("ComponentName", componentName))
.AddParameter(DbFactory.Instance.DbParameter("NameSpace", obj.GetType().FullName))
.ExecuteReader();
while (dr.Read())
{
ruleSet = evaluationService.GetRuleSet(dr.GetString("RuleSet"));
evaluationService.AddRuleSet(ruleSet);
rule = ruleSet.GetRule(dr.GetString("RuleName"));
rule.RuleType = dr.GetString("RuleType");
rule.RuleSyntax = dr.GetString("RuleSyntax");
rule.RuleDescription = dr.GetString("RuleDesc");
rule.RuleMessage = dr.GetString("RuleMessage");
IXapRuleVariable ruleVariable = EvaluationFactory.Instance.CreateRuleVariable(dr.GetString("PropertyName"));
rule.AddRuleVariable(ruleVariable);
ruleDependents = dr.GetString("Dependencies");
string[] dependents = ruleDependents.Split(',');
for (int i = 0; i < dependents.Length; i++)
{
IXapRuleVariable variableDependent = EvaluationFactory.Instance.CreateRuleVariable(dependents[i]);
rule.AddRuleVariable(variableDependent);
}
ruleSet.AddRule(rule);
}
return(evaluationService);
}catch (XapException ex) {
throw;
}catch (Exception ex) {
throw new XapException($"Error loading validation rules for {obj.GetType().FullName}", ex);
} finally {
db.CloseConnection();
}
}
private void DoInsertUpdate <T>(T obj, PocoOperationType operationType)
{
bool setParameter = false;
IXapPocoField pocoField;
try {
foreach (PropertyInfo prop in PropertyService.Instance.GetInterfaceProperties <T>(obj).GetProperties())
{
pocoField = pocoMap.GetField(prop.ShortName());
switch (operationType)
{
case PocoOperationType.Insert:
setParameter = pocoField == null ? false : pocoField.DoesInsert;
break;
case PocoOperationType.Select:
setParameter = pocoField == null ? false : pocoField.DoesSelect;
break;
case PocoOperationType.Update:
setParameter = pocoField == null ? false : pocoField.DoesUpdate;
break;
case PocoOperationType.Delete:
setParameter = pocoField == null ? false : pocoField.DoesDelete;
break;
case PocoOperationType.SelectList:
setParameter = pocoField == null ? false : pocoField.DoesSelectList;
break;
}
if (setParameter)
{
object objValue = prop.GetValue(obj, null);
if (prop.PropertyType == typeof(string))
{
if (pocoMap.GetField(prop.ShortName()).DataType == "SmartDate")
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, SmartDate.Parse(objValue.ToString()).DBValue));
}
else
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString()));
}
}
else if (prop.PropertyType == typeof(SmartDate))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, SmartDate.Parse(objValue.ToString()).DBValue));
}
else if (prop.PropertyType == typeof(bool))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString().ConvertValue <bool>()));
}
else if (prop.PropertyType == typeof(int))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString().ConvertValue <int>()));
}
else if (prop.PropertyType == typeof(long))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString().ConvertValue <long>()));
}
else if (prop.PropertyType == typeof(short))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString().ConvertValue <short>()));
}
else if (prop.PropertyType == typeof(double))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString().ConvertValue <double>()));
}
else if (prop.PropertyType == typeof(decimal))
{
_dataProvider.AddParameter(DbFactory.Instance.DbParameter(pocoMap.GetField(prop.ShortName()).DbColumn, objValue.ToString().ConvertValue <decimal>()));
}
}
}
} catch (Exception ex) {
throw new XapException($"Error setting parameter values {obj.GetType().FullName}", ex);
}
}
