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; }
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; }
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; } }
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(); } }