public static WorkFlowRuleApplied Map(this WorkFlowRulesPOCO wfRulePoco)
{
var ret = new WorkFlowRuleApplied
{
};
return(ret);
}
internal static List <WorkFlowRulesPOCO> GetWorkFlowRules(int toTake)
{
string sqlGetRuleValidationsForConversion =
string.Format("SELECT * FROM zch.workcenter.workflowRule WITH(NOLOCK) where ruleid > {0} ORDER BY RuleID", lastWFIdRead);
List <WorkFlowRulesPOCO> ret = new List <WorkFlowRulesPOCO>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DSN"]))
using (SqlCommand cmd = new SqlCommand(sqlGetRuleValidationsForConversion, conn))
{
conn.Open();
var reader = cmd.ExecuteReader();
int i = 0;
while (reader.Read() && i++ < toTake)
{
WorkFlowRulesPOCO r = new WorkFlowRulesPOCO
{
RuleId = int.Parse(reader["ruleid"].ToString()),
UserId = int.Parse(reader["usrid"].ToString()),
AccountId = int.Parse(reader["AccountId"].ToString()),
DTCreated = DateTime.Parse(reader["DTCreated"].ToString()),
WorkGroupID = int.Parse(reader["WorkGroupID"].ToString()),
RuleXPath = reader["RuleXPath"].ToString(),
SerializedObject = reader["SerializedObject"].ToString(),
RuleOrder = int.Parse(reader["RuleOrder"].ToString()),
Broken = reader["Broken"].ToString() == "0",
};
if (r.RuleXPath.StartsWith("/*[("))
{
r.RuleXPath = r.RuleXPath.Substring(4, r.RuleXPath.Length - 4 - 4);
}
ret.Add(r);
}
}
lastValIdRead = ret.Max(c => c.RuleId);
return(ret);
}
