public List<DataObject.Load> List()
{
List<DataObject.Load> resultList = new List<DataObject.Load>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[ListLoad]";
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Load dataObjectResult = new DataObject.Load();
dataObjectResult.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectResult.CurrentLoad = int.Parse(reader.GetValue(1).ToString());
dataObjectResult.MaximumLoad = int.Parse(reader.GetValue(2).ToString());
dataObjectResult.ManualLoad = int.Parse(reader.GetValue(3).ToString());
resultList.Add(dataObjectResult);
}
}
}
}
return resultList;
}
public List <DataObject.Load> List()
{
List <DataObject.Load> resultList = new List <DataObject.Load>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [BusinessRule].[ListLoad]";
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Load dataObjectResult = new DataObject.Load();
dataObjectResult.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectResult.CurrentLoad = int.Parse(reader.GetValue(1).ToString());
dataObjectResult.MaximumLoad = int.Parse(reader.GetValue(2).ToString());
dataObjectResult.ManualLoad = int.Parse(reader.GetValue(3).ToString());
resultList.Add(dataObjectResult);
}
}
}
}
return(resultList);
}
