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