Пример #1
0
        public void Alterar(PizzaC p)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection())
                {
                    conn.ConnectionString = strConexao;
                    conn.Open();

                    using (SqlCommand command = new SqlCommand())
                    {
                        string query = "Update dbo.Pizza set nome=@nome,descricao=@descricao,preco=@preco where id=@id";
                        command.CommandText = query;
                        command.Connection  = conn;
                        command.Parameters.AddWithValue("@nome", p.Nome);
                        command.Parameters.AddWithValue("@descricao", p.Descricao);
                        command.Parameters.AddWithValue("@preco", p.Preco);
                        command.Parameters.AddWithValue("@id", p.Id);
                        command.ExecuteNonQuery();
                    }
                }
                MessageBox.Show("Pizza " + p.Nome + " alterada com sucesso!");
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #2
0
        public void Excluir(PizzaC p)
        {
            try
            {
                using (SqlConnection conexao = new SqlConnection())
                {
                    conexao.ConnectionString = strConexao;
                    conexao.Open();

                    using (SqlCommand comando = new SqlCommand())
                    {
                        string strSql = "Delete Pizza where id=@id";
                        comando.CommandText = strSql;
                        comando.Connection  = conexao;
                        comando.Parameters.AddWithValue("@id", p.Id);
                        comando.ExecuteNonQuery();
                    }
                }
                MessageBox.Show("Pizza deletada com sucesso!");
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #3
0
        public void Incluir(PizzaC piz)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection())
                {
                    conn.ConnectionString = strConexao;
                    conn.Open();

                    using (SqlCommand command = new SqlCommand())
                    {
                        string query = "Insert into dbo.Pizza(nome,descricao,preco) values(@nome, @descricao, @preco)";
                        command.CommandText = query;
                        command.Connection  = conn;
                        command.Parameters.AddWithValue("@nome", piz.Nome);
                        command.Parameters.AddWithValue("@descricao", piz.Descricao);
                        command.Parameters.AddWithValue("@preco", piz.Preco);
                        command.ExecuteNonQuery();
                    }
                }
                MessageBox.Show("Pizza cadastrada com sucesso!");
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }