public UXBeneficialOwnershipURLEntity UXGetBeneficialOwnershipURL(string duns, string country) { UXBeneficialOwnershipURLEntity uRLEntity = new UXBeneficialOwnershipURLEntity(); DataTable dt; try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.UXGetBeneficialOwnershipURL"; StoredProceduresParameterEntity param = new StoredProceduresParameterEntity(); sproc.StoredProceduresParameter.Add(GetParam("@DnBDUNSNumber", duns, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@CountryISO2AlphaCode", country, SQLServerDatatype.charDataType)); dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { uRLEntity = CommonConvertMethods.GetItem <UXBeneficialOwnershipURLEntity>(item); } } return(uRLEntity); } catch (Exception ex) { //Put log to db here throw; } }
internal ThirdPartyEnrichmentsEntity GetThirdPartyEnrichmentsByEnrichmentId(int enrichId) { ThirdPartyEnrichmentsEntity thirdPartyEnrichments = new ThirdPartyEnrichmentsEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetThirdPartyEnrichmentsByEnrichmentId"; sproc.StoredProceduresParameter.Add(GetParam("@EnrichmentId", enrichId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, ""); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { thirdPartyEnrichments = CommonConvertMethods.GetItem <ThirdPartyEnrichmentsEntity>(dr); } } return(thirdPartyEnrichments); } catch (Exception) { throw; } }
internal List <MultiPassGroupConfiguration> GetVerificationGroupLookupList(int providerCode, string tag) { List <MultiPassGroupConfiguration> lstGroups = new List <MultiPassGroupConfiguration>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mpm.GetLookupsByVerificationGroup"; sproc.StoredProceduresParameter.Add(GetParam("@ProviderCode", Convert.ToString(providerCode), SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@Tag", string.IsNullOrEmpty(tag) ? null : tag, SQLServerDatatype.VarcharDataType)); DataTable dt = new DataTable(); dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, ""); lstGroups = CommonConvertMethods.ConvertDataTable <MultiPassGroupConfiguration>(dt); } catch (Exception) { //Put log to db here throw; } return(lstGroups); }
internal List <ThirdPartyEnrichmentsEntity> GetThirdPartyEnrichments() { List <ThirdPartyEnrichmentsEntity> results = new List <ThirdPartyEnrichmentsEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetThirdPartyEnrichments"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, ""); if (dt != null && dt.Rows.Count > 0) { results = CommonConvertMethods.ConvertDataTable <ThirdPartyEnrichmentsEntity>(dt); } } catch (Exception) { throw; } return(results); }
public List <ScreenResponseEntity> GetScreenResponse(string alternateId, string beneficiaryType) { List <ScreenResponseEntity> lstScreenData = new List <ScreenResponseEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "cmpl.GetScreenResponse"; StoredProceduresParameterEntity param = new StoredProceduresParameterEntity(); sproc.StoredProceduresParameter.Add(GetParam("@alternateId", alternateId, SQLServerDatatype.NvarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@beneficiaryType", beneficiaryType, SQLServerDatatype.VarcharDataType)); DataTable dt = new DataTable(); dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); lstScreenData = CommonConvertMethods.ConvertDataTable <ScreenResponseEntity>(dt); return(lstScreenData); } catch (Exception ex) { //Put log to db here throw; } }