public static DiscountDisplay GetDiscount(int productID, int quantity, decimal price) { DiscountDisplay item = new DiscountDisplay(); System.Data.IDataReader dr = SPsQtyDiscount.StoreProductQtyDiscountGet(productID, quantity).GetReader(); if (dr.Read()) { decimal discount = decimal.Parse(dr["discount"].ToString()); if (bool.Parse(dr["isPercent"].ToString())) { item.DiscountAmount = (price * (discount / 100)) * quantity; item.Discount = discount; item.IsPercent = true; item.Qty = int.Parse(dr["quantity"].ToString()); return(item); } else { item.DiscountAmount = (discount * quantity); item.Discount = discount; item.IsPercent = false; item.Qty = int.Parse(dr["quantity"].ToString()); return(item); } } return(null); }
public static QtyDiscountCollection GetByProductID(int productID) { QtyDiscountCollection coll = new QtyDiscountCollection(); using (IDataReader rdr = SPsQtyDiscount.StoreProductQtyDiscountGetByProductID(productID).GetReader()) { coll.Load(rdr); } return(coll); }