protected void SetQueriesObjects()
{
if (this._DBConnection != null)
{
// check client application langauge code is given or not. If given then check it is available or not & if available then use it otherwise work on default language code
if (!string.IsNullOrEmpty(this._ClientApplicationLanguageCode))
{
if (this._DBConnection.IsValidDILanguage(this.DatasetPrefix, this._ClientApplicationLanguageCode))
{
this.LanguageCode = this._ClientApplicationLanguageCode;
}
}
if (string.IsNullOrEmpty(LanguageCode))
{
this.LanguageCode = this._DBConnection.DILanguageCodeDefault(this.DatasetPrefix);
}
this._DBQueries = new DIQueries(this.DatasetPrefix, this.LanguageCode);
this.DAQuery = new ImportQueries(this.DBQueries);
// Setting Update queries object on the basis of Database Server Type. (UPDATE queries having JOINS are different for ACCESS and SQL Server)
this.DAQuery.SetUpdateQueryObject(this._DBConnection.ConnectionStringParameters.ServerType);
}
}
/// <summary>
/// Updates specified DataBase name as parameter, in DB_Available Table.
/// </summary>
/// <param name="availableDbName"></param>
public void UpdateAvialableDBInSavedFile(string availableDbWName)
{
DIConnectionDetails ConnectionDetails;
DIConnection AvailableDBConnection;
string DatasetPrefix;
string LanguageCode;
DIQueries AvailableDBQuery;
ImportQueries Query;
//' --Create connection with saved file
ConnectionDetails = new DIConnectionDetails(DIServerType.MsAccess, string.Empty, string.Empty, availableDbWName, string.Empty, DAImportCommon.Constants.DBPassword);
AvailableDBConnection = new DIConnection(ConnectionDetails);
DatasetPrefix = AvailableDBConnection.DIDataSetDefault();
LanguageCode = AvailableDBConnection.DILanguageCodeDefault(DatasetPrefix);
AvailableDBQuery = new DIQueries(DatasetPrefix, LanguageCode);
Query = new ImportQueries(AvailableDBQuery);
//' - Update Avialble DB fileName in DB_Available_Database table.
AvailableDBConnection.ExecuteNonQuery(Query.UpdateDB_Available_DatabaseTable(Path.GetFileNameWithoutExtension(availableDbWName)));
//' -- Dispose Connection
AvailableDBConnection.Dispose();
AvailableDBQuery = null;
Query = null;
}
/// <summary>
/// Set basic database properties for online connection
/// </summary>
/// <param name="dataset"></param>
/// <param name="languageCode"></param>
protected void SetDatabasePropertiesForOnlineConnection(string dataset, string languageCode)
{
this.DatasetPrefix = dataset;
this.LanguageCode = languageCode;
this._DBQueries = new DIQueries(this.DatasetPrefix, this.LanguageCode);
this.DAQuery = new ImportQueries(this.DBQueries);
// Setting Update queries object on the basis of Database Server Type. (UPDATE queries having JOINS are different for ACCESS and SQL Server)
this.DAQuery.SetUpdateQueryObject(this._DBConnection.ConnectionStringParameters.ServerType);
}
