public void UpdateConferenceStartTime(int id, DateTime conferenceStartTime) { try { using (var _dbContext = new TwilloDbContext()) { var found = _dbContext.TwilioConferenceCalls.Find(id); found.ConferenceStartTime = conferenceStartTime; _dbContext.SaveChanges(); } } catch (Exception ex) { ErrorMessage(string.Format( "|Error Message - {0}" + "| 1.Source {1} " + "| 2.Trace {2} " + "| 3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); throw; } }
public void UpdateConference(int id, string Call2Sid, SystemStatus systemStatus) { try { //SystemStatus sysStat = (SystemStatus)systemStatus; using (var _dbContext = new TwilloDbContext()) { var found = _dbContext.TwilioConferenceCalls.Find(id); if (found != null) { if (found.PhoneCall2SID == null) { found.PhoneCall2SID = Call2Sid; } if (found.SystemStatus != SystemStatus.CONFERENCE_COMPLETED) { found.SystemStatus = systemStatus; } } _dbContext.SaveChanges(); } } catch (Exception ex) { ErrorMessage(string.Format("|Error Message - {0}| 1.Source {1} | 2.Trace {2} |3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); throw; } }
public void ErrorMessage(string message, int id = 0) { using (var _dbContext = new TwilloDbContext()) { _dbContext.LogMessages.Add(new LogMessage() { LogTime = DateTime.Now, ConferenceRecordId = id, Message = message }); _dbContext.SaveChanges(); } }
public void LogMessage(string message, int seq = 0, int id = 0) { //if (!Logging_enabled) return; using (var _dbContext = new TwilloDbContext()) { _dbContext.LogMessages.Add(new LogMessage() { LogTime = DateTime.Now, ConferenceRecordId = id, Seq = seq, Message = message }); _dbContext.SaveChanges(); } }
public void UpdateConference(TwilioConferenceCall conference) { try { using (var _dbContext = new TwilloDbContext()) { var found = _dbContext.TwilioConferenceCalls.Find(conference.Id); found.ConferenceSID = conference.ConferenceSID; found.SystemStatus = SystemStatus.CONFERENCE_IN_PROGRESS; _dbContext.SaveChanges(); } } catch (Exception ex) { ErrorMessage(string.Format("|Error Message - {0}| 1.Source {1} | 2.Trace {2} |3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); throw; } }
public void UpdateSystemStatus(int id, SystemStatus status) { try { using (var _dbContext = new TwilloDbContext()) { var found = _dbContext.TwilioConferenceCalls.Find(id); found.SystemStatus = status; _dbContext.SaveChanges(); } } catch (Exception ex) { ErrorMessage(string.Format("|Error Message - {0}| 1.Source {1} | 2.Trace {2} |3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); throw; } }
public void UpdateActiveStatus(int id, bool v) { try { using (var _dbContext = new TwilloDbContext()) { var found = _dbContext.TwilioConferenceCalls.Find(id); if (found != null) { found.CallIsActive = v; found.SystemStatus = SystemStatus.CONFERENCE_COMPLETED; } _dbContext.SaveChanges(); } } catch (Exception ex) { ErrorMessage(string.Format("|Error Message - {0}| 1.Source {1} | 2.Trace {2} |3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); } }
public TwilioConferenceCall CreateTwilioConferenceRecord(string phoneFrom, string phoneTo, string twilioPhoneNumber, string conferenceName, string phoneCall1Sid, double hangupIntervalinSeconds, double messageIntervalinSeconds, double warningIntervalInSeconds, DateTime callStartTime) { using (var _dbContext = new TwilloDbContext()) { TwilioConferenceCall callRecord = new TwilioConferenceCall(); try { callRecord.PhoneFrom = phoneFrom; callRecord.CallStartTime = callStartTime; callRecord.PhoneTo = phoneTo; callRecord.TwilioPhoneNumber = twilioPhoneNumber; callRecord.ConferenceName = conferenceName; callRecord.PhoneCall1SID = phoneCall1Sid; callRecord.CallIsActive = true; callRecord.hangupIntervalInSeconds = hangupIntervalinSeconds; callRecord.messageIntervalInSeconds = messageIntervalinSeconds; callRecord.warningIntervalInSeconds = warningIntervalInSeconds; callRecord.SystemStatus = SystemStatus.RECORD_CREATED; _dbContext.TwilioConferenceCalls.Add(callRecord); _dbContext.SaveChanges(); } catch (Exception ex) { ErrorMessage(string.Format("|Error Message - {0}| 1.Source {1} | 2.Trace {2} |3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); throw; } return(callRecord); } }
public string updateStatus(Int16 requiredStatus, string twilioPhoneNumber) { var retVal = string.Empty; try { using (var context = new TwilloDbContext()) { var user = context .User .Where(u => u.Service_User_Twilio_Phone_Number == twilioPhoneNumber.ToString().Substring(2)).FirstOrDefault(); switch (Convert.ToBoolean(requiredStatus)) { case true: { if ((user.AvailableStatus) == true) { retVal = "Status is already Available"; } // Do nothing else { user.AvailableStatus = true; context.SaveChanges(); retVal = "Status is now set to Available"; } } break; case false: { if ((user.AvailableStatus) == false) { retVal = "Status is already Not Available"; } // Do nothing else { user.AvailableStatus = false; context.SaveChanges(); retVal = "Status is now set to Not Available"; } } break; default: break; } } } catch (Exception ex) { ErrorMessage(string.Format("|Error Message - {0}| 1.Source {1} | 2.Trace {2} |3.Inner Exception {3} |", ex.Message, ex.Source, ex.StackTrace, ex.InnerException)); throw; } return(retVal); }