/// <summary> /// Returns true/false. True if Database is in valid format otherwise false. /// </summary> /// <param name="forOnlineDB"></param> /// <returns></returns> public override bool IsValidDB(bool forOnlineDB) { bool RetVal = false; // check RecommendedSources table exists or not RecommendedSourcesBuilder RecommendedSrcBuilder = new RecommendedSourcesBuilder(this._DBConnection, this._DBQueries); RetVal = RecommendedSrcBuilder.IsRecommendedSourcesTableExists(); return(RetVal); }
private void CreateNUpdateRecommendedSourcesTable(bool forOnlineDB) { string DataPrefix = string.Empty; string LanguageCode = string.Empty; DITables TableNames; RecommendedSourcesBuilder RecommendedSourcesTblBuilder; 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); RecommendedSourcesTblBuilder = new RecommendedSourcesBuilder(this._DBConnection, TempQueries); if (RecommendedSourcesTblBuilder.IsRecommendedSourcesTableExists() == false) { TableNames = new DITables(DataPrefix, LanguageCode); this._DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.RecommendedSources.Insert.CreateTable(TableNames.RecommendedSources, forOnlineDB, this._DBConnection.ConnectionStringParameters.ServerType)); // step2: insert IC_IUS_Label into recommendedsource table from IC_IUS table this.DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.RecommendedSources.Insert.InsertAllLabelFrmICIUS(TableNames)); } } } } catch (Exception ex) { throw new ApplicationException(ex.ToString()); } }
/// <summary> /// Returns true/false. True if Database is in valid format otherwise false. /// </summary> /// <param name="forOnlineDB"></param> /// <returns></returns> public override bool IsValidDB(bool forOnlineDB) { bool RetVal = false; // check RecommendedSources table exists or not RecommendedSourcesBuilder RecommendedSrcBuilder = new RecommendedSourcesBuilder(this._DBConnection, this._DBQueries); RetVal = RecommendedSrcBuilder.IsRecommendedSourcesTableExists(); return RetVal; }