private void IdentifyBreakerOperations(AdoDataConnection connection, FileGroup fileGroup, DataGroup dataGroup, VIDataGroup viDataGroup, VICycleDataGroup viCycleDataGroup)
{
TableOperations <Event> eventTable = new TableOperations <Event>(connection);
TableOperations <BreakerChannel> breakerChannelTable = new TableOperations <BreakerChannel>(connection);
TableOperations <BreakerOperation> breakerOperationTable = new TableOperations <BreakerOperation>(connection);
List <int> channelIDs = dataGroup.DataSeries
.Select(dataSeries => dataSeries.SeriesInfo.ChannelID)
.Distinct()
.ToList();
if (channelIDs.Count == 0)
{
return;
}
List <string> breakerNumbers = breakerChannelTable
.QueryRecordsWhere($"ChannelID IN ({string.Join(",", channelIDs)})")
.Select(breakerChannel => breakerChannel.BreakerNumber)
.Distinct()
.ToList();
// If the breaker currents are defined for breaker-and-a-half or ring bus configurations,
// skip this data group so that timing is only applied to the breaker currents
if (breakerNumbers.Count > 1 && breakerNumbers.Any(num => m_breakerCurrents.Contains(num)))
{
return;
}
Event evt = eventTable.GetEvent(fileGroup, dataGroup);
if ((object)evt == null)
{
return;
}
foreach (string breakerNumber in breakerNumbers)
{
double breakerSpeed = connection.ExecuteScalar(double.NaN, "SELECT Speed FROM Breaker WHERE AssetKey = {0}", breakerNumber.TrimStart('0'));
Func <DataSeries, bool> digitalFilter = dataSeries =>
{
int channelID = dataSeries.SeriesInfo.ChannelID;
RecordRestriction recordRestriction =
new RecordRestriction("ChannelID = {0}", channelID) &
new RecordRestriction("BreakerNumber = {0}", breakerNumber);
int breakerChannelCount = breakerChannelTable.QueryRecordCount(recordRestriction);
return(breakerChannelCount > 0);
};
List <DataSeries> breakerDigitals = dataGroup.DataSeries
.Where(dataSeries => dataSeries.SeriesInfo.Channel.MeasurementType.Name == "Digital")
.Where(digitalFilter)
.ToList();
List <DataSeries> tripCoilEnergizedChannels = breakerDigitals
.Where(dataSeries => dataSeries.SeriesInfo.Channel.MeasurementCharacteristic.Name == "TCE")
.ToList();
DataSeries breakerStatusChannel = breakerDigitals
.FirstOrDefault(dataSeries => dataSeries.SeriesInfo.Channel.MeasurementCharacteristic.Name == "BreakerStatus");
List <XValue> tripCoilEnergizedTriggers = Range <XValue> .MergeAllOverlapping(tripCoilEnergizedChannels.SelectMany(FindTCERanges))
.Select(range => range.Start)
.ToList();
foreach (XValue tripCoilEnergizedTrigger in tripCoilEnergizedTriggers)
{
BreakerTiming breakerTiming = new BreakerTiming(tripCoilEnergizedTrigger, breakerStatusChannel, m_systemFrequency, breakerSpeed, m_breakerSettings.MinWaitBeforeReclose);
PhaseTiming aPhaseTiming = new PhaseTiming(viDataGroup.IA, viCycleDataGroup.IA, breakerTiming, m_breakerSettings, m_systemFrequency);
PhaseTiming bPhaseTiming = new PhaseTiming(viDataGroup.IB, viCycleDataGroup.IB, breakerTiming, m_breakerSettings, m_systemFrequency);
PhaseTiming cPhaseTiming = new PhaseTiming(viDataGroup.IC, viCycleDataGroup.IC, breakerTiming, m_breakerSettings, m_systemFrequency);
BreakerOperation breakerOperation = GetBreakerOperation(connection, evt.ID, breakerNumber, breakerTiming, aPhaseTiming, bPhaseTiming, cPhaseTiming);
breakerOperationTable.AddNewRecord(breakerOperation);
}
}
}
public Dictionary <string, dynamic> GetHeaderData()
{
Dictionary <string, string> query = Request.QueryParameters();
int eventId = int.Parse(query["eventId"]);
string breakerOperationID = (query.ContainsKey("breakeroperation") ? query["breakeroperation"] : "-1");
const string NextBackForSystem = "GetPreviousAndNextEventIdsForSystem";
const string NextBackForStation = "GetPreviousAndNextEventIdsForMeterLocation";
const string NextBackForMeter = "GetPreviousAndNextEventIdsForMeter";
const string NextBackForLine = "GetPreviousAndNextEventIdsForLine";
Dictionary <string, Tuple <EventView, EventView> > nextBackLookup = new Dictionary <string, Tuple <EventView, EventView> >()
{
{ NextBackForSystem, Tuple.Create((EventView)null, (EventView)null) },
{ NextBackForStation, Tuple.Create((EventView)null, (EventView)null) },
{ NextBackForMeter, Tuple.Create((EventView)null, (EventView)null) },
{ NextBackForLine, Tuple.Create((EventView)null, (EventView)null) }
};
Dictionary <string, dynamic> returnDict = new Dictionary <string, dynamic>();
EventView theEvent = m_dataContext.Table <EventView>().QueryRecordWhere("ID = {0}", eventId);
returnDict.Add("postedSystemFrequency", m_dataContext.Connection.ExecuteScalar <string>("SELECT Value FROM Setting WHERE Name = 'SystemFrequency'") ?? "60.0");
returnDict.Add("postedStationName", theEvent.StationName);
returnDict.Add("postedMeterId", theEvent.MeterID.ToString());
returnDict.Add("postedMeterName", theEvent.MeterName);
returnDict.Add("postedLineName", theEvent.LineName);
returnDict.Add("postedLineLength", theEvent.Length.ToString());
returnDict.Add("postedEventName", theEvent.EventTypeName);
returnDict.Add("postedEventDate", theEvent.StartTime.ToString("yyyy-MM-dd HH:mm:ss.fffffff"));
returnDict.Add("postedDate", theEvent.StartTime.ToShortDateString());
returnDict.Add("postedEventMilliseconds", theEvent.StartTime.Subtract(new DateTime(1970, 1, 1)).TotalMilliseconds.ToString());
returnDict.Add("xdaInstance", m_dataContext.Connection.ExecuteScalar <string>("SELECT Value FROM DashSettings WHERE Name = 'System.XDAInstance'"));
using (IDbCommand cmd = m_dataContext.Connection.Connection.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EventID", eventId));
cmd.CommandTimeout = 300;
foreach (string procedure in nextBackLookup.Keys.ToList())
{
EventView back = null;
EventView next = null;
int backID = -1;
int nextID = -1;
cmd.CommandText = procedure;
using (IDataReader rdr = cmd.ExecuteReader())
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
backID = rdr.GetInt32(0);
}
if (!rdr.IsDBNull(1))
{
nextID = rdr.GetInt32(1);
}
}
back = m_dataContext.Table <EventView>().QueryRecordWhere("ID = {0}", backID);
next = m_dataContext.Table <EventView>().QueryRecordWhere("ID = {0}", nextID);
nextBackLookup[procedure] = Tuple.Create(back, next);
}
}
returnDict.Add("nextBackLookup", nextBackLookup);
if (new List <string>()
{
"Fault", "RecloseIntoFault"
}.Contains(returnDict["postedEventName"]))
{
const string SagDepthQuery =
"SELECT TOP 1 " +
" (1 - PerUnitMagnitude) * 100 " +
"FROM " +
" FaultSummary JOIN " +
" Disturbance ON " +
" Disturbance.EventID = FaultSummary.EventID AND " +
" Disturbance.StartTime <= dbo.AdjustDateTime2(FaultSummary.Inception, FaultSummary.DurationSeconds) AND " +
" Disturbance.EndTime >= FaultSummary.Inception JOIN " +
" EventType ON " +
" Disturbance.EventTypeID = EventType.ID AND " +
" EventType.Name = 'Sag' JOIN " +
" Phase ON " +
" Disturbance.PhaseID = Phase.ID AND " +
" Phase.Name = 'Worst' " +
"WHERE FaultSummary.ID = {0} " +
"ORDER BY PerUnitMagnitude";
FaultSummary thesummary = m_dataContext.Table <FaultSummary>().QueryRecordsWhere("EventID = {0} AND IsSelectedAlgorithm = 1", theEvent.ID).OrderBy(row => row.IsSuppressed).ThenBy(row => row.Inception).FirstOrDefault();
double sagDepth = m_dataContext.Connection.ExecuteScalar <double>(SagDepthQuery, thesummary.ID);
if ((object)thesummary != null)
{
returnDict.Add("postedStartTime", thesummary.Inception.TimeOfDay.ToString());
returnDict.Add("postedPhase", thesummary.FaultType);
returnDict.Add("postedDurationPeriod", thesummary.DurationCycles.ToString("##.##", CultureInfo.InvariantCulture) + " cycles");
returnDict.Add("postedMagnitude", thesummary.CurrentMagnitude.ToString("####.#", CultureInfo.InvariantCulture) + " Amps (RMS)");
returnDict.Add("postedSagDepth", sagDepth.ToString("####.#", CultureInfo.InvariantCulture) + "%");
returnDict.Add("postedCalculationCycle", thesummary.CalculationCycle.ToString());
}
}
else if (new List <string>()
{
"Sag", "Swell"
}.Contains(returnDict["postedEventName"]))
{
openXDA.Model.Disturbance disturbance = m_dataContext.Table <openXDA.Model.Disturbance>().QueryRecordsWhere("EventID = {0}", theEvent.ID).Where(row => row.EventTypeID == theEvent.EventTypeID).OrderBy(row => row.StartTime).FirstOrDefault();
if ((object)disturbance != null)
{
returnDict.Add("postedStartTime", disturbance.StartTime.TimeOfDay.ToString());
returnDict.Add("postedPhase", m_dataContext.Table <Phase>().QueryRecordWhere("ID = {0}", disturbance.PhaseID).Name);
returnDict.Add("postedDurationPeriod", disturbance.DurationCycles.ToString("##.##", CultureInfo.InvariantCulture) + " cycles");
if (disturbance.PerUnitMagnitude != -1.0e308)
{
returnDict.Add("postedMagnitude", disturbance.PerUnitMagnitude.ToString("N3", CultureInfo.InvariantCulture) + " pu (RMS)");
}
}
}
if (breakerOperationID != "")
{
int id;
if (int.TryParse(breakerOperationID, out id))
{
BreakerOperation breakerRow = m_dataContext.Table <BreakerOperation>().QueryRecordWhere("ID = {0}", id);
if ((object)breakerRow != null)
{
returnDict.Add("postedBreakerNumber", breakerRow.BreakerNumber);
returnDict.Add("postedBreakerPhase", m_dataContext.Table <Phase>().QueryRecordWhere("ID = {0}", breakerRow.PhaseID).Name);
returnDict.Add("postedBreakerTiming", breakerRow.BreakerTiming.ToString());
returnDict.Add("postedBreakerSpeed", breakerRow.BreakerSpeed.ToString());
returnDict.Add("postedBreakerOperation", m_dataContext.Connection.ExecuteScalar("SELECT Name FROM BreakerOperationType WHERE ID = {0}", breakerRow.BreakerOperationTypeID).ToString());
}
}
}
return(returnDict);
}
