private void button_List_Click(object sender, EventArgs e) { var nameEm = comboBox_EmList.SelectedItem.ToString(); var buiss = ConectionBD.ExexuteQuery($"SELECT \"idBussiness\" FROM \"BUSSINESS\"" + $" WHERE \"name\" = '{nameEm}'"); var buisID = buiss.Rows[0][0].ToString(); var productoDT = ConectionBD.ExexuteQuery($"SELECT \"idProduct\",\"name\" FROM \"PRODUCT\"" + $" WHERE \"idBussiness\" = {buisID};"); dataGridView1.DataSource = productoDT; }
private void Products_Load(object sender, EventArgs e) { var buiss = ConectionBD.ExexuteQuery("SELECT name FROM \"BUSSINESS\""); var buisCombo = new List <string>(); foreach (DataRow dr in buiss.Rows) { buisCombo.Add(dr[0].ToString()); } comboBox_EmNew.DataSource = buisCombo; comboBox_EmDelete.DataSource = buisCombo; comboBox_EmList.DataSource = buisCombo; }
private void IniciarSesion_button_Click(object sender, EventArgs e) { if (Usuario_textBox.Text.Equals("") || Contraseña_textBox.Text.Equals("")) { MessageBox.Show("No se puede dejar datos vacios"); } else { try { var txtUsuario = Usuario_textBox.Text; var txtContra = Contraseña_textBox.Text; var Select = ConectionBD.ExexuteQuery($"SELECT username, password, \"userType\" FROM" + $" \"APPUSER\" WHERE username = '******' " + $"AND password = '******'"); foreach (DataRow dr in Select.Rows) { if (dr[2].ToString().Equals("Admin")) { AdminForm AF = new AdminForm(); AF.Show(); } else if (dr[2].ToString().Equals("Normal")) { NormalForm NF = new NormalForm(); NF.Show(); } } } catch (Exception ex) { MessageBox.Show("Ocurrio un error"); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox_NameProduct.Text.Equals("")) { MessageBox.Show("No dejar campos vacios"); } else { try { var select = comboBox_EmNew.SelectedItem.ToString(); var buiss = ConectionBD.ExexuteQuery($"SELECT \"idBussiness\" FROM \"BUSSINESS\" " + $"WHERE \"name\" = '{select}'"); var buisID = buiss.Rows[0][0].ToString(); ConectionBD.ExecuteNonQuiery($"INSERT INTO \"PRODUCT\" (name,\"idBussiness\")" + $" VALUES ('{textBox_NameProduct.Text}',{buisID})"); MessageBox.Show("Se creo el nuevo producto"); } catch (Exception ex) { MessageBox.Show("Ocurrio un error"); } } }
private void button_CargarUsuarios_Click(object sender, EventArgs e) { var dat = ConectionBD.ExexuteQuery("SELECT * FROM \"APPUSER\""); dataGridView1.DataSource = dat; }
private void button1_Click(object sender, EventArgs e) { var dat = ConectionBD.ExexuteQuery("SELECT * FROM \"BUSSINESS\""); dataGridView1.DataSource = dat; }