private void button6_Click(object sender, EventArgs e) { if (textBox5.Text.Equals("")) { MessageBox.Show("Llene todos los campos"); } else { try { var qr = $"SELECT idBusiness FROM public.business WHERE" + $" name = '{comboBox3.GetItemText(comboBox3.SelectedItem)}'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int id4 = Convert.ToInt32(dt.Rows[0][0].ToString()); ConnectionBD.ExecuteNonQuery($"INSERT INTO public.product(idBusiness, name)" + $" VALUES({id4}, '{textBox5.Text}')"); MessageBox.Show("Se ha guardado el producto"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
private void button3_Click(object sender, EventArgs e) { if (textBox2.Text.Equals("")) { MessageBox.Show("Llene todos los campos"); } else { try { var qr = $"SELECT idAddress FROM public.address WHERE" + $" address = '{comboBox2.GetItemText(comboBox2.SelectedItem)}'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int id2 = Convert.ToInt32(dt.Rows[0][0].ToString()); //MODIFICAR DIRECCION ConnectionBD.ExecuteNonQuery( $"UPDATE public.address SET address = '{textBox2.Text}' WHERE idAddress = {id2}"); MessageBox.Show("Se ha modificado la direccion"); } catch (Exception ex) { MessageBox.Show("ha ocurrido un error"); } } }
private void button4_Click(object sender, EventArgs e) { try { var qr = $"SELECT idAddress FROM public.address WHERE" + $" address = '{comboBox4.GetItemText(comboBox4.SelectedItem)}'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int id3 = Convert.ToInt32(dt.Rows[0][0].ToString()); var qr2 = $"SELECT idProduct FROM public.product WHERE" + $" name = '{comboBox3.GetItemText(comboBox3.SelectedItem)}'"; DataTable dt2 = ConnectionBD.ExecuteQuery(qr2); int id4 = Convert.ToInt32(dt2.Rows[0][0].ToString()); var date = ((DateTime.Now)).ToString(@"yyyy-MM-dd");; ConnectionBD.ExecuteNonQuery($"INSERT INTO public.appOrder(createDate, idProduct, idAddress)" + $" VALUES('{date}', {id4}, {id3})"); MessageBox.Show("Su orden ha sido procesada"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error!"); } }
private void button7_Click(object sender, EventArgs e) { var qr = $"SELECT idProduct FROM public.product WHERE name" + $" = '{comboBox4.GetItemText(comboBox4.SelectedItem)}'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int id5 = Convert.ToInt32(dt.Rows[0][0].ToString()); ConnectionBD.ExecuteNonQuery($"DELETE FROM public.product WHERE idProduct = {id5}"); MessageBox.Show("El producto ha sido eliminado!"); }
private void button5_Click(object sender, EventArgs e) { var qr = $"SELECT idBusiness FROM public.business WHERE" + $" name = '{comboBox2.GetItemText(comboBox2.SelectedItem)}'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int id3 = Convert.ToInt32(dt.Rows[0][0].ToString()); ConnectionBD.ExecuteNonQuery($"DELETE FROM public.business WHERE idBusiness = {id3}"); MessageBox.Show("El negocio ha sido eliminado!"); }
private void button2_Click_1(object sender, EventArgs e) { var qr = $"SELECT idUser FROM public.appuser WHERE" + $" username = '******'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int idd = Convert.ToInt32(dt.Rows[0][0].ToString()); ConnectionBD.ExecuteNonQuery($"DELETE FROM public.appuser WHERE idUser = {idd}"); MessageBox.Show("El usuario ha sido eliminado!"); }
private void button2_Click(object sender, EventArgs e) { var qr = $"SELECT idAddress FROM public.address WHERE" + $" address = '{comboBox1.GetItemText(comboBox1.SelectedItem)}'"; DataTable dt = ConnectionBD.ExecuteQuery(qr); int idd = Convert.ToInt32(dt.Rows[0][0].ToString()); ConnectionBD.ExecuteNonQuery($"DELETE FROM public.address WHERE idAddress = {idd}"); MessageBox.Show("La direccion ha sido eliminada!"); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("")) { MessageBox.Show("Llene todos los campos"); } else { try { var sl = $"SELECT * FROM public.appuser WHERE username = '******'"; var dt = ConnectionBD.ExecuteQuery(sl); if (dt != null) { if (checkBox1.Checked) { ConnectionBD.ExecuteNonQuery($"INSERT INTO" + $" public.appuser(fullname, username, password," + $" userType) VALUES('{textBox1.Text}', '{textBox2.Text}'," + $" '{textBox2.Text}'," + $" {true})"); } else { ConnectionBD.ExecuteNonQuery($"INSERT INTO" + $" public.appuser(fullname, username, password," + $" userType) VALUES('{textBox1.Text}', '{textBox2.Text}'," + $" '{textBox2.Text}'," + $" {false})"); } MessageBox.Show("El usuario ha sido creado"); } } catch (Exception ex) { MessageBox.Show("El usuario ya existe..."); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Llene todos los campos!"); } else { try { ConnectionBD.ExecuteNonQuery($"INSERT INTO public.address(idUser, address)" + $" VALUES({id}, '{textBox1.Text}')"); MessageBox.Show("La direccion se ha guardado!"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error!"); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("") || textBox3.Text.Equals("") || textBox4.Text.Equals("")) { MessageBox.Show("Llene todos los campos"); } else { try { string query = $"SELECT * FROM public.appuser WHERE username='******' AND password='******'"; var dt = ConnectionBD.ExecuteQuery(query); if (dt.Rows.Count == 1) { if (textBox3.Text.Equals(textBox4.Text)) { ConnectionBD.ExecuteNonQuery($"UPDATE public.appuser SET password = '******' WHERE" + $" username = '******'"); MessageBox.Show("Se ha actualizado la contraseña"); Hide(); new Form1().Show(); } } else { MessageBox.Show("Usuario y/o Contraseña Incorrecta"); } } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error!"); } } }
private void button4_Click(object sender, EventArgs e) { if (textBox3.Text.Equals("") || textBox4.Text.Equals("")) { MessageBox.Show("Llene todos los campos"); } else { try { ConnectionBD.ExecuteNonQuery($"INSERT INTO public.business(name, description)" + $" VALUES('{textBox3.Text}', '{textBox4.Text}')"); MessageBox.Show("Se ha creado el negocio"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }