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; } }