protected Dictionary<int, double?> VariableObservations(int aVariableID) { MainDataSetTableAdapters.OBSERVATIONSTableAdapter adptObservations = new Plig.TimeSeries.Client.MainDataSetTableAdapters.OBSERVATIONSTableAdapter(); MainDataSet.OBSERVATIONSDataTable tblObservations = new MainDataSet.OBSERVATIONSDataTable(); tblObservations = adptObservations.GetDataByVariable(aVariableID); Dictionary<int, double?> observations = new Dictionary<int,double?>(); foreach (MainDataSet.OBSERVATIONSRow obsRow in tblObservations) { if (!obsRow.IsVALUENull()) observations.Add(obsRow.COUNTER, obsRow.VALUE); else observations.Add(obsRow.COUNTER, null); } return observations; }
protected void CalculateExtractInformation() { ExtractBegin = Int32.MinValue; ExtractEnd = Int32.MaxValue; int begin, end; foreach (int aVarId in DependentVariables.Keys) { CalculateVariableInformation(aVarId, out begin, out end); if (ExtractBegin < begin) ExtractBegin = begin; if (ExtractEnd > end) ExtractEnd = end; } foreach (int aVarId in IndependentVariables.Keys) { CalculateVariableInformation(aVarId, out begin, out end); if (ExtractBegin < begin) ExtractBegin = begin; if (ExtractEnd > end) ExtractEnd = end; } TestEnd = ExtractEnd; udModelValidation.Maximum = ExtractEnd - ExtractBegin; TestBegin = ExtractEnd - (int)udModelValidation.Value + 1; ExtractEnd = ExtractEnd - (int)udModelValidation.Value; lblExtractBegin.Text = ExtractBegin.ToString(); lblExtractEnd.Text = ExtractEnd.ToString(); SeriesInfo.Clear(); MainDataSetTableAdapters.OBSERVATIONSTableAdapter obsAdapter = new Plig.TimeSeries.Client.MainDataSetTableAdapters.OBSERVATIONSTableAdapter(); foreach (int key in IndependentVariables.Keys) { MainDataSet.OBSERVATIONSDataTable tblObservations = new MainDataSet.OBSERVATIONSDataTable(); tblObservations = obsAdapter.GetDataByVariable(key); double?[] varObservations = new double?[tblObservations.Rows.Count]; int count = 0; foreach (MainDataSet.OBSERVATIONSRow obsRow in tblObservations) { if (obsRow.IsVALUENull()) varObservations[count] = null; else varObservations[count] = obsRow.VALUE; count++; } SeriaInformation seria_info = new SeriaInformation(varObservations); seria_info.Values = this.VariableObservations(key); SeriesInfo.Add(key, seria_info); } foreach (int key in DependentVariables.Keys) { MainDataSet.OBSERVATIONSDataTable tblObservations = new MainDataSet.OBSERVATIONSDataTable(); tblObservations = obsAdapter.GetDataByVariable(key); double?[] varObservations = new double?[tblObservations.Rows.Count]; int count = 0; foreach (MainDataSet.OBSERVATIONSRow obsRow in tblObservations) { if (obsRow.IsVALUENull()) varObservations[count] = null; else varObservations[count] = obsRow.VALUE; count++; } SeriaInformation seria_info = new SeriaInformation(varObservations); SeriesInfo.Add(key, seria_info); } }