internal List <ThirdPartyAPIForEnrichmentEntity> GetUXDefaultUXEnrichments()
{
List <ThirdPartyAPIForEnrichmentEntity> results = new List <ThirdPartyAPIForEnrichmentEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "cfg.GetUXDefaultUXEnrichment";
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
ThirdPartyAPIForEnrichmentAdapter adta = new ThirdPartyAPIForEnrichmentAdapter();
results = new ThirdPartyAPIForEnrichmentAdapter().Adapt(dt);
foreach (ThirdPartyAPIForEnrichmentEntity comp in results)
{
results = new ThirdPartyAPIForEnrichmentAdapter().Adapt(dt);
}
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal List <ThirdPartyAPIForEnrichmentEntity> GetThirdPartyAPICredentialsForEhrichment(string ThirdPartyProvider)
{
List <ThirdPartyAPIForEnrichmentEntity> results = new List <ThirdPartyAPIForEnrichmentEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "cfg.GetThirdPartyAPICredentials";
sproc.StoredProceduresParameter.Add(GetParam("@ThirdPartyProvider", ThirdPartyProvider, SQLServerDatatype.VarcharDataType));
DataTable dt = new DataTable();
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new ThirdPartyAPIForEnrichmentAdapter().Adapt(dt);
}
}
catch (Exception)
{
throw;
}
return(results);
}
