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;
            }
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        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);
        }
Exemplo n.º 4
0
        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);
        }
Exemplo n.º 5
0
        // 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);
        }
Exemplo n.º 6
0
        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);
        }
Exemplo n.º 7
0
        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);
        }
Exemplo n.º 8
0
        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);
        }
Exemplo n.º 10
0
 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;
     }
 }
Exemplo n.º 11
0
 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;
     }
 }
Exemplo n.º 12
0
 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;
     }
 }
Exemplo n.º 13
0
 // 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;
     }
 }
Exemplo n.º 14
0
        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, "&amp;");

            param._ParameterValue = res;
            sproc.StoredProceduresParameter.Add(param);

            sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
        }
Exemplo n.º 15
0
 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);
     }
 }
Exemplo n.º 16
0
 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);
     }
 }
Exemplo n.º 17
0
        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;
            }
        }
Exemplo n.º 18
0
        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);
        }
Exemplo n.º 19
0
 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;
     }
 }
Exemplo n.º 20
0
        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
            }
        }
Exemplo n.º 21
0
        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;
            }
        }