Exemplo n.º 1
0
        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());
        }