Exemple #1
0
        public static Prices GetLastPrice()
        {
            Prices price = null;
            String query = "SELECT * FROM price ORDER BY PRI_ID DESC LIMIT 1";

            MySqlCommand cmd = new MySqlCommand(query, _dbConn);

            _dbConn.Open();

            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                int    id   = (int)reader["PRI_ID"];
                String pb95 = reader["PRI_PB95"].ToString();
                String pb98 = reader["PRI_PB98"].ToString();
                String on   = reader["PRI_ON"].ToString();
                String lpg  = reader["PRI_LPG"].ToString();
                String date = reader["PRI_DATE"].ToString();

                price = new Prices(id, pb95, pb98, on, lpg, date);
            }
            reader.Close();
            _dbConn.Close();
            return(price);
        }
Exemple #2
0
        public static List <Prices> GetPrices()
        {
            List <Prices> prices = new List <Prices>();

            String query = "SELECT * FROM price";

            MySqlCommand cmd = new MySqlCommand(query, _dbConn);

            _dbConn.Open();

            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                int    id   = (int)reader["PRI_ID"];
                String pb95 = reader["PRI_PB95"].ToString();
                String pb98 = reader["PRI_PB98"].ToString();
                String on   = reader["PRI_ON"].ToString();
                String lpg  = reader["PRI_LPG"].ToString();
                String date = reader["PRI_DATE"].ToString();

                Prices price = new Prices(id, pb95, pb98, on, lpg, date);
                prices.Add(price);
            }
            reader.Close();
            _dbConn.Close();
            return(prices);
        }
Exemple #3
0
        public static void AddNewPrice(Prices price)
        {
            String query = $"INSERT INTO price(PRI_PB95, PRI_PB98, PRI_ON, PRI_LPG, PRI_DATE) VALUES ('{price.PricePB95}','{price.PricePB98}','{price.PriceON}','{price.PriceLPG}','{price.PriceDate}')";

            MySqlCommand cmd = new MySqlCommand(query, _dbConn);

            _dbConn.Open();
            cmd.ExecuteNonQuery();
            int id = (int)cmd.LastInsertedId;

            //User u = new User(id, u, p, m, n, s, a, r);
            _dbConn.Close();
        }
Exemple #4
0
        public static Product RandomProduct(int i)
        {
            string item     = null;
            int    amount   = 0;
            double price    = 0;
            double sum      = 0;
            Random rnd      = new Random();
            Random rndamt   = new Random();
            Prices prices   = Prices.GetLastPrice();
            int    randItem = rnd.Next(1, 5 + i);

            switch (randItem)
            {
            case 1:
                item   = "PB95";
                amount = rndamt.Next(10, 50);
                price  = Convert.ToDouble(prices.PricePB95);
                sum    = amount * price;
                break;

            case 2:
                item   = "PB98";
                amount = rndamt.Next(10, 50);
                price  = Convert.ToDouble(prices.PricePB98);
                sum    = amount * price;
                break;

            case 3:
                item   = "ON";
                amount = rndamt.Next(10, 50);
                price  = Convert.ToDouble(prices.PriceON);
                sum    = amount * price;
                break;

            case 4:
                item   = "LPG";
                amount = rndamt.Next(30, 70);
                price  = Convert.ToDouble(prices.PriceLPG);
                sum    = amount * price;
                break;

            case 5:
                item   = "Myjnia standardowa";
                amount = rndamt.Next(5, 10);
                price  = 19.99;
                sum    = amount * price;
                break;

            case 6:
                item   = "Myjnia woskowanie";
                amount = rndamt.Next(5, 10);
                price  = 34.99;
                sum    = amount * price;
                break;

            default:
                MessageBox.Show("Nieznany błąd");
                break;
            }

            Product product = new Product(item, amount.ToString(), price.ToString(), sum.ToString());

            return(product);
        }