public DataObject.Status Get(int Id_Device) { DataObject.Status dataObjectDeviceStatus = null; using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "Exec [Configuration].[GetDeviceStatus] {0}"; using (SqlCommand command = new SqlCommand(string.Format(query, Id_Device), connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dataObjectDeviceStatus = new DataObject.Status(); dataObjectDeviceStatus.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectDeviceStatus.Description = reader.GetValue(1).ToString(); } } } } return(dataObjectDeviceStatus); }
public DataObject.Status Get(int Id_Device) { DataObject.Status dataObjectDeviceStatus = null; using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); string query = "Exec [Configuration].[GetDeviceStatus] {0}"; using (SqlCommand command = new SqlCommand(string.Format(query, Id_Device), connection)) { SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dataObjectDeviceStatus = new DataObject.Status(); dataObjectDeviceStatus.Id = int.Parse(reader.GetValue(0).ToString()); dataObjectDeviceStatus.Description = reader.GetValue(1).ToString(); } } } } return dataObjectDeviceStatus; }