public List <DataObject.CurrentStatus> List(int Id_Zone)
{
List <DataObject.CurrentStatus> list = new List <DataObject.CurrentStatus>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = @"Select c.Id,c.UnitName,c.[Status]
FROM [Configuration].[Zone] a
INNER JOIN [Configuration].[Unit] b on b.Id_Zone = a.Id
INNER JOIN [Logging].[CurrentStatus] c on c.UnitName = b.Name
WHERE a.Id = {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id_Zone), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.CurrentStatus dataObject = new DataObject.CurrentStatus();
dataObject.Id = int.Parse(reader.GetValue(0).ToString());
dataObject.UnitName = reader.GetValue(1).ToString();
dataObject.Status = reader.GetValue(2).ToString();
list.Add(dataObject);
}
}
}
}
return(list);
}
public List<DataObject.CurrentStatus> List(int Id_Zone)
{
List<DataObject.CurrentStatus> list = new List<DataObject.CurrentStatus>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = @"Select c.Id,c.UnitName,c.[Status]
FROM [Configuration].[Zone] a
INNER JOIN [Configuration].[Unit] b on b.Id_Zone = a.Id
INNER JOIN [Logging].[CurrentStatus] c on c.UnitName = b.Name
WHERE a.Id = {0}";
using (SqlCommand command = new SqlCommand(string.Format(query,Id_Zone), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.CurrentStatus dataObject = new DataObject.CurrentStatus();
dataObject.Id = int.Parse(reader.GetValue(0).ToString());
dataObject.UnitName = reader.GetValue(1).ToString();
dataObject.Status = reader.GetValue(2).ToString();
list.Add(dataObject);
}
}
}
}
return list;
}
