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);
}
/// <summary>
/// Single Convertion of DTO to Database Table, this is used normally for when update the record in database
/// </summary>
/// <param name="tagDTO"></param>
/// <param name="tagsTable"></param>
public static void ConvertDTOtoTable(TagDTO tagDTO, ref tblTag tagsTable)
{
try
{
tagsTable.ID = tagDTO.ID;
tagsTable.Tag_Kind = tagDTO.Tag_Kind.ToString();
tagsTable.Tag_Type = tagDTO.Tag_Type.ToString();
tagsTable.Tag_Value = tagDTO.Tag_Value;
tagsTable.Is_Disabled = tagDTO.Is_Disabled;
tagsTable.tblDescription = DescriptionConvert.DescriptionConvertDTOToTbl(tagDTO.TagName);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
/// <summary>
/// Single Convertion of Database Table to DTO
/// </summary>
/// <param name="tagTbl"></param>
/// <returns type ="TagDTO" ></returns>
public static TagDTO ConvertTableToDTO(tblTag tagTbl)
{
TagDTO tagsDTO = new TagDTO();
try
{
tagsDTO.ID = tagTbl.ID;
tagsDTO.Tag_Kind = (TagKind)Enums.TryParse(typeof(TagKind), tagTbl.Tag_Kind);
tagsDTO.Tag_Type = (TagType)Enums.TryParse(typeof(TagType), tagTbl.Tag_Type);
tagsDTO.Tag_Value = tagTbl.Tag_Value;
tagsDTO.Is_Disabled = tagTbl.Is_Disabled;
if (tagTbl.tblDescription != null)
{
tagsDTO.TagName = DescriptionConvert.DescriptionConvertDTOToTbl(tagTbl.tblDescription);
}
return(tagsDTO);
}
catch (Exception ex)
{
throw ex;
}
}
