/// <summary>
/// Gets the table size, row count etc. from the Database
/// </summary>
/// <param name="SQLDwConfig"></param>
public void RefreshTableListFromDB(MySettingsEnvironments SQLDwConfig)
{
string connstr = SQLDwConfig.GetConnectionString();
string sql;
string strFolderApplication = UtilGeneral.GetApplicationFolder();
string strFileTableList = strFolderApplication + "\\" + Constants.FOLDER_CONNECTION_TYPE + "\\" + SQLDwConfig.ConnectionType + "\\" + Constants.FILE_TABLE_LIST;
sql = System.IO.File.ReadAllText(strFileTableList);
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
try
{
comm.CommandTimeout = 120;
SqlDataReader rdr = comm.ExecuteReader();
TableList.Clear();
TableList.Load(rdr);
rdr = null;
}
catch (Exception ex)
{
throw new System.Exception(ex.Message);
}
finally
{
conn.Close();
}
}
public frmConfig(string strConfigName, frmMain ParentForm)
{
InitializeComponent();
string strSQLDWGeneratorMainFolder = Properties.Settings.Default.ApplicationFolder;
SQLDwConfigurationFolder = strSQLDWGeneratorMainFolder + "\\" + Constants.SUB_FOLDER_SETTINGS;
frmParent = ParentForm;
cmbAuthentication.Items.Clear();
cmbAuthentication.Items.Add(Constants.DB_AUTHENTICATION_INTEGRATED);
cmbAuthentication.Items.Add(Constants.DB_AUTHENTICATION_SQL);
cmbAuthentication.SelectedIndex = 0;
txtUserName.Text = "";
txtPassword.Text = "";
if (!Directory.Exists(SQLDwConfigurationFolder))
{
Directory.CreateDirectory(SQLDwConfigurationFolder);
}
DirectoryInfo d = new DirectoryInfo(SQLDwConfigurationFolder);
FileInfo[] Files = d.GetFiles("*.Config");
// Clear the main combo box and load the availble configuration files
cmbConfigFile.Items.Clear();
foreach (FileInfo file in Files)
{
cmbConfigFile.Items.Add(file.Name);
}
cmbConfigFile.Items.Add(NEW_CONFIG_FILE);
string strFolderApplication = UtilGeneral.GetApplicationFolder();
string strFolderConnectionType = strFolderApplication + "\\" + Constants.FOLDER_CONNECTION_TYPE;
string[] subdirectoryEntries = Directory.GetDirectories(strFolderConnectionType);
cmbConnectionType.Items.Clear();
foreach (string subdirectory in subdirectoryEntries)
{
DirectoryInfo di = new DirectoryInfo(subdirectory);
cmbConnectionType.Items.Add(di.Name);
}
for (int i = 0; i < cmbConnectionType.Items.Count; i++)
{
if (cmbConnectionType.Items[i].ToString() == "SQL Server")
{
cmbConnectionType.SelectedIndex = i;
break;
}
}
LoadInitialData(strConfigName);
}
public MySettingsUserConfig()
{
try
{
string appPath = UtilGeneral.GetApplicationFolder();
string configFileName = System.IO.Path.Combine(appPath, USER_SETTINGS_FILENAME);
ExeConfigurationFileMap configFileMap = new ExeConfigurationFileMap();
configFileMap.ExeConfigFilename = configFileName;
ConfigFile = ConfigurationManager.OpenMappedExeConfiguration(configFileMap, ConfigurationUserLevel.None);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Creates a new ColumnList instance based on Schema and Table Name.
/// Uses the current configuration data for more details
/// </summary>
/// <param name="strSchemaName"></param>
/// <param name="strTableName"></param>
/// <param name="SQLDwConfig">The application configuration is passed to get all details related to currently selected configuration</param>
internal MyColumnList(string strSchemaName, string strTableName, MySettingsEnvironments SQLDwConfig)
{
ColumnList = new DataTable();
ColumnList.Columns.Add(COLUMN_NAME);
ColumnList.Columns.Add(DATA_TYPE);
ColumnList.Columns.Add(LENGTH, Type.GetType("System.Int32"));
ColumnList.Columns.Add(PRECISION, Type.GetType("System.Int32"));
ColumnList.Columns.Add(SCALE, Type.GetType("System.Int32"));
ColumnList.Columns.Add(IS_NULLABLE, Type.GetType("System.Int32"));
ColumnList.Columns.Add(ORDER, Type.GetType("System.Int32"));
ColumnList.Columns.Add(PKCOLUMN, Type.GetType("System.Int32"));
ColumnList.Columns.Add(PKDESCENDING, Type.GetType("System.Int32"));
// Get the connection string from the current selected configuration
string connstr = SQLDwConfig.GetConnectionString();
string strFolderApplication = UtilGeneral.GetApplicationFolder();
string strFileTableList = strFolderApplication + "\\" + Constants.FOLDER_CONNECTION_TYPE + "\\" + SQLDwConfig.ConnectionType + "\\" + Constants.FILE_COLUMN_LIST;
string sql = System.IO.File.ReadAllText(strFileTableList);
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
comm.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.VarChar));
comm.Parameters["@SchemaName"].Value = strSchemaName;
comm.Parameters.Add(new SqlParameter("@TableName", SqlDbType.VarChar));
comm.Parameters["@TableName"].Value = strTableName;
try
{
SqlDataReader rdr = comm.ExecuteReader();
ColumnList.Load(rdr);
}
catch (Exception ex)
{
throw new System.Exception(ex.ToString());
}
finally
{
conn.Close();
}
}
