public List <DataObject.Device> List(int Id_Unit)
{
List <DataObject.Device> deviceList = new List <DataObject.Device>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [Configuration].[ListActiveDevice] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id_Unit), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Device dataObjectDevice = new DataObject.Device();
dataObjectDevice.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectDevice.Id_Unit = Id_Unit;
dataObjectDevice.Name = reader.GetValue(1).ToString();
dataObjectDevice.DateAdded = Convert.ToDateTime(reader.GetValue(2).ToString());
dataObjectDevice.IsActive = Convert.ToBoolean(reader.GetValue(3).ToString());
dataObjectDevice.Switch = reader.GetValue(4).ToString();
deviceList.Add(dataObjectDevice);
}
}
}
}
return(deviceList);
}
public DataObject.Device Get(int Id)
{
DataObject.Device dataObjectDevice = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [Configuration].[GetActiveDevice] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObjectDevice = new DataObject.Device();
dataObjectDevice.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectDevice.Id_Unit = int.Parse(reader.GetValue(1).ToString());
dataObjectDevice.Name = reader.GetValue(2).ToString();
dataObjectDevice.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString());
dataObjectDevice.IsActive = Convert.ToBoolean(reader.GetValue(4).ToString());
}
}
}
}
return dataObjectDevice;
}
public DataObject.Device Get(int Id)
{
DataObject.Device dataObjectDevice = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = @"SELECT Id, Id_Unit, Name, DateAdded, IsActive, Switch FROM [Configuration].[Device]
WHERE Id = {0} AND IsActive = 1" ;
using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObjectDevice = new DataObject.Device();
dataObjectDevice.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectDevice.Id_Unit = int.Parse(reader.GetValue(1).ToString());
dataObjectDevice.Name = reader.GetValue(2).ToString();
dataObjectDevice.DateAdded = Convert.ToDateTime(reader.GetValue(3).ToString());
dataObjectDevice.IsActive = Convert.ToBoolean(reader.GetValue(4).ToString());
dataObjectDevice.Switch = reader.GetValue(5).ToString();
}
}
}
}
return(dataObjectDevice);
}
