/// <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;
}
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());
}
}