public void RefreshList()
{
using (
var cmd =
new MySqlCommand(@"SELECT UniqueId,CallDirection,CallerIDNum,CreateTime,AnswerTime,EndTime,BridgedTime,MonitorFile,TalkTime,WaitingTime FROM asterisk.CallsHistory C
where CreateTime between @fromdate and @todate order by UniqueId", AppSettings.DbConnection))
{
cmd.Parameters.AddWithValue("@fromdate", FromDate);
cmd.Parameters.AddWithValue("@todate", ToDate);
using (var dataReader = cmd.ExecuteReader())
{
CallsList.Clear();
while (dataReader.Read())
{
CallsList.Add(new CallsListDto
{
UniqueId = dataReader.GetNullableString("UniqueID"),
CallerId = dataReader.GetNullableString("CallerIDNum"),
Direction = dataReader.GetNullableString("CallDirection"),
AnswerTime = dataReader.GetNullableDateTime("AnswerTime"),
CreateTime = dataReader.GetNullableDateTime("CreateTime"),
BridgedTime = dataReader.GetNullableDateTime("BridgedTime"),
EndTime = dataReader.GetNullableDateTime("EndTime"),
TalkTime = dataReader.GetNullableInt("TalkTime"),
WaitingTime = dataReader.GetNullableInt("WaitingTime"),
MonitorFileName = dataReader.GetNullableString("MonitorFile"),
});
}
dataReader.Close();
CallsCount = CallsList.Count;
}
}
}
private void AddNewCallEvent(VATRPCallEvent callEvent)
{
try
{
var dn = callEvent.RemoteParty;
var callItem = new RecentsCallItem()
{
CallerName = dn,
CallTime = callEvent.StartTime,
Duration = callEvent.Status == VATRPHistoryEvent.StatusType.Missed ? -1 : callEvent.Duration,
TargetNumber = callEvent.RemoteParty,
CallStatus = callEvent.Status,
ContactId = callEvent.Contact != null ? callEvent.Contact.DisplayName : String.Empty
};
if (callEvent.Status == VATRPHistoryEvent.StatusType.Missed)
{
MissedCallsList.Add(callItem);
}
CallsList.Add(callItem);
}
catch (Exception ex)
{
ServiceManager.LogError("AddNewCallEvent", ex);
}
}
private void LoadAllCalls()
{
CallsList.Clear();
var callsItemDB = from VATRPCallEvent call in _historyService.AllCallsEvents
orderby call.StartTime descending
select call;
foreach (var avCall in callsItemDB.Take(30))
{
try
{
var dn = avCall.RemoteParty;
var callItem = new RecentsCallItem()
{
CallerName = dn,
CallTime = avCall.StartTime,
Duration = avCall.Status == VATRPHistoryEvent.StatusType.Missed ? -1 : avCall.Duration,
TargetNumber = avCall.RemoteParty,
CallStatus = avCall.Status,
ContactId = avCall.Contact != null ? avCall.Contact.DisplayName : string.Empty
};
CallsList.Add(callItem);
}
catch (Exception ex)
{
LOG.Error("Exception on LoadAllCalls: " + ex.Message);
}
}
}
public void AddCall(string GetMethod, object Params = null)
{
CallsList.Add(new object[] { GetMethod, typeof(TType), Params, CT, typeof(List <TType>) });
}