/// <summary> /// Update auto calculated columns ( IC table - Publisher, Year & title ,Indicator table- Data_Exists, area table - data_exist, IUS table - subgroup_nids & data_exist) into the database/template /// </summary> /// <returns></returns> public bool UpdateAutoCalculatedFieldsInTables() { bool RetVal = false; IndicatorClassificationBuilder ICBuilder; IndicatorBuilder IndBuilder; IUSBuilder IUSBuilderObj; AreaBuilder AreaBuilderObj; try { // 1. Indicator classification table - Publisher, year & title columns ICBuilder = new IndicatorClassificationBuilder(this.DBConnection, this.DBQueries); ICBuilder.UpdatePublisherTitleYear(); // 2. Indicator table - Data_exist column IndBuilder = new IndicatorBuilder(this.DBConnection, this.DBQueries); IndBuilder.UpdateDataExistValues(); // 3. IUS table- Subgroup_Nids & Data_Exist columns IUSBuilderObj = new IUSBuilder(this.DBConnection, this.DBQueries); IUSBuilderObj.UpdateSubgroupNids(); IUSBuilderObj.UpdateDataExistValues(); // 4. Area table- Data_Exist column AreaBuilderObj = new AreaBuilder(this.DBConnection, this.DBQueries); AreaBuilderObj.UpdateDataExistValues(); RetVal = true; } catch (Exception ex) { ExceptionFacade.ThrowException(ex); } return RetVal; }