private async void Window_Loaded_1(object sender, RoutedEventArgs e)
{
Trigger = await _context.DeviceValueTriggers
.Include(o => o.DeviceValue)
.Include(o => o.DeviceValue.Device)
.FirstOrDefaultAsync(o => o.Id == _deviceValueTriggerId) ??
new DeviceValueTrigger
{
Name = "New Trigger"
};
//EAGER LOAD
await _context.Devices
.Include(o => o.Values)
.ToListAsync();
await _context.Scenes.ToListAsync();
var deviceViewSource = ((CollectionViewSource)(FindResource("deviceViewSource")));
// Load data by setting the CollectionViewSource.Source property:
deviceViewSource.Source = _context.Devices.Local;
OperatorCmboBx.ItemsSource = Enum.GetValues(typeof(TriggerOperator));
OperatorCmboBx.SelectedIndex = 0;
//Set presets
if (Trigger != null && Trigger.DeviceValue != null)
{
if (Trigger.DeviceValue.Device != null)
{
DeviceCmboBx.SelectedItem = Trigger.DeviceValue.Device;
}
if (Trigger.DeviceValue != null)
{
ValueCmboBx.SelectedItem = Trigger.DeviceValue;
}
}
try
{
OperatorCmboBx.Text = Enum.GetName(typeof(TriggerOperator), Trigger.Operator);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
if (Trigger.Value != null)
{
ValueTxtBx.Text = Trigger.Value;
}
}
public override async Task <Result> ImportAsync(string fileName, CancellationToken cancellationToken)
{
var result = await ReadAsXmlFromDiskAsync <List <TriggerBackup> >(fileName);
if (result.HasError)
{
return(Result.ReportError(result.Message));
}
var skippedCount = 0;
var newTriggers = new List <DeviceValueTrigger>();
using (var context = new ZvsContext(EntityContextConnection))
{
var existingTriggers = await context.DeviceValueTriggers.ToListAsync(cancellationToken);
var existingDeviceValues = await context.DeviceValues
.Include(o => o.Device)
.ToListAsync(cancellationToken);
foreach (var backupTrigger in result.Data)
{
if (existingTriggers.Any(o => o.Name == backupTrigger.Name))
{
skippedCount++;
continue;
}
var dv = existingDeviceValues.FirstOrDefault(o => o.Device.NodeNumber == backupTrigger.NodeNumber &&
o.Name == backupTrigger.DeviceValueName);
var cmd =
await
StoredCmdBackup.RestoreStoredCommandAsync(context, backupTrigger.StoredCommand,
cancellationToken);
if (dv == null || cmd == null)
{
continue;
}
var dvTrigger = new DeviceValueTrigger
{
Name = backupTrigger.Name,
DeviceValue = dv,
IsEnabled = backupTrigger.isEnabled
};
dvTrigger.Name = backupTrigger.Name;
dvTrigger.Argument = cmd.Argument;
dvTrigger.Argument2 = cmd.Argument2;
dvTrigger.CommandId = cmd.CommandId;
if (backupTrigger.Operator != null)
{
dvTrigger.Operator = (TriggerOperator)backupTrigger.Operator;
}
dvTrigger.Value = backupTrigger.Value;
newTriggers.Add(dvTrigger);
}
context.DeviceValueTriggers.AddRange(newTriggers);
if (newTriggers.Count > 0)
{
var saveResult = await context.TrySaveChangesAsync(cancellationToken);
if (saveResult.HasError)
{
return(Result.ReportError(saveResult.Message));
}
foreach (var cmd in newTriggers)
{
cmd.SetDescription();
await cmd.SetTargetObjectNameAsync(context);
cmd.SetTriggerDescription();
}
var r = await context.TrySaveChangesAsync(cancellationToken);
if (r.HasError)
{
return(Result.ReportError(r.Message));
}
}
}
return
(Result.ReportSuccess(
$"Imported {newTriggers.Count} triggers, skipped {skippedCount} from {Path.GetFileName(fileName)}"));
}
