public JsonResult UpdateRecord(CallRecordRequest request)
{
rtn_data rtn = new rtn_data {
code = 1
};
if (string.IsNullOrEmpty(request.ObjectId))
{
rtn.code = 0;
rtn.message = "更新参数错误";
return(Json(rtn, JsonRequestBehavior.AllowGet));
}
if (!string.IsNullOrEmpty(request.QuestionTypeStr))
{
request.QuestionType = JsonConvert.DeserializeObject <List <QuestionType> >(request.QuestionTypeStr);
}
try
{
UpdateCallRecordInfo(request);
if (request.QuestionType != null && request.QuestionType.Any())
{
UpdateCallQuestionType(request.ObjectId, request.UniqueId, request.QuestionType);
}
}
catch (Exception ex)
{
rtn.code = 0;
rtn.message = ex.ToString();
}
return(Json(rtn, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveRecord(CallRecordRequest request)
{
rtn_data rtn = new rtn_data {
code = 1
};
var objectId = string.Empty;
try
{
if (!string.IsNullOrEmpty(request.QuestionTypeStr))
{
request.QuestionType = JsonConvert.DeserializeObject <List <QuestionType> >(request.QuestionTypeStr);
}
InsertCallRecord(request, ref objectId);
if (request.QuestionType != null && request.QuestionType.Any())
{
InsertCallQuestionType(objectId, request.UniqueId, request.QuestionType);
}
rtn.data = objectId;
}
catch (Exception ex)
{
rtn.code = 0;
rtn.message = ex.ToString();
}
return(Json(rtn, JsonRequestBehavior.AllowGet));
}
public ActionResult Question(CallRecordRequest request)
{
return(TwiML(response => response
.Say("The Magical 8 Ball Says")
.Say(Magic8BallAnswerizer3000.GetAnswer())
.Pause(1)
.GatherWhileSaying("Press Any Key To Ask Another Question. Or Pound to Exit.",
actionUrl: Url.Action("New"),
timeoutSeconds: 3)
.Say("Goodbye")
.Hangup()));
}
public async Task <IActionResult> Create(Guid userId, [FromForm] CallRecordRequest request, [Required] IFormFile file)
{
var callRecord = m_Mapper.Map <CallRecord>(request);
callRecord.OwnerId = userId;
var fileBytes = IOExtensions.StreamToBytes(file?.OpenReadStream());
var saveResult = await m_CallRecordManager.Instance.SaveFileAsync(callRecord, file?.FileName, fileBytes);
if (saveResult.IsSuccess)
{
callRecord.FileId = saveResult.Data;
await m_CallRecordManager.Instance.CreateAsync(callRecord);
}
return(Json(saveResult));
}
/// <summary>
/// 保存通话记录
/// </summary>
public int InsertCallRecord(CallRecordRequest request, ref string objectId)
{
if (request.CalledNumber.StartsWith("0") && request.CalledNumberType == "手机 Mobile Phone")
{
request.CalledNumber = request.CalledNumber.Substring(1);
}
//if (request.CalledNumberType == "座机")
//{
// request.CalledNumber = "0" + request.CalledNumber;
//}
var questiontypecount = request.QuestionType != null && request.QuestionType.Any() ? request.QuestionType.Count : 0;
var sql = @"insert into c_callrecords(objectid,applicationnumber,contractno,mianapplicantname,calledpartyname,calledpartytype,calledpartynumber,calledpartynumbertype,calledpartyidtype,calledpartyidnumber,callername,callerposition,remark,callduration,recordfilename,calltype,uniqueid,callercode,questiontypecount,recordcreatedtime) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}',{18},to_date('{19}','yyyy/mm/dd HH24:MI:SS')) ";
objectId = Guid.NewGuid().ToString();
sql = string.Format(sql, objectId, request.ApplicationNumber, request.ContractNo, request.MainApplicantName, request.CalledName, request.CalledType, request.CalledNumber, request.CalledNumberType, request.CalledIdType, request.CalledIdNumber, request.CallerName, request.CallerPosition, request.Remark, request.CallDuration, request.RecordFileName.ToUpper(), request.CallType, request.UniqueId, request.CallerCode, questiontypecount, request.RecordCreatedTime);
return(OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql));
}
public CallRecordResponse CallRecord(CallRecordRequest request)
{
CallRecordResponse res = new CallRecordResponse();
return(res);
}
/// <summary>
/// 编辑录音内容
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool UpdateCallRecordInfo(CallRecordRequest request)
{
if (string.IsNullOrEmpty(request.ObjectId))
{
return(false);
}
var sql = @"update c_callrecords set {0} where objectId='{1}'";
var updateSql = string.Empty;
if (!string.IsNullOrEmpty(request.CalledName))
{
updateSql += "calledpartyname='" + request.CalledName + "',";
}
if (!string.IsNullOrEmpty(request.CalledType))
{
updateSql += "calledpartytype='" + request.CalledType + "',";
}
if (!string.IsNullOrEmpty(request.CalledIdType))
{
updateSql += "calledpartyidtype='" + request.CalledIdType + "',";
}
if (!string.IsNullOrEmpty(request.CalledIdNumber))
{
updateSql += "calledpartyidnumber='" + request.CalledIdNumber + "',";
}
if (!string.IsNullOrEmpty(request.ContractNo))
{
updateSql += "contractno='" + request.ContractNo + "',";
}
if (!string.IsNullOrEmpty(request.CalledNumber))
{
updateSql += "calledpartynumber='" + request.CalledNumber + "',";
}
if (!string.IsNullOrEmpty(request.CalledNumberType))
{
updateSql += "calledpartynumbertype='" + request.CalledNumberType + "',";
}
if (!string.IsNullOrEmpty(request.CallerName))
{
updateSql += "callername='" + request.CallerName + "',";
}
if (!string.IsNullOrEmpty(request.CallerPosition))
{
updateSql += "callerposition='" + request.CallerPosition + "',";
}
if (!string.IsNullOrEmpty(request.Remark))
{
updateSql += "remark='" + request.Remark + "',";
}
if (request.CallDuration > 0)
{
updateSql += "callduration=" + request.CallDuration + ",";
}
var questiontypecount = request.QuestionType != null && request.QuestionType.Any() ? request.QuestionType.Count : 0;
updateSql += "questiontypecount=" + questiontypecount + ",";
if (string.IsNullOrEmpty(updateSql))
{
return(false);
}
updateSql = updateSql.Substring(0, updateSql.Length - 1);
sql = string.Format(sql, updateSql, request.ObjectId);
return(OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql) > 0 ? true : false);
}