internal ThirdPartyAPICredentialsEntity GetMinConfidenceSettingsById(int MinCCId)
{
ThirdPartyAPICredentialsEntity results = new ThirdPartyAPICredentialsEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetMinConfidenceSettingsById";
sproc.StoredProceduresParameter.Add(GetParam("@Id", MinCCId.ToString(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "");
if (dt != null && dt.Rows.Count > 0)
{
ThirdPartyAPICredentialsAdapter adta = new ThirdPartyAPICredentialsAdapter();
foreach (DataRow rw in dt.Rows)
{
results = adta.AdaptItem(rw);
}
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal List <ThirdPartyAPICredentialsEntity> GetThirdPartyAPICredentialsForRefresh(string ThirdPartyProvider)
{
List <ThirdPartyAPICredentialsEntity> results = new List <ThirdPartyAPICredentialsEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "cfg.GetThirdPartyAPICredentialsForRefresh";
sproc.StoredProceduresParameter.Add(GetParam("@ThirdPartyProvider", ThirdPartyProvider, SQLServerDatatype.VarcharDataType));
DataTable dt = new DataTable();
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
if (dt != null && dt.Rows.Count > 0)
{
results = new ThirdPartyAPICredentialsAdapter().Adapt(dt);
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal ThirdPartyAPICredentialsEntity GetThirdPartyAPICredentialsById(int CredentialId)
{
ThirdPartyAPICredentialsEntity results = new ThirdPartyAPICredentialsEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "cfg.GetThirdPartyAPICredentialsById";
sproc.StoredProceduresParameter.Add(GetParam("@CredentialId", CredentialId.ToString(), SQLServerDatatype.VarcharDataType));
DataTable dt = new DataTable();
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new ThirdPartyAPICredentialsAdapter().AdaptItem(dt.Rows[0]);
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal List <ThirdPartyAPICredentialsEntity> GetMinConfidenceSettingsListPage(bool IsGlobal, string LOBTag)
{
List <ThirdPartyAPICredentialsEntity> results = new List <ThirdPartyAPICredentialsEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetMinConfidenceSettingsListPaging";
sproc.StoredProceduresParameter.Add(GetParam("@IsGlobal", IsGlobal.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LOBTag", LOBTag, SQLServerDatatype.VarcharDataType));
DataTable dt = new DataTable();
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
if (dt != null && dt.Rows.Count > 0)
{
results = new ThirdPartyAPICredentialsAdapter().Adapt(dt);
}
return(results);
}
catch (Exception)
{
throw;
}
}
