private void button1_Click(object sender, EventArgs e) { if (comboBox1.SelectedItem == null) { throw new NotBusinessSelected("No se ha seleccionado un restaurante"); } else { try { ConnectionBD.ExecuteNonQuery($"INSERT INTO PRODUCT(idBusiness, name) " + $"VALUES('{comboBox1.SelectedValue}', '{textBox1.Text}');"); MessageBox.Show("Se ha agregado el producto"); } catch (NotBusinessSelected ex) { MessageBox.Show(ex.Message); } 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("")) { MessageBox.Show("No se pueden dejar campos vacios"); } else { try { if (radioButton1.Checked) { ConnectionBD.ExecuteNonQuery($"INSERT INTO APPUSER (fullname, username, password, userType) " + $"VALUES ('{textBox1.Text}', " + $"'{textBox2.Text}', '{textBox3.Text}' ,'{true}')"); MessageBox.Show("Se registro un administrador exitosamente"); } else { ConnectionBD.ExecuteNonQuery($"INSERT INTO APPUSER (fullname, username, password, userType) " + $"VALUES ('{textBox1.Text}', " + $"'{textBox2.Text}', '{textBox3.Text}' ,'{false}')"); MessageBox.Show("Se registro un usuario exitosamente"); } } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error!"); } } }
private void RemoveUser_Load(object sender, EventArgs e) { var name = ConnectionBD.ExecuteQuery("SELECT username FROM APPUSER"); var nameCombo = new List <string>(); foreach (DataRow dr in name.Rows) { nameCombo.Add(dr[0].ToString()); } comboBox1.DataSource = nameCombo; }
private void PoblarControles() { var users = ConnectionBD.ExecuteQuery("SELECT username FROM appuser"); var usersNames = new List <string>(); foreach (DataRow dr in users.Rows) { usersNames.Add(dr[0].ToString()); } comboBox1.DataSource = usersNames; }
private void button1_Click(object sender, EventArgs e) { try { string nonQuery = $"DELETE FROM BUSINESS WHERE idBusiness ={comboBox1.SelectedValue}"; ConnectionBD.ExecuteNonQuery(nonQuery); MessageBox.Show("Se ha eliminado el negocio"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } }
private void button1_Click(object sender, EventArgs e) { try { if (comboBox1.SelectedItem == null) { MessageBox.Show("Debe de escoger una dirección"); } else { ConnectionBD.ExecuteNonQuery($"DELETE FROM ADDRESS WHERE idAddress = '{comboBox1.SelectedValue}'"); MessageBox.Show("Se ha eliminado la dirección"); } } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } }
private void button8_Click(object sender, EventArgs e) { try { var dt = ConnectionBD.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; "); dataGridView1.DataSource = dt; MessageBox.Show("Se obtuvieron los datos exitosamente"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error"); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Se necesita de una dirección"); } else { try { ConnectionBD.ExecuteNonQuery($"INSERT INTO ADDRESS(idUser, address) " + $"VALUES({currentUser.IdUser}, '{textBox1.Text})"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
private void button1_Click(object sender, EventArgs e) { try { if (comboBox1.SelectedItem == null) { MessageBox.Show("No se ha escogido un producto"); } else { ConnectionBD.ExecuteNonQuery($"DELETE FROM PRODUCT WHERE idProduct = '{comboBox1.SelectedValue}'"); MessageBox.Show("Se ha eliminado el producto"); } } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } }
public static List <Product> getLista() { string sql = "select * from PRODUCT"; DataTable dt = ConnectionBD.ExecuteQuery(sql); List <Product> lista = new List <Product>(); foreach (DataRow fila in dt.Rows) { Product pr = new Product(); pr.IdProduct = Convert.ToInt32(fila[0].ToString()); pr.IdBusiness = Convert.ToInt32(fila[1].ToString()); pr.Name = fila[2].ToString(); lista.Add(pr); } return(lista); }
public static List <Business> getLista() { string sql = "select * from BUSINESS"; DataTable dt = ConnectionBD.ExecuteQuery(sql); List <Business> lista = new List <Business>(); foreach (DataRow fila in dt.Rows) { Business bu = new Business(); bu.IdBusiness = Convert.ToInt32(fila[0].ToString()); bu.Name = fila[1].ToString(); bu.Description = fila[2].ToString(); lista.Add(bu); } return(lista); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacios"); } else { try { ConnectionBD.ExecuteNonQuery($"INSERT INTO BUSINESS(name, description) " + $"VALUES('{textBox1.Text}', '{textBox2.Text}');"); MessageBox.Show("Se agrego un negocio exitosamente"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
public static List <Address> getLista() { string sql = "select * from ADDRESS"; DataTable dt = ConnectionBD.ExecuteQuery(sql); List <Address> lista = new List <Address>(); foreach (DataRow fila in dt.Rows) { Address ad = new Address(); ad.IdAddress = Convert.ToInt32(fila[0].ToString()); ad.IdUser = Convert.ToInt32(fila[1].ToString()); ad.Addreess = fila[1].ToString(); lista.Add(ad); } return(lista); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacio"); } else { try { ConnectionBD.ExecuteNonQuery($"UPDATE ADDRESS SET address = '{textBox1.Text}' " + $"WHERE idAddress = {comboBox1.SelectedValue}"); MessageBox.Show("Se modificó la dirección"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }
public static List <User> getLista() { string sql = "select * from APPUSER"; DataTable dt = ConnectionBD.ExecuteQuery(sql); List <User> lista = new List <User>(); foreach (DataRow fila in dt.Rows) { User u = new User(); u.IdUser = Convert.ToInt32(fila[0].ToString()); u.FullName = fila[1].ToString(); u.UserName = fila[2].ToString(); u.Password = fila[3].ToString(); u.UserType = Convert.ToBoolean(fila[4].ToString()); lista.Add(u); } return(lista); }
private void button1_Click(object sender, EventArgs e) { try { string query = $"SELECT idUser FROM APPUSER WHERE username = '******'"; var dt = ConnectionBD.ExecuteQuery(query); var dr = dt.Rows[0]; var idUsuario = Convert.ToInt32(dr[0].ToString()); string nonQuery = $"DELETE FROM APPUSER WHERE idUser = {idUsuario}"; ConnectionBD.ExecuteNonQuery(nonQuery); MessageBox.Show("Se elimino un usuario exitosamente"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error!"); } }
public static List <Order> getLista() { string sql = "select * from APPORDER"; DataTable dt = ConnectionBD.ExecuteQuery(sql); List <Order> lista = new List <Order>(); foreach (DataRow fila in dt.Rows) { Order ped = new Order(); User u = new User(); ped.IdOrder = Convert.ToInt32(fila[0].ToString()); ped.CreateDate = Convert.ToDateTime(fila[1].ToString()); ped.IdProduct = ped.IdOrder = Convert.ToInt32(fila[2].ToString()); ped.IdAddress = Convert.ToInt32(fila[3].ToString()); lista.Add(ped); } return(lista); }
private void button7_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Debe cambiar la contraseña"); } else { try { string aux = comboBox1.SelectedItem.ToString(); string accion = $"update appuser set password = '******'" + $" where username = '******'"; ConnectionBD.ExecuteNonQuery(accion); MessageBox.Show("Se cambio la contraseña"); } catch (Exception ex) { MessageBox.Show("Ha ocurrido un error"); } } }