void SaveOutputStreamDevicePhasor(OutputStreamDevicePhasor outputStreamDevicePhasor, bool isNew)
{
SystemMessages sm;
try
{
string result = CommonFunctions.SaveOutputStreamDevicePhasor(null, outputStreamDevicePhasor, isNew);
sm = new SystemMessages(new Message()
{
UserMessage = result, SystemMessage = string.Empty, UserMessageType = MessageType.Success
},
ButtonType.OkOnly);
GetOutputStreamDevicePhasorList();
//ClearForm();
//make this newly added or updated item as default selected. So user can click initialize right away.
ListBoxOutputStreamDevicePhasorList.SelectedItem = ((List <OutputStreamDevicePhasor>)ListBoxOutputStreamDevicePhasorList.ItemsSource).Find(c => c.Label == outputStreamDevicePhasor.Label);
}
catch (Exception ex)
{
CommonFunctions.LogException(null, "WPF.SaveOutputStreamDevicePhasor", ex);
sm = new SystemMessages(new Message()
{
UserMessage = "Failed to Save Output Stream Device Phasor Information", SystemMessage = ex.Message, UserMessageType = MessageType.Error
},
ButtonType.OkOnly);
}
sm.Owner = Window.GetWindow(this);
sm.WindowStartupLocation = WindowStartupLocation.CenterOwner;
sm.ShowPopup();
}
void ButtonSave_Click(object sender, RoutedEventArgs e)
{
#if SILVERLIGHT
Storyboard sb = new Storyboard();
sb = Application.Current.Resources["ButtonPressAnimation"] as Storyboard;
sb.Completed += new EventHandler(delegate(object obj, EventArgs es) { sb.Stop(); });
Storyboard.SetTarget(sb, ButtonSaveTransform);
sb.Begin();
#endif
if (IsValid())
{
OutputStreamDevicePhasor outputStreamDevicePhasor = new OutputStreamDevicePhasor();
App app = (App)Application.Current;
outputStreamDevicePhasor.NodeID = app.NodeValue;
outputStreamDevicePhasor.OutputStreamDeviceID = m_sourceOutputStreamDeviceID;
outputStreamDevicePhasor.Label = TextBoxLabel.Text.CleanText();
outputStreamDevicePhasor.Type = ((KeyValuePair <string, string>)ComboboxType.SelectedItem).Key;
outputStreamDevicePhasor.Phase = ((KeyValuePair <string, string>)ComboboxPhase.SelectedItem).Key;
outputStreamDevicePhasor.LoadOrder = TextBoxLoadOrder.Text.ToInteger();
outputStreamDevicePhasor.ScalingValue = TextBoxScalingValue.Text.ToInteger();
if (m_inEditMode == true && m_outputStreamDevicePhasorID > 0)
{
outputStreamDevicePhasor.ID = m_outputStreamDevicePhasorID;
SaveOutputStreamDevicePhasor(outputStreamDevicePhasor, false);
}
else
{
SaveOutputStreamDevicePhasor(outputStreamDevicePhasor, true);
}
}
}
void ListBoxOutputStreamDevicePhasorList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (ListBoxOutputStreamDevicePhasorList.SelectedIndex >= 0)
{
OutputStreamDevicePhasor selectedOutputStreamDevicePhasor = ListBoxOutputStreamDevicePhasorList.SelectedItem as OutputStreamDevicePhasor;
GridOutputStreamDevicePhasorDetail.DataContext = selectedOutputStreamDevicePhasor;
ComboboxPhase.SelectedItem = new KeyValuePair <string, string>(selectedOutputStreamDevicePhasor.Phase, selectedOutputStreamDevicePhasor.PhaseType);
ComboboxType.SelectedItem = new KeyValuePair <string, string>(selectedOutputStreamDevicePhasor.Type, selectedOutputStreamDevicePhasor.PhasorType);
m_inEditMode = true;
m_outputStreamDevicePhasorID = selectedOutputStreamDevicePhasor.ID;
ButtonSave.Tag = "Update";
}
}
public string SaveOutputStreamDevicePhasor(OutputStreamDevicePhasor outputStreamDevicePhasor, bool isNew)
{
try
{
return(CommonFunctions.SaveOutputStreamDevicePhasor(null, outputStreamDevicePhasor, isNew));
}
catch (Exception ex)
{
CommonFunctions.LogException(null, "Service.SaveOutputStreamDevicePhasor", ex);
CustomServiceFault fault = new CustomServiceFault()
{
UserMessage = "Failed to Save Output Stream Device Phasor Information", SystemMessage = ex.Message
};
throw new FaultException <CustomServiceFault>(fault);
}
}
void SaveOutputStreamDevicePhasor(OutputStreamDevicePhasor outputStreamDevicePhasor, bool isNew)
{
m_client.SaveOutputStreamDevicePhasorAsync(outputStreamDevicePhasor, isNew);
}
void SaveOutputStreamDevicePhasor(OutputStreamDevicePhasor outputStreamDevicePhasor, bool isNew)
{
m_client.SaveOutputStreamDevicePhasorAsync(outputStreamDevicePhasor, isNew);
}
static int Main()
{
int row = 0;
try
{
// Handle command line arguments
Arguments args = new Arguments(Environment.CommandLine, true);
bool skipFirstRow;
int successes = 0, failures = 0;
// First ordered argument is source CSV file name, it is required
if (args.Count < RequiredArgumentCount)
{
throw new ArgumentException($"Expected {RequiredArgumentCount:N0} argument, received {args.Count:N0}.");
}
// Check for switch based arguments
if (!args.TryGetValue("sourceApp", out string sourceApp)) // Source GPA application, defaults to "SIEGate"
{
sourceApp = DefaultSourceApp;
}
if (!args.TryGetValue("outputName", out string outputName)) // Target IEEE C37.118 output stream name, defaults to "IMPORTEDSTREAM"
{
outputName = DefaultOutputName;
}
if (args.TryGetValue("skipFirstRow", out string setting)) // Setting to skip first row of import file, default to true
{
skipFirstRow = setting.ParseBoolean();
}
else
{
skipFirstRow = true;
}
// Make sure output name is upper case, this is an acronym for the output adapter in the target system
outputName = outputName.ToUpperInvariant();
// Make provided files name are relative to run path if not other path was provided
string sourceFileName = FilePath.GetAbsolutePath(args["OrderedArg1"]);
#if DEBUG
string configFile = "C:\\Program Files\\openPDC\\openPDC.exe.config";
#else
string configFile = FilePath.GetAbsolutePath($"{sourceApp}.exe.config");
#endif
if (!File.Exists(configFile))
{
configFile = FilePath.GetAbsolutePath($"..\\{sourceApp}.exe.config");
// Fail if source config file cannot be found
if (!File.Exists(configFile))
{
throw new FileNotFoundException($"Config file for {sourceApp} application \"{configFile}\" was not found. Checked this folder and parent folder.");
}
}
// Load needed database settings from target config file
XDocument serviceConfig = XDocument.Load(configFile);
nodeID = Guid.Parse(serviceConfig
.Descendants("systemSettings")
.SelectMany(systemSettings => systemSettings.Elements("add"))
.Where(element => "NodeID".Equals((string)element.Attribute("name"), StringComparison.OrdinalIgnoreCase))
.Select(element => (string)element.Attribute("value"))
.FirstOrDefault());
string connectionString = serviceConfig
.Descendants("systemSettings")
.SelectMany(systemSettings => systemSettings.Elements("add"))
.Where(element => "ConnectionString".Equals((string)element.Attribute("name"), StringComparison.OrdinalIgnoreCase))
.Select(element => (string)element.Attribute("value"))
.FirstOrDefault();
string dataProviderString = serviceConfig
.Descendants("systemSettings")
.SelectMany(systemSettings => systemSettings.Elements("add"))
.Where(element => "DataProviderString".Equals((string)element.Attribute("name"), StringComparison.OrdinalIgnoreCase))
.Select(element => (string)element.Attribute("value"))
.FirstOrDefault();
// Open database schema and input CSV file
using (AdoDataConnection connection = new AdoDataConnection(connectionString, dataProviderString))
using (StreamReader reader = File.OpenText(sourceFileName))
{
// Configuration database tracks user changes for CIP reasons, use current user for ID
currentUserID = UserInfo.CurrentUserID ?? DefaultUserID;
// Setup database table operations for OutputStream table - this allows model, i.e., class instance representing record, based CRUD operations
TableOperations <OutputStream> outputStreamTable = new TableOperations <OutputStream>(connection);
// See if target output stream already exists
OutputStream outputStream = outputStreamTable.QueryRecordWhere("NodeID = {0} AND Acronym = {1}", nodeID, outputName);
if (outputStream == null)
{
// Setup a new output stream using default settings (user can adjust later as needed)
outputStream = new OutputStream
{
NodeID = nodeID,
Acronym = outputName,
Name = outputName,
ConnectionString = "RoundToNearestTimestamp=True; addPhaseLabelSuffix=false;",
DataChannel = "port=-1; clients=localhost:4712; interface=0.0.0.0",
AutoPublishConfigFrame = true,
AutoStartDataChannel = true,
NominalFrequency = 60,
FramesPerSecond = 30,
LagTime = 5.0D,
LeadTime = 5.0D,
AllowSortsByArrival = true,
TimeResolution = 330000,
AllowPreemptivePublishing = true,
PerformTimeReasonabilityCheck = true,
DownsamplingMethod = "LastReceived",
DataFormat = "FloatingPoint",
CoordinateFormat = "Polar",
CurrentScalingValue = 2423,
VoltageScalingValue = 2725785,
AnalogScalingValue = 1373291,
DigitalMaskValue = -65536,
Enabled = true,
CreatedOn = DateTime.UtcNow,
CreatedBy = currentUserID,
UpdatedOn = DateTime.UtcNow,
UpdatedBy = currentUserID
};
outputStreamTable.AddNewRecord(outputStream);
outputStream = outputStreamTable.QueryRecordWhere("NodeID = {0} AND Acronym = {1}", nodeID, outputName);
if (outputStream == null)
{
throw new InvalidOperationException($"Failed to lookup OutputStream record with Acronym of \"{outputName}\".");
}
}
else
{
// If record already exists, just track updates by user with timestamp
outputStream.UpdatedOn = DateTime.UtcNow;
outputStream.UpdatedBy = currentUserID;
outputStreamTable.UpdateRecord(outputStream);
}
// Setup database table operations for other needed tables
TableOperations <Device> deviceTable = new TableOperations <Device>(connection);
TableOperations <Measurement> measurementTable = new TableOperations <Measurement>(connection);
TableOperations <Phasor> phasorTable = new TableOperations <Phasor>(connection);
TableOperations <OutputStreamDevice> outputStreamDeviceTable = new TableOperations <OutputStreamDevice>(connection);
TableOperations <OutputStreamMeasurement> outputStreamMeasurementTable = new TableOperations <OutputStreamMeasurement>(connection);
TableOperations <OutputStreamDevicePhasor> outputStreamDevicePhasorTable = new TableOperations <OutputStreamDevicePhasor>(connection);
Device device = null;
OutputStreamDevice outputStreamDevice = null;
string line, lastDeviceName = null;
int deviceIndex = 0, phasorIndex = 0;
// Loop through each line in CSV input file
while ((line = reader.ReadLine()) != null)
{
row++;
if (skipFirstRow)
{
skipFirstRow = false;
continue;
}
string[] columns = line.Split(',');
if (columns.Length < 6)
{
Console.WriteLine($"Not enough columns in CSV file at row {row} - expected 6, encountered {columns.Length}, skipped row.");
continue;
}
// Read columns of data from current row
string sourceDeviceName = columns[0].ToUpperInvariant().Trim();
string destDeviceName = columns[1].ToUpperInvariant().Trim();
string sourcePhasorName = columns[2].ToUpperInvariant().Trim();
string destPhasorName = columns[3].ToUpperInvariant().Trim();
ushort idCode = ushort.Parse(columns[4].Trim());
string description = columns[5].Trim();
if (!sourceDeviceName.Equals(lastDeviceName, StringComparison.InvariantCultureIgnoreCase))
{
lastDeviceName = sourceDeviceName;
deviceIndex++;
phasorIndex = 0;
// Lookup existing source device
device = deviceTable.QueryRecordWhere("Acronym = {0}", sourceDeviceName);
if (device == null)
{
Console.WriteLine($"Failed to find source device \"{sourceDeviceName}\" - cannot create new output stream device for \"{destDeviceName}\".");
failures++;
continue;
}
Console.WriteLine($"Mapping source device \"{sourceDeviceName}\" to output stream device \"{destDeviceName}\"...");
// Setup a new output stream device
outputStreamDevice = outputStreamDeviceTable.QueryRecordWhere("NodeID = {0} AND AdapterID = {1} AND Acronym = {2}", nodeID, outputStream.ID, destDeviceName);
if (outputStreamDevice == null)
{
outputStreamDevice = new OutputStreamDevice
{
NodeID = nodeID,
AdapterID = outputStream.ID,
IDCode = idCode > 0 ? idCode : deviceIndex,
Acronym = destDeviceName,
Name = destDeviceName.ToTitleCase(),
Enabled = true,
CreatedOn = DateTime.UtcNow,
CreatedBy = currentUserID,
UpdatedOn = DateTime.UtcNow,
UpdatedBy = currentUserID
};
outputStreamDeviceTable.AddNewRecord(outputStreamDevice);
outputStreamDevice = outputStreamDeviceTable.QueryRecordWhere("NodeID = {0} AND AdapterID = {1} AND Acronym = {2}", nodeID, outputStream.ID, destDeviceName);
if (outputStreamDevice == null)
{
throw new InvalidOperationException($"Failed to lookup OutputStreamDevice record with Acronym of \"{destDeviceName}\".");
}
}
else
{
// TODO: Could augment existing record, current logic just skips existing to account for possible input file errors
outputStreamDevice.IDCode = idCode > 0 ? idCode : deviceIndex;
outputStreamDevice.UpdatedOn = DateTime.UtcNow;
outputStreamDevice.UpdatedBy = currentUserID;
outputStreamDeviceTable.UpdateRecord(outputStreamDevice);
}
// Validate base output stream measurements exist
foreach (string signalType in new[] { "SF", "FQ", "DF" }) // Status flags, frequency and dF/dT (delta frequency over delta time, i.e., rate of change of frequency)
{
AddOutputStreamMeasurement(measurementTable, outputStreamMeasurementTable, outputStream.ID, $"{device.Acronym}-{signalType}", $"{destDeviceName}-{signalType}");
}
}
if (device == null)
{
failures++;
continue;
}
// 123456789012345678901234567890
Console.WriteLine($" Adding phasors for \"{$"{destPhasorName} - {description}".TrimWithEllipsisEnd(70)}\"");
// Lookup existing device phasor record
Phasor phasor = phasorTable.QueryRecordWhere("DeviceID = {0} AND Label = {1}", device.ID, sourcePhasorName);
phasorIndex++;
if (phasor == null)
{
Console.WriteLine($"Failed to lookup Phasor record with Label of \"{sourcePhasorName}\"");
failures++;
}
else
{
// Setup a new output stream device phasor
OutputStreamDevicePhasor outputStreamDevicePhasor = outputStreamDevicePhasorTable.QueryRecordWhere("NodeID = {0} AND OutputStreamDeviceID = {1} AND Label = {2}", nodeID, outputStreamDevice.ID, destPhasorName);
if (outputStreamDevicePhasor == null)
{
outputStreamDevicePhasor = new OutputStreamDevicePhasor
{
NodeID = nodeID,
OutputStreamDeviceID = outputStreamDevice.ID,
Label = destPhasorName,
Type = phasor.Type,
Phase = phasor.Phase,
LoadOrder = phasorIndex,
CreatedOn = DateTime.UtcNow,
CreatedBy = currentUserID,
UpdatedOn = DateTime.UtcNow,
UpdatedBy = currentUserID
};
outputStreamDevicePhasorTable.AddNewRecord(outputStreamDevicePhasor);
outputStreamDevicePhasor = outputStreamDevicePhasorTable.QueryRecordWhere("NodeID = {0} AND OutputStreamDeviceID = {1} AND Label = {2}", nodeID, outputStreamDevice.ID, destPhasorName);
if (outputStreamDevicePhasor == null)
{
throw new InvalidOperationException($"Failed to lookup OutputStreamDevicePhasor record with Label of \"{destPhasorName}\".");
}
}
else
{
// TODO: Could augment existing record, current logic just skips existing to account for possible input file errors
outputStreamDevicePhasor.UpdatedOn = DateTime.UtcNow;
outputStreamDevicePhasor.UpdatedBy = currentUserID;
outputStreamDevicePhasorTable.UpdateRecord(outputStreamDevicePhasor);
}
// Define output stream phasor measurements
AddOutputStreamMeasurement(measurementTable, outputStreamMeasurementTable, outputStream.ID, $"{device.Acronym}-PA{phasor.SourceIndex}", $"{destDeviceName}-PA{phasorIndex}");
AddOutputStreamMeasurement(measurementTable, outputStreamMeasurementTable, outputStream.ID, $"{device.Acronym}-PM{phasor.SourceIndex}", $"{destDeviceName}-PM{phasorIndex}");
successes++;
}
}
}
Console.WriteLine();
Console.WriteLine($"{successes:N0} successful phasor imports.");
Console.WriteLine($"{failures:N0} failed phasor imports.");
#if DEBUG
Console.ReadKey();
#endif
return(0);
}
catch (Exception ex)
{
Console.WriteLine();
Console.WriteLine($"Import halted at row {row}!");
Console.Error.WriteLine($"Load Exception: {ex.Message}");
return(1);
}
}
