Esempio n. 1
0
        public ProductPrice CurrentPrice(int prodID)
        {
            List<ProductPrice> PriceList = new List<ProductPrice>();
            PriceList = GetProductPrice(prodID);
            ProductPrice productprice;

            List<ProductPrice> SortedList = PriceList.OrderBy(o => o.EffectiveDate).ToList();

            for (int i = SortedList.Count - 1; i >= 0; i++)
            {

                if (SortedList[i].EffectiveDate <= DateTime.Now)
                {

                    productprice = new ProductPrice();
                    productprice.Price = SortedList[i].Price;
                    productprice.EffectiveDate = SortedList[i].EffectiveDate;
                    productprice.Id = SortedList[i].Id;
                    productprice.Product = SortedList[i].Product;

                    //Console.WriteLine("Price" + productprice.Price);

                    return productprice;
                }
            }

            return null;
        }
Esempio n. 2
0
        public ProductPrice CurrentPrice(int prodID, DateTime date, SqlCeConnection conn)
        {
            List<ProductPrice> PriceList = new List<ProductPrice>();
            PriceList = GetProductPrice(prodID, conn);
            ProductPrice productprice;

            List<ProductPrice> SortedList = PriceList.OrderBy(o => o.EffectiveDate).ToList();

            for (int i = 0; i <= SortedList.Count - 1; i++)
            {

                if (SortedList[i].EffectiveDate >= date)
                {

                    productprice = new ProductPrice();
                    productprice.Price = SortedList[i].Price;
                    productprice.EffectiveDate = SortedList[i].EffectiveDate;
                    productprice.Id = SortedList[i].Id;
                    productprice.Product = SortedList[i].Product;

                    //Console.WriteLine("Price" + productprice.Price);

                    return productprice;
                }

                else
                {
                    productprice = new ProductPrice();
                    productprice.Price = 0;
                    productprice.EffectiveDate = SortedList[i].EffectiveDate;
                    productprice.Id = SortedList[i].Id;
                    productprice.Product = SortedList[i].Product;

                    //Console.WriteLine("Price" + productprice.Price);

                    return productprice;
                }

            }

            return null;
        }
Esempio n. 3
0
        public List<ProductPrice> GetProductPrice(int prodID, SqlCeConnection conn)
        {
            List<ProductPrice> PriceList = new List<ProductPrice>();

            try
            {
                string commandText = SQLQueryString.SelectPriceString;

                SqlCeCommand cmd = new SqlCeCommand(commandText, conn);

                cmd.Parameters.AddWithValue("@id", prodID);

                SqlCeDataReader dr = cmd.ExecuteReader();

                ProductPrice price;

                while (dr.Read())
                {

                    price = new ProductPrice();

                    price.Price = (int)dr[1];
                    price.EffectiveDate = (DateTime)dr[2];

                    PriceList.Add(price);
                }

                return PriceList;

            }

            catch (SqlCeException ex)
            {
                log.Error(ex.Message);
                return null;
            }
        }
Esempio n. 4
0
        public List<ProductPrice> GetProductPrice(int prodID)
        {
            List<ProductPrice> PriceList = new List<ProductPrice>();

            SqlCeConnection conn = new SqlCeConnection(SQLQueryString.ConnStr);

            try
            {

                conn.Open();

                // Console.WriteLine("Connection is successfully made!");

                string commandText = SQLQueryString.SelectPriceString;

                SqlCeCommand cmd = new SqlCeCommand(commandText, conn);

                cmd.Parameters.AddWithValue("@id", prodID);

                SqlCeDataReader dr = cmd.ExecuteReader();

                ProductPrice price;

                while (dr.Read())
                {
                    // Console.WriteLine("{0}\t{1}\t{2}", dr[0], dr[1], dr[2]);

                    price = new ProductPrice();

                    price.Price = (int)dr[1];
                    price.EffectiveDate = (DateTime)dr[2];

                    PriceList.Add(price);
                }

                return PriceList;

            }

            finally
            {
                conn.Close();

            }
        }