public DataObject.Unit Get(int Id)
{
DataObject.Unit dataObjectUnit = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [Configuration].[GetActiveUnit] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObjectUnit = new DataObject.Unit();
dataObjectUnit.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectUnit.Id_Zone = 0;
dataObjectUnit.Name = reader.GetValue(1).ToString();
dataObjectUnit.Address = reader.GetValue(3).ToString();
dataObjectUnit.DateAdded = Convert.ToDateTime(reader.GetValue(2).ToString());
dataObjectUnit.IsActive = true;
}
}
}
}
return(dataObjectUnit);
}
public DataObject.Unit Get(int Id)
{
DataObject.Unit dataObjectUnit = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [Configuration].[GetActiveUnit] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dataObjectUnit = new DataObject.Unit();
dataObjectUnit.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectUnit.Id_Zone = 0;
dataObjectUnit.Name = reader.GetValue(1).ToString();
dataObjectUnit.Address = reader.GetValue(3).ToString();
dataObjectUnit.DateAdded = Convert.ToDateTime(reader.GetValue(2).ToString());
dataObjectUnit.IsActive = true;
}
}
}
}
return dataObjectUnit;
}
public List <DataObject.Unit> List(int Id_Zone)
{
List <DataObject.Unit> unitList = new List <DataObject.Unit>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [Configuration].[ListActiveUnit] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id_Zone), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Unit dataObjectUnit = new DataObject.Unit();
dataObjectUnit.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectUnit.Id_Zone = Id_Zone;
dataObjectUnit.Name = reader.GetValue(1).ToString();
dataObjectUnit.Address = reader.GetValue(3).ToString();
dataObjectUnit.DateAdded = Convert.ToDateTime(reader.GetValue(2).ToString());
dataObjectUnit.IsActive = Convert.ToBoolean(reader.GetValue(4).ToString());
unitList.Add(dataObjectUnit);
}
}
}
}
return(unitList);
}
private string GetUnitIpAddress(int unitId)
{
lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new pmgmt.data.DAO.Configuration.Unit();
unitDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Unit unitDTO = unitDAO.Get(unitId);
return(unitDTO.Address);
}
public List<DataObject.Unit> List(int Id_Zone)
{
List<DataObject.Unit> unitList = new List<DataObject.Unit>();
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
string query = "Exec [Configuration].[ListActiveUnit] {0}";
using (SqlCommand command = new SqlCommand(string.Format(query, Id_Zone), connection))
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DataObject.Unit dataObjectUnit = new DataObject.Unit();
dataObjectUnit.Id = int.Parse(reader.GetValue(0).ToString());
dataObjectUnit.Id_Zone = Id_Zone;
dataObjectUnit.Name = reader.GetValue(1).ToString();
dataObjectUnit.Address = reader.GetValue(3).ToString();
dataObjectUnit.DateAdded = Convert.ToDateTime(reader.GetValue(2).ToString());
dataObjectUnit.IsActive = Convert.ToBoolean(reader.GetValue(4).ToString());
unitList.Add(dataObjectUnit);
}
}
}
}
return unitList;
}