private void button6_Click(object sender, EventArgs e)
        {
            try
            {
                DBManager     manager    = new DBManager();
                SqlConnection connection = manager.Connection();

                string     selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders";
                SqlCommand cmd         = new SqlCommand(selectQuery, connection);
                connection.Open();
                List <Order>  orders = new List <Order>();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    string bookName   = reader[0].ToString();
                    string writerName = reader[1].ToString();
                    string edition    = reader[2].ToString();
                    string qu         = reader[3].ToString();
                    int    quantity   = Convert.ToInt16(qu);

                    Order anOrder = new Order();
                    anOrder.BookName   = bookName;
                    anOrder.WriterName = writerName;
                    anOrder.Edition    = edition;
                    anOrder.Quantity   = quantity;
                    orders.Add(anOrder);
                }

                QuantitySelect aQuantitySelect = new QuantitySelect(orders);
                aQuantitySelect.ShowDialog();
            }
            catch (SqlException exception)
            {
                MessageBox.Show(exception.Message);
            }
        }
        private void button6_Click_1(object sender, EventArgs e)
        {
            try
            {

                DBManager manager = new DBManager();
                SqlConnection connection = manager.Connection();

                string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders";
                SqlCommand cmd = new SqlCommand(selectQuery, connection);
                connection.Open();
                List<Order> orders = new List<Order>();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    string bookName = reader[0].ToString();
                    string writerName = reader[1].ToString();
                    string edition = reader[2].ToString();
                    string qu = reader[3].ToString();
                    int quantity = Convert.ToInt16(qu);

                    Order anOrder = new Order();
                    anOrder.BookName = bookName;
                    anOrder.WriterName = writerName;
                    anOrder.Edition = edition;
                    anOrder.Quantity = quantity;
                    orders.Add(anOrder);


                }

                QuantitySelect aQuantitySelect = new QuantitySelect(orders);
                aQuantitySelect.ShowDialog();
            }
            catch (SqlException exception)
            {
                MessageBox.Show(exception.Message);
            }

        }