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