protected void btnSave_Click(object sender, EventArgs e)
{
if (this.ruleTestControl.IsEmpty || !this.ruleTestControl.IsValid)
{
return;
}
// string file = Server.MapPath("/Rules/Rule.config");
string ruleXml = this.ruleTestControl.GetRuleXml();
// File.WriteAllText(file, rule);
// string ruleText = ruleTestControl.GetClientRuleData();
string ruleText = ruleTestControl.ToString();
TMRule rule = new TMRule();
rule.RuleName = txtRuleName.Text.Trim();
rule.RuleType = ddlEntity.Text;
rule.RuleText = ruleText;
rule.RuleXml = ruleXml;
rule.RuleDescription = txtDescription.Text.Trim();
rule.ExecutionOrder = int.Parse(txtExecOrder.Text);
bool result = DalManager.InsertRule(rule);
ruleTestControl.Clear();
txtDescription.Text = "";
txtExecOrder.Text = "";
txtRuleName.Text = "";
BindData();
}
public static List <TMRule> GetRules(string ruleCategory)
{
if (strConnectionString.Equals(string.Empty))
{
strConnectionString = ConfigurationManager.ConnectionStrings["SMConnectionString"].ToString();
}
List <TMRule> rules = new List <TMRule>();
SqlConnection con;
SqlCommand cmd;
try
{
con = new SqlConnection(strConnectionString);
cmd = new SqlCommand("GetRules", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("@RuleType", SqlDbType.Int).Value = ruleCategory.ToUpper() == "OPTION" ? 2 : 1;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TMRule rule = new TMRule();
rule.RuleID = Convert.ToInt32(dr["RuleID"]);
rule.RuleName = Convert.ToString(dr["RuleName"]);
rule.RuleDescription = Convert.ToString(dr["RuleDescription"]);
rule.RuleType = ruleCategory;
rule.RuleXml = Convert.ToString(dr["RuleXml"]);
rule.RuleText = Convert.ToString(dr["RuleText"]);
rule.ExecutionOrder = Convert.ToInt32(dr["ExecutionOrder"]);
rules.Add(rule);
}
cmd.Connection.Close();
}
catch (Exception ex)
{
rules = null;
throw ex;
}
finally
{
con = null;
cmd = null;
}
return(rules);
}
public static bool InsertRule(TMRule rule)
{
if (strConnectionString.Equals(string.Empty))
{
strConnectionString = ConfigurationManager.ConnectionStrings["SMConnectionString"].ToString();
}
try
{
SqlConnection con = new SqlConnection(strConnectionString);
SqlCommand cmd = new SqlCommand("InsertRule", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("@RuleName", SqlDbType.VarChar).Value = rule.RuleName;
cmd.Parameters.Add("@RuleType", SqlDbType.Int).Value = rule.RuleType == "Stock" ? 1 : 2;
cmd.Parameters.Add("@RuleXml", SqlDbType.VarChar).Value = rule.RuleXml;
cmd.Parameters.Add("@RuleText", SqlDbType.VarChar).Value = rule.RuleText;
cmd.Parameters.Add("@RuleDescription", SqlDbType.VarChar).Value = rule.RuleDescription;
cmd.Parameters.Add("@ExecutionOrder", SqlDbType.Int).Value = rule.ExecutionOrder;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd = null;
con = null;
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
