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