private void WriteLivePoint(LivePoint_DTO livepoint)
{
try
{
tblElement element = get_tblElement_by_Id(livepoint.Point_Id);
if (element == null)
{
throw new ArgumentNullException($"Invalid Element Id, No element found against this element ID {livepoint.Point_Id} ");
}
ILiveVariable liveVariable = new Obix(StringEncryDecry.Decrypt(element.tblConnector.Server_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.User_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.Password, element.tblConnector.SessionID));
if (livepoint.Current_Value.dValue.HasValue)
{
liveVariable.SetValueLiveVariable <decimal>(element.Source_Element_Name_Live, livepoint.Current_Value.dValue.Value);
}
else if (livepoint.Current_Value.bValue.HasValue)
{
liveVariable.SetValueLiveVariable <bool>(element.Source_Element_Name_Live, livepoint.Current_Value.bValue.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void ReadLivePoint(tblElement element, LivePoint_DTO livepoint)
{
if (element.tblConnector.Gateway_Type == DataGatewayType.Obix.ToString())
{
try
{
if (_connection_id != element.tblConnector.ID)
{
_connection_id = element.tblConnector.ID;
_liveVariable = new Obix(
StringEncryDecry.Decrypt(element.tblConnector.Server_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.User_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.Password, element.tblConnector.SessionID));
}
LivePoint_ResponseDTO response_dto = new LivePoint_ResponseDTO();
if (_liveVariable.Is_Connected)
{
response_dto = _liveVariable.ReadLiveVariable(element.Source_Element_Name_Live);
livepoint.Current_Value = response_dto;
}
else
{
livepoint.Error_Info = Error_Internal.SetError("Connection Error");
}
}
catch (Exception ex) { }
}
else
{
throw new Exception("Invalid GatewayType");
}
}
public static tblConnector ConvertDTOToTable(ConnectorDTO _dtoConnector)
{
tblConnector _tblConnector = new tblConnector();
_tblConnector.ID = _dtoConnector.ConnectionID;
_tblConnector.Connection_Name = _dtoConnector.ConnectionName;
_tblConnector.User_Name = StringEncryDecry.Encrypt(_dtoConnector.ServerUserName, _dtoConnector.SessionId);
_tblConnector.Password = StringEncryDecry.Encrypt(_dtoConnector.ServerPassword, _dtoConnector.SessionId);
_tblConnector.Server_Name = StringEncryDecry.Encrypt(_dtoConnector.ServerOrIP, _dtoConnector.SessionId);
_tblConnector.Port_Number = _dtoConnector.PortNumber;
_tblConnector.Data_Connector_Connection_Type = _dtoConnector.DataConnectorType.ToString();
_tblConnector.Gateway_Type = _dtoConnector.DataConnectorType.ToString();
_tblConnector.Is_Active = _dtoConnector.IsActive;
_tblConnector.SessionID = _dtoConnector.SessionId;
_tblConnector.Database_Name = _dtoConnector.DatabaseName;
_tblConnector.Default_Path = _dtoConnector.DefaultPath;
if (_dtoConnector.Mode != null)
{
_tblConnector.FTP_Mode = _dtoConnector.Mode.ToString();
}
return(_tblConnector);
}
public static ConnectorDTO ConvertTableToDTO(tblConnector _tblConnector)
{
ConnectorDTO _dtoConnector = new ConnectorDTO();
_dtoConnector.ConnectionID = _tblConnector.ID;
_dtoConnector.ConnectionName = _tblConnector.Connection_Name;
_dtoConnector.ServerUserName = StringEncryDecry.Decrypt(_tblConnector.User_Name, _tblConnector.SessionID);
_dtoConnector.ServerPassword = StringEncryDecry.Decrypt(_tblConnector.Password, _tblConnector.SessionID);
_dtoConnector.ServerOrIP = StringEncryDecry.Decrypt(_tblConnector.Server_Name, _tblConnector.SessionID);
_dtoConnector.PortNumber = _tblConnector.Port_Number;
_dtoConnector.DataConnectorType = (DataSouceConnectionType)Enums.TryParse(typeof(DataSouceConnectionType), _tblConnector.Data_Connector_Connection_Type.ToString());
_dtoConnector.GatewayType = (DataGatewayType)Enums.TryParse(typeof(DataGatewayType), _tblConnector.Gateway_Type.ToString());
_dtoConnector.IsActive = _tblConnector.Is_Active;
_dtoConnector.SessionId = _tblConnector.SessionID;
_dtoConnector.DatabaseName = _tblConnector.Database_Name;
_dtoConnector.DefaultPath = _tblConnector.Default_Path;
if (_tblConnector.FTP_Mode != null)
{
_dtoConnector.Mode = (FTPMode)Enums.TryParse(typeof(FTPMode), _tblConnector.FTP_Mode);
}
return(_dtoConnector);
}
public static DataConnectorsDTO ConvertTableToDTO(tblConnector objDbtbl)
{
DataConnectorsDTO objDataConnectorDTO = new DataConnectorsDTO();
objDataConnectorDTO.ConnectorCredential.ServerUserName = StringEncryDecry.Decrypt(objDbtbl.User_Name, objDbtbl.SessionID);
objDataConnectorDTO.ConnectorCredential.ServerPassword = StringEncryDecry.Decrypt(objDbtbl.Password, objDbtbl.SessionID);
objDataConnectorDTO.ConnectorCredential.ServerOrIP = StringEncryDecry.Decrypt(objDbtbl.Server_Name, objDbtbl.SessionID);
objDataConnectorDTO.ConnectorCredential.PortNumber = objDbtbl.Port_Number;
objDataConnectorDTO.NameofConnection = DescriptionConvert.DescriptionConvertDTOToTbl(objDbtbl.tblDescription);
objDataConnectorDTO.ID = objDbtbl.ID;
if (Enum.IsDefined(typeof(DataSouceConnectionType), objDbtbl.Data_Connector_Connection_Type))
{
objDataConnectorDTO.DataConnectorConnectionType = (DataSouceConnectionType)Enum.Parse(typeof(DataSouceConnectionType), objDbtbl.Data_Connector_Connection_Type);
switch ((DataSouceConnectionType)Enum.Parse(typeof(DataSouceConnectionType), objDbtbl.Data_Connector_Connection_Type))
{
case DataSouceConnectionType.Database:
objDataConnectorDTO.objConnectionDatabaseDTO = new ConnectionDataBaseDTO();
objDataConnectorDTO.objConnectionDatabaseDTO.strDatabaseName = objDbtbl.Database_Name;
break;
case DataSouceConnectionType.API:
objDataConnectorDTO.objConnectionAPIDTO = new ConnectionAPIDTO();
throw new NotImplementedException();
case DataSouceConnectionType.FTP:
objDataConnectorDTO.objConnectionFTPDTO = new ConnectionFTPDTO();
objDataConnectorDTO.objConnectionFTPDTO.DefaultFolder = objDbtbl.Default_Path;
FTPMode enumFTPMode;
if (Enum.TryParse(objDbtbl.FTP_Mode, out enumFTPMode))
{
objDataConnectorDTO.objConnectionFTPDTO.Mode = enumFTPMode;
}
else
{
throw new Exception(string.Format(Resources.FTPModeTypeInvalid + "- {0}" + objDbtbl.tblDescription.tblLanguageDescriptions.FirstOrDefault().Short_Desription));
}
break;
default:
throw new Exception(string.Format(Resources.DataSouceConnectionTypeInvalid + "- {0}" + objDbtbl.tblDescription.tblLanguageDescriptions.FirstOrDefault().Short_Desription));
}
}
else
{
throw new DataConnectorExcetion(Resources.DataSouceConnectionTypeInvalid);
// Handle values not in enum here if needed
}
return(objDataConnectorDTO);
}
public static void ConvertDTOtoTable(DataConnectorsDTO objConnectorDTO, ref tblConnector objConnector)
{
if (objConnector == null)
{
objConnector = new tblConnector();
}
objConnector.Data_Connector_Connection_Type = objConnectorDTO.DataConnectorConnectionType.ToString();
if (objConnectorDTO.DataConnectorConnectionType == DataSouceConnectionType.Database)
{
objConnector.Database_Name = objConnectorDTO.objConnectionDatabaseDTO.strDatabaseName;
}
else if (objConnectorDTO.DataConnectorConnectionType == DataSouceConnectionType.API)
{
throw new NotImplementedException();
}
else if (objConnectorDTO.DataConnectorConnectionType == DataSouceConnectionType.FTP)
{
objConnector.Default_Path = objConnectorDTO.objConnectionFTPDTO.DefaultFolder;
objConnector.FTP_Mode = objConnectorDTO.objConnectionFTPDTO.Mode.ToString();
}
else
{
throw new DataConnectorExcetion(Resources.DataSouceConnectionTypeInvalid);
}
objConnector.ID = objConnectorDTO.ID;
objConnector.User_Name = StringEncryDecry.Encrypt(objConnectorDTO.ConnectorCredential.ServerUserName, objConnectorDTO.SessionId);
objConnector.Password = StringEncryDecry.Encrypt(objConnectorDTO.ConnectorCredential.ServerPassword, objConnectorDTO.SessionId);
objConnector.Server_Name = StringEncryDecry.Encrypt(objConnectorDTO.ConnectorCredential.ServerOrIP, objConnectorDTO.SessionId);
objConnector.Port_Number = objConnectorDTO.ConnectorCredential.PortNumber;
objConnector.SessionID = objConnectorDTO.SessionId;
//if (objConnector.tblDescription == null)
// objConnector.tblDescription = new tblDescription();
tblDescription objtblDescription = objConnector.tblDescription;
DescriptionConvert.DescriptionConvertDTOToTbl(objConnectorDTO.NameofConnection, ref objtblDescription);
objConnector.tblDescription = objtblDescription;
}
