public void Leave()
        {
            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_MySql)((ISrcControl)this).X_Result);

            try
            {
                CoreEA.ICoreEAHander tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;

                tempHandler.Open(
                    new LoginInfo_MySql()
                {
                    Database = txtDbName.Text,
                    Pwd      = passwordBox1.Password,
                    Server   = txtServername.Text,
                    Username = txtUsername.Text,
                }
                    );
                if (tempHandler.IsOpened)
                {
                }
                else
                {
                    throw new Exception("Connection not correct");
                }
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }
        public void Leave()
        {
            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_SSCE)((ISrcControl)this).X_Result);

            try
            {
                CoreEA.ICoreEAHander tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler;

                tempHandler.Open(
                    new LoginInfo_SSCE()
                {
                    DbName          = txtDbPath.Text,
                    Pwd             = txtPwd.Password,
                    IsEncrypted     = !string.IsNullOrEmpty(txtPwd.Password),
                    IsCaseSensitive = true,
                }
                    );
                if (tempHandler.IsOpened)
                {
                }
                else
                {
                    throw new Exception("Password not correct");
                }
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }
Example #3
0
        public void Leave()
        {
            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_Effiproz)((ISrcControl)this).X_Result);

            try
            {
                CoreEA.ICoreEAHander tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Effiproz).X_Handler;

                tempHandler.Open(
                    new LoginInfo_Effiproz()
                {
                    InitialCatalog   = DbFullName,
                    Username         = txtUserName.Text,
                    Password         = txtPwd.Password,
                    DBConnectionType = currentDBConnectionType,
                }
                    );
                if (tempHandler.IsOpened)
                {
                }
                else
                {
                    throw new Exception("can't open ");
                }
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }
        public void Leave()
        {
            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_Sqlite)((ISrcControl)this).X_Result);
            try
            {
                CoreEA.ICoreEAHander tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Sqlite).X_Handler;

                tempHandler.Open(
                    new LoginInfo_Sqlite()
                {
                    DbFile = txtSqlFile.Text,
                }
                    );
                if (tempHandler.IsOpened)
                {
                }
                else
                {
                    throw new Exception("Connection not correct");
                }
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }
        private void butEnumDbs_Click(object sender, RoutedEventArgs e)
        {
            txtDbName.DataContext = null;


            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_MySql)((ISrcControl)this).X_Result);

            try
            {
                CoreEA.ICoreEAHander tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;

                tempHandler.Open(
                    new LoginInfo_MySql()
                {
                    Pwd      = passwordBox1.Password,
                    Server   = txtServername.Text,
                    Username = txtUsername.Text,
                }
                    );
                if (tempHandler.IsOpened)
                {
                    List <string> dbList = tempHandler.GetDatabaseList();

                    txtDbName.DataContext = dbList;

                    txtDbName.SelectedIndex = 0;
                }
                else
                {
                    throw new Exception("Connection not correct");
                }
            }
            catch (Exception ee)
            {
                ee.Message.Show();
            }
        }
Example #6
0
        void IStep.Leave()
        {
            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_Oledb)((ISrcControl)this).X_Result);

            try
            {
                CoreEA.ICoreEAHander tempHandler = null;

                if ((bool)radAccess.IsChecked)
                {
                    tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.OleDb).X_Handler;
                }
                else if ((bool)radCVS.IsChecked)
                {
                    tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.CSV).X_Handler;
                }
                else if ((bool)radExcel.IsChecked)
                {
                    tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Excel).X_Handler;
                }

                tempHandler.Open(myInfo.LoginInfo);
                if (tempHandler.IsOpened)
                {
                }
                else
                {
                    throw new Exception("Password not correct");
                }
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }
        void IStep.Leave()
        {
            DocDbObject myInfo = (DocDbObject)MyDocDataContext;

            myInfo.LoginInfo = ((LoginInfo_SqlServer)((ISrcControl)this).X_Result);

            try
            {
                CoreEA.ICoreEAHander tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler;
                SqlServerLoginControl.X_CollectionData curResult = sqlServerLoginControl1.X_Result;

                tempHandler.Open(
                    new LoginInfo_SqlServer()
                {
                    X_Database            = curResult.DbName,
                    X_Server              = curResult.Server,
                    X_UserName            = curResult.UID,
                    X_Pwd                 = curResult.PWD,
                    X_CurDbConnectionMode = curResult.CurType.CurConnMode,
                    IsTrustedConn         = curResult.IsTrust,
                }
                    );

                if (tempHandler.IsOpened)
                {
                }
                else
                {
                    throw new Exception("Connection not correct");
                }
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }