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