Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
 public string InsertiResearchInvestigationFailedCalls(iResearchEntityTargetedEntity obj)
 {
     return(rep.InsertiResearchInvestigationFailedCalls(obj));
 }
Пример #4
0
 public string InsertResearchInvestigation(iResearchEntityTargetedEntity obj)
 {
     return(rep.InsertResearchInvestigation(obj));
 }