Exemplo n.º 1
0
        /// <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;
        }
Exemplo n.º 2
0
        /// <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;
        }