/// <summary>
/// Get all door mode
/// </summary>
/// <returns>Return list door mode or null if error</returns>
public List <DTO_DoorMode> GetAllDoorMode()
{
List <DTO_DoorMode> lstModes = new List <DTO_DoorMode>();
DataTable dt = dal.GetAllDoorMode();
if (dt.Rows.Count < 0)
{
return(null);
}
try
{
foreach (DataRow row in dt.Rows)
{
DTO_DoorMode mode = new DTO_DoorMode();
mode.Id = row["Id"] == DBNull.Value ? null : row["Id"].ToString();
mode.Name = row["Name"] == DBNull.Value ? null : row["Name"].ToString();
mode.Description = row["Description"] == DBNull.Value ? null : row["Description"].ToString();
mode.ReaderUse = row["ReadersUse"] == DBNull.Value ? -1 : (int)row["ReadersUse"];
mode.InputUse = row["InputUse"] == DBNull.Value ? -1 : (int)row["InputUse"];
mode.OutputUse = row["OutputUse"] == DBNull.Value ? -1 : (int)row["OutputUse"];
lstModes.Add(mode);
}
return(lstModes);
}
catch
{
return(null);
}
}
/// <summary>
/// Get all Door
/// </summary>
/// <returns>Return list door or null if error</returns>
public List <DTO_Door> GetAllDoor()
{
List <DTO_Door> lstDoors = new List <DTO_Door>();
DataTable dt = dal.GetAllDoor();
if (dt.Rows.Count < 0)
{
return(null);
}
try
{
foreach (DataRow row in dt.Rows)
{
DTO_Door door = new DTO_Door();
door.Id = row["Id"] == DBNull.Value ? null : row["Id"].ToString();
door.Name = row["Name"] == DBNull.Value ? null : row["Name"].ToString();
door.LOTimeOut = row["LOTimeout"] == DBNull.Value ? 0 : (int)row["LOTimeout"];
door.DOTimeOut = row["DOTimeout"] == DBNull.Value ? 0 : (int)row["DOTimeout"];
door.Description = row["Description"] == DBNull.Value ? null : row["Description"].ToString();
DTO_DoorMode mode = new DTO_DoorMode();
mode.Id = row["DMode"] == DBNull.Value ? null : row["DMode"].ToString();
mode.Name = row["DoorModeName"] == DBNull.Value ? null : row["DoorModeName"].ToString();
mode.ReaderUse = row["ReadersUse"] == DBNull.Value ? 0 : (int)row["ReadersUse"];
mode.InputUse = row["InputUse"] == DBNull.Value ? 0 : (int)row["InputUse"];
mode.OutputUse = row["OutputUse"] == DBNull.Value ? 0 : (int)row["OutputUse"];
mode.Description = row["DoorModeDescr"] == DBNull.Value ? null : row["DoorModeDescr"].ToString();
door.Mode = mode;
door.Sockets = bus_Socket.GetDoorSocketInDoor(door.Id);
lstDoors.Add(door);
}
return(lstDoors);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Get door by key (Id)
/// </summary>
/// <param name="Id"></param>
/// <returns>Return door if founed or null if error</returns>
public DTO_Door GetDoorByKey(string Id)
{
DataTable dt = dal.GetDoorById(Id);
if (dt.Rows.Count < 0)
{
return(null);
}
try
{
DataRow row = dt.Rows[0];
DTO_Door door = new DTO_Door();
door.Id = row["Id"] == DBNull.Value ? null : row["Id"].ToString();
door.Name = row["Name"] == DBNull.Value ? null : row["Name"].ToString();
door.LOTimeOut = row["LOTimeOut"] == DBNull.Value ? 0 : (int)row["LOTimeOut"];
door.DOTimeOut = row["DOTimeOut"] == DBNull.Value ? 0 : (int)row["DOTimeOut"];
door.Description = row["Description"] == DBNull.Value ? null : row["Description"].ToString();
DTO_DoorMode mode = new DTO_DoorMode();
mode.Id = row["DMode"] == DBNull.Value ? null : row["DMode"].ToString();
mode.Name = row["DoorModeName"] == DBNull.Value ? null : row["DoorModeName"].ToString();
mode.ReaderUse = row["ReadersUse"] == DBNull.Value ? 0 : (int)row["ReadersUse"];
mode.InputUse = row["InputUse"] == DBNull.Value ? 0 : (int)row["InputUse"];
mode.OutputUse = row["OutputUse"] == DBNull.Value ? 0 : (int)row["OutputUse"];
mode.Description = row["DoorModeDescr"] == DBNull.Value ? null : row["DoorModeDescr"].ToString();
door.Mode = mode;
door.Sockets = bus_Socket.GetDoorSocketInDoor(door.Id);
return(door);
}
catch
{
return(null);
}
}
