コード例 #1
0
ファイル: Authorization.cs プロジェクト: Tsarar/Hospital2
        public Authorization()
        {
            InitializeComponent();

            _connect           = new DBConnectorMySQL();
            _componentSettings = new ComponentsSetting();
        }
コード例 #2
0
        public Registration(DBConnectorMySQL connect)
        {
            InitializeComponent();

            _connect = connect;

            NameTextBox.GotFocus  += RemovePlaceholder;
            NameTextBox.LostFocus += AddPlaceholderName;

            LoginTextBox.GotFocus  += RemovePlaceholder;
            LoginTextBox.LostFocus += AddPlaceholderLogin;

            PasswordTextBox.GotFocus  += RemovePlaceholder;
            PasswordTextBox.LostFocus += AddPlaceholderPassword;

            CodeTextBox.GotFocus  += RemovePlaceholder;
            CodeTextBox.LostFocus += AddPlaceholderCode;
        }
コード例 #3
0
 static DataFabric()
 {
     _connect = new DBConnectorMySQL();
 }
コード例 #4
0
        private void btnConnect_Click(object sender, EventArgs e)
        {
            if (cmbDriver.SelectedIndex == 0)
            {
                DBConnectorDB2 conn = new DBConnectorDB2(@txtServer.Text, int.Parse(txtPortNum.Text), @txtUsername.Text, @txtPassword.Text, txtDBName.Text, chkIntegrated.Checked);
                if (conn.CanConnect())
                {
                    MessageBox.Show("Connection successful!");
                }
                else
                {
                    string tmpMessage = "";
                    foreach (Error error in conn.ErrorList)
                    {
                        tmpMessage += error.Message + " " + error.RoutineName + Environment.NewLine;
                    }
                    MessageBox.Show(tmpMessage);
                }
            }
            else if (cmbDriver.SelectedIndex == 1)
            {
                DBConnectorOracle conn = new DBConnectorOracle(@txtServer.Text, @txtDBName.Text, @txtUsername.Text, txtPassword.Text,
                                                               Convert.ToBoolean(cmbPersist.SelectedItem), integratedSecurity, 40);
                if (conn.CanConnect())
                {
                    MessageBox.Show("Connection successful!");
                }
                else
                {
                    string tmpMessage = "";
                    foreach (Error error in conn.ErrorList)
                    {
                        tmpMessage += error.Message + " " + error.RoutineName + Environment.NewLine;
                    }
                    MessageBox.Show(tmpMessage);
                }
            }
            else if (cmbDriver.SelectedIndex == 2)
            {
                DBConnectorMSSQL conn = new DBConnectorMSSQL(@txtServer.Text, @txtDBName.Text, @txtUsername.Text, txtPassword.Text,
                                                             Convert.ToBoolean(cmbPersist.SelectedItem), integratedSecurity, 40);

                if (conn.CanConnect())
                {
                    MessageBox.Show("Connection successful!");
                }
                else
                {
                    string tmpMessage = "";
                    foreach (Error error in conn.ErrorList)
                    {
                        tmpMessage += error.Message + " " + error.RoutineName + Environment.NewLine;
                    }
                    MessageBox.Show(tmpMessage);
                }
            }
            else if (cmbDriver.SelectedIndex == 3)
            {
                DBConnectorPostgreSQL conn = new DBConnectorPostgreSQL(@txtServer.Text, @txtDBName.Text, @txtUsername.Text, txtPassword.Text,
                                                                       Convert.ToBoolean(cmbPersist.SelectedItem), 40, 40);

                if (conn.CanConnect())
                {
                    MessageBox.Show("Connection successful!");
                }
                else
                {
                    string tmpMessage = "";
                    foreach (Error error in conn.ErrorList)
                    {
                        tmpMessage += error.Message + " " + error.RoutineName + Environment.NewLine;
                    }
                    MessageBox.Show(tmpMessage);
                }
            }
            else if (cmbDriver.SelectedIndex == 4)
            {
                DBConnectorMySQL conn = new DBConnectorMySQL(@txtServer.Text, @txtDBName.Text, @txtUsername.Text, txtPassword.Text,
                                                             Convert.ToBoolean(cmbPersist.SelectedItem), integratedSecurity, 40, 40);

                if (conn.CanConnect())
                {
                    MessageBox.Show("Connection successful!");
                }
                else
                {
                    string tmpMessage = "";
                    foreach (Error error in conn.ErrorList)
                    {
                        tmpMessage += error.Message + " " + error.RoutineName + Environment.NewLine;
                    }
                    MessageBox.Show(tmpMessage);
                }
            }
        }