/// <summary>
/// Get UnStructuce Elements
/// </summary>
/// <param name="strDataConnectorType, iDataConnectorID"></param>
/// <returns></returns>
//public IList<DiscoveryElementDTO> GetDiscoveryViewModel(string strDataConnectorType,int iDataConnectorID)
//{
// try
// {
// return GetNonDiscoverElementByConnectorID(strDataConnectorType, iDataConnectorID);
// }
// catch (ConnectorException conex)
// {
// throw conex;
// }
//}
/// <summary>
/// Getiing the table onformation from the Database nad obix points
/// </summary>
/// <param name="strDataConnectorType"></param>
/// <param name="iDataConnectorID"></param>
/// <returns>IList<DiscoveryElementDTO></returns>
public IList <DiscoveryPoint_DTO> GetNonDiscoverElementByConnectorID(int iDataConnectorID)
{
ConnectorDTO objDataConnectorDTO = _objConectorRepository.GetExistingConnectionById(iDataConnectorID);
IList <ElementDTO> strucutredlist = _objElementRepository.GetElementByConnectionID(iDataConnectorID);
ExistingConnectionNameDTO objExistingConnectionNameDTO = ExistingConnectionNameDTO.ConvertTableToDTO(objDataConnectorDTO);
try
{
if (objExistingConnectionNameDTO.DataConnectorType == Common.Enums.DataSouceConnectionType.Live)
{
ILiveVariable obix = new Obix(objDataConnectorDTO.ServerOrIP, objDataConnectorDTO.ServerUserName, objDataConnectorDTO.ServerPassword);
IList <LivePointModel> list_of_Live_Point = obix.GetPoints(objDataConnectorDTO.ServerOrIP);
return(DiscoveryPoint_DTO_Conversion.ConvertTableToDTO(list_of_Live_Point, objExistingConnectionNameDTO.ConnectionID, objExistingConnectionNameDTO.ConnectionID, strucutredlist).ToList());
//return DiscoveryElementDTO.ConvertTableToDTO(list_of_Live_Point, objExistingConnectionNameDTO, strucutredlist).ToList();
}
else
{
_objRawTableName.GetRowTableNames(objDataConnectorDTO.ServerOrIP, objDataConnectorDTO.ServerUserName, objDataConnectorDTO.ServerPassword, objDataConnectorDTO.DatabaseName);
return(DiscoveryPoint_DTO_Conversion.ConvertTableToDTO(_objRawTableName.RowTableNames, objExistingConnectionNameDTO, strucutredlist).ToList());
}
}
catch (ConnectorException conex)
{
throw conex;
}
}
public IList <DiscoveryPoint_DTO> GetNonDiscoverElementByConnectorID(int iDataConnectorID, string Element_Source_ID, int parent_id)
{
ConnectorDTO objDataConnectorDTO = _objConectorRepository.GetExistingConnectionById(iDataConnectorID);
IList <ElementDTO> strucutredlist = _objElementRepository.GetElementByConnectionID(iDataConnectorID);
ExistingConnectionNameDTO objExistingConnectionNameDTO = ExistingConnectionNameDTO.ConvertTableToDTO(objDataConnectorDTO);
ILiveVariable obix = new Obix(objDataConnectorDTO.ServerOrIP, objDataConnectorDTO.ServerUserName, objDataConnectorDTO.ServerPassword);
IList <LivePointModel> list_of_Live_Point = obix.GetPoints(Element_Source_ID);
return(DiscoveryPoint_DTO_Conversion.ConvertTableToDTO(list_of_Live_Point, parent_id, objExistingConnectionNameDTO.ConnectionID, strucutredlist).ToList());
}
/// <summary>
/// Get all connection by Is_Active
/// </summary>
/// <param name="Active"></param>
/// <returns>IList<ConnectorDTO></returns>
public IList <ExistingConnectionNameDTO> GetExistingConnectionsBy_Is_Active(bool Active)
{
try
{
//_dbcontext = new InnonAnalyticsEngineEntities();
ICollection <tblConnector> objtblConnector = _dbcontext.tblConnectors.Where(c => c.Is_Active == Active).ToList();
return(ExistingConnectionNameDTO.ConvertTableToDTO(objtblConnector));
}
catch
{ throw; }
}
/// <summary>
/// Get connection by ConnectorID this is for general use
/// </summary>
/// <param name="ConnectorID"></param>
/// <returns>ExistingConnectionNameDTO</returns>
public ExistingConnectionNameDTO GetExistingConnectionGeneralInfoById(int ConnectorID)
{
try
{
//_dbcontext = new InnonAnalyticsEngineEntities();
tblConnector objtblConnector = _dbcontext.tblConnectors.SingleOrDefault(s => s.ID == ConnectorID);
if (objtblConnector == null)
{
throw new ConnectorException(Resources.ConnectorNotFound);
}
return(ExistingConnectionNameDTO.ConvertTableToDTO(objtblConnector));
}
catch
{ throw; }
}
