private void button1_Click(object sender, EventArgs e) { FormAuthoriz formAuthoriz = new FormAuthoriz(); formAuthoriz.Show(); this.Hide(); }
private void btConect_Click(object sender, EventArgs e) { Registry_Class registry = new Registry_Class(); registry.Registry_Set(cbIPServer.Text, cbDataSource.Text, cbInitialCatalog.Text, tbUserID.Text, tbPassword.Text); //((FormAuthoriz)Owner).FormAuthoriz_Load(sender, e); FormAuthoriz formAuthoriz = new FormAuthoriz(); formAuthoriz.Show(); DataBase_Configuration.logCon = true; Close(); }
private void buttonReg_Click(object sender, EventArgs e) { try { string Regist = "INSERT INTO Accounts(Login_accounts, Password_accounts, Roles_id, Accounts_Logical_Delete) VALUES('" + textBoxLogin.Text + "', '" + cueTextBoxPassword.Text + "', 5, 0)"; string CountLogin1 = "SELECT COUNT(Login_accounts) FROM Accounts WHERE Login_accounts = '" + textBoxLogin.Text + "'"; string Emp = "INSERT INTO Employee(Login_employee, Surname_employee, Name_employee, Patronymic_employee, Position_id, Employee_Logical_Delete) VALUES('" + textBoxLogin.Text + "', '" + textBoxFam.Text + "', '" + textBoxName.Text + "', '" + textBoxMiddleName.Text + "', '" + (comboBoxPosition.SelectedIndex + 1) + "', 0)"; FormAuthoriz.sql.Open(); SqlCommand cmdLogin1 = new SqlCommand(CountLogin1, FormAuthoriz.sql); SqlCommand cmdRegistr1 = new SqlCommand(Regist, FormAuthoriz.sql); SqlCommand cmdRegistr2 = new SqlCommand(Emp, FormAuthoriz.sql); int count1 = Convert.ToInt32(cmdLogin1.ExecuteScalar()); FormAuthoriz.sql.Close(); if (cueTextBoxPassword.Text == textBoxReturnPassword.Text) //если пароль соответствует повторению { if (count1 > 0) //если уже есть такой логин { MessageBox.Show("Данная учётная запись уже существует"); } else //если новый логин { FormAuthoriz.sql.Open(); cmdRegistr1.ExecuteNonQuery(); cmdRegistr2.ExecuteNonQuery(); FormAuthoriz.sql.Close(); MessageBox.Show("Учетная запись успешно создана"); FormAuthoriz fa = new FormAuthoriz(); fa.Show(); this.Hide(); } } else //если не соответствует { textBoxReturnPassword.BackColor = Color.BlueViolet; } } catch (Exception ex) { MessageBox.Show("Проверьте правильность заполнения полей", ex.ToString()); } }