private void button10_Click(object sender, EventArgs e) { try { string query = $"SELECT id_product FROM product WHERE name ='{comboBox6.Text}'"; var dt = ConnectionDB.ExecuteQuery(query); var dr = dt.Rows[0]; var iduser = Convert.ToInt32(dr[0].ToString()); string query2 = $"SELECT id_address FROM address WHERE address ='{comboBox8.Text}'"; var dt2 = ConnectionDB.ExecuteQuery(query2); var dr2 = dt2.Rows[0]; var idaddress = Convert.ToInt32(dr2[0].ToString()); ConnectionDB.ExecuteNonQuery($"INSERT INTO apporder(createdate, id_product, id_address) VALUES(" + $"'{type.dia}'," + $"{iduser}," + $"{idaddress})"); MessageBox.Show("Orden Registrada"); DatosProduct(); DatosOrden(); DatosAddress(); } catch (Exception) { MessageBox.Show("Ha ocurrido un error"); } }
private void button7_Click(object sender, EventArgs e) //Agregar Productos { if (textBox3.Text.Equals("")) { MessageBox.Show("Digite los datos pedidos !"); } else { try { var query2 = ConnectionDB.ExecuteQuery("select idbusiness from business " + $"WHERE name ='{comboBox1.Text}'"); var query3 = query2.Rows[0]; var query4 = Convert.ToInt32(query3[0].ToString()); var query = ""; query = "INSERT INTO product(idBusiness,name)" + $"VALUES ('{query4}', '{textBox3.Text}')"; ConnectionDB.ExecuteNonQuery(query); MessageBox.Show("Producto Agregado"); } catch (Exception exception) { MessageBox.Show("No se ha agregado"); throw; } } }
public static void crearNuevo(int id, string direccion) { string nonQuery = String.Format("INSERT INTO address(idUser, address) " + $"VALUES({id}, '{direccion}')"); ConnectionDB.ExecuteNonQuery(nonQuery); }
private void button13_Click_1(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Esta seguro de CERRAR DIA ?", "Corte de caja", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { //Insertando ganancias en T3 try { ConnectionDB.ExecuteNonQuery($"INSERT INTO GANANCIADIA (select current_date, SUM(ganancia)FROM GANANCIADIAARTICULO);"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error actualizando suma de ganancias"); } //Vaciando datos de T2 try { ConnectionDB.ExecuteNonQuery($"truncate table GANANCIADIAARTICULO;"); MessageBox.Show("Se ha cortado caja!!"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error BORRANDO T2"); } } }
public static void hacerOrden(string time, Product pro, Address ad) { var sql = string.Format("INSERT INTO APPORDER(createDate, idProduct, idAddress) " + " VALUES('{0}', {1}, {2});", time, pro.idproduct, ad.addressID); ConnectionDB.ExecuteNonQuery(sql); }
private void button6_Click(object sender, EventArgs e) //nueva orden { try { var query2 = ConnectionDB.ExecuteQuery("select idproduct from product " + $"WHERE name ='{comboBox7.Text}'"); var query3 = query2.Rows[0]; var query4 = Convert.ToInt32(query3[0].ToString()); var add = ConnectionDB.ExecuteQuery("select idaddress from address " + $"WHERE address ='{comboBox2.Text}'"); var addre = add.Rows[0]; var address = Convert.ToInt32(addre[0].ToString()); var query = ""; query = "INSERT INTO APPORDER(createDate, idProduct, idAddress)" + $" VALUES('{DateTime.UtcNow.ToString("d")}','{query4}','{address}')"; ConnectionDB.ExecuteNonQuery(query); MessageBox.Show("Se ha hecho el pedido"); } catch (Exception exception) { MessageBox.Show("No se ha hecho el pedido"); throw; } }
private void button5_Click(object sender, EventArgs e) { if (textBox7.Text.Equals("")) { MessageBox.Show("No se pueden dejar campos vacios"); } else { try { string query = $"SELECT id_business from business WHERE name ='{comboBox1.Text}'"; var dt = ConnectionDB.ExecuteQuery(query); var dr = dt.Rows[0]; var iduser = Convert.ToInt32(dr[0].ToString()); ConnectionDB.ExecuteNonQuery($"INSERT INTO product(id_business, name) VALUES(" + $"{iduser}," + $"'{textBox7.Text}')"); MessageBox.Show("Producto Registrado"); DatosProduct(); DatosBusiness(); } catch (Exception) { MessageBox.Show("Ha ocurrido un error"); } } }
public static void actualizarPassword(string user, string newPassword) { string nonQuery = String.Format($"UPDATE appuser SET password = '******' " + $"WHERE username = '******'"); ConnectionDB.ExecuteNonQuery(nonQuery); }
private void button5_Click(object sender, EventArgs e) //Actualizar contraseña { if (textBox5.Text.Equals("")) { MessageBox.Show("Ingrese la nueva contraseña por favor"); } else { var query2 = ConnectionDB.ExecuteQuery("select iduser from appuser " + $"WHERE username ='******'"); var query3 = query2.Rows[0]; var query4 = Convert.ToInt32(query3[0].ToString()); var NonQuery = $"UPDATE appuser SET password= '******' WHERE iduser= '******'"; try { ConnectionDB.ExecuteNonQuery(NonQuery); MessageBox.Show("Contraseña Actualizada"); } catch (Exception exception) { MessageBox.Show("Usuario no eliminado"); } } }
public static void crearNuevo(string nombre, string descripcion) { string nonQuery = String.Format("INSERT INTO business(name, description) " + $"VALUES('{nombre}', '{descripcion}')"); ConnectionDB.ExecuteNonQuery(nonQuery); }
private void button3_Click(object sender, EventArgs e) //actualizar la ubicacion { if (textBox2.Text.Equals("")) { MessageBox.Show("Ingrese los datos requeridos."); } else { try { var add = ConnectionDB.ExecuteQuery("select idaddress from address " + $"WHERE address ='{comboBox4.Text}'"); var addre = add.Rows[0]; var address = Convert.ToInt32(addre[0].ToString()); var query = ""; query = $"UPDATE ADDRESS SET address = '{textBox2.Text}' WHERE idAddress = '{address}'"; ConnectionDB.ExecuteNonQuery(query); MessageBox.Show("Se ha actualizado la direccion"); } catch (Exception exception) { MessageBox.Show("No se ha actualizado la direccion."); throw; } } }
public static void UpdateUserPassword(string userName, string newPassword) { var lista = UserNonQuery.getLista(); foreach (var user in lista) { if (userName.Equals(user.userName)) { try { ConnectionDB.ExecuteNonQuery($"UPDATE APPUSER " + $"SET password = '******' " + $"WHERE username = '******' "); MessageBox.Show("Se ha modificado la contrasena con exito!!!"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error"); } } else { MessageBox.Show("Usuario Incorrecto"); } } }
public static void crearNuevo(int id, string nombre) { string nonQuery = String.Format("INSERT INTO product(idBusiness, name) " + $"VALUES({id}, '{nombre}')"); ConnectionDB.ExecuteNonQuery(nonQuery); }
public static void addPro(Negocio neg, string desc) { var sql = string.Format("INSERT INTO PRODUCT(idBusiness, name) " + " VALUES({0}, '{1}');", neg.idneg, desc); ConnectionDB.ExecuteNonQuery(sql); }
private void btnCambiarContra_Click(object sender, EventArgs e) { try { string query = $"SELECT password from appuser WHERE username ='******'"; var dt = ConnectionDB.ExecuteQuery(query); var dr = dt.Rows[0]; var iduser = Convert.ToString(dr[0].ToString()); if (txtActual.Text.Equals(iduser) && txtNueva.Text.Equals(txtRepetir.Text)) { string actualizar = $"UPDATE appuser SET password = '******' WHERE password = '******'"; ConnectionDB.ExecuteNonQuery(actualizar); MessageBox.Show("Se ha actualizado la contra"); } else { MessageBox.Show("Datos incorrectos"); } } catch (Exception) { MessageBox.Show("Ha ocurrido un Error"); } }
public static void agregarDireccion(Usuario us, string address) { string sql = string.Format("INSERT INTO ADDRESS(idUser, address) " + " VALUES({0},'{1}');", us.userID, address); ConnectionDB.ExecuteNonQuery(sql); }
public static void modificar(int id, string nueva) { string nonQuery = String.Format($"UPDATE address SET address = '{nueva}' " + $"WHERE idAddress = {id}"); ConnectionDB.ExecuteNonQuery(nonQuery); }
private void button3_Click(object sender, EventArgs e) { if (textBox3.Text.Equals("")) { MessageBox.Show("Error no se puede dejar vacio"); } else { try { string query = $"SELECT id_user from appuser WHERE username ='******'"; var dt = ConnectionDB.ExecuteQuery(query); var dr = dt.Rows[0]; var iduser = Convert.ToInt32(dr[0].ToString()); ConnectionDB.ExecuteNonQuery($"INSERT INTO address(id_user, address) VALUES(" + $"{iduser}," + $"'{textBox3.Text}')"); MessageBox.Show("Dirección Registrada"); DatosAddress(); } catch (Exception) { MessageBox.Show("Ha ocurrido un error"); } } }
public static void addUser(string nombre, string usuario) { string sql = string.Format("INSERT INTO appuser(fullname, username, password, usertype) " + " VALUES('{0}', '{1}', '{2}', false)", nombre, usuario, nombre); ConnectionDB.ExecuteNonQuery(sql); }
private void button4_Click(object sender, EventArgs e) //Nueva direccion { if (textBox3.Text.Equals("")) { MessageBox.Show("ingrese los datos requeridos."); } else { try { var query2 = ConnectionDB.ExecuteQuery("select iduser from appuser " + $"WHERE username ='******'"); var query3 = query2.Rows[0]; var query4 = Convert.ToInt32(query3[0].ToString()); var query = ""; query = "INSERT INTO ADDRESS(iduser,address)" + $"values('{query4}','{textBox3.Text}')"; ConnectionDB.ExecuteNonQuery(query); MessageBox.Show("se ha guardado la nueva ubicacion."); } catch (Exception exception) { MessageBox.Show("No se ha registrado la ubicacion"); throw; } } }
public static void crearNuevo(string nombre, string usuario) { string nonQuery = String.Format("INSERT INTO APPUSER(fullname, username, password, userType) " + $"VALUES('{nombre}','{usuario}','{usuario}', false)"); ConnectionDB.ExecuteNonQuery(nonQuery); }
public static void agregarNegocio(string nombreN, string description) { string sql = string.Format("INSERT INTO BUSINESS(name, description) " + " VALUES('{0}', '{1}');", nombreN, description); ConnectionDB.ExecuteNonQuery(sql); }
public static void crearOrden(DateTime fecha, int idP, int idA) { string f = fecha.ToShortDateString(); string nonQuery = String.Format("INSERT INTO apporder(createDate, idProduct, idAddress) " + $"VALUES('{f}', {idP}, {idA})"); ConnectionDB.ExecuteNonQuery(nonQuery); }
private void button7_Click(object sender, EventArgs e) { if (MessageBox.Show("¿Seguro que quieres eliminar al usuario?", "Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ConnectionDB.ExecuteNonQuery($"DELETE FROM appuser WHERE username = '******'"); MessageBox.Show("Usuario Eliminado"); DatosAppUser(); } }
private void button6_Click(object sender, EventArgs e) { if (MessageBox.Show("¿Seguro que quieres eliminar la dirección?", "Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ConnectionDB.ExecuteNonQuery($"DELETE FROM address WHERE address = '{comboBox2.Text}'"); MessageBox.Show("Dirección Eliminada"); DatosAddress(); } }
private void button8_Click(object sender, EventArgs e) { if (MessageBox.Show("¿Seguro que quieres eliminar el negocio?", "Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ConnectionDB.ExecuteNonQuery($"DELETE FROM business WHERE name = '{comboBox4.Text}'"); MessageBox.Show("Negocio Eliminado"); DatosBusiness(); } }
//Actualizando Producto (stock inicial, etc) public static void UpdateProduct(string nombre) { try { ConnectionDB.ExecuteNonQuery($"UPDATE GANANCIA SET stock_actual = stock_ingresado, precio_compra_acumulado = (stock_ingresado*precio_unidad_compra) WHERE nombre = '{nombre}';"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error actualizando"); } }
private void button13_Click(object sender, EventArgs e) { if (MessageBox.Show("¿Seguro que quieres eliminar la orden?", "Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ConnectionDB.ExecuteNonQuery($"DELETE FROM apporder WHERE id_order = '{comboBox7.Text}'"); MessageBox.Show("Orden Eliminada"); DatosProduct(); DatosOrden(); DatosAddress(); } }
//Actualizando Producto (stock) public static void UpdateProductStock(int id, int cantidad) { try { ConnectionDB.ExecuteNonQuery($"UPDATE GANANCIA SET stock_ingresado = stock_ingresado + '{cantidad}', stock_actual = stock_actual + '{cantidad}' WHERE idproducto = '{id}';"); MessageBox.Show("Se ha actualizado el stock", "Stock Actualizado"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error actualizando"); } }
public static void DeleteUser(string userName) { try { ConnectionDB.ExecuteNonQuery($"DELETE FROM appuser " + $"WHERE username = '******'"); MessageBox.Show("Se ha eliminado el usuario"); } catch (Exception exception) { MessageBox.Show("Ha ocurrido un error"); } }