internal List <IResearchInvestigationEntity> GetIResearchInvestigation() { List <IResearchInvestigationEntity> results = new List <IResearchInvestigationEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetiResearchInvestigation"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { IResearchInvestigationAdapter ta = new IResearchInvestigationAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.Adapt(dt); } } } catch (Exception) { throw; } return(results); }
internal IResearchInvestigationEntity iResearchInvestigationIsExists(string InputId, string SrcRecordId, string Duns) { IResearchInvestigationEntity results; try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "[dnb].[CheckiResearchInvestigated]"; sproc.StoredProceduresParameter.Add(GetParam("@InputId", InputId, SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", SrcRecordId, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@DUNSNumber", !string.IsNullOrEmpty(Duns) ? Duns : null, SQLServerDatatype.VarcharDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { IResearchInvestigationAdapter ta = new IResearchInvestigationAdapter(); results = ta.AdaptItem(dt.Rows[0], dt); return(results); } else { return(null); } } catch (Exception) { return(null); } }
internal List <IResearchInvestigationEntity> GetFilterIResearchInvestigation(string SrcRecordId, string Status, string RequestStartDateTime, string RequestendDateTime, string Keyword) { List <IResearchInvestigationEntity> results = new List <IResearchInvestigationEntity>(); List <IResearchInvestigationEntity> resultsFailed = new List <IResearchInvestigationEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetiResearchInvestigation"; sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", !string.IsNullOrEmpty(SrcRecordId) ? SrcRecordId : null, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@CaseStatus", !string.IsNullOrEmpty(Status) ? Status : null, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@RequestStartDateTime", !string.IsNullOrEmpty(RequestStartDateTime) ? RequestStartDateTime : null, SQLServerDatatype.DateTimeDataType)); sproc.StoredProceduresParameter.Add(GetParam("@RequestendDateTime", !string.IsNullOrEmpty(RequestendDateTime) ? Convert.ToDateTime(RequestendDateTime).Add(DateTime.MaxValue.TimeOfDay).ToString() : null, SQLServerDatatype.DateTimeDataType)); sproc.StoredProceduresParameter.Add(GetParam("@SearchKeyword", !string.IsNullOrEmpty(Keyword) ? Keyword.Trim() : null, SQLServerDatatype.NvarcharDataType)); DataSet ds; ds = sql.ExecuteDataSet(CommandType.StoredProcedure, sproc); if (ds != null) { IResearchInvestigationAdapter ta = new IResearchInvestigationAdapter(); if (ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow rw in ds.Tables[0].Rows) { results = ta.Adapt(ds.Tables[0]); } } if (ds.Tables.Count > 1 && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { foreach (DataRow rw in ds.Tables[1].Rows) { resultsFailed = ta.Adapt(ds.Tables[1]); } if (!string.IsNullOrEmpty(SrcRecordId)) { resultsFailed = resultsFailed.Where(x => x.RequestBodylst.customerTransactionID.ToLower() == SrcRecordId.ToLower()).ToList(); } resultsFailed.ForEach(x => { x.SrcRecordId = x.RequestBodylst.customerTransactionID; x.RequestType = x.RequestBodylst.researchRequestType; if (x.RequestBodylst.researchRequestType.ToLower() == "targeted") { x.ResolutionDUNS = x.RequestBodylst?.organization?.duns; } }); results.AddRange(resultsFailed); } } } catch (Exception) { throw; } return(results); }
internal List <DashboardV2GetInvestigationStatistics> GetDashboardV2GetInvestigationStatistics() { List <DashboardV2GetInvestigationStatistics> lstStats = new List <DashboardV2GetInvestigationStatistics>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "[dnb].[DashboardV2GetInvestigationStatistics]"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.ReadWrite.ToString()); IResearchInvestigationAdapter ta = new IResearchInvestigationAdapter(); lstStats = ta.AdaptInvestigationStatistics(dt); } catch (Exception) { throw; } return(lstStats); }
internal List <iResearchEntityTargetedEntity> GetDnBReferenceDataBycategoryID(int categoryID) { List <iResearchEntityTargetedEntity> results = new List <iResearchEntityTargetedEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetDnBReferenceDataBycategoryID"; sproc.StoredProceduresParameter.Add(GetParam("@categoryID", Convert.ToString(categoryID), SQLServerDatatype.IntDataType)); DataTable dt = new DataTable(); dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new IResearchInvestigationAdapter().AdaptItems(dt); } } catch (Exception) { throw; } return(results); }