Ejemplo n.º 1
0
        protected void OnBotonAceptarClicked(object sender, System.EventArgs e)
        {
            TreeModel tModel;
            treeView.Selection.Mode = SelectionMode.Multiple;
            TreeSelection tSelect = treeView.Selection;
            tSelect.SelectAll();			//selecciona todas las filas necesario para obtener la informacion de todas.
            Array treePaths = tSelect.GetSelectedRows(out tModel);

            foreach(TreePath tPath in treePaths)
            {
                TreeIter iter;

                if(listStore.GetIter(out iter, tPath))
                {
                    string nombre = (string)listStore.GetValue(iter,1);
                    string tamano = (string)listStore.GetValue(iter,2);
                    string precio = (string)listStore.GetValue(iter,3);
                    string cantidad = (string)listStore.GetValue(iter,4);

                    if(!cantidad.Equals("0"))
                    {
                        IDbCommand dbCommand = dbConnection.CreateCommand ();

                        dbCommand.CommandText = "insert into pedidos (nombre, tamano, precio,cantidad) values (:nombre, :tamano, :precio,:cantidad)";

                        DbCommandExtensions.AddParameter (dbCommand, "nombre",nombre);
                        DbCommandExtensions.AddParameter (dbCommand, "tamano", tamano);
                        DbCommandExtensions.AddParameter (dbCommand, "precio", Convert.ToDouble(precio));
                        DbCommandExtensions.AddParameter (dbCommand, "cantidad", Convert.ToInt32(cantidad));

                        dbCommand.ExecuteNonQuery ();

                        Destroy ();

                    }
                }
            }
            CalculoLabelMain calculoLabel = new CalculoLabelMain();
            calculoLabel.calculoLabelTotal(totalMainWindow,botonNuevoPedidoMainWindow);
        }
Ejemplo n.º 2
0
        protected void OnBotonAceptarClicked(object sender, System.EventArgs e)
        {
            if((comboboxBebida.Active != 0)&&(comboboxBocadillo.Active !=0)&&(comboboxCafe.Active!=0)&&(spinbuttonCantidad.Value!=0)){

            string cadena = "Almuerzo Completo: "+valorComboBebida+", "+valorComboBocadillo +", "+valorComboCafe;
            IDbCommand dbCommand = dbConnection.CreateCommand ();

            dbCommand.CommandText = "insert into pedidos (nombre, tamano, precio,cantidad) values (:nombre, :tamano, :precio,:cantidad)";

            DbCommandExtensions.AddParameter (dbCommand, "nombre",cadena);
            DbCommandExtensions.AddParameter (dbCommand, "tamano", "Normal");
            DbCommandExtensions.AddParameter (dbCommand, "precio", Convert.ToDouble(comboboxPrecio.ActiveText));
            DbCommandExtensions.AddParameter (dbCommand, "cantidad", Convert.ToInt32(spinbuttonCantidad.Value));

                        dbCommand.ExecuteNonQuery ();

            CalculoLabelMain calculoLabel = new CalculoLabelMain();
            calculoLabel.calculoLabelTotal(totalMainWindow,botonNuevoPedidoMainWindow);
            Destroy ();
            }else{
                MensajeComboInfo mensaje = new MensajeComboInfo();
                mensaje.Show();
            }
        }