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));
}