private void CallsIvrStat(object sender)
{
var model = new SelectPeriodDialogViewModel();
model.FromDate = DateTime.Today.AddDays(-7);
model.ToDate = DateTime.Today;
var view = new SelectPeriodDialog();
view.Owner = Application.Current.MainWindow;
model.SetView(view);
view.DataContext = model;
if (view.ShowDialog() ?? false)
{
try
{
var saveDialog = new SaveFileDialog();
saveDialog.AddExtension = true;
saveDialog.DefaultExt = ".xml";
saveDialog.Filter = "XML ‘айл|*.xml";
if (saveDialog.ShowDialog() == true)
{
List <StatIvrCallListDto> results;
using (var con = new MySqlConnection(AppSettings.ConnectionString))
{
_requestService = new RequestService(AppSettings.DbConnection);
results = _requestService.GetIvrStatCalls(model.FromDate.Date,
model.ToDate.Date.AddDays(1).AddSeconds(-1)).ToList();
}
var fileName = saveDialog.FileName;
XElement root = new XElement("Records");
foreach (var record in results)
{
root.AddFirst(
new XElement("Record",
new[]
{
new XElement("ID", record.LinkedId),
new XElement("Ќомер", record.CallerIdNum),
new XElement("¬х«вонок", record.InCreateTime.ToString("dd.MM.yyyy HH:mm")),
new XElement("ќтветЌа¬х", record.InBridgedTime?.ToString("dd.MM.yyyy HH:mm")),
new XElement("ќкончан褬х", record.InEndTime.ToString("dd.MM.yyyy HH:mm")),
new XElement("¬нутреннийЌомер", record.Phone),
new XElement("ќтвет", record.Result),
new XElement("«вонок¬нут", record.CreateTime.ToString("dd.MM.yyyy HH:mm")),
new XElement("ќтвет¬нут", record.BridgedTime?.ToString("dd.MM.yyyy HH:mm")),
new XElement("ќкончан褬нут", record.EndTime.ToString("dd.MM.yyyy HH:mm")),
new XElement("ќжидание", record.ClientWaitSec),
new XElement("¬ре줫вонка", record.CallDuration),
new XElement("¬рем¤–азговора", record.TalkDuration),
}));
}
var saver = new FileStream(fileName, FileMode.Create);
root.Save(saver);
saver.Close();
MessageBox.Show("ƒанные сохранены в файл\r\n" + fileName);
}
}
catch (Exception exc)
{
MessageBox.Show("ѕроизошла ошибка:\r\n" + exc.Message);
}
}
}
private void CallsStat(object sender)
{
var model = new SelectPeriodDialogViewModel();
model.FromDate = DateTime.Today.AddDays(-7);
model.ToDate = DateTime.Today;
var view = new SelectPeriodDialog();
view.Owner = Application.Current.MainWindow;
model.SetView(view);
view.DataContext = model;
if (view.ShowDialog() ?? false)
{
try
{
var saveDialog = new SaveFileDialog();
saveDialog.AddExtension = true;
saveDialog.DefaultExt = ".xml";
saveDialog.Filter = "XML ‘айл|*.xml";
if (saveDialog.ShowDialog() == true)
{
List <StatCallListDto> results;
using (var con = new MySqlConnection(AppSettings.ConnectionString))
{
_requestService = new RequestService(AppSettings.DbConnection);
results = _requestService.GetStatCalls(model.FromDate.Date,
model.ToDate.Date.AddDays(1).AddSeconds(-1)).ToList();
}
var fileName = saveDialog.FileName;
XElement root = new XElement("Records");
foreach (var record in results)
{
root.AddFirst(
new XElement("Record",
new[]
{
new XElement("Ќаправление", record.Direction),
new XElement("Exten", record.Exten),
new XElement("” ", record.ServiceCompany),
new XElement("Ќомер", record.PhoneNum),
new XElement("ƒата«вонка", record.CreateDate),
new XElement("¬ре줫вонка", record.CreateTime),
new XElement("ƒатаќтвета", record.BridgeDate),
new XElement("¬рем¤ќтвета", record.BridgeTime),
new XElement("ƒатаќкончани¤", record.EndDate),
new XElement("¬рем¤ќкончани¤", record.EndTime),
new XElement("ќжидание", record.WaitSec),
new XElement("ѕродолжительность", record.CallTime),
new XElement("ќператор", record.Fio)
}));
}
var saver = new FileStream(fileName, FileMode.Create);
root.Save(saver);
saver.Close();
MessageBox.Show("ƒанные сохранены в файл\r\n" + fileName);
}
}
catch (Exception exc)
{
MessageBox.Show("ѕроизошла ошибка:\r\n" + exc.Message);
}
}
}