예제 #1
0
        private void LC(object sender, MouseEventArgs e)
        {
            ListBook G1 = new ListBook(list.OneTypeBooks(onlineGenre));

            if (BBook.Count < 5)
            {
                BBook.Add(G1.Lista[(FromFourth(((Rectangle)sender).Name))]);
            }
            else
            {
                MessageBox.Show("Корзина повна");
            }
            Repaing(BBook.Count);
            Releaze1();
        }
예제 #2
0
        public void RReleaze(int ir)
        {
            string b;

            if (sort == 1)
            {
                b = "SELECT * FROM Books order by Price";
            }
            else
            {
                b = "SELECT * FROM Books order by Name";
            }
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand    command = new SqlCommand(b, connection);
                SqlDataReader CC      = command.ExecuteReader();

                if (CC.HasRows)
                {
                    while (CC.Read())
                    {
                        object x1 = CC.GetValue(0);
                        object x2 = CC.GetValue(1);
                        object x3 = CC.GetValue(2);
                        object x4 = CC.GetValue(3);
                        object x5 = CC.GetValue(4);
                        list.Lista.Add(new Book(Convert.ToString(x1), Convert.ToString(x2), Convert.ToDouble(x3), Convert.ToString(x4), Convert.ToInt32(x5)));
                    }
                }
            }
            ListBook G1 = new ListBook(list.OneTypeBooks(onlineGenre));
            int      i  = 1;

            I1.Content = G1.Lista[i * 5 + ir].Name;
            I2.Content = G1.Lista[i * 5 + ir].Author;
            I3.Content = G1.Lista[i * 5 + ir].price + "₴";
            I4.Content = G1.Lista[i * 5 + ir].About;
            I5.Content = GenreStr(G1.Lista[i * 5 + ir].Genre);
        }
예제 #3
0
        public void Releaze()
        {
            Tovari.Children.Clear();
            list.Lista.Clear();
            string b;

            if (sort == 1)
            {
                b = "SELECT * FROM Books order by Price";
            }
            else
            {
                b = "SELECT * FROM Books order by Name";
            }
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand    command = new SqlCommand(b, connection);
                SqlDataReader CC      = command.ExecuteReader();
                if (CC.HasRows)
                {
                    while (CC.Read())
                    {
                        object x1 = CC.GetValue(0);
                        object x2 = CC.GetValue(1);
                        object x3 = CC.GetValue(2);
                        object x4 = CC.GetValue(3);
                        object x5 = CC.GetValue(4);
                        list.Lista.Add(new Book(Convert.ToString(x1), Convert.ToString(x2), Convert.ToDouble(x3), Convert.ToString(x4), Convert.ToInt32(x5)));
                    }
                }
            }
            ListBook G1 = new ListBook(list.OneTypeBooks(onlineGenre));

            foreach (var j in G1.Lista)
            {
                AddBooks(j);
            }
        }