public static List <RCCFLib.Records.RecordingSet> GetRecordingSetSeriesFrom(int recordingSetId, DateTime fromDateTime)
{
LinqObjectsDataContext dataContext = new LinqObjectsDataContext();
var recordingSets = dataContext.RecordingSets.Where(p => p.RecordingSetId == recordingSetId);
List <RCCFLib.Records.RecordingSet> allRecordingSets = new List <RCCFLib.Records.RecordingSet>();
foreach (RecordingSet thisRecordingSet in recordingSets)
{
RCCFLib.Records.RecordingSet newRecordingSet = new RCCFLib.Records.RecordingSet();
newRecordingSet.RecordingSetDateTime = thisRecordingSet.RecordingSetDateTime;
newRecordingSet.RecordingSetId = thisRecordingSet.RecordingSetId;
var recordings = dataContext.Recordings.Where(p => p.RecordingSetId == recordingSetId);
newRecordingSet.Recordings = new List <RCCFLib.Records.Recording>();
foreach (Recording thisRecording in recordings)
{
RCCFLib.Records.Recording newRecording = new RCCFLib.Records.Recording();
newRecording.Type = (Records.ValueType)thisRecording.Type;
switch ((Records.ValueType)thisRecording.Type)
{
case Records.ValueType.DateTime:
newRecording.Value = thisRecording.DateTimeValue;
break;
case Records.ValueType.Float:
newRecording.Value = thisRecording.FloatValue;
break;
case Records.ValueType.Integer:
newRecording.Value = thisRecording.IntValue;
break;
case Records.ValueType.String:
newRecording.Value = thisRecording.StringValue;
break;
default:
break;
}
newRecordingSet.Recordings.Add(newRecording);
}
}
return(allRecordingSets);
}
public static RCCFLib.Records.RecordingSet GetLatestReading(int recordingSetId)
{
LinqObjectsDataContext dataContext = new LinqObjectsDataContext();
var recordingSet = dataContext.RecordingSets.FirstOrDefault(p => p.RecordingSetId == recordingSetId);
RCCFLib.Records.RecordingSet newRecordingSet = new RCCFLib.Records.RecordingSet();
newRecordingSet.RecordingSetDateTime = recordingSet.RecordingSetDateTime;
newRecordingSet.RecordingSetId = recordingSet.RecordingSetId;
var recordings = dataContext.Recordings.Where(p => p.RecordingSetId == recordingSetId);
newRecordingSet.Recordings = new List <RCCFLib.Records.Recording>();
foreach (Recording thisRecording in recordings)
{
RCCFLib.Records.Recording newRecording = new RCCFLib.Records.Recording();
newRecording.Type = (Records.ValueType)thisRecording.Type;
switch ((Records.ValueType)thisRecording.Type)
{
case Records.ValueType.DateTime:
newRecording.Value = thisRecording.DateTimeValue;
break;
case Records.ValueType.Float:
newRecording.Value = thisRecording.FloatValue;
break;
case Records.ValueType.Integer:
newRecording.Value = thisRecording.IntValue;
break;
case Records.ValueType.String:
newRecording.Value = thisRecording.StringValue;
break;
default:
break;
}
newRecordingSet.Recordings.Add(newRecording);
}
return(newRecordingSet);
}
