public void Calculate_ShouldReturnDiscountResult_WithCorrectProductsAndModel() { // Arrange IQuantityDiscountCalculator timespanDiscountCalculator = new QuantityDiscountCalculator(); List <Product> products = new List <Product>() { new Product() { Id = 1, Name = "Beans", PluralName = "Beans", Price = 0.65m }, new Product() { Id = 2, Name = "Bread", PluralName = "Breads", Price = 0.8m }, new Product() { Id = 3, Name = "Milk", PluralName = "Milk", Price = 1.3m }, new Product() { Id = 4, Name = "Apple", PluralName = "Apples", Price = 1.0m }, }; QuantityDiscount quantityDiscount = new QuantityDiscount() { Id = 1, BuyingProduct = products[0], Quantity = 2, DiscountedProduct = products[1], DiscountPercentage = 0.5f, IsActive = true }; IEnumerable <BasketItem> items = new List <BasketItem>() { new BasketItem() { Product = new BasketItemProduct() { Id = 1, Name = "Beans", PluralName = "Beans", Price = 0.65m }, Quantity = 2 }, new BasketItem() { Product = new BasketItemProduct() { Id = 2, Name = "Bread", PluralName = "Breads", Price = 0.8m }, Quantity = 1 }, }; // Act DiscountResult discountResult = timespanDiscountCalculator.Calculate(items, quantityDiscount); // Assert Assert.Equal(0.5, discountResult.DiscountPercentage); Assert.Equal(0.40m, discountResult.DiscountedPrice); Assert.Equal("Breads", discountResult.ProductPluralName); }
public virtual QuantityDiscount UpdateQuantityDiscount(QuantityDiscount entity) { if (entity.IsTransient()) { return(entity); } QuantityDiscount other = GetQuantityDiscount(entity.QuantityDiscountId); if (entity.Equals(other)) { return(entity); } string sql = @"Update QuantityDiscount set [QuantityDiscountGUID]=@QuantityDiscountGUID , [Name]=@Name , [DisplayOrder]=@DisplayOrder , [ExtensionData]=@ExtensionData , [DiscountType]=@DiscountType , [CreatedOn]=@CreatedOn where QuantityDiscountID=@QuantityDiscountID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@QuantityDiscountID", entity.QuantityDiscountId) , new SqlParameter("@QuantityDiscountGUID", entity.QuantityDiscountGuid) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@DisplayOrder", entity.DisplayOrder) , new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value) , new SqlParameter("@DiscountType", entity.DiscountType) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetQuantityDiscount(entity.QuantityDiscountId)); }
public void When_constructed() { var sut = new QuantityDiscount("apple", 3, 2.00m); Assert.That(sut.Barcode, Is.EqualTo("apple")); Assert.That(sut.DiscountQuantity, Is.EqualTo(3)); Assert.That(sut.DiscountPrice, Is.EqualTo(2.00m)); }
public void When_constructed() { var sut = new QuantityDiscount("apple", 3, 2.00m); Assert.That(sut.Barcode, Is.EqualTo("apple")); Assert.That(sut.DiscountQuantity, Is.EqualTo(3)); Assert.That(sut.DiscountPrice, Is.EqualTo(2.00m)); }
public FQuantityDiscount() { InitializeComponent(); quantityDiscountModel = new QuantityDiscountModel(); listDiscount = new DataTable(); rowIndex = 0; seletedFunction = 0; quantityDiscount = new QuantityDiscount(); }
// To display the discounted amount. protected string ShowDiscountAmount(object QuantityDiscountID, object DiscountPercent) { Customer ThisCustomer = ((AspDotNetStorefrontPrincipal)HttpContext.Current.User).ThisCustomer; if (QuantityDiscount.isFixedQuantityDiscount(Convert.ToInt32(QuantityDiscountID))) { return(Localization.CurrencyStringForDisplayWithExchangeRate((Decimal)DiscountPercent, ThisCustomer.CurrencySetting)); } else { return(Convert.ToDecimal(DiscountPercent).ToString("N" + AppLogic.AppConfigNativeInt("QuantityDiscount.PercentDecimalPlaces")) + "%"); } }
public DiscountItem() { SpendLevels = new List <SpendLevel>(); RestrictedProductIds = new List <int>(); DiscountSchedule = new List <Schedule>(); AdvancedQuantityDiscount = new QuantityDiscount { BuyQuantity = 1, GetQuantity = 1 }; RestrictedPackageIds = new List <int>(); MinimumPacksEligibleIds = new List <int>(); }
public virtual QuantityDiscount QuantityDiscountFromDataRow(DataRow dr) { if (dr == null) { return(null); } QuantityDiscount entity = new QuantityDiscount(); entity.QuantityDiscountId = (System.Int32)dr["QuantityDiscountID"]; entity.QuantityDiscountGuid = (System.Guid)dr["QuantityDiscountGUID"]; entity.Name = dr["Name"].ToString(); entity.DisplayOrder = (System.Int32)dr["DisplayOrder"]; entity.ExtensionData = dr["ExtensionData"].ToString(); entity.DiscountType = (System.Byte)dr["DiscountType"]; entity.CreatedOn = (System.DateTime)dr["CreatedOn"]; return(entity); }
public DiscountResult Calculate(IEnumerable <BasketItem> items, QuantityDiscount model) { if (items == null) { throw new ArgumentNullException(nameof(items)); } if (model == null) { throw new ArgumentNullException(nameof(model)); } BasketItem buyingProduct = items.FirstOrDefault(p => p.Product.Id == model.BuyingProduct.Id); if (buyingProduct == null) { return(null); } BasketItem productForDiscount = items.FirstOrDefault(p => p.Product.Id == model.DiscountedProduct.Id); if (productForDiscount == null) { return(null); } int quantity = buyingProduct.Quantity / model.Quantity; int numberOfDiscounts = quantity > productForDiscount.Quantity ? productForDiscount.Quantity : quantity; if (numberOfDiscounts == 0) { return(null); } decimal currentPrice = productForDiscount.Product.Price; decimal discountedPrice = (currentPrice * (decimal)model.DiscountPercentage) * numberOfDiscounts; DiscountResult result = new DiscountResult(); result.DiscountedPrice = discountedPrice; result.ProductPluralName = productForDiscount.Product.PluralName; result.DiscountPercentage = model.DiscountPercentage; return(result); }
private List <QuantityDiscount> GetQuantityDiscounts() { List <QuantityDiscount> quantityDiscounts = new List <QuantityDiscount>(); QuantityDiscount quantityDiscountA = new QuantityDiscount(); quantityDiscountA.DiscountPrice = 7; quantityDiscountA.MinimumQuantity = 4; quantityDiscountA.ProductCode = "A"; quantityDiscounts.Add(quantityDiscountA); QuantityDiscount quantityDiscountC = new QuantityDiscount(); quantityDiscountC.DiscountPrice = 6; quantityDiscountC.MinimumQuantity = 6; quantityDiscountC.ProductCode = "C"; quantityDiscounts.Add(quantityDiscountC); return(quantityDiscounts); }
public virtual QuantityDiscount InsertQuantityDiscount(QuantityDiscount entity) { QuantityDiscount other = new QuantityDiscount(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into QuantityDiscount ( [QuantityDiscountGUID] ,[Name] ,[DisplayOrder] ,[ExtensionData] ,[DiscountType] ,[CreatedOn] ) Values ( @QuantityDiscountGUID , @Name , @DisplayOrder , @ExtensionData , @DiscountType , @CreatedOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@QuantityDiscountID", entity.QuantityDiscountId) , new SqlParameter("@QuantityDiscountGUID", entity.QuantityDiscountGuid) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@DisplayOrder", entity.DisplayOrder) , new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value) , new SqlParameter("@DiscountType", entity.DiscountType) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray); if (identity == DBNull.Value) { throw new DataException("Identity column was null as a result of the insert operation."); } return(GetQuantityDiscount(Convert.ToInt32(identity))); } return(entity); }
public string ShowQuantityDiscountTableForAccordion(String sProductID, string HeaderText, string ID) //our version to allow display inline without changing app config "ShowQuantityDiscountTablesInline" { Customer ThisCustomer = null; try { ThisCustomer = ((AspDotNetStorefrontPrincipal)HttpContext.Current.User).ThisCustomer; } catch { } if (ThisCustomer == null) { ThisCustomer = new Customer(true); } InputValidator IV = new InputValidator("ShowQuantityDiscountTable"); int ProductID = IV.ValidateInt("ProductID", sProductID); StringBuilder results = new StringBuilder(""); bool CustomerLevelAllowsQuantityDiscounts = QuantityDiscount.CustomerLevelAllowsQuantityDiscounts(ThisCustomer.CustomerLevelID); String MainProductSKU = String.Empty; int ActiveDIDID = QuantityDiscount.LookupProductQuantityDiscountID(ProductID); bool ActiveDID = (ActiveDIDID != 0); if (!CustomerLevelAllowsQuantityDiscounts) { ActiveDID = false; } if (ActiveDID) { results.Append("<div data-role=\"collapsible\">"); results.Append("<h3>" + HeaderText + "</h3>"); results.Append("<div>" + QuantityDiscount.GetQuantityDiscountDisplayTable(ActiveDIDID, ThisCustomer.SkinID) + "</div>"); results.Append("</div>"); } return(results.ToString()); }
public bool insertQuantityDiscount(QuantityDiscount discount) { bool inserted = false; SqlConnection connection; SqlCommand command; string sql = "INSERT INTO tbQuantityDiscount VALUES(" + discount.MinQuantity + ", " + discount.MaxQuantity + ", " + discount.DiscountRate + ")"; try { connection = new ConnectDB().connectToSQL(); command = new SqlCommand(sql, connection); if (command.ExecuteNonQuery() == 1) { inserted = true; } } catch (Exception) { throw; } connection.Close(); return(inserted); }
public bool updateQuantityDiscount(QuantityDiscount quantityDiscount) { bool updated = false; SqlConnection connection; SqlCommand command; string sql = "UPDATE tbQuantityDisCount SET MinQuantity = " + quantityDiscount.MinQuantity + ", MaxQuantity = " + quantityDiscount.MaxQuantity + ", Discount = " + quantityDiscount.DiscountRate + " WHERE DiscountId = " + quantityDiscount.DiscountId; try { connection = new ConnectDB().connectToSQL(); command = new SqlCommand(sql, connection); if (command.ExecuteNonQuery() == 1) { updated = true; } } catch (Exception) { throw; } connection.Close(); return(updated); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); QuantityDiscountID = CommonLogic.QueryStringUSInt("QuantityDiscountID"); QuantityDiscountName = QuantityDiscount.GetQuantityDiscountName(QuantityDiscountID, LocaleSetting); if (CommonLogic.FormBool("IsSubmitByCount")) { // check for new row addition: int Low0 = CommonLogic.FormUSInt("Low_0"); int High0 = CommonLogic.FormUSInt("High_0"); String NewGUID = DB.GetNewGUID(); int NewRowID = 0; if (Low0 != 0 || High0 != 0) { // add the new row if necessary: Decimal Discount = CommonLogic.FormUSDecimal("Rate_0_" + QuantityDiscountID.ToString()); DB.ExecuteSQL("insert into QuantityDiscountTable(QuantityDiscountTableGUID,QuantityDiscountID,LowQuantity,HighQuantity,DiscountPercent) values(" + DB.SQuote(NewGUID) + "," + QuantityDiscountID.ToString() + "," + Localization.IntStringForDB(Low0) + "," + Localization.IntStringForDB(High0) + "," + Localization.DecimalStringForDB(Discount) + ")"); } using (SqlConnection dbconn = DB.dbConn()) { dbconn.Open(); using (IDataReader rs = DB.GetRS("Select QuantityDiscountTableID from QuantityDiscountTable with (NOLOCK) where QuantityDiscountTableGUID=" + DB.SQuote(NewGUID), dbconn)) { rs.Read(); NewRowID = DB.RSFieldInt(rs, "QuantityDiscountTableID"); } } // update existing rows: for (int i = 0; i <= Request.Form.Count - 1; i++) { String FieldName = Request.Form.Keys[i]; if (FieldName.IndexOf("_0_") == -1 && FieldName != "Low_0" && FieldName != "High_0" && FieldName.IndexOf("_vldt") == -1 && (FieldName.IndexOf("Rate_") != -1 || FieldName.IndexOf("Low_") != -1 || FieldName.IndexOf("High_") != -1)) { Decimal FieldVal = CommonLogic.FormUSDecimal(FieldName); // this field should be processed String[] Parsed = FieldName.Split('_'); if (FieldName.IndexOf("Rate_") != -1) { // update discount: DB.ExecuteSQL("Update QuantityDiscountTable set DiscountPercent=" + Localization.DecimalStringForDB(FieldVal) + " where QuantityDiscountTableID=" + Parsed[1]); } if (FieldName.IndexOf("Low_") != -1) { // update low value: DB.ExecuteSQL("Update QuantityDiscountTable set LowQuantity=" + FieldVal.ToString() + " where QuantityDiscountTableID=" + DB.SQuote(Parsed[1])); } if (FieldName.IndexOf("High_") != -1) { // update high value: DB.ExecuteSQL("Update QuantityDiscountTable set HighQuantity=" + FieldVal.ToString() + " where QuantityDiscountTableID=" + DB.SQuote(Parsed[1])); } } } DB.ExecuteSQL("Update QuantityDiscountTable set HighQuantity=999999 where HighQuantity=0 and LowQuantity<>0"); } if (CommonLogic.QueryStringCanBeDangerousContent("deleteByCountid").Length != 0) { DB.ExecuteSQL("delete from QuantityDiscountTable where QuantityDiscountTableID=" + CommonLogic.QueryStringCanBeDangerousContent("deleteByCountid")); } SectionTitle = "<a href=\"" + AppLogic.AdminLinkUrl("quantitydiscounts.aspx") + "\">" + AppLogic.GetString("admin.editquantitydiscounttable.QuantityDiscounts", SkinID, LocaleSetting) + "</a> - " + String.Format(AppLogic.GetString("admin.editquantitydiscounttable.ManageQuantityDiscountTable", SkinID, LocaleSetting), QuantityDiscountName); RenderHtml(); }
public IActionResult AddQuantityDiscountToProduct(Guid productId, QuantityDiscount quantityDiscount) => AddDiscountToProduct(productId, quantityDiscount);
public QuantityDiscount InsertQuantityDiscount(QuantityDiscount entity) { return(_iQuantityDiscountRepository.InsertQuantityDiscount(entity)); }
public QuantityDiscount UpdateQuantityDiscount(QuantityDiscount entity) { return(_iQuantityDiscountRepository.UpdateQuantityDiscount(entity)); }
/// <summary> /// Creates the child controls in a control derived from System.Web.UI.WebControls.CompositeControl. /// </summary> protected override void CreateChildControls() { if (cItem.ProductID > 0) { txtQuantity.Text = cItem.Quantity.ToString(); if (this.AllowEdit) { (txtQuantity as TextBox).Columns = 4; (txtQuantity as TextBox).MaxLength = 4; (txtQuantity as TextBox).ReadOnly = false; (txtQuantity as TextBox).CssClass = "mobileinput"; } //Line Item Description if (LineItemSetting != null) { lineItemDescription.LineItemDescriptionSettings = LineItemSetting; } lineItemDescription.DataSource = this.CartItem; lineItemDescription.AllowEdit = this.AllowEdit; lineItemDescription.IsMiniCart = false; lblSubTotal.Text = cItem.ExtPriceRateDisplayFormat.ToString(); lblVatDisplay.Text = cItem.VatRateDisplayFormat; lblQtyDiscount.Text = cItem.LineItemQuantityDiscount; lblSubTotal.CssClass = "shoppingcartproductprice"; lblVatDisplay.CssClass = "shoppingcartproductprice"; lblQtyDiscount.CssClass = "shoppingcartproductprice"; btnDelete.CssClass = "shoppingcartdeletebutton"; btnDelete.CommandName = "Delete"; btnDelete.CommandArgument = cItem.ShoppingCartRecordID.ToString(); Controls.Add(new LiteralControl(" <table style='width : 100%; padding-top: 10px; padding-bottom: 10px' cellpadding='0' cellspacing='0' border='0'>")); Controls.Add(new LiteralControl(" <tr>")); if (this.DisplayMode != CartDisplayMode.MiniCart) { //LineItemDescription Controls.Add(new LiteralControl(" <td style='width: 50%;' valign='top'>")); Controls.Add(lineItemDescription); Controls.Add(new LiteralControl(" </td>")); Controls.Add(new LiteralControl(" <td style='width: 15%;' align='left' valign='top'>")); Controls.Add(new LiteralControl(" <div>")); //check for restricted quantity if (this.CartItem.RestrictedQuantities.Count == 0 || !this.AllowEdit) { Controls.Add(txtQuantity as Control); } else { // build dropdown for restricted quantities BuildRestrictedQuantities(); Controls.Add(cboQuantity); } Controls.Add(new LiteralControl(" </div>")); Controls.Add(new LiteralControl(" </td>")); } Controls.Add(new LiteralControl(" <td style='width: 25%; padding-right:5px;' align='right' valign='top'>")); Controls.Add(new LiteralControl(" <table style='width:100% padding-right:5px;' cellpadding='0' cellspacing='0' border='0'>")); Controls.Add(new LiteralControl(" <tr>")); Controls.Add(new LiteralControl(" <td style='padding-top:5px; padding-right:5px;' align='right' valign='top'>")); Controls.Add(lblSubTotal); Controls.Add(new LiteralControl(" </td>")); Controls.Add(new LiteralControl(" </tr>")); if (this.DisplayMode != CartDisplayMode.MiniCart) { if (cItem.ThisShoppingCart.VatEnabled) { Controls.Add(new LiteralControl(" <tr>")); Controls.Add(new LiteralControl(" <td align='right'>")); Controls.Add(lblVatDisplay); Controls.Add(new LiteralControl(" </td>")); Controls.Add(new LiteralControl(" </tr>")); } if (QuantityDiscount.CustomerLevelAllowsQuantityDiscounts(cItem.ThisCustomer.CustomerLevelID)) { Controls.Add(new LiteralControl(" <tr>")); Controls.Add(new LiteralControl(" <td align='right'>")); Controls.Add(lblQtyDiscount); Controls.Add(new LiteralControl(" </td>")); Controls.Add(new LiteralControl(" </tr>")); } } Controls.Add(new LiteralControl(" </table>")); Controls.Add(new LiteralControl(" </td>")); // Delete column Controls.Add(new LiteralControl(" <td style='width: 10%; padding-top:5px;' valign='top' align='right'>")); Controls.Add(btnDelete); Controls.Add(new LiteralControl(" </td>")); Controls.Add(new LiteralControl(" </tr>")); Controls.Add(new LiteralControl(" </table>")); } }
public virtual QuantityDiscount DeleteQuantityDiscount(QuantityDiscount entity) { this.DeleteQuantityDiscount(entity.QuantityDiscountId); return(entity); }