/// <summary> /// Create and add record into database. /// </summary> /// <param name="areaInfo"></param> /// <param name="iusInfo"></param> /// <param name="timeperiodInfo"></param> /// <param name="sourceInfo"></param> /// <returns></returns> public int AddDataPoint(AreaInfo areaInfo, IUSInfo iusInfo, TimeperiodInfo timeperiodInfo, SourceInfo sourceInfo, string dataValue) { int RetVal = 0; int AreaNid = 0; int IUSNid = 0; int TimeperiodNid = 0; int SourceNid = 0; // Step 1: Area if (areaInfo.Nid <= 0) { AreaNid = this.DIArea.CheckNCreateArea(areaInfo); } else { AreaNid = areaInfo.Nid; } // Step 2: IUS, check for IUS only if IUSNid is zero. if (iusInfo.Nid <= 0) { IUSNid = this.DIIUS.CheckNCreateIUS(iusInfo); } else { IUSNid = iusInfo.Nid; } // Step 3: Timeperiod if (timeperiodInfo.Nid <= 0) { TimeperiodNid = this.DITimeperiod.CheckNCreateTimeperiod(timeperiodInfo.TimeperiodValue); } else { TimeperiodNid = timeperiodInfo.Nid; } // Step 4: Source if (sourceInfo.Nid <= 0) { SourceNid = this.DISource.CheckNCreateSource(sourceInfo.Name); } else { SourceNid = sourceInfo.Nid; } // Step 5: Insert Data and source , IUSNId & sourceparent ,IUSNID relationship into IC_IUS table RetVal = this.CheckNCreateData(AreaNid, IUSNid, SourceNid, TimeperiodNid, dataValue); return RetVal; }
/// <summary> /// Create and add record into database. /// </summary> /// <param name="areaInfo">object of AreaInfo</param> /// <param name="iusInfo">object of IUSInfo</param> /// <param name="timeperiod">Timeperiod</param> /// <param name="source">Source Name</param> /// <param name="dataValue">Data Value</param> /// <returns></returns> public int AddDataPoint(AreaInfo areaInfo, IUSInfo iusInfo, string timeperiod, string source, string dataValue) { int RetVal = 0; TimeperiodInfo TimeperiodObject = new TimeperiodInfo(); SourceInfo SourceObject = new SourceInfo(); if (areaInfo == null | string.IsNullOrEmpty(iusInfo.IndicatorInfo.Name) | string.IsNullOrEmpty(iusInfo.UnitInfo.Name) | string.IsNullOrEmpty(iusInfo.SubgroupValInfo.Name) | string.IsNullOrEmpty(timeperiod) | string.IsNullOrEmpty(source)) { //do nothing } else { //set timeperiod info TimeperiodObject.Nid = 0; TimeperiodObject.TimeperiodValue = timeperiod; //set source info SourceObject.Nid = 0; SourceObject.Name = source; //insert data RetVal = this.AddDataPoint(areaInfo, iusInfo, TimeperiodObject, SourceObject, dataValue); } return RetVal; }