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); }