private void CheckNCreateMetadataCategoryTable(bool forOnlineDB, DITables tablesName) { string DataPrefix = string.Empty; string LanguageCode = string.Empty; MetadataCategoryBuilder MetadataCategoryBuilderObj = null; DIQueries TempQueries; try { // check table already exists or not TempQueries = new DIQueries(tablesName.CurrentDataPrefix, tablesName.CurrentLanguageCode); MetadataCategoryBuilderObj = new MetadataCategoryBuilder(this._DBConnection, TempQueries); if (MetadataCategoryBuilderObj.IsMetadataCategoryTableExists() == false) { this.AddMissingMetadataCategoryTables(tablesName.MetadataCategory); this._DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.MetadataCategory.Insert.CreateTable(tablesName.MetadataCategory, forOnlineDB, this._DBConnection.ConnectionStringParameters.ServerType)); } } catch (Exception ex) { throw new ApplicationException(ex.ToString()); } }
private void CreateMetadatCategoryTable(bool forOnlineDB) { string DataPrefix = string.Empty; string LanguageCode = string.Empty; DITables TableNames; MetadataCategoryBuilder MetadataCategoryBuilderObj = null; DIQueries TempQueries; try { // step1: create table for all dataset foreach (DataRow DataPrefixRow in this._DBConnection.DIDataSets().Rows) { DataPrefix = DataPrefixRow[DBAvailableDatabases.AvlDBPrefix].ToString() + "_"; // create table for all available langauges foreach (DataRow LanguageRow in this._DBConnection.DILanguages(DataPrefix).Rows) { LanguageCode = "_" + LanguageRow[Language.LanguageCode].ToString(); // check table already exists or not TempQueries = new DIQueries(DataPrefix, LanguageCode); MetadataCategoryBuilderObj = new MetadataCategoryBuilder(this._DBConnection, TempQueries); if (MetadataCategoryBuilderObj.IsMetadataCategoryTableExists() == false) { TableNames = new DITables(DataPrefix, LanguageCode); this._DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.MetadataCategory.Insert.CreateTable(TableNames.MetadataCategory, forOnlineDB, this._DBConnection.ConnectionStringParameters.ServerType)); } } } } catch (Exception ex) { throw new ApplicationException(ex.ToString()); } }