private List <vCurrentAndAccepted> BindCurrentAcceptedValuesssssss(String variable, PredictedObservedDetail currPODetails) { List <vCurrentAndAccepted> POCurrentValuesList; //some of the older records may not have this yet. So find it the old way. if ((currPODetails.AcceptedPredictedObservedDetailsID == null) || (currPODetails.AcceptedPredictedObservedDetailsID <= 0)) { //Retrieve the curresponding (parent) ApsimFile for this PredictedObservedDetail ApsimFile apsimFile = ApsimFilesDS.GetByID(currPODetails.ApsimFilesID); //get the Pull Request Id for the lastest released pull request that is not the current one int acceptPullRequestId = ApsimFilesDS.GetLatestMergedPullRequestId(apsimFile.PullRequestId); //get the PredictedObservedDetail.ID for the records that match our current record 'matching' criteria currPODetails.AcceptedPredictedObservedDetailsID = PredictedObservedDS.GetIDByMatchingDetails(acceptPullRequestId, apsimFile.FileName, currPODetails.TableName, currPODetails.PredictedTableName, currPODetails.ObservedTableName, currPODetails.FieldNameUsedForMatch); } POCurrentValuesList = PredictedObservedDS.GetCurrentAcceptedValuesWithNulls(variable, currPODetails.ID, (int)currPODetails.AcceptedPredictedObservedDetailsID); //POCurrentValuesList = PredictedObservedDS.GetCurrentAcceptedValues(variable, currPODetails.ID, (int)currPODetails.AcceptedPredictedObservedDetailsID); //get the data to be displayed in the chart and grid //POValuesList = PredictedObservedDS.GetCurrentAcceptedValues(variable, currPODetails.ID, (int)currPODetails.AcceptedPredictedObservedDetailsID); //POValuesDT = Genfuncs.ToDataTable(POCurrentValuesList); return(POCurrentValuesList); }
private string GetPredictedObservedIDforPullRequestID(int predictedObservedId, int pullRequestId, string fileName, string tablename) { int altAcceptedPredictedObservedDetailsID = 0; try { //get the PredictedObservedDetail.ID for the records that match our current record 'matching' criteria altAcceptedPredictedObservedDetailsID = PredictedObservedDS.GetIDByMatchingDetails(pullRequestId, fileName, tablename); } catch (Exception) { } return(altAcceptedPredictedObservedDetailsID.ToString()); }
private void RetrieveDataAndBindCharts(PredictedObservedDetail currPODetails) { //some of the older records may not have this yet. So find it the old way. if ((currPODetails.AcceptedPredictedObservedDetailsID == null) || (currPODetails.AcceptedPredictedObservedDetailsID <= 0)) { //Retrieve the curresponding (parent) ApsimFile for this PredictedObservedDetail ApsimFile apsimFile = ApsimFilesDS.GetByID(currPODetails.ApsimFilesID); //get the Pull Request Id for the lastest released pull request that is not the current one int acceptPullRequestId = ApsimFilesDS.GetLatestMergedPullRequestId(apsimFile.PullRequestId); //get the PredictedObservedDetail.ID for the records that match our current record 'matching' criteria currPODetails.AcceptedPredictedObservedDetailsID = PredictedObservedDS.GetIDByMatchingDetails(acceptPullRequestId, apsimFile.FileName, currPODetails.TableName, currPODetails.PredictedTableName, currPODetails.ObservedTableName, currPODetails.FieldNameUsedForMatch); } List <vSimulationPredictedObserved> POCurrentValuesList = PredictedObservedDS.GetCurrentAcceptedSimulationValues(currPODetails.ID, (int)currPODetails.AcceptedPredictedObservedDetailsID); string holdVariable = string.Empty; string holdSimulationName = string.Empty; string tooltip = string.Empty; string textAnnotation = string.Empty; List <PODataPoint> acceptedData = new List <PODataPoint>(); List <PODataPoint> currentData = new List <PODataPoint>(); double maxXYValue = 0; bool newchart = false; int chartNo = 0; foreach (vSimulationPredictedObserved item in POCurrentValuesList) { if (holdVariable == string.Empty) { holdVariable = item.ValueName; holdSimulationName = item.SimulationName; tooltip = String.Format("{0} - {1}", item.SimulationName, item.ValueName); } newchart = false; //if (item.SimulationName != holdSimulationName) { newchart = true; } if (item.ValueName != holdVariable) { newchart = true; } if (newchart == true) { //create the chart if ((currentData.Count > 0) || (currentData.Count > 0)) { chartNo += 1; textAnnotation = GetPredictedObservedTests(currPODetails.ID, holdVariable); BindCurrentAcceptedChart(chartNo, holdVariable, currPODetails.ID, tooltip, currentData.ToArray(), acceptedData.ToArray(), maxXYValue, textAnnotation); } //reset the variables acceptedData.Clear(); currentData.Clear(); maxXYValue = 0; holdVariable = item.ValueName; holdSimulationName = item.SimulationName; } if ((item.AcceptedObservedValue != null) && (item.AcceptedPredictedValue != null)) { acceptedData.Add(new PODataPoint() { X = (double)item.AcceptedObservedValue, Y = (double)item.AcceptedPredictedValue, SimulationName = item.SimulationName }); if ((double)item.AcceptedObservedValue > maxXYValue) { maxXYValue = (double)item.AcceptedObservedValue; } if ((double)item.AcceptedPredictedValue > maxXYValue) { maxXYValue = (double)item.AcceptedPredictedValue; } } if ((item.CurrentObservedValue != null) && (item.CurrentPredictedValue != null)) { currentData.Add(new PODataPoint() { X = (double)item.CurrentObservedValue, Y = (double)item.CurrentPredictedValue, SimulationName = item.SimulationName }); if ((double)item.CurrentObservedValue > maxXYValue) { maxXYValue = (double)item.CurrentObservedValue; } if ((double)item.CurrentPredictedValue > maxXYValue) { maxXYValue = (double)item.CurrentPredictedValue; } } } if ((currentData.Count > 0) || (acceptedData.Count > 0)) { chartNo += 1; textAnnotation = GetPredictedObservedTests(currPODetails.ID, holdVariable); BindCurrentAcceptedChart(chartNo, holdVariable, currPODetails.ID, tooltip, currentData.ToArray(), acceptedData.ToArray(), maxXYValue, textAnnotation); } }