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); }
public static void AddRecordingSet(RCCFLib.Records.RecordingSet recordingSet) { LinqObjectsDataContext dataContext = new LinqObjectsDataContext(); RecordingSet newRecordingSet = new RecordingSet(); newRecordingSet.RecordingSetDateTime = recordingSet.RecordingSetDateTime; newRecordingSet.RecordingSetId = recordingSet.RecordingSetId; newRecordingSet.RecordingRunId = recordingSet.RecordingRunId; dataContext.RecordingSets.InsertOnSubmit(newRecordingSet); foreach (Records.Recording thisRecording in recordingSet.Recordings) { Recording newRecording = new Recording(); newRecording.Key = thisRecording.Key; newRecording.RecordingSetId = recordingSet.RecordingSetId; switch (thisRecording.Type) { case Records.ValueType.DateTime: newRecording.DateTimeValue = DateTime.Parse(thisRecording.Value.ToString()); break; case Records.ValueType.Float: newRecording.FloatValue = float.Parse(thisRecording.Value.ToString()); break; case Records.ValueType.Integer: newRecording.IntValue = Int32.Parse(thisRecording.Value.ToString()); break; case Records.ValueType.String: newRecording.StringValue = thisRecording.Value.ToString(); break; default: break; } dataContext.Recordings.InsertOnSubmit(newRecording); } dataContext.SubmitChanges(); }