public async Task <ResponseModel> UpdateCallsStatus(CallStatusModel callStatus) { XmlSerializer xsSubmit = new XmlSerializer(callStatus.SelectedDevices.GetType()); string xml = ""; using (var sww = new StringWriter()) { using (XmlWriter writer = XmlWriter.Create(sww)) { xsSubmit.Serialize(writer, callStatus.SelectedDevices); xml = sww.ToString(); // Your XML } } //Remove the title element. xml = xml.Replace("<?xml version=\"1.0\" encoding=\"utf-16\"?>", ""); List <SqlParameter> sp = new List <SqlParameter>(); SqlParameter param = new SqlParameter("@Status", ToDBNull(callStatus.StatusId)); sp.Add(param); param = new SqlParameter("@AllocateXML", SqlDbType.Xml) { Value = xml }; sp.Add(param); param = new SqlParameter("@Reasion", ToDBNull(callStatus.RejectionReason)); sp.Add(param); param = new SqlParameter("@USER", ToDBNull(callStatus.UserId)); sp.Add(param); param = new SqlParameter("@CompId", ToDBNull(callStatus.CompId)); sp.Add(param); param = new SqlParameter("@REFKEY", ToDBNull(callStatus.RefKey)); sp.Add(param); var sql = "UpdateCallStatus @Status,@AllocateXML,@Reasion,@USER,@CompId,@REFKEY"; var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync(); if (res.ResponseCode == 0) { res.IsSuccess = true; } else { res.IsSuccess = false; } return(res); }
public IActionResult CallStatus() { CallStatusDataModel callStatusDataModel = new CallStatusDataModel(); callStatusDataModel.LineId = "1"; callStatusDataModel.RemotePartyName = "tel:1234"; callStatusDataModel.Type = "Outgoing"; callStatusDataModel.Protocol = "Sip"; callStatusDataModel.CallState = "Connected"; callStatusDataModel.RemotePartyNumber = "tel:1234"; callStatusDataModel.DurationInSeconds = "45"; CallStatusModel callStatusModel = new CallStatusModel(); callStatusModel.data = callStatusDataModel; callStatusModel.Status = "2000"; }
public async Task <ActionResult> CallStatus(CallStatusModel callStatus) { try { callStatus.UserId = CurrentUser.UserId; callStatus.RefKey = CurrentUser.RefKey; callStatus.CompId = CurrentUser.CompanyId; var response = await _centerRepo.UpdateCallsStatus(callStatus); TempData["response"] = response; return(Json("Ok", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var response = new ResponseModel { Response = ex.Message, IsSuccess = false }; TempData["response"] = response; TempData.Keep("response"); return(Json("ex", JsonRequestBehavior.AllowGet)); } }