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