private void button1_Click(object sender, EventArgs e) { //MessageBox.Show("Funcionalidad no desarrollada", "Funcionalidad no desarrollada", MessageBoxButtons.OK, MessageBoxIcon.Error); ABM_de_Cliente.AltaCliente f = new ABM_de_Cliente.AltaCliente(this, back, back2, param); f.Show(); this.Hide(); }
private void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count != 0) { //string[] result = dataGridView1.SelectedCells[1].Value.ToString().Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); string[] param = new string[16]; param[0] = dataGridView1.SelectedCells[0].Value.ToString(); //id param[1] = dataGridView1.SelectedCells[1].Value.ToString(); //nombre param[2] = dataGridView1.SelectedCells[2].Value.ToString(); //apellido param[3] = dataGridView1.SelectedCells[3].Value.ToString(); //tipo doc param[4] = dataGridView1.SelectedCells[4].Value.ToString(); //numero param[5] = dataGridView1.SelectedCells[5].Value.ToString(); //mail param[6] = dataGridView1.SelectedCells[6].Value.ToString(); //telefono param[7] = dataGridView1.SelectedCells[7].Value.ToString(); //localidad param[8] = dataGridView1.SelectedCells[8].Value.ToString(); //pais param[9] = dataGridView1.SelectedCells[9].Value.ToString(); //calle param[10] = dataGridView1.SelectedCells[10].Value.ToString(); //nro calle param[11] = dataGridView1.SelectedCells[11].Value.ToString(); //depto param[12] = dataGridView1.SelectedCells[12].Value.ToString(); //piso param[13] = dataGridView1.SelectedCells[13].Value.ToString(); //nacionalidad param[14] = dataGridView1.SelectedCells[14].Value.ToString(); //estado param[15] = dataGridView1.SelectedCells[15].Value.ToString(); //nacimiento Form f = new ABM_de_Cliente.AltaCliente(this, param, 2, false); f.Show(); } else { MessageBox.Show("No hay datos que modificar", "No se puede modificar", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnCrear_Click(object sender, EventArgs e) { ABM_de_Cliente.AltaCliente form = new ABM_de_Cliente.AltaCliente(); form.Location = this.Location; form.StartPosition = FormStartPosition.CenterScreen; form.FormClosing += delegate { this.Show(); }; form.ShowDialog(); }
private void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count != 0) { //string[] result = dataGridView1.SelectedCells[1].Value.ToString().Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); Form f = new ABM_de_Cliente.AltaCliente(this, dataGridView1.SelectedCells[1].Value.ToString(), //nombre dataGridView1.SelectedCells[2].Value.ToString(), //apellido dataGridView1.SelectedCells[3].Value.ToString(), //tipo doc dataGridView1.SelectedCells[4].Value.ToString(), //numero dataGridView1.SelectedCells[5].Value.ToString(), //mail dataGridView1.SelectedCells[6].Value.ToString(), //telefono dataGridView1.SelectedCells[9].Value.ToString(), //calle dataGridView1.SelectedCells[7].Value.ToString(), //localidad dataGridView1.SelectedCells[8].Value.ToString(), //pais dataGridView1.SelectedCells[13].Value.ToString(), //nacionalidad dataGridView1.SelectedCells[15].Value.ToString()); //nacimiento f.Show(); } else { MessageBox.Show("No hay datos que modificar", "No se puede modificar", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { if ((dataGridView1.SelectedCells.Count != 0) && (modo == 2)) { //string[] result = dataGridView1.SelectedCells[1].Value.ToString().Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); string[] param = new string[16]; param[0] = dataGridView1.SelectedCells[0].Value.ToString(); //id param[1] = dataGridView1.SelectedCells[1].Value.ToString(); //nombre param[2] = dataGridView1.SelectedCells[2].Value.ToString(); //apellido param[3] = dataGridView1.SelectedCells[3].Value.ToString(); //tipo doc param[4] = dataGridView1.SelectedCells[4].Value.ToString(); //numero param[5] = dataGridView1.SelectedCells[5].Value.ToString(); //mail param[6] = dataGridView1.SelectedCells[6].Value.ToString(); //telefono param[7] = dataGridView1.SelectedCells[7].Value.ToString(); //localidad param[8] = dataGridView1.SelectedCells[8].Value.ToString(); //pais param[9] = dataGridView1.SelectedCells[9].Value.ToString(); //calle param[10] = dataGridView1.SelectedCells[10].Value.ToString(); //nro calle param[11] = dataGridView1.SelectedCells[11].Value.ToString(); //depto param[12] = dataGridView1.SelectedCells[12].Value.ToString(); //piso param[13] = dataGridView1.SelectedCells[13].Value.ToString(); //nacionalidad param[14] = dataGridView1.SelectedCells[14].Value.ToString(); //estado param[15] = dataGridView1.SelectedCells[15].Value.ToString(); //nacimiento Form f = new ABM_de_Cliente.AltaCliente(this, param, 2, true); f.Show(); } else if ((dataGridView1.SelectedCells.Count != 0) && (modo == 3)) { string ConnStr = ConfigurationManager.AppSettings["stringConexion"]; SqlConnection con = new SqlConnection(ConnStr); con.Open(); SqlCommand scCommand; scCommand = new SqlCommand("CONTROL_ZETA.MB_CLIENTE", con); scCommand.CommandType = CommandType.StoredProcedure; scCommand.Parameters.AddWithValue("@NOMBRE", DBNull.Value); scCommand.Parameters.AddWithValue("@APELLIDO", DBNull.Value); scCommand.Parameters.Add("@TIPO_IDENT", SqlDbType.TinyInt).Value = int.Parse(dataGridView1.SelectedCells[3].Value.ToString()); scCommand.Parameters.Add("@NRO_IDENT", SqlDbType.VarChar, 15).Value = dataGridView1.SelectedCells[4].Value.ToString(); scCommand.Parameters.Add("@EMAIL", SqlDbType.VarChar, 50).Value = dataGridView1.SelectedCells[5].Value.ToString(); scCommand.Parameters.AddWithValue("@TEL", DBNull.Value); scCommand.Parameters.AddWithValue("@NOMBRE_LOC", DBNull.Value); scCommand.Parameters.AddWithValue("@NOMBRE_PAIS", DBNull.Value); scCommand.Parameters.AddWithValue("@DOM_CALLE", DBNull.Value); scCommand.Parameters.AddWithValue("@DOM_NRO", DBNull.Value); scCommand.Parameters.AddWithValue("@DEPTO", DBNull.Value); scCommand.Parameters.AddWithValue("@DOM_PISO", DBNull.Value); scCommand.Parameters.AddWithValue("@NACIONALIDAD_NOMBRE", DBNull.Value); scCommand.Parameters.AddWithValue("@FECHA_NAC", DBNull.Value); scCommand.Parameters.AddWithValue("@CODIGO_ENTRADA", SqlDbType.TinyInt).Value = 3; scCommand.Parameters.Add("@CLIENTE_ID", SqlDbType.Int).Value = int.Parse(dataGridView1.SelectedCells[0].Value.ToString()); scCommand.Parameters.Add("@CODIGO", SqlDbType.TinyInt).Direction = ParameterDirection.Output; // scCommand.Parameters.Add("@CLIENTE_ID_NEW", SqlDbType.Int).Direction = ParameterDirection.Output; if (scCommand.Connection.State == ConnectionState.Closed) { scCommand.Connection.Open(); } scCommand.ExecuteNonQuery(); int result = int.Parse(scCommand.Parameters["@CODIGO"].Value.ToString()); switch (result) { case 1: { MessageBox.Show("Operacion realizada exitosamente", "Operacion realizada", MessageBoxButtons.OK, MessageBoxIcon.Information); break; } case 2: { MessageBox.Show("Modificacion/Baja de usuario inexistente", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } case 3: { MessageBox.Show("Alta de usuario existente", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } default: { string mensaje = string.Format("Error en la operacion, COD: {0}", result); MessageBox.Show(mensaje, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } con.Close(); back.Show(); this.Close(); } else { MessageBox.Show("No hay datos que modificar", "No se puede modificar", MessageBoxButtons.OK, MessageBoxIcon.Error); } }