/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
this.Columns.Add(Unit.UnitName, DILanguage.GetLanguageString(Constants.LanguageKeys.Unit));
this.TagValueColumnName = Unit.UnitNId;
this.GlobalValueColumnName1 = Unit.UnitGlobal;
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
this.Columns.Add(SubgroupTypes.SubgroupTypeName, DILanguage.GetLanguageString(Constants.LanguageKeys.SubgroupType));
this.TagValueColumnName = SubgroupTypes.SubgroupTypeNId;
this.GlobalValueColumnName1 = SubgroupTypes.SubgroupTypeGlobal;
}
protected override void SetColumnHeaders()
{
//Get header string from language file and set column headers string
this._FirstColumnHeader = DILanguage.GetLanguageString("AREANAME");
this._SecondColumnHeader = DILanguage.GetLanguageString("AREAID");
this._ThirdColumnHeader = DILanguage.GetLanguageString("LEVEL");
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
if (this._ShowSector)
{
for (int Level = 1; Level <= this.MaxLevel; Level++)
{
this.Columns.Add(Constants.LanguageKeys.Level + " " + Level, DILanguage.GetLanguageString(Constants.LanguageKeys.Level) + " " + Level);
}
}
if (this._ShowIUS)
{
this.Columns.Add(Indicator.IndicatorName, DILanguage.GetLanguageString(Constants.LanguageKeys.Indicator));
this.Columns.Add(Unit.UnitName, DILanguage.GetLanguageString(Constants.LanguageKeys.Unit));
this.Columns.Add(SubgroupVals.SubgroupVal, DILanguage.GetLanguageString(Constants.LanguageKeys.Subgroup));
this.TagValueColumnName = Indicator_Unit_Subgroup.IUSNId;
}
else
{
this.Columns.Add(Indicator.IndicatorName, DILanguage.GetLanguageString(Constants.LanguageKeys.Indicator));
this.TagValueColumnName = Indicator.IndicatorNId;
}
this.GlobalValueColumnName1 = Indicator.IndicatorGlobal;
this.GlobalValueColumnName2 = Unit.UnitGlobal;
this.GlobalValueColumnName3 = SubgroupVals.SubgroupValGlobal;
}
protected override void SetColumnNames()
{
//Get header string from language file and set column headers string
this._FirstColumnHeader = DILanguage.GetLanguageString("TIMEPERIOD");
this._SecondColumnHeader = DILanguage.GetLanguageString("STARTDATE");
this._ThirdColumnHeader = DILanguage.GetLanguageString("ENDDATE");
}
protected override void SetColumnHeaders()
{
//Get header string from language file and set column headers string
this._FirstColumnHeader = DILanguage.GetLanguageString("INDICATOR");
this._SecondColumnHeader = DILanguage.GetLanguageString("UNIT");
this._ThirdColumnHeader = DILanguage.GetLanguageString("SUBGROUP");
}
public SearchUnits()
{
this._GIdColumnName = Unit.UnitNId;
this._NameColumnName = Unit.UnitName;
this._GlobalValueColumnName = Unit.UnitGlobal;
this._NameColumnHeader = DILanguage.GetLanguageString("UNIT");
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
this.Columns.Add(Indicator.IndicatorName, DILanguage.GetLanguageString("Indicator"));
this.TagValueColumnName = Indicator.IndicatorNId;
this.GlobalValueColumnName1 = Indicator.IndicatorGlobal;
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
this.Columns.Add(Area_Map_Metadata.LayerName, DILanguage.GetLanguageString(Constants.LanguageKeys.Layer));
this.TagValueColumnName = Area_Map_Metadata.MetadataNId;
this.GlobalValueColumnName1 = string.Empty;
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
this.Columns.Add(Metadata_Category.CategoryName, DILanguage.GetLanguageString("METADATA_CATEGORY"));
this.TagValueColumnName = Metadata_Category.CategoryNId;
this.GlobalValueColumnName1 = string.Empty;
}
protected override void InitializeVaribles()
{
this.KeyColumnName = Indicator.IndicatorNId;
this._GlobalColumnName = Indicator.IndicatorGlobal;
if (this._DisplayColumnsInfo == null)
{
this._DisplayColumnsInfo = new Dictionary <string, string>();
}
this._DisplayColumnsInfo.Add(Indicator.IndicatorName, DILanguage.GetLanguageString("INDICATORNAME"));
}
internal override void SetColumnInfo()
{
this._Columns.Clear();
//set columns info
this._Columns.Add(new ColumnInfo(SubgroupVals.SubgroupVal, DILanguage.GetLanguageString("SUBGROUP"), SubgroupVals.SubgroupValGlobal));
//set tag value column
this._TagValueColumnName = SubgroupVals.SubgroupValNId;
}
internal override void SetColumnInfo()
{
this._Columns.Clear();
//set columns info
this._Columns.Add(new ColumnInfo(Timeperiods.TimePeriod, DILanguage.GetLanguageString("TIMEPERIOD"), string.Empty));
//set tag value column
this._TagValueColumnName = Timeperiods.TimePeriodNId;
}
internal override void SetColumnInfo()
{
this._Columns.Clear();
//set columns info
this._Columns.Add(new ColumnInfo(Unit.UnitName, DILanguage.GetLanguageString("UNIT"), Unit.UnitGlobal));
//set tag value column
this._TagValueColumnName = Unit.UnitNId;
}
internal override void SetColumnInfo()
{
this._Columns.Clear();
//set columns info
this._Columns.Add(new ColumnInfo(Area.AreaName, DILanguage.GetLanguageString("AREA"), Area.AreaGlobal));
//set tag value column
this._TagValueColumnName = Area.AreaNId;
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
for (int Level = 1; Level <= this.MaxLevel; Level++)
{
this.Columns.Add(Constants.LanguageKeys.Level + " " + Level, DILanguage.GetLanguageString(Constants.LanguageKeys.Level) + " " + Level);
}
this.TagValueColumnName = IndicatorClassifications.ICNId;
this.GlobalValueColumnName1 = IndicatorClassifications.ICGlobal;
}
internal override void SetColumnInfo()
{
this._Columns.Clear();
//set columns info
this._Columns.Add(new ColumnInfo(IndicatorClassifications.ICName, DILanguage.GetLanguageString("SOURCE"), string.Empty));
//set tag value column
this._TagValueColumnName = IndicatorClassifications.ICNId;
}
internal override void SetColumnInfo()
{
this._Columns.Clear();
//set columns info
this._Columns.Add(new ColumnInfo(Indicator.IndicatorName, DILanguage.GetLanguageString("INDICATOR"), Indicator.IndicatorGlobal));
//set tag value column
this._TagValueColumnName = Indicator.IndicatorNId;
}
protected override void InitializeVaribles()
{
this.KeyColumnName = Unit.UnitNId;
this._GlobalColumnName = Unit.UnitGlobal;
if (this._DisplayColumnsInfo == null)
{
this._DisplayColumnsInfo = new Dictionary <string, string>();
}
this._DisplayColumnsInfo.Add(Unit.UnitName, DILanguage.GetLanguageString("UNIT"));
}
protected override void InitializeVaribles()
{
this.KeyColumnName = SubgroupTypes.SubgroupTypeNId;
this._GlobalColumnName = SubgroupTypes.SubgroupTypeGlobal;
if (this._DisplayColumnsInfo == null)
{
this._DisplayColumnsInfo = new Dictionary <string, string>();
}
this._DisplayColumnsInfo.Add(SubgroupTypes.SubgroupTypeName, DILanguage.GetLanguageString("SUBGROUP_TYPE"));
}
protected override void InitializeVaribles()
{
this.KeyColumnName = IndicatorClassifications.ICNId;
this._GlobalColumnName = IndicatorClassifications.ICGlobal;
if (this._DisplayColumnsInfo == null)
{
this._DisplayColumnsInfo = new Dictionary <string, string>();
}
this._DisplayColumnsInfo.Add(IndicatorClassifications.ICName, DILanguage.GetLanguageString("INDICATORCLASSIFICATION"));
}
protected override void InitializeVaribles()
{
this.KeyColumnName = Area.AreaNId;
this._GlobalColumnName = Area.AreaGlobal;
if (this._DisplayColumnsInfo == null)
{
this._DisplayColumnsInfo = new Dictionary <string, string>();
}
this._DisplayColumnsInfo.Add(Area.AreaName, DILanguage.GetLanguageString("AREANAME"));
this._DisplayColumnsInfo.Add(Area.AreaLevel, DILanguage.GetLanguageString("AREALEVEL"));
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
this.Columns.Clear();
this.Columns.Add(Indicator.IndicatorName, DILanguage.GetLanguageString(Constants.LanguageKeys.Indicator));
this.Columns.Add(Unit.UnitName, DILanguage.GetLanguageString(Constants.LanguageKeys.Unit));
this.Columns.Add(SubgroupVals.SubgroupVal, DILanguage.GetLanguageString(Constants.LanguageKeys.Subgroup));
this.TagValueColumnName = Indicator_Unit_Subgroup.IUSNId;
this.GlobalValueColumnName1 = Indicator.IndicatorGlobal;
this.GlobalValueColumnName2 = Unit.UnitGlobal;
this.GlobalValueColumnName3 = SubgroupVals.SubgroupValGlobal;
this._ShowIUS = true;
}
public SearchIndicators(DIConnection dbConnection, DIQueries dbQueries)
{
this._GIdColumnName = Indicator.IndicatorNId;
this._NameColumnName = Indicator.IndicatorName;
this._GlobalValueColumnName = Indicator.IndicatorGlobal;
this._NameColumnHeader = DILanguage.GetLanguageString("INDICATOR");
this.DBConnection = dbConnection;
this.DBQueries = dbQueries;
FreeTextObj = new FreeText(dbConnection, dbQueries);
}
protected override void SetColumnHeaders()
{
this._SecondColumnHeader = String.Empty;
this._ThirdColumnHeader = String.Empty;
//Get header string from language file and set column headers string
switch (this._IndicatorClassificationType)
{
case ICType.Sector:
this._FirstColumnHeader = DILanguage.GetLanguageString("SECTOR");
break;
case ICType.Goal:
this._FirstColumnHeader = DILanguage.GetLanguageString("GOAL");
break;
case ICType.CF:
this._FirstColumnHeader = DILanguage.GetLanguageString("FRAMEWORK");
break;
case ICType.Theme:
this._FirstColumnHeader = DILanguage.GetLanguageString("THEME");
break;
case ICType.Source:
this._FirstColumnHeader = DILanguage.GetLanguageString("SOURCE");
if (this.ShowISBNNatureColumn)
{
this._SecondColumnHeader = DILanguage.GetLanguageString("ISBN");
this._ThirdColumnHeader = DILanguage.GetLanguageString("NATURE");
}
break;
case ICType.Institution:
this._FirstColumnHeader = DILanguage.GetLanguageString("INSTITUTION");
break;
case ICType.Convention:
this._FirstColumnHeader = DILanguage.GetLanguageString("CONVENTION");
break;
default:
break;
}
}
/// <summary>
/// Sets the columns info like name , global value column name,etc
/// </summary>
public override void SetColumnsInfo()
{
string ColumnHeader = string.Empty;
this.Columns.Clear();
switch (this._IndicatorClassificationType)
{
case ICType.CF:
ColumnHeader = Constants.LanguageKeys.Framework;
break;
case ICType.Convention:
ColumnHeader = Constants.LanguageKeys.Convention;
break;
case ICType.Goal:
ColumnHeader = Constants.LanguageKeys.Goal;
break;
case ICType.Institution:
ColumnHeader = Constants.LanguageKeys.Institution;
break;
case ICType.Sector:
ColumnHeader = Constants.LanguageKeys.Sector;
break;
case ICType.Source:
ColumnHeader = Constants.LanguageKeys.Source;
break;
case ICType.Theme:
ColumnHeader = Constants.LanguageKeys.Theme;
break;
default:
break;
}
this.Columns.Add(IndicatorClassifications.ICName, DILanguage.GetLanguageString(ColumnHeader));
this.TagValueColumnName = IndicatorClassifications.ICNId;
this.GlobalValueColumnName1 = string.Empty;
}
/// <summary>
/// Export metadata to excel file
/// </summary>
/// <param name="ExcelFilePath">Excel File Path to be written as export data</param>
public void ExportMetaDataToExcel(string ExcelFilePath, MetadataElementType elementType, string elementName, string elementGId, int targetElementNID)
{
try
{
// --Open excel and get first worksheet
this.DiExcel = new DIExcel(ExcelFilePath);
MetadataSheet = DiExcel.GetWorksheet(0);
// --Set Matadata Type in Cell 0,0
switch (elementType)
{
case MetadataElementType.Indicator:
SetMetadataCommonCellValues(DILanguage.GetLanguageString("INDICATOR") + "-" + DILanguage.GetLanguageString("METADATA"), elementName, elementGId);
break;
case MetadataElementType.Area:
SetMetadataCommonCellValues(DILanguage.GetLanguageString("AREA") + "-" + DILanguage.GetLanguageString("METADATA"), elementName, elementGId);
break;
case MetadataElementType.Source:
SetMetadataCommonCellValues(DILanguage.GetLanguageString("SOURCE") + "-" + DILanguage.GetLanguageString("METADATA"), elementName, elementGId);
break;
default:
break;
}
// --Load data from xml to excel file
this.LoadData(elementType, targetElementNID);
//-- Save excel
this.DiExcel.Save();
}
catch (Exception ex)
{
}
}
protected override void SetColumnHeaders()
{
////Get header string from language file and set column headers string
this._FirstColumnHeader = DILanguage.GetLanguageString("UNIT");
}
/// <summary>
/// Load Data into excel report file
/// </summary>
private void LoadData(MetadataElementType elementType, int elementNID)
{
string ParaNodeText = string.Empty;
string ConcatenatedParaNodeText = string.Empty;
DataTable CategoryTable = null;
DataTable MetadataReportTable = null;
string CategoryName = string.Empty;
string CategoryNid = string.Empty;
string MetadataText = string.Empty;
string ReplaceableSymbol = "{{~}}";
string CategoryGID = string.Empty;
try
{
// 1. Get category table from database where ispresentational is false
CategoryTable = this.GetCategoryDataTable(elementType);
// rearrange categories
CategoryTable = DI7MetadataCategoryBuilder.RearrangeCategoryTableByCategoryOrder(CategoryTable);
// 2. get metadata reports
MetadataReportTable = this.GetMetadataReportsTableFrmDB(elementNID, elementType);
// 3. Add Title
// writes metadata values in excel report.
this.WriteMetadataField(CategoryIndex, DILanguage.GetLanguageString("CATEGORY"), DILanguage.GetLanguageString("CATEGORY_GID"));
//Write values to excel
this.WriteMetadataValueToExcel(CategoryIndex, DILanguage.GetLanguageString("METADATA"));
this.MetadataSheet.Cells[this._MetadataStartRowIndexInExl + CategoryIndex, 0, this._MetadataStartRowIndexInExl + CategoryIndex, 2].Font.Bold = true;
this.MetadataSheet.Cells[this._MetadataStartRowIndexInExl + CategoryIndex, 0, this._MetadataStartRowIndexInExl + CategoryIndex, 2].Interior.Color = SpreadsheetGear.Drawing.Color.FromArgb(System.Drawing.Color.LightGray.ToArgb());
CategoryIndex++;
//Iterate through category node
foreach (DataRow CategoryRow in CategoryTable.Rows)
{
// 4.2 get category label form table
CategoryName = Convert.ToString(CategoryRow[Metadata_Category.CategoryName]);
CategoryNid = Convert.ToString(CategoryRow[Metadata_Category.CategoryNId]);
CategoryGID = Convert.ToString(CategoryRow[Metadata_Category.CategoryGId]);
// writes metadata values in excel report.
this.WriteMetadataField(CategoryIndex, CategoryName, CategoryGID);
// Get metadata report from metadata report table for the current category
foreach (DataRow Row in MetadataReportTable.Select(MetadataReport.CategoryNid + "=" + CategoryNid))
{
MetadataText = Convert.ToString(Row[MetadataReport.Metadata]).Replace(ReplaceableSymbol, Microsoft.VisualBasic.ControlChars.NewLine);
//Write values to excel
WriteMetadataValueToExcel(CategoryIndex, MetadataText);
}
CategoryIndex = CategoryIndex + 1;
}
}
catch (Exception ex)
{ ExceptionHandler.ExceptionFacade.ThrowException(ex); }
}
/// <summary>
/// Sets the columns info like name etc
/// </summary>
public void SetColumnsInfo(int currentMaxLevel)
{
this.DisplayColumnsInfo.Clear();
for (int Level = 1; Level <= currentMaxLevel; Level++)
{
this.DisplayColumnsInfo.Add(MergetTemplateConstants.Columns.Level + " " + Level, DILanguage.GetLanguageString(MergetTemplateConstants.Columns.Level) + " " + Level);
}
}
