using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        SqlConnection cnn = new SqlConnection(@"Data Source=DESKTOP-JE2MKN6\SQLEXPRESS;Initial Catalog=database_new; Integrated Security = True");

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            cnn.Open();

            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "select product_name, price from Товары";

            cmd.Connection = cnn;

            SqlDataReader reader = cmd.ExecuteReader();

            richTextBox1.Clear();

            while (reader.Read())
            { richTextBox1.Text += reader[0] + " за " + reader[1] + "\n"; }
            richTextBox1.Text += new string('*', 50) + "\n";
            reader.NextResult();

            cnn.Close();
            reader.Close();
        }

        private void listView1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)
        {
            cnn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "select product_name, price from Товары where price > @price_filter ";
            cmd.Connection = cnn;
            cmd.Parameters.Add("@price_filter", SqlDbType.Int, 8);
            cmd.Parameters["@price_filter"].Value = Convert.ToDecimal(textBox1.Text);
            SqlDataReader reader = cmd.ExecuteReader();
            richTextBox1.Clear();
            while (reader.Read())
            { richTextBox1.Text += reader[0] + " за " + reader[1] + "\n"; }
            cnn.Close(); reader.Close();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {
            cnn.Open();
            SqlCommand cmd = new SqlCommand();
            richTextBox1.Clear();
            cmd.Connection = cnn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "getBooks";
            cmd.Parameters.Add("@max_price", SqlDbType.Int);
            cmd.Parameters["@max_price"].Direction = ParameterDirection.Output;

            SqlDataReader reader = cmd.ExecuteReader();

            richTextBox1.Text += "Список книг:\n";
            while (reader.Read())
            { richTextBox1.Text += reader[0] + " " + reader[1] + "\n"; }
            reader.NextResult();
            richTextBox1.Text += "\nМаксимальная стоимость = " +
           Convert.ToString(cmd.Parameters["@max_price"].Value);
            cnn.Close(); reader.Close();
        }

    }
}