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); }