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 List <InvestigateViewEntity> GetCompanyInvestigationPaging(int SortOrder, int PgaeIndex, int PageSize, out int TotalCount)
{
List <InvestigateViewEntity> results = new List <InvestigateViewEntity>();
try
{
TotalCount = 0;
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "[oi].[GetCompanyInvestigationPaging]";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@SortOrder", SortOrder.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PageSize", PageSize.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PageNumber", PgaeIndex.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TotalRecords", TotalCount.ToString(), SQLServerDatatype.IntDataType, ParameterDirection.Output));
string outParam = "";
DataTable dt;
dt = sql.ExecuteDataTableWithOutputParam(CommandType.StoredProcedure, sproc, out outParam, "", DBIntent.ReadWrite.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new InvestigateUserAdapter().AdaptLists(dt);
TotalCount = Convert.ToInt32(outParam);
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
internal List <MatchEntity> GetMatches(int InputId, string SrcRecordId)
{
List <MatchEntity> results = new List <MatchEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.StewGetLCMMatchExtended";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@InputId", InputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", SrcRecordId.ToString(), SQLServerDatatype.VarcharDataType));
//sproc.StoredProceduresParameter.Add(param);
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new MatchAdapter().Adapt(dt);
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
internal UserSessionFilterEntity GetUserSessionFilterByUserId(int UserID)
{
UserSessionFilterEntity results = new UserSessionFilterEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetUserSessionFilterByUserId";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = "@UserId";
param.ParameterValue = UserID.ToString();
sproc.StoredProceduresParameter.Add(param);
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new UserSessionFilterAdapter().Adapt(dt).FirstOrDefault();
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
// DB Changes (MP-716)
internal OIUserSessionFilterEntity OIGetUserSessionFilterText(int UserID)
{
OIUserSessionFilterEntity result = new OIUserSessionFilterEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.GetUserSessionFilterText";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserID.ToString(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
result = new OIUserSessionFilterAdapter().Adapt(dt).FirstOrDefault();
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(result);
}
internal List <MonitoringProductElementEntity> GetProductElementData(int productID)
{
List <MonitoringProductElementEntity> results = new List <MonitoringProductElementEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetProductElementData";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = "@ProductID";
param.ParameterValue = productID.ToString();
sproc.StoredProceduresParameter.Add(param);
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new MonitoringProductAdapter().AdaptElement(dt);
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal MonitoringProfileEntity GetMonitorProfileByID(int Id)
{
MonitoringProfileEntity results = new MonitoringProfileEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetMonitorProfileByID";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = "@MonitoringProfileID";
param.ParameterValue = Id.ToString();
sproc.StoredProceduresParameter.Add(param);
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new MonitoringProductAdapter().AdaptProfile(dt).FirstOrDefault();
}
}
catch (Exception)
{
throw;
}
return(results);
}
internal List <ClientApplicationListEntity> GetClientsApplication(int ClientId)
{
List <ClientApplicationListEntity> results = new List <ClientApplicationListEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.GetClientsApplication";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@ClientId", ClientId.ToString(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
if (dt != null && dt.Rows.Count > 0)
{
results = new ClientApplicationListAdapter().AdaptLists(dt);
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
private StoredProceduresParameterEntity GetParam(string ParameterName, string ParameterValue, SQLServerDatatype DataType)
{
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = ParameterName;
param.ParameterValue = ParameterValue;
param.Datatype = DataType;
return(param);
}
internal bool CheckNotificationProfileUsed(int ProfileId)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.CheckNotificationProfileUsed";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@ProfileId", ProfileId.ToString(), SQLServerDatatype.IntDataType));
return(Convert.ToBoolean(sql.ExecuteScalar(CommandType.StoredProcedure, sproc)));
}
catch (SqlException)
{
throw;
}
}
internal bool CheckUserPreferenceUsed(string UserPreference)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.CheckUserPreferenceUsed";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@UserPreference", UserPreference.ToString(), SQLServerDatatype.VarcharDataType));
return(Convert.ToBoolean(sql.ExecuteScalar(CommandType.StoredProcedure, sproc)));
}
catch (SqlException)
{
throw;
}
}
internal void StewUserActivityCloseWindowOI(int UserId)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewUserActivityCloseWindow";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserId.ToString(), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (SqlException)
{
throw;
}
}
// Validate SrcId for checking duplicate records at "Add Match as a new Company".
internal bool ValidateCompanySrcId(string SrcRecordId)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.StewCheckNewSrcRecordId";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", SrcRecordId.ToString(), SQLServerDatatype.VarcharDataType));
sql.ExecuteScalar(CommandType.StoredProcedure, sproc);
return(false);
}
catch (SqlException)
{
throw;
}
}
internal void AddCompanyRecord(MatchEntity Match, int UserId)
{
string InpAsXML = "";
InpAsXML = "'<CreateMatch>";
InpAsXML += "<UserId>" + UserId + "</UserId>";
InpAsXML += "<Rec><SrcRecordId>" + Match.SrcRecordId + "</SrcRecordId>";
InpAsXML += "<Tags>" + Match.Tags + "</Tags>";
InpAsXML += "<OriginalSrcRecordId>" + Match.OriginalSrcRecordId + "</OriginalSrcRecordId>";
InpAsXML += "<TransactionTimestamp>" + DateTime.Now.Date + "</TransactionTimestamp>";
InpAsXML += "<DnBDUNSNumber>" + Match.DnBDUNSNumber + "</DnBDUNSNumber>";
InpAsXML += "<DnBOrganizationName>" + Match.DnBOrganizationName + "</DnBOrganizationName>";
InpAsXML += "<DnBTradeStyleName>" + Match.DnBTradeStyleName + "</DnBTradeStyleName>";
InpAsXML += "<DnBSeniorPrincipalName>" + Match.DnBSeniorPrincipalName + "</DnBSeniorPrincipalName>";
InpAsXML += "<DnBStreetAddressLine>" + Match.DnBStreetAddressLine + "</DnBStreetAddressLine>";
InpAsXML += "<DnBPrimaryTownName>" + Match.DnBPrimaryTownName + "</DnBPrimaryTownName>";
InpAsXML += "<DnBCountryISOAlpha2Code>" + Match.DnBCountryISOAlpha2Code + "</DnBCountryISOAlpha2Code>";
InpAsXML += "<DnBPostalCode>" + Match.DnBPostalCode + "</DnBPostalCode>";
InpAsXML += "<DnBPostalCodeExtensionCode>" + Match.DnBPostalCodeExtensionCode + "</DnBPostalCodeExtensionCode>";
InpAsXML += "<DnBTerritoryAbbreviatedName>" + Match.DnBTerritoryAbbreviatedName + "</DnBTerritoryAbbreviatedName>";
InpAsXML += "<DnBAddressUndeliverable>" + Match.DnBAddressUndeliverable + "</DnBAddressUndeliverable>";
InpAsXML += "<DnBTelephoneNumber>" + Match.DnBTelephoneNumber + "</DnBTelephoneNumber>";
InpAsXML += "<DnBOperatingStatus>" + Match.DnBOperatingStatus + "</DnBOperatingStatus>";
InpAsXML += "<DnBFamilyTreeMemberRole>" + Match.DnBFamilyTreeMemberRole + "</DnBFamilyTreeMemberRole>";
InpAsXML += "<DnBStandaloneOrganization>" + Match.DnBStandaloneOrganization + "</DnBStandaloneOrganization>";
InpAsXML += "<DnBConfidenceCode>" + Match.DnBConfidenceCode + "</DnBConfidenceCode>";
InpAsXML += "<DnBMatchGradeText>" + Match.DnBMatchGradeText + "</DnBMatchGradeText>";
InpAsXML += "<DnBMatchDataProfileText>" + Match.DnBMatchDataProfileText + "</DnBMatchDataProfileText>";
InpAsXML += "<DnBMatchDataProfileComponentCount>" + Match.DnBMatchDataProfileComponentCount + "</DnBMatchDataProfileComponentCount>";
InpAsXML += "<DnBDisplaySequence>" + Match.DnBDisplaySequence + "</DnBDisplaySequence>";
InpAsXML += "</Rec ></CreateMatch>";
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.StewCreateNewCompanyFromMatch";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = "@inp";
Regex badAmpersand = new Regex("&(?![a-zA-Z]{2,6};|#[0-9]{2,4};)");
string res = badAmpersand.Replace(InpAsXML, "&");
param._ParameterValue = res;
sproc.StoredProceduresParameter.Add(param);
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
internal String StewUndoOIMatch(int InputId, int MatchId)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewUndoMatch";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@InputId", InputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MatchId", MatchId.ToString(), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
return("");
}
catch (Exception ex)
{
//Put log to db here
return(ex.Message);
}
}
internal string AssignStewMatchRecord(int inputId, string OrbNum, int UserId)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewMatchRecord";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@InputId", inputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@OrbNum", OrbNum.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserId.ToString(), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
return(string.Empty);
}
catch (Exception ex)
{
//Put log to db here
return(ex.Message);
}
}
internal OIlstMatchDetails GetCompanyMatchDetails(int InputId, int UserId, bool ApplyFilter, string MatchIds = null)
{
OIlstMatchDetails oIlstMatchDetails = new OIlstMatchDetails();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewGetCompanyMatchDetails";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@InputId", InputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MatchIds", string.IsNullOrEmpty(MatchIds) ? null : MatchIds.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ApplyFilter", ApplyFilter.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserId.ToString(), SQLServerDatatype.IntDataType));
DataSet ds;
ds = sql.ExecuteDataSet(CommandType.StoredProcedure, sproc, "", DBIntent.ReadWrite.ToString());
if (ds != null)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)
{
OICompanyAdapter ta = new OICompanyAdapter();
foreach (DataRow rw in ds.Tables[0].Rows)
{
oIlstMatchDetails.lstOICompanyInput = ta.AdaptItem(rw);
}
}
if (ds.Tables[1] != null && ds.Tables[1].Rows != null && ds.Tables[1].Rows.Count > 0)
{
oIlstMatchDetails.lstOISearchMatch = new OICompanyAdapter().SearchMatchAdapt(ds.Tables[1]);
}
if (ds.Tables[2] != null && ds.Tables[2].Rows != null && ds.Tables[2].Rows.Count > 0)
{
oIlstMatchDetails.lstOIMatchDetail = new OICompanyAdapter().OICompanyMatchDetailsAdapt(ds.Tables[2]);
}
}
return(oIlstMatchDetails);
}
catch (Exception)
{
//Put log to db here
throw;
}
}
internal LstOIMatchCompany GetOICompanyList(int UserID, bool IncludeWithCandidates, bool IncludeWithoutCandidates, int PgaeIndex, int PageSize, out int TotalCount)
{
TotalCount = 0;
LstOIMatchCompany lstOICompany = new LstOIMatchCompany();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewGetCompanyListPaging";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserID.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IncludeWithCandidates", IncludeWithCandidates.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IncludeWithoutCandidates", IncludeWithoutCandidates.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PageSize", PageSize.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PageNumber", PgaeIndex.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TotalRecords", TotalCount.ToString(), SQLServerDatatype.IntDataType, ParameterDirection.Output));
string outParam = "";
DataSet ds;
ds = sql.ExecuteDataSetWithOutputParam(CommandType.StoredProcedure, sproc, out outParam);
lstOICompany.lstOICompany = new List <OICompanyEntity>();
if (ds != null && ds.Tables.Count > 1)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
lstOICompany.lstOICompany = new OICompanyAdapter().Adapt(ds.Tables[0]);
TotalCount = Convert.ToInt32(outParam);
}
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
lstOICompany.Message = Convert.ToString(ds.Tables[1].Rows[0][0]);
}
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(lstOICompany);
}
internal string OIAddRecordAsNewCompanyFromMatch(string InputId, string OrbNumber, string SrcRecordId, string Tags, int UserId)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.AddRecordAsNewCompanyFromMatch";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@srcInputId", InputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@OrbNumber", OrbNumber.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", SrcRecordId.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tags", Tags.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserId.ToString(), SQLServerDatatype.IntDataType));
sql.ExecuteScalar(CommandType.StoredProcedure, sproc);
return(string.Empty);
}
catch (SqlException)
{
throw;
}
}
internal string GetNewSearch(int InputId, string MatchURL, string ResponseJSON)
{
string Message = string.Empty;
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewNewSearch";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@InputId", InputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MatchURL", MatchURL.ToString(), SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ResponseJSON", ResponseJSON.ToString(), SQLServerDatatype.NvarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
return(Message);
}
catch (Exception ex)
{
return(ex.Message);
//Put log to db here
}
}
internal OIlstMatchMetaDetails GetStewOIMatchMetadata(int inputId, string OrbNum)
{
OIlstMatchMetaDetails oIlstMatchDetails = new OIlstMatchMetaDetails();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.StewGetMatchMetadata";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
sproc.StoredProceduresParameter.Add(GetParam("@InputId", inputId.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@OrbNum", OrbNum.ToString(), SQLServerDatatype.VarcharDataType));
DataSet ds;
ds = sql.ExecuteDataSet(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (ds != null)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)
{
OICompanyAdapter ta = new OICompanyAdapter();
foreach (DataRow rw in ds.Tables[0].Rows)
{
oIlstMatchDetails.lstOICompanyInput = ta.AdaptItem(rw);
}
}
if (ds.Tables[1] != null && ds.Tables[1].Rows != null && ds.Tables[1].Rows.Count > 0)
{
oIlstMatchDetails.lstMatchQualityMetadatas = new OICompanyAdapter().SearchMatchMetaDataAdapt(ds.Tables[1]);
}
if (ds.Tables[2] != null && ds.Tables[2].Rows != null && ds.Tables[2].Rows.Count > 0)
{
oIlstMatchDetails.lstMatchMetaDatas = new OICompanyAdapter().MatchMetaDataDetailAdapt(ds.Tables[2]);
}
}
return(oIlstMatchDetails);
}
catch (Exception)
{
//Put log to db here
throw;
}
}
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;
}
}