public List <DataObject.Priority> ListPriority() { List <DataObject.Priority> scheduleList = new List <DataObject.Priority>(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "SELECT a.Id, a.Id_RuleSet, b.Name, a.Priority FROM [BusinessRule].[PriorityRule] a "; query += "INNER JOIN [BusinessRule].[Ruleset] b on b.Id = a.Id_RuleSet"; using (SqlCommand command = new SqlCommand(query, connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DataObject.Priority dataObjectSchedule = new DataObject.Priority(); dataObjectSchedule.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectSchedule.Id_RuleSet = int.Parse(reader.GetValue(1).ToString()); dataObjectSchedule.Name = reader.GetValue(2).ToString(); dataObjectSchedule.PriorityType = reader.GetValue(3).ToString(); scheduleList.Add(dataObjectSchedule); } } } } return(scheduleList); }
public List<DataObject.Priority> ListPriority(string priority) { List<DataObject.Priority> scheduleList = new List<DataObject.Priority>(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "SELECT a.Id, a.Id_RuleSet, b.Name, a.Priority FROM [BusinessRule].[PriorityRule] a "; query += "INNER JOIN [BusinessRule].[Ruleset] b on b.Id = a.Id_RuleSet WHERE Priority = '{0}'"; using (SqlCommand command = new SqlCommand(string.Format(query, priority), connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DataObject.Priority dataObjectSchedule = new DataObject.Priority(); dataObjectSchedule.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectSchedule.Id_RuleSet = int.Parse(reader.GetValue(1).ToString()); dataObjectSchedule.Name = reader.GetValue(2).ToString(); dataObjectSchedule.PriorityType = reader.GetValue(3).ToString(); scheduleList.Add(dataObjectSchedule); } } } } return scheduleList; }