/// <summary> /// To import source into template or database /// </summary> /// <param name="sourceInfo"></param> /// <param name="NidInSourceDB"></param> /// <param name="sourceQurey"></param> /// <param name="sourceDBConnection"></param> /// <returns></returns> public int ImportSource(SourceInfo sourceInfo, int NidInSourceDB, DIQueries sourceQurey, DIConnection sourceDBConnection) { int RetVal = -1; string MetadataInfo = string.Empty; string SqlString = string.Empty; string Publisher = string.Empty; int ParentNid = -1; DataRow Row; DataTable TempTable; Dictionary<String, String> OldIconNId_NewIconNId = new Dictionary<string, string>(); DI7MetaDataBuilder SourceMetadataBuilder = null; try { //check source already exists in database or not RetVal = this.GetSourceNid(sourceInfo.Name); if (RetVal > 0) { // if source indicator is global if (sourceInfo.Global) { // do nothing } } else { RetVal = this.CheckNCreateSource(sourceInfo.Name, sourceInfo.ISBN, sourceInfo.Nature); } //update/insert icon DIIcons.ImportElement(NidInSourceDB, RetVal, IconElementType.IndicatorClassification, sourceQurey, sourceDBConnection, this.DBQueries, this.DBConnection); // import metadata reports from source database into current database SourceMetadataBuilder = new DI7MetaDataBuilder(this.DBConnection, this.DBQueries); SourceMetadataBuilder.ImportMetadata(sourceDBConnection, sourceQurey, NidInSourceDB, RetVal, MetadataElementType.Source, MetaDataType.Source, IconElementType.MetadataSource); //OldIconNId_NewIconNId = DIIcons.ImportElement(NidInSourceDB, RetVal, IconElementType.MetadataSource, sourceQurey, sourceDBConnection, this.DBQueries, this.DBConnection); //// get metadata info. //MetadataInfo = sourceInfo.Info; //// Update IconNids in xml if exists //foreach (string OldIconName in OldIconNId_NewIconNId.Keys) //{ // MetadataInfo = MetadataInfo.Replace(OldIconName, OldIconNId_NewIconNId[OldIconName].ToString()); //} //MetadataInfo = DICommon.CheckNConvertMetadataXml(MetadataInfo); //// Update Metadata //this.DBConnection.ExecuteNonQuery(DALQueries.IndicatorClassification.Update.UpdateICInfo(this.DBQueries.DataPrefix, this.DBQueries.LanguageCode, DICommon.RemoveQuotes(MetadataInfo), ICType.Source, RetVal)); //// -- insert records in xslt tables //SqlString = sourceQurey.Xslt.GetXSLT(NidInSourceDB.ToString(), MetadataElementType.Source); //TempTable = sourceDBConnection.ExecuteDataTable(SqlString); //if (TempTable.Rows.Count > 0) //{ // Row = TempTable.Rows[0]; // MetaDataBuilderObj = new MetaDataBuilder(this.DBConnection, this.DBQueries); // MetaDataBuilderObj.ImportTransformInfo(Row[XSLT.XSLTText].ToString(), Row[XSLT.XSLTFile].ToString(), RetVal.ToString(), MetadataElementType.Source); //} } catch (Exception ex) { throw new ApplicationException(ex.Message); } return RetVal; }
/// <summary> /// To import indicator into template or database /// </summary> /// <param name="indicatorInfo"></param> /// <param name="NidInSourceDB"></param> /// <param name="sourceQurey"></param> /// <param name="sourceDBConnection"></param> /// <returns></returns> public int ImportIndicator(IndicatorInfo sourceIndicatorInfo, int NidInSourceDB, DIQueries sourceQurey, DIConnection sourceDBConnection, bool importIndicatorInfoAlso) { int RetVal = -1; string metadataInfo = string.Empty; string SqlString = string.Empty; DataRow Row; DataTable TempTable; //Dictionary<String, String> OldIconNId_NewIconNId = new Dictionary<string, string>(); //MetaDataBuilder MetaDataBuilderObj; DI7MetaDataBuilder MetadataBuilderObj = null; IndicatorInfo TrgIndicatorInfo; try { //check Indicator already exists in database or not RetVal = this.GetIndicatorNid(sourceIndicatorInfo.GID, sourceIndicatorInfo.Name); if (RetVal > 0) { TrgIndicatorInfo = this.GetIndicatorInfo(FilterFieldType.NId, RetVal.ToString(), FieldSelection.Heavy); // dont import if trg indicator is global but source indicator is local if (TrgIndicatorInfo.Global & sourceIndicatorInfo.Global == false) { // dont import if trg indicator is global but source indicator is local } else { sourceIndicatorInfo.Info = DICommon.CheckNConvertMetadataXml(sourceIndicatorInfo.Info); //update the gid,name and global on the basis of nid this.DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.Indicator.Update.UpdateByNid(this.DBQueries.DataPrefix, this.DBQueries.LanguageCode, sourceIndicatorInfo.Name, sourceIndicatorInfo.GID, sourceIndicatorInfo.Global, sourceIndicatorInfo.Info, RetVal, sourceIndicatorInfo.HighIsGood)); } } else if (importIndicatorInfoAlso) { if (this.InsertIntoDatabase(sourceIndicatorInfo)) { //get nid RetVal = Convert.ToInt32(this.DBConnection.ExecuteScalarSqlQuery("SELECT @@IDENTITY")); } } if (RetVal > 0) { //update/insert icon DIIcons.ImportElement(NidInSourceDB, RetVal, IconElementType.Indicator, sourceQurey, sourceDBConnection, this.DBQueries, this.DBConnection); // import metadata MetadataBuilderObj = new DI7MetaDataBuilder(this.DBConnection, this.DBQueries); MetadataBuilderObj.ImportMetadata(sourceDBConnection, sourceQurey, NidInSourceDB, RetVal, MetadataElementType.Indicator, MetaDataType.Indicator, IconElementType.MetadataIndicator); //////// -- insert records in xslt tables //////SqlString = sourceQurey.Xslt.GetXSLT(NidInSourceDB.ToString(), MetadataElementType.Indicator); //////TempTable = sourceDBConnection.ExecuteDataTable(SqlString); //////if (TempTable.Rows.Count > 0) //////{ ////// Row = TempTable.Rows[0]; ////// MetaDataBuilderObj = new MetaDataBuilder(this.DBConnection, this.DBQueries); ////// MetaDataBuilderObj.ImportTransformInfo(Row[XSLT.XSLTText].ToString(), Row[XSLT.XSLTFile].ToString(), RetVal.ToString(), MetadataElementType.Indicator); //////} } } catch (Exception ex) { throw new ApplicationException(ex.Message); } return RetVal; }
/// <summary> /// To import source into template or database /// </summary> /// <param name="sourceInfo"></param> /// <param name="NidInSourceDB"></param> /// <param name="sourceQurey"></param> /// <param name="sourceDBConnection"></param> /// <returns></returns> public int ImportSource(SourceInfo sourceInfo, int NidInSourceDB, DIQueries sourceQurey, DIConnection sourceDBConnection) { int RetVal = -1; string MetadataInfo = string.Empty; string SqlString = string.Empty; string Publisher = string.Empty; int ParentNid = -1; DataRow Row; DataTable TempTable; Dictionary <String, String> OldIconNId_NewIconNId = new Dictionary <string, string>(); DI7MetaDataBuilder SourceMetadataBuilder = null; try { //check source already exists in database or not RetVal = this.GetSourceNid(sourceInfo.Name); if (RetVal > 0) { // if source indicator is global if (sourceInfo.Global) { // do nothing } } else { RetVal = this.CheckNCreateSource(sourceInfo.Name, sourceInfo.ISBN, sourceInfo.Nature); } //update/insert icon DIIcons.ImportElement(NidInSourceDB, RetVal, IconElementType.IndicatorClassification, sourceQurey, sourceDBConnection, this.DBQueries, this.DBConnection); // import metadata reports from source database into current database SourceMetadataBuilder = new DI7MetaDataBuilder(this.DBConnection, this.DBQueries); SourceMetadataBuilder.ImportMetadata(sourceDBConnection, sourceQurey, NidInSourceDB, RetVal, MetadataElementType.Source, MetaDataType.Source, IconElementType.MetadataSource); //OldIconNId_NewIconNId = DIIcons.ImportElement(NidInSourceDB, RetVal, IconElementType.MetadataSource, sourceQurey, sourceDBConnection, this.DBQueries, this.DBConnection); //// get metadata info. //MetadataInfo = sourceInfo.Info; //// Update IconNids in xml if exists //foreach (string OldIconName in OldIconNId_NewIconNId.Keys) //{ // MetadataInfo = MetadataInfo.Replace(OldIconName, OldIconNId_NewIconNId[OldIconName].ToString()); //} //MetadataInfo = DICommon.CheckNConvertMetadataXml(MetadataInfo); //// Update Metadata //this.DBConnection.ExecuteNonQuery(DALQueries.IndicatorClassification.Update.UpdateICInfo(this.DBQueries.DataPrefix, this.DBQueries.LanguageCode, DICommon.RemoveQuotes(MetadataInfo), ICType.Source, RetVal)); //// -- insert records in xslt tables //SqlString = sourceQurey.Xslt.GetXSLT(NidInSourceDB.ToString(), MetadataElementType.Source); //TempTable = sourceDBConnection.ExecuteDataTable(SqlString); //if (TempTable.Rows.Count > 0) //{ // Row = TempTable.Rows[0]; // MetaDataBuilderObj = new MetaDataBuilder(this.DBConnection, this.DBQueries); // MetaDataBuilderObj.ImportTransformInfo(Row[XSLT.XSLTText].ToString(), Row[XSLT.XSLTFile].ToString(), RetVal.ToString(), MetadataElementType.Source); //} } catch (Exception ex) { throw new ApplicationException(ex.Message); } return(RetVal); }