private void button1_Click(object sender, EventArgs e) { bool ban = true; if (textBox1.Text == "" || textBox1.Text == " ") { MessageBox.Show("Ingrese número de sucursal corrrectamente"); ban = false; } else if (ban == true) { //condicionar el area y sucursal para el cambio string connectionString = "datasource=10.108.1.93;port=3306;username=rootadmin;password=admin735;database=directorio;SslMode = none;"; string querya = "SELECT sucursales FROM `sucursal` WHERE ID_SUCURSAL=" + textBox1.Text.Trim(); MySqlConnection databaseConnection2 = new MySqlConnection(connectionString); MySqlCommand commandDatabase2 = new MySqlCommand(querya, databaseConnection2); MySqlDataReader reader2; databaseConnection2.Open(); string elim; reader2 = commandDatabase2.ExecuteReader(); using (reader2) while (reader2.Read()) { textBox5.Text = reader2["sucursales"].ToString(); } elim = textBox5.Text; if (MessageBox.Show("¿Desea eliminar la sucursal " + elim + "?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { deleteUserarea(); deleteUserareas2(); GetDataarea(); Loadlistarea(); textBox1.Clear(); textBox5.Clear(); Form1 frm1 = new Form1(); Form2 frm2 = new Form2(); frm1.Actualizar(); frm2.Actualizar(); ID(); } else { textBox1.Clear(); textBox5.Clear(); ID(); } } }
private void Guardar_Click(object sender, EventArgs e) { bool ban = false; if (textBox1.Text == "" || textBox5.Text == "") { MessageBox.Show("Ingrese Datos Corrrectamente"); ban = true; } else if (ban == false) { string connectionString = "datasource=10.108.1.93;port=3306;username=rootadmin;password=admin735;database=directorio;SslMode = none;"; string querya = "SELECT sucursales FROM `sucursal` WHERE sucursales LIKE '" + '%' + textBox5.Text + '%' + "' "; MySqlConnection databaseConnection2 = new MySqlConnection(connectionString); MySqlCommand commandDatabase2 = new MySqlCommand(querya, databaseConnection2); MySqlDataReader reader2; databaseConnection2.Open(); string guarda; reader2 = commandDatabase2.ExecuteReader(); using (reader2) while (reader2.Read()) { textBox2.Text = reader2["sucursales"].ToString(); } guarda = textBox5.Text; if (MessageBox.Show("¿Desea guardar la sucursal " + guarda + "?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { if (guarda == textBox2.Text) { MessageBox.Show("Esta sucursal ya existe, verificar los datos ingresados"); textBox1.Clear(); textBox5.Clear(); } else if (guarda != textBox2.Text) { SaveUserarea(); GetDataarea(); Loadlistarea(); textBox1.Clear(); textBox5.Clear(); Form1 frm1 = new Form1(); Form2 frm2 = new Form2(); frm1.Actualizar(); frm2.Actualizar(); ID(); } } else { textBox1.Clear(); textBox5.Clear(); ID(); } } }
private void button2_Click(object sender, EventArgs e) { bool ban = false; if (comboBox1.SelectedIndex.Equals(-1) || comboBox1.Text == "" || comboBox2.SelectedIndex.Equals(-1) || comboBox2.Text == "") { MessageBox.Show("Seleccione área y sucursal"); ban = true; } else if (ban == false) { string connectionString = "datasource=10.108.1.93;port=3306;username=rootadmin;password=admin735;database=directorio;SslMode = none;"; string querya = "SELECT * FROM `areasysucursales` WHERE area LIKE '" + '%' + comboBox2.Text + '%' + "' " + "AND sucursal LIKE '" + '%' + comboBox1.Text + '%' + "' "; MySqlConnection databaseConnection2 = new MySqlConnection(connectionString); MySqlCommand commandDatabase2 = new MySqlCommand(querya, databaseConnection2); MySqlDataReader reader2; databaseConnection2.Open(); string guarda, guarda2; reader2 = commandDatabase2.ExecuteReader(); using (reader2) while (reader2.Read()) { textBox5.Text = reader2["area"].ToString(); textBox2.Text = reader2["sucursal"].ToString(); } guarda = comboBox2.Text; guarda2 = comboBox1.Text; if (MessageBox.Show("¿Desea agregar el área " + guarda + " a la sucursal " + guarda2 + " ?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { SaveUserareas(); GetDataareas(); Loadlistareas(); textBox1.Clear(); textBox5.Clear(); Form1 frm1 = new Form1(); Form2 frm2 = new Form2(); frm1.Actualizar(); frm2.Actualizar(); } else { comboBox1.Text = ""; comboBox2.Text = ""; } } }