public MainMatchEntity LoadData(string CompanyName, string Address, string Address2, string City, string State, string Country, string zip, string Phone, bool ExcludeNonHeadQuarters, bool ExcludeNonMarketable, bool ExcludeOutofBusiness, bool ExcludeUndeliverable, bool ExcludeUnreachable, string Language, string SrcRecId, string ConnectionString, string InputId)
{
MainMatchEntity objmainMatchEntity = new MainMatchEntity();
try
{
// Checking APIType is there or not
string APItype = CommonMethod.GetThirdPartyProperty(ThirdPartyCode.DNB_SINGLE_ENTITY_SEARCH.ToString(), ThirdPartyProperties.APIType.ToString());
if (string.IsNullOrEmpty(APItype))
{
objmainMatchEntity.ResponseErroeMessage = CommonMessagesLang.msgNoDefaultKeyForSearch;
return(objmainMatchEntity);
}
bool IsDirectPlusCall = false;
CommonMethod objCommon = new CommonMethod();
Utility api = new Utility();
var objResult = objCommon.LoadCleanseMatchSettings(ConnectionString);
bool IsGlobal = true;
string LOBTag = null;
int PageSize = 10, PageNumber = 1, SortOrder = 0, TotalRecords = 0;
int totalCount = 0;
DataTable lstThirdPartyAPICredentials = new DataTable();
ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(ConnectionString);
lstThirdPartyAPICredentials = fac.GetMinConfidenceSettingsListPaging(IsGlobal, LOBTag);
int candidateMaxQuantity = 0, confidenceLowerLevelThresholdValue = 0;
foreach (DataRow row in lstThirdPartyAPICredentials.Rows)
{
candidateMaxQuantity = Convert.ToInt32(row["MaxCandidateQty"]);
confidenceLowerLevelThresholdValue = Convert.ToInt32(row["MinConfidenceCode"]);
}
CountryGroupModel.CountryISOAlpha2Enum objEnum = new CountryGroupModel.CountryISOAlpha2Enum();
try
{
objEnum = (CountryGroupModel.CountryISOAlpha2Enum)Enum.Parse(typeof(CountryGroupModel.CountryISOAlpha2Enum), Convert.ToString(Country));
}
catch
{
objEnum = (CountryGroupModel.CountryISOAlpha2Enum)Enum.Parse(typeof(CountryGroupModel.CountryISOAlpha2Enum), "US");
}
try
{
CompanyFacade fcd = new CompanyFacade(ConnectionString, Helper.oUser.UserName);
if (APItype.ToLower() == ApiLayerType.Directplus.ToString().ToLower())
{
IsDirectPlusCall = true;
response = api.GetCleanseMatchResultDirectPlus(CompanyName, Address, Address2, City, State, objEnum, zip, Phone, ExcludeNonHeadQuarters, ExcludeNonMarketable, ExcludeOutofBusiness, ExcludeUndeliverable, ExcludeUnreachable, Language, candidateMaxQuantity, confidenceLowerLevelThresholdValue, ConnectionString, InputId);
}
else if (APItype.ToLower() == ApiLayerType.Direct20.ToString().ToLower())
{
response = api.GetCleanseMatchResult(CompanyName, Address, Address2, City, State, objEnum, zip, Phone, ExcludeNonHeadQuarters, ExcludeNonMarketable, ExcludeOutofBusiness, ExcludeUndeliverable, ExcludeUnreachable, candidateMaxQuantity, confidenceLowerLevelThresholdValue, ConnectionString, InputId);
}
if (response != null && response.TransactionResponseDetail != null)
{
objCommon.InsertAPILogs(response.TransactionResponseDetail, ConnectionString);
fcd.InsertCleanseMatchCallResults(SrcRecId, response.ResponseJSON, response.APIRequest, Helper.oUser.UserId, InputId);
objmainMatchEntity.lstMatches = response.MatchEntities;
objmainMatchEntity.lstMatches.ForEach(x => x.MatchDataCriteriaText = response?.TransactionResponseDetail?.MatchDataCriteriaText);
}
else
{
objmainMatchEntity.ResponseErroeMessage = CommonMessagesLang.msgResponseErroeMessage;
}
if (!string.IsNullOrEmpty(response?.ResponseJSON))
{
dynamic data = JObject.Parse(response.ResponseJSON);
if (data.error != null && !string.IsNullOrEmpty(data.error.errorMessage.Value))
{
objmainMatchEntity.ResponseErroeMessage = data.error.errorMessage.Value;
}
}
}
catch (WebException webEx)
{
using (var stream = webEx.Response.GetResponseStream())
using (var streamReader = new StreamReader(stream))
{
var result = streamReader.ReadToEnd();
if (result != null)
{
var serializer = new JavaScriptSerializer();
if (IsDirectPlusCall == false)
{
GetCleanseMatchResponseMain objResponse = serializer.Deserialize <GetCleanseMatchResponseMain>(result);
if (objResponse != null && objResponse.GetCleanseMatchResponse != null && objResponse.GetCleanseMatchResponse.TransactionResult != null)
{
objmainMatchEntity.ResponseErroeMessage = objResponse.GetCleanseMatchResponse.TransactionResult.ResultText;
//objCommon.InsertAPILogs(ConnectionString, null, null, objResponse.GetCleanseMatchResponse.TransactionResult.SeverityText, objResponse.GetCleanseMatchResponse.TransactionResult.ResultID, objResponse.GetCleanseMatchResponse.TransactionResult.ResultText, null, 0, null);
}
}
else
{
var settings = new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore, MissingMemberHandling = MissingMemberHandling.Ignore
};
IdentityResolutionResponse objResponse = JsonConvert.DeserializeObject <IdentityResolutionResponse>(result, settings);
if (objResponse != null)
{
objmainMatchEntity.ResponseErroeMessage = objResponse.error.errorMessage;
objCommon.InsertAPILogs(ConnectionString, objResponse.transactionDetail.transactionID, Convert.ToDateTime(objResponse.transactionDetail.transactionTimestamp), null, null, objResponse.error.errorMessage, null, 0, null);
}
}
}
}
}
}
catch (Exception ex)
{
objmainMatchEntity.ResponseErroeMessage = CommonMessagesLang.msgResponseErroeMessage;
}
finally
{
}
return(objmainMatchEntity);
}
public ActionResult RegistrationNumberPopup(string Parameters)
{
MainMatchEntity mainMatchEntity = new MainMatchEntity();
mainMatchEntity.lstMatches = new List <MatchEntity>();
//Resert values for Display Input field in match detail view(popup)
Helper.CompanyName = "";
Helper.Address = "";
Helper.City = "";
Helper.State = "";
Helper.PhoneNbr = "";
Helper.Zip = "";
Helper.Address1 = "";
string RegistrationNoValue = string.Empty, type = string.Empty, CountryCode = string.Empty, SrcRecId = string.Empty, InputId = string.Empty;
bool IsCleanSearch = false;
CompanyFacade fcd = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName);
if (!string.IsNullOrEmpty(Parameters))
{
Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase);
RegistrationNoValue = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 0, 1);
type = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 1, 1);
IsCleanSearch = Convert.ToBoolean(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 2, 1));
CountryCode = Convert.ToString(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 3, 1));
SrcRecId = Convert.ToString(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 4, 1));
InputId = Convert.ToString(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 5, 1));
}
CommonMethod objCommon = new CommonMethod();
Utility.Utility api = new Utility.Utility();
var objResult = objCommon.LoadCleanseMatchSettings(this.CurrentClient.ApplicationDBConnectionString);
bool IsGlobal = true;
string LOBTag = null;
int PageSize = 10, PageNumber = 1, SortOrder = 0;
int totalCount = 0;
DataTable lstThirdPartyAPICredentials = new DataTable();
ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(this.CurrentClient.ApplicationDBConnectionString);
lstThirdPartyAPICredentials = fac.GetMinConfidenceSettingsListPaging(IsGlobal, LOBTag);
int confidenceLowerLevelThresholdValue = 0;
foreach (DataRow row in lstThirdPartyAPICredentials.Rows)
{
confidenceLowerLevelThresholdValue = Convert.ToInt32(row["MinConfidenceCode"]);
}
List <MatchEntity> lstMatchEntity = new List <MatchEntity>();
IPagedList <MatchEntity> pagedSearch = new StaticPagedList <MatchEntity>(lstMatchEntity, 1, 1, 1);
string APItype = CommonMethod.GetThirdPartyProperty(ThirdPartyCode.DNB_SINGLE_ENTITY_SEARCH.ToString(), ThirdPartyProperties.APIType.ToString());
try // Validate Api Family is DirectPlus or Direct20 than according to API family call method for response.
{
if (APItype.ToLower() == ApiLayerType.Directplus.ToString().ToLower())
{
response = api.GetMatchByRegistrationNoDirectPlus(CountryCode, this.CurrentClient.ApplicationDBConnectionString, RegistrationNoValue);
}
else if (APItype.ToLower() == ApiLayerType.Direct20.ToString().ToLower())
{
response = api.GetMatchByRegistrationNo(CountryCode, this.CurrentClient.ApplicationDBConnectionString, RegistrationNoValue);
}
else
{
mainMatchEntity.ResponseErroeMessage = CommonMessagesLang.msgNoDefaultKeyForSearch;
}
}
catch (WebException webEx)
{
using (var stream = webEx.Response.GetResponseStream())
using (var streamReader = new StreamReader(stream))
{
var result = streamReader.ReadToEnd();
if (result != null)
{
var serializer = new JavaScriptSerializer();
if (APItype.ToLower() == ApiLayerType.Directplus.ToString().ToLower())
{
var settings = new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore, MissingMemberHandling = MissingMemberHandling.Ignore
};
IdentityResolutionResponse objResponse = JsonConvert.DeserializeObject <IdentityResolutionResponse>(result, settings);
if (objResponse != null)
{
mainMatchEntity.ResponseErroeMessage = objResponse.error.errorMessage;
objCommon.InsertAPILogs(this.CurrentClient.ApplicationDBConnectionString, objResponse.transactionDetail.transactionID, Convert.ToDateTime(objResponse.transactionDetail.transactionTimestamp), null, null, objResponse.error.errorMessage, null, 0, null);
}
}
else if (APItype.ToLower() == ApiLayerType.Direct20.ToString().ToLower())
{
GetCleanseMatchResponseMain objResponse = serializer.Deserialize <GetCleanseMatchResponseMain>(result);
if (objResponse != null && objResponse.GetCleanseMatchResponse != null && objResponse.GetCleanseMatchResponse.TransactionResult != null)
{
mainMatchEntity.ResponseErroeMessage = objResponse.GetCleanseMatchResponse.TransactionResult.ResultText;
}
}
}
}
}
if (response != null)
{
objCommon.InsertAPILogs(response.TransactionResponseDetail, this.CurrentClient.ApplicationDBConnectionString);
fcd.InsertCleanseMatchCallResults(SrcRecId, response.ResponseJSON, response.APIRequest, Helper.oUser.UserId, InputId);
int Count = Convert.ToInt32(response.MatchEntities.Count()) + 1;
SessionHelper.SearchMatch = JsonConvert.SerializeObject(response.MatchEntities);
SessionHelper.SearchMatches = JsonConvert.SerializeObject(response.MatchEntities);
//lstMatchEntity = new List<MatchEntity>(response.MatchEntities);
mainMatchEntity.lstMatches = response.MatchEntities;
if (!string.IsNullOrEmpty(response?.ResponseJSON))
{
dynamic data = JObject.Parse(response.ResponseJSON);
if (data.error != null && !string.IsNullOrEmpty(data.error.errorMessage.Value))
{
mainMatchEntity.ResponseErroeMessage = data.error.errorMessage.Value;
}
}
}
if (IsCleanSearch)
{
return(PartialView("~/Views/BadInputData/_SearchData.cshtml", mainMatchEntity));
}
else
{
ViewBag.SearchedRegNum = RegistrationNoValue;
ViewBag.SearchedWebsite = "";
return(PartialView("_Index", mainMatchEntity));
}
}
public APIResponse SearchByDUNS(string DUNSNO, string ConnectionString)
{
// Checking APIType is there or not
string APItype = CommonMethod.GetThirdPartyProperty(ThirdPartyCode.DNB_SINGLE_ENTITY_SEARCH.ToString(), ThirdPartyProperties.APIType.ToString());
if (string.IsNullOrEmpty(APItype))
{
Helper.ResponseErroeMessage = CommonMessagesLang.msgNoDefaultKeyForSearch;
}
else
{
Helper.ResponseErroeMessage = null;
}
Helper.IsSearchBYDUNS = true;
CommonMethod objCommon = new CommonMethod();
Utility api = new Utility();
var objResult = objCommon.LoadCleanseMatchSettings(ConnectionString);
bool IsGlobal = true;
string LOBTag = null;
int PageSize = 10, PageNumber = 1, SortOrder = 0, TotalRecords = 0;
int totalCount = 0;
DataTable lstThirdPartyAPICredentials = new DataTable();
ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(ConnectionString);
lstThirdPartyAPICredentials = fac.GetMinConfidenceSettingsListPaging(IsGlobal, LOBTag);
int candidateMaxQuantity = 0, confidenceLowerLevelThresholdValue = 0;
foreach (DataRow row in lstThirdPartyAPICredentials.Rows)
{
confidenceLowerLevelThresholdValue = Convert.ToInt32(row["MinConfidenceCode"]);
}
// if Country is not specified than by default pass United state as a default company.
bool IsDirectPlusCall = false;
try
{
if (APItype.ToLower() == ApiLayerType.Directplus.ToString().ToLower())
{
IsDirectPlusCall = true;
response = api.GetMatchResultDirectPlus(DUNSNO.ToString().Trim(), ConnectionString, confidenceLowerLevelThresholdValue);
}
else if (APItype.ToLower() == ApiLayerType.Direct20.ToString().ToLower())
{
response = api.GetMatchResult(DUNSNO.ToString().Trim(), ConnectionString, confidenceLowerLevelThresholdValue);
}
}
catch (WebException webEx)
{
using (var stream = webEx.Response.GetResponseStream())
using (var streamReader = new StreamReader(stream))
{
var result = streamReader.ReadToEnd();
if (result != null)
{
var serializer = new JavaScriptSerializer();
if (IsDirectPlusCall == false)
{
MatchResponseMain objResponse = serializer.Deserialize <MatchResponseMain>(result);
if (objResponse != null && objResponse.MatchResponse != null && objResponse.MatchResponse.TransactionResult != null)
{
Helper.ResponseErroeMessage = objResponse.MatchResponse.TransactionResult.ResultText;
objCommon.InsertAPILogs(ConnectionString, null, null, objResponse.MatchResponse.TransactionResult.SeverityText, objResponse.MatchResponse.TransactionResult.ResultID, objResponse.MatchResponse.TransactionResult.ResultText, null, 0, null);
}
}
else
{
var settings = new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore, MissingMemberHandling = MissingMemberHandling.Ignore
};
IdentityResolutionResponse objResponse = JsonConvert.DeserializeObject <IdentityResolutionResponse>(result, settings);
if (objResponse != null)
{
Helper.ResponseErroeMessage = objResponse.error?.errorMessage;
objCommon.InsertAPILogs(ConnectionString, objResponse.transactionDetail.transactionID, Convert.ToDateTime(objResponse.transactionDetail.transactionTimestamp), null, null, objResponse.error.errorMessage, null, 0, null);
}
}
}
}
if (string.IsNullOrEmpty(Helper.ResponseErroeMessage))
{
Helper.ResponseErroeMessage = "No match found.";
}
}
return(response);
}
