Esempio n. 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (comboBox1.SelectedItem == null || comboBox2.SelectedItem == null)
            {
                MessageBox.Show("Llene los campos");
            }
            else
            {
                try
                {
                    DateTime d = DateTime.Now;
                    ConnectionBD.ExecuteNonQuery($"INSERT INTO APPORDER(createDate, idProduct, idAddress) " +
                                                 $"VALUES('{d}', '{comboBox1.SelectedValue}', '{comboBox2.SelectedValue}'); ");



                    MessageBox.Show("Se ha procesado su orden");
                }


                catch (Exception ex)
                {
                    MessageBox.Show("Ha ocurrido un error");
                }
            }
        }
Esempio n. 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (comboBox1.SelectedItem == null)
            {
                throw new NoRestaurantSelected("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 (NoRestaurantSelected ex)
                {
                    MessageBox.Show(ex.Message);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ha ocurrido un error");
                }
            }
        }
Esempio n. 3
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            if (textBox1.Text.Equals(""))
            {
                MessageBox.Show("Debe cambiar la contraseña");
            }
            else
            {
                try
                {
                    string aux = comboBox1.SelectedItem.ToString();


                    /*string consulta = $"select password from appuser where username='******'";
                     * var dt = ConnectionBD.ExecuteQuery(consulta);
                     * var dr = dt.Rows[0];
                     * var contra = Convert.ToString(dr[0].ToString());*/

                    string accion = $"update appuser set password = '******'" +
                                    $" where username = '******'";
                    ConnectionBD.ExecuteNonQuery(accion);

                    MessageBox.Show("Se ha actualizado la contraseña");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ha ocurrido un error");
                }
            }
        }
Esempio n. 4
0
        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}' ,'{false}')");

                        MessageBox.Show("Se ha registrado un usuario!");
                    }
                    else
                    {
                        ConnectionBD.ExecuteNonQuery($"INSERT INTO APPUSER (fullname, username, password, userType) " +
                                                     $"VALUES ('{textBox1.Text}', " +
                                                     $"'{textBox2.Text}', '{textBox3.Text}' ,'{true}')");

                        MessageBox.Show("Se ha registrado un usuario!");
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Ha ocurrido un error!");
                }
            }
        }
Esempio n. 5
0
        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;
        }
Esempio n. 6
0
        private void DeleteUser_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 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");
            }
        }
Esempio n. 8
0
        private void button1_Click(object sender, EventArgs e)
        {
            // mensaje de prueba
            //MessageBox.Show(user.IdUser.ToString());
            //iduser = Convert.ToInt32(uw.ToString());
            //MessageBox.Show(iduser.ToString());
            var dt2 = 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 AND au.idUser = '******'; ");

            dataGridView1.DataSource = dt2;

            MessageBox.Show("Datos obtenidos exitosamente");
        }
 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");
     }
 }
Esempio n. 10
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (comboBox1.SelectedItem == null)
         {
             MessageBox.Show("Escoga una dirección");
         }
         else
         {
             ConnectionBD.ExecuteNonQuery($"DELETE FROM ADDRESS WHERE idAddress = '{comboBox1.SelectedValue}'");
             PoblarControles();
             MessageBox.Show("Se ha eliminado la direccion");
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("Ha ocurrido un error");
     }
 }
Esempio n. 11
0
        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);
        }
Esempio n. 12
0
        public static List <AddressA> getLista()
        {
            string sql = "select * from ADDRESS";

            DataTable dt = ConnectionBD.ExecuteQuery(sql);

            List <AddressA> lista = new List <AddressA>();

            foreach (DataRow fila in dt.Rows)
            {
                AddressA ad = new AddressA();
                ad.IdAddress = Convert.ToInt32(fila[0].ToString());
                ad.IdUser    = Convert.ToInt32(fila[1].ToString());
                ad.Address   = fila[2].ToString();



                lista.Add(ad);
            }
            return(lista);
        }
Esempio n. 13
0
        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 ha agregado el negocio");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ha ocurrido un error");
                }
            }
        }
Esempio n. 14
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Equals(""))
            {
                MessageBox.Show("Necesita una dirección");
            }
            else
            {
                try
                {
                    ConnectionBD.ExecuteNonQuery($"INSERT INTO ADDRESS(idUser, address) " +
                                                 $"VALUES('{logged.IdUser}', '{textBox1.Text}')");

                    MessageBox.Show("Se ha agregado la direccion");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ha ocurrido un error");
                }
            }
        }
Esempio n. 15
0
        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);
        }
Esempio n. 16
0
        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 ha eliminado el usuario");
            }
            catch (Exception exception)
            {
                MessageBox.Show("Ha ocurrido un error!");
            }
        }
Esempio n. 17
0
        public static List <Pedido> getLista()
        {
            string sql = "select * from APPORDER";

            DataTable dt = ConnectionBD.ExecuteQuery(sql);

            List <Pedido> lista = new List <Pedido>();

            foreach (DataRow fila in dt.Rows)
            {
                Pedido ped = new Pedido();
                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);
        }
Esempio n. 18
0
        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}");

                    PoblarControles();

                    MessageBox.Show("Se ha modificado la direccion");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ha ocurrido un erros");
                }
            }
        }
Esempio n. 19
0
        private void button1_Click(object sender, EventArgs e)
        {
            ConnectionBD.ExecuteNonQuery($"DELETE FROM APPORDER WHERE idOrder = '{comboBox1.SelectedValue}'");

            MessageBox.Show("Orden eliminada");
        }