public List <DataObject.Condition> List()
{
List <DataObject.Condition> conditionList = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[ListCondition]";
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Condition dataObjectCondition = new DataObject.Condition();
dataObjectCondition.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectCondition.Value = reader.GetValue(1).ToString();
dataObjectCondition.Description = reader.GetValue(2).ToString();
conditionList.Add(dataObjectCondition);
}
}
}
}
return(conditionList);
}
public List<DataObject.Condition> List()
{
List<DataObject.Condition> conditionList = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[ListCondition]";
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Condition dataObjectCondition = new DataObject.Condition();
dataObjectCondition.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectCondition.Value = reader.GetValue(1).ToString();
dataObjectCondition.Description = reader.GetValue(2).ToString();
conditionList.Add(dataObjectCondition);
}
}
}
}
return conditionList;
}
public DataObject.Condition Get(int Id)
{
DataObject.Condition dataObjectCondition = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[GetCondition] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObjectCondition = new DataObject.Condition();
dataObjectCondition.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectCondition.Value = reader.GetValue(1).ToString();
dataObjectCondition.Description = reader.GetValue(2).ToString();
}
}
}
}
return(dataObjectCondition);
}
public DataObject.Condition Get(int Id)
{
DataObject.Condition dataObjectCondition = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[GetCondition] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObjectCondition = new DataObject.Condition();
dataObjectCondition.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectCondition.Value = reader.GetValue(1).ToString();
dataObjectCondition.Description = reader.GetValue(2).ToString();
}
}
}
}
return dataObjectCondition;
}