private void button8_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(textBox1.Text) == true || string.IsNullOrWhiteSpace(textBox2.Text) == true || string.IsNullOrWhiteSpace(textBox3.Text) == true || string.IsNullOrWhiteSpace(maskedTextBox1.Text) == true || string.IsNullOrWhiteSpace(textBox6.Text) == true) { MessageBox.Show("No se permiten campos vacios"); } else { string Query = "select *from Contactos where Rtn= " + textBox1.Text + ""; contactos cl = new contactos(); if (cl.Buscar(Query) == true) { MessageBox.Show("Rtn ya existe"); } else { string cadenasql = "insert into Contactos values ('" + textBox2.Text + "', '" + textBox3.Text + "','" + maskedTextBox1.Text + "', " + 16 + ", " + int.Parse(textBox6.Text) + ", " + int.Parse(textBox1.Text) + ", " + 1 + ")"; contactos.insetarCon(cadenasql); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox5.Clear(); textBox6.Clear(); textBox1.Clear(); maskedTextBox1.Clear(); this.Hide(); clientes clifrm = new clientes(); clifrm.Show(); } } }
private void button8_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtrtnid.Text) == true || string.IsNullOrWhiteSpace(txtnom.Text) == true || string.IsNullOrWhiteSpace(txtdirec.Text) == true || string.IsNullOrWhiteSpace(comboBox1.Text) == true) { MessageBox.Show("No se permiten campos vacios"); } else { string Query = "select *from CLIENTE where [RTN/ID]= " + txtrtnid.Text + ""; contactos cl = new contactos(); if (cl.Buscar(Query) == true) { MessageBox.Show("Rtn ya existe"); } else { string idtype = "select IDType from IDTypes where Descripcion = '" + comboBox1.Text + "'"; int idbd = 0; idbd = clients.idtypecheck(idtype); string cadenasql = "insert into CLIENTE values (" + txtrtnid.Text + ", '" + txtnom.Text + "', '" + txtdirec.Text + "', " + 16 + ", " + idbd + ");"; clients.insetarclien(cadenasql); txtdirec.Clear(); txtnom.Clear(); txtrtnid.Clear(); comboBox1.Text = " "; this.Hide(); clientes clifrm = new clientes(); clifrm.Show(); } } }
private void button8_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(registro.Text) == true || string.IsNullOrWhiteSpace(desc.Text) == true || string.IsNullOrWhiteSpace(diag.Text) == true || string.IsNullOrEmpty(comboBox1.Text) || string.IsNullOrEmpty(comboBox2.Text) || string.IsNullOrEmpty(comboBox3.Text)) { MessageBox.Show("No se permiten campos vacios"); } else { string Query = "select * from DISPOSITIVO where NumRegistro = " + registro.Text + ""; contactos cl = new contactos(); if (cl.Buscar(Query) == true) { MessageBox.Show("Registro ya existe"); } else { string idtype = "select IDModelo from Modelo where Descripcion = '" + comboBox2.Text + "'"; int idbd = 0; idbd = clients.idtypecheck(idtype); string idtype1 = "select IDTipoDispositivo from TipoDispositivo where Descripcion = '" + comboBox3.Text + "'"; int idbd1 = 0; idbd1 = clients.idtypecheck(idtype1); modeloTest.Text = idbd.ToString(); TipoTest.Text = idbd1.ToString(); string cadenasql = "INSERT INTO DISPOSITIVO(IDMODELO, DESCRIPCION, DIAGNOSTICO, IDCliente, fechaIngreso, Estado, NumRegistro, TipoDispositivo) VALUES (" + idbd + ", '" + desc.Text + "', '" + diag.Text + "', " + idcliente.Text + ", '" + fecha.Text + "', " + 10 + ", " + registro.Text + ", " + idbd1 + ");"; Mantenimiento.insertar(cadenasql); /**************/ foreach (DataGridViewRow row in dgvMostrarItem.Rows) { string constring = @"Data Source=(localdb)\MyInstance;Initial Catalog=IT4;Integrated Security=True"; using (SqlConnection con = new SqlConnection(constring)) { if (Convert.ToBoolean(row.Cells[0].Value) == true) { using (SqlCommand cmd = new SqlCommand("INSERT INTO [Dispositivo/Accesorio] VALUES(@DispoID, @Acc)", con)) { cmd.Parameters.AddWithValue("@DispoID", iddis.Text); cmd.Parameters.AddWithValue("@Acc", row.Cells[2].Value); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } } /**************/ this.Hide(); } } }
private void button8_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(nom.Text) == true || string.IsNullOrWhiteSpace(tel.Text) == true || string.IsNullOrWhiteSpace(comboBox1.Text) == true || string.IsNullOrWhiteSpace(user.Text) == true || string.IsNullOrWhiteSpace(clave.Text) == true) { MessageBox.Show("No se permiten campos vacios"); } else { string Query = "select *from USUARIO where USUARIO= '" + user.Text + "'"; contactos cl = new contactos(); if (cl.Buscar(Query) == true) { MessageBox.Show("USUARIO ya existe"); } else { users us = new users(); string login_pass = clave.Text; MD5 md5 = MD5.Create(); byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(login_pass); byte[] hash = md5.ComputeHash(inputBytes); login_pass = BitConverter.ToString(hash).Replace("-", ""); if (comboBox1.Text == "Administrador") { string cadenasql = "insert into USUARIO values ('" + nom.Text + "', '" + tel.Text + "', '" + user.Text + "', '" + login_pass + "'," + 8 + ", " + 0 + "," + 6 + ");"; users.insertarUser(cadenasql); } else { string cadenasql = "insert into USUARIO values ('" + nom.Text + "', '" + tel.Text + "', '" + user.Text + "', '" + login_pass + "'," + 8 + ", " + 0 + "," + 7 + ");"; users.insertarUser(cadenasql); } //string cadenasql = "insert into USUARIO values ('" + nom.Text + "', '" + tel.Text + "', '" + user.Text + "', '" + clave.Text + "'," + 5 + ", " + 0 + "," + comboBox1.Text + ");"; //users.insertarUser(cadenasql); nom.Clear(); tel.Clear(); user.Clear(); comboBox1.Text = " "; this.Hide(); usuarios user1 = new usuarios(); user1.Show(); } } }
private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(textBox2.Text) == true) { MessageBox.Show("No se permiten espacios en blanco"); textBox2.Clear(); } else { try { string Query = "select *from IDTypes where Descripcion= '" + textBox2.Text + "'"; contactos cl = new contactos(); if (cl.Buscar(Query) == true) { MessageBox.Show("IDType ya existe"); } else { string cadenasql = "insert into IDTypes values ('" + textBox2.Text + "', " + 16 + ")"; contactos.insertar(cadenasql); textBox2.Clear(); textBox1.Text = Mantenimiento.codigoIDTypes().ToString(); ParametrosAdmon form = new ParametrosAdmon(); form.tabControl1.SelectedIndex = 3; form.Show(); this.Hide(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }