private void button1_Click(object sender, EventArgs e) { try { string query = $"SELECT EXISTS (SELECT * FROM appuser WHERE username = '******' " + $"AND password = '******')"; var dt = ConnectionDB.executeQuery(query); var dr = dt.Rows[0][0]; if ((bool)dr) { string quer = $"SELECT * FROM appuser WHERE username = '******' " + $"AND password = '******'"; var dte = ConnectionDB.executeQuery(quer); Program.activeUser.Id = Convert.ToInt32(dte.Rows[0][0]); Program.activeUser.Name = Convert.ToString(dte.Rows[0][1]); Program.activeUser.Nickname = Convert.ToString(dte.Rows[0][2]); Program.activeUser.Password = Convert.ToString(dte.Rows[0][3]); Program.activeUser.Type = Convert.ToBoolean(dte.Rows[0][4]); this.Hide(); new Form1().Show(); } else { MessageBox.Show("La combinación de usuario y contraseña no existe"); } } catch (Exception exception) { MessageBox.Show("Ha ocurrido un Error"); } }
private void Orders_load(object sender, EventArgs e) { if (Program.activeUser.Type) { tabControl1.TabPages.RemoveByKey("tabPage2"); textBox3.Visible = false; button2.Visible = false; var dt = ConnectionDB.executeQuery("SELECT * FROM apporder"); dataGridView1.DataSource = dt; } else { var dt = ConnectionDB.executeQuery($"SELECT ao.idOrder, ao.createDate, pr.name, au.fullname, ad.address " + "FROM apporder ao, address ad, PRODUCT pr, appuser au " + "WHERE ao.idProduct = pr.idProduct " + "AND ao.idAddress = ad.idAddress " + "AND ad.idUser = au.idUser " + $"AND au.idUser = {Program.activeUser.Id.ToString()};"); dataGridView1.DataSource = dt; var det = ConnectionDB.executeQuery($"SELECT * FROM product"); dataGridView2.DataSource = det; var address = ConnectionDB.executeQuery("SELECT * FROM address " + $"WHERE idUser = {Program.activeUser.Id.ToString()}"); var addressCombo = new List <string>(); foreach (DataRow dr in address.Rows) { addressCombo.Add(dr[0].ToString()); } } }
private void button2_Click(object sender, EventArgs e) { var query = ConnectionDB.executeQuery($"SELECT idBusiness FROM business WHERE name = '{comboBox2.SelectedItem}'"); var dr = query.Rows[0][0]; if (textBox2.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacíos"); } else { try { ConnectionDB.ExecuteNonQuery("INSERT INTO product(idBusiness, name)" + "VALUES(" + $"{dr}," + $"'{textBox2.Text}')"); MessageBox.Show("Agregado exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
private void CrudProduct_Load(object sender, EventArgs e) { var dt = ConnectionDB.executeQuery("SELECT * FROM product"); dataGridView1.DataSource = dt; var business = ConnectionDB.executeQuery("SELECT name FROM business"); var businessCombo = new List <string>(); foreach (DataRow dr in business.Rows) { businessCombo.Add(dr[0].ToString()); } comboBox2.DataSource = businessCombo; }
private void CrudBusiness_Load(object sender, EventArgs e) { var dt = ConnectionDB.executeQuery("SELECT * FROM business"); dataGridView1.DataSource = dt; }