public List <DataObject.RuleSet> List() { List <DataObject.RuleSet> ruleSetList = new List <DataObject.RuleSet>(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "Exec [BusinessRule].[ListActiveRuleSet]"; using (SqlCommand command = new SqlCommand(query, connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DataObject.RuleSet dataObjectRuleSet = new DataObject.RuleSet(); dataObjectRuleSet.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectRuleSet.Name = reader.GetValue(1).ToString(); dataObjectRuleSet.Version = reader.GetValue(2).ToString(); dataObjectRuleSet.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString()); dataObjectRuleSet.IsActive = true; ruleSetList.Add(dataObjectRuleSet); } } } } return(ruleSetList); }
public DataObject.RuleSet Get(int Id) { DataObject.RuleSet dataObjectRuleSet = null; using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "Exec [BusinessRule].[GetActiveRuleSet] {0}"; using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dataObjectRuleSet = new DataObject.RuleSet(); dataObjectRuleSet.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectRuleSet.Name = reader.GetValue(1).ToString(); dataObjectRuleSet.Version = reader.GetValue(2).ToString(); dataObjectRuleSet.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString()); dataObjectRuleSet.IsActive = true; } } } } return dataObjectRuleSet; }
public DataObject.RuleSet Get(int Id) { DataObject.RuleSet dataObjectRuleSet = null; using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "Exec [BusinessRule].[GetActiveRuleSet] {0}"; using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dataObjectRuleSet = new DataObject.RuleSet(); dataObjectRuleSet.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectRuleSet.Name = reader.GetValue(1).ToString(); dataObjectRuleSet.Version = reader.GetValue(2).ToString(); dataObjectRuleSet.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString()); dataObjectRuleSet.IsActive = true; } } } } return(dataObjectRuleSet); }
public List<DataObject.RuleSet> List() { List<DataObject.RuleSet> ruleSetList = new List<DataObject.RuleSet>(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "Exec [BusinessRule].[ListActiveRuleSet]"; using (SqlCommand command = new SqlCommand(query, connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DataObject.RuleSet dataObjectRuleSet = new DataObject.RuleSet(); dataObjectRuleSet.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectRuleSet.Name = reader.GetValue(1).ToString(); dataObjectRuleSet.Version = reader.GetValue(2).ToString(); dataObjectRuleSet.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString()); dataObjectRuleSet.IsActive = true; ruleSetList.Add(dataObjectRuleSet); } } } } return ruleSetList; }