private void btnSourceCnn_Click(object sender, EventArgs e)
{
if (GetSourceConnectionClick != null)
{
GetSourceConnectionClick.Invoke(this, out sourceCnn);
if (sourceCnn != string.Empty)
{
sqlSourceCopier = new SqlCopier(sourceCnn);
this.gridSource.DataSource = sqlSourceCopier.GetAllTables();
}
}
}
private void btnDestCnn_Click(object sender, EventArgs e)
{
if (GetDestinationConnectionClick != null)
{
GetDestinationConnectionClick.Invoke(this, out destCnn);
if (destCnn != string.Empty)
{
sqlDestCopier = new SqlCopier(destCnn);
this.gridDestination.DataSource = sqlDestCopier.GetAllTables();
}
}
}
private static void RegisterSuccess()
{
if (ConfigurationManager.ConnectionStrings["dbEcustomEntities"] == null)
{
Application.Run(new frmConfigSQL());
}
if (ConfigurationManager.ConnectionStrings["dbEcustomEntities"] == null)
{
Application.Exit();
return;
}
string connectionString =
Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true);
connectionString = connectionString.Substring(connectionString.IndexOf('\'') == -1 ? 0 : connectionString.IndexOf('\'')).Trim('\'');
SqlCopier sqlCopier = new SqlCopier(connectionString);
var tables = sqlCopier.GetAllTables();
var tblSettings = tables.FirstOrDefault(item => item.Name.ToLower() == "tblsettings");
if (tblSettings == null)
{
ConfirmUpgradeDB();
//frmUpgradeDatabase upgradeDatabase = new frmUpgradeDatabase(ConstantInfo.CurrentVersion, connectionString);
Application.Run(new frmUpgradeDatabase(ConstantInfo.CurrentVersion, connectionString));
}
else
{
var data = sqlCopier.GetDataFromTable(tblSettings.Name);
var version = (data.Rows.Count == 0 ? ConstantInfo.CurrentVersion : data.Rows[0]["Version"].ToString());
if (version != UpgradeDatabase.CommandNames[UpgradeDatabase.CommandNames.Length - 1])
{
ConfirmUpgradeDB();
Application.Run(new frmUpgradeDatabase(version, connectionString));
}
}
Application.Run(new frmLogin());
}
