Lesson 3 exercise solutions

Exercise 1, print interpolated values

static void PrintInterpolated(AFDatabase database, string meterName,
string startTime, string endTime, TimeSpan timeSpan)
{
Console.WriteLine(string.Format("Print Interpolated Values - Meter: {0},
Start: {1}, End: {2}", meterName, startTime, endTime));

AFAttribute attr =
AFAttribute.FindAttribute(@"\Meters\" + meterName + @"|Energy Usage",
database);

AFTime start = new AFTime(startTime);
AFTime end = new AFTime(endTime);
AFTimeRange timeRange = new AFTimeRange(start, end);

AFTimeSpan interval = new AFTimeSpan(timeSpan);

AFValues vals = attr.Data.InterpolatedValues(
timeRange: timeRange,
interval: interval,
desiredUOM: null,
filterExpression: null,
includeFilteredValues: false);

foreach (AFValue val in vals)
{
Console.WriteLine("Timestamp (Local): {0},
Value: {1:0.00} {2}", val.Timestamp.LocalTime, val.Value,
val?.UOM.Abbreviation);
}
Console.WriteLine();
}

Exercise 2, print hourly average

static void PrintHourlyAverage(AFDatabase database, string meterName,
string startTime, string endTime)
{
Console.WriteLine(string.Format
("Print Hourly Average - Meter: {0}, Start: {1}, End: {2}", meterName,
startTime, endTime));

AFAttribute attr =
AFAttribute.FindAttribute(@"\Meters\" + meterName + @"|Energy Usage",
database);

AFTime start = new AFTime(startTime);
AFTime end = new AFTime(endTime);
AFTimeRange timeRange = new AFTimeRange(start, end);

IDictionary<AFSummaryTypes, AFValues> vals = attr.Data.Summaries(
timeRange: timeRange,
summaryDuration: new AFTimeSpan(TimeSpan.FromHours(1)),
summaryType: AFSummaryTypes.Average,
calcBasis: AFCalculationBasis.TimeWeighted,
timeType: AFTimestampCalculation.EarliestTime);


foreach (AFValue val in vals[AFSummaryTypes.Average])
{
Console.WriteLine("Timestamp (Local):
{0:yyyy-MM-dd HH\\h}, Value: {1:0.00} {2}", val.Timestamp.LocalTime,
val.Value,val?.UOM.Abbreviation);
}

Console.WriteLine();
}

Exercise 3, print energy usage

static void PrintEnergyUsageAtTime(AFDatabase database, string timeStamp)
{
Console.WriteLine("Print Energy Usage at Time: {0}", timeStamp);

AFAttributeList attrList = GetAttributes(database, "MeterBasic",
"Energy Usage");

AFTime time = new AFTime(timeStamp);

IList<AFValue> vals = attrList.Data.RecordedValue(time);
foreach (AFValue val in vals)
{
Console.WriteLine("Meter: {0},
Timestamp (Local): {1:yyyy-MM-dd HH\\h}, Value: {2:0.00} {3}",
val.Attribute.Element.Name,val.Timestamp.LocalTime,
val.Value,val?.UOM.Abbreviation);
}
Console.WriteLine();
}

Exercise 4, print daily average energy usage

static void PrintDailyAverageEnergyUsage(AFDatabase database,
string startTime, string endTime)
{
Console.WriteLine(string.Format("Print Daily Energy Usage - Start: {0},
End: {1}", startTime, endTime));

AFAttributeList attrList = GetAttributes(database,
"MeterBasic", "Energy Usage");

AFTime start = new AFTime(startTime);
AFTime end = new AFTime(endTime);
AFTimeRange timeRange = new AFTimeRange(start, end);

// Ask for 100 PI Points at a time
PIPagingConfiguration pagingConfig =
new PIPagingConfiguration(PIPageType.TagCount, 100);

IEnumerable<IDictionary<AFSummaryTypes, AFValues>> summaries =
attrList.Data.Summaries(
timeRange: timeRange,
summaryDuration: new AFTimeSpan(TimeSpan.FromDays(1)),
summaryTypes: AFSummaryTypes.Average,
calculationBasis: AFCalculationBasis.TimeWeighted,
timeType: AFTimestampCalculation.EarliestTime,
pagingConfig: pagingConfig);

// Loop through attributes
foreach (IDictionary<AFSummaryTypes, AFValues> dict in summaries)
{
AFValues values = dict[AFSummaryTypes.Average];
Console.WriteLine("Averages for Meter: {0}",
values.Attribute.Element.Name);

// Loop through values per attribute
foreach (AFValue val in dict[AFSummaryTypes.Average])
{
Console.WriteLine("Timestamp (Local): {0:yyyy-MM-dd},
Avg. Value: {1:0.00} {2}",
val.Timestamp.LocalTime,val.Value,val?.UOM.Abbreviation);
}
Console.WriteLine();

}
Console.WriteLine();
}

Exercise 5, swap values

static void SwapValues(AFDatabase database, string meter1, string meter2,
string startTime, string endTime)
{
Console.WriteLine
(string.Format("Swap values for meters: {0}, {1} between {2} and {3}",
meter1, meter2, startTime, endTime));

// NOTE: This method does not ensure that there is no data loss
// if there is failure.
// Persist the data first in case you need to rollback.

AFAttribute attr1 = AFAttribute.FindAttribute(@"\Meters\" +
meter1 + @"|Energy Usage", database);
AFAttribute attr2 = AFAttribute.FindAttribute(@"\Meters\" +
meter2 + @"|Energy Usage", database);

AFTime start = new AFTime(startTime);
AFTime end = new AFTime(endTime);
AFTimeRange timeRange = new AFTimeRange(start, end);

// Get values to delete for meter1
AFValues valsToRemove1 = attr1.Data.RecordedValues(
timeRange: timeRange,
boundaryType: AFBoundaryType.Inside,
desiredUOM: null,
filterExpression: null,
includeFilteredValues: false);

// Get values to delete for meter2
AFValues valsToRemove2 = attr2.Data.RecordedValues(
timeRange: timeRange,
boundaryType: AFBoundaryType.Inside,
desiredUOM: null,
filterExpression: null,
includeFilteredValues: false);

List<AFValue> valsToRemove = valsToRemove1.ToList();
valsToRemove.AddRange(valsToRemove2.ToList());

// Remove the values
AFListData.UpdateValues(valsToRemove, AFUpdateOption.Remove);

// Create new AFValues from the other meter and assign them to this meter
List<AFValue> valsToAdd1 = valsToRemove2.Select(v => new AFValue(attr1,
v.Value, v.Timestamp)).ToList();
List<AFValue> valsToAdd2 = valsToRemove1.Select(v => new AFValue(attr2,
v.Value, v.Timestamp)).ToList();

List<AFValue> valsCombined = valsToAdd1;
valsCombined.AddRange(valsToAdd2);

AFListData.UpdateValues(valsCombined, AFUpdateOption.Insert);
Console.WriteLine();
}