internal string InsertResearchInvestigation(iResearchEntityTargetedEntity objViewEntity) { string result = string.Empty; try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "[dnb].[iResearchInsertInvestigation]"; sproc.StoredProceduresParameter.Add(GetParam("@ResearchRequestId", objViewEntity.ResearchRequestId.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@RequestType", !string.IsNullOrEmpty(objViewEntity.ResearchRequestType) ? objViewEntity.ResearchRequestType : "", SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@UserId", objViewEntity.UserId.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@InputId", !string.IsNullOrEmpty(objViewEntity.InputId) ? objViewEntity.InputId : "", SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", !string.IsNullOrEmpty(objViewEntity.SrcRecordId) ? objViewEntity.SrcRecordId : "", SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@Tags", !string.IsNullOrEmpty(objViewEntity.Tags) ? objViewEntity.Tags : "", SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@RequestBody", !string.IsNullOrEmpty(objViewEntity.RequestBody) ? objViewEntity.RequestBody : "", SQLServerDatatype.NvarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@RequestResponseJSON", !string.IsNullOrEmpty(objViewEntity.RequestResponseJSON) ? objViewEntity.RequestResponseJSON : "", SQLServerDatatype.NvarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@DUNSNumber", !string.IsNullOrEmpty(objViewEntity.Duns) ? objViewEntity.Duns : null, SQLServerDatatype.VarcharDataType)); result = Convert.ToString(sql.ExecuteScalar(CommandType.StoredProcedure, sproc)); } catch (Exception ex) { return(result = ex.ToString()); } return(result); }
internal string InsertiResearchInvestigationFailedCalls(iResearchEntityTargetedEntity objViewEntity) { string result = string.Empty; try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "[dnb].[InsertiResearchInvestigationFailedCalls]"; sproc.StoredProceduresParameter.Add(GetParam("@UserId", objViewEntity.UserId.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@RequestBody", !string.IsNullOrEmpty(objViewEntity.RequestBody) ? objViewEntity.RequestBody : "", SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@ResponseJSON", !string.IsNullOrEmpty(objViewEntity.RequestResponseJSON) ? objViewEntity.RequestResponseJSON : "", SQLServerDatatype.VarcharDataType)); result = Convert.ToString(sql.ExecuteScalar(CommandType.StoredProcedure, sproc)); } catch (Exception) { return(result); } return(result); }
public string InsertiResearchInvestigationFailedCalls(iResearchEntityTargetedEntity obj) { return(rep.InsertiResearchInvestigationFailedCalls(obj)); }
public string InsertResearchInvestigation(iResearchEntityTargetedEntity obj) { return(rep.InsertResearchInvestigation(obj)); }