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 = "";
}
}
}
