public ActionResult AdditionalTierPriceInsert(ProductModel.AdditionalTierPriceModel model) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageProducts)) return AccessDeniedView(); if (model.TierPriceId == 0 || model.TierPriceTypeId == 0) return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Please select price type!"); if (_additionalTierPriceService.IsAdditionalExists(model.TierPriceId, model.TierPriceTypeId)) return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Selected type already exists please delete that first!"); var additionalPriceType = new AdditionalTierPrice { TypeId = model.TierPriceTypeId, TierPriceId = model.TierPriceId, Price = model.Price, Code = model.Code, }; _additionalTierPriceService.InsertAdditionalTierPrice(additionalPriceType); return new NullJsonResult(); }
public ActionResult AdditionalTierPriceUpdate(ProductModel.AdditionalTierPriceModel model) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageProducts)) return AccessDeniedView(); if (model.TierPriceId == 0 || model.TierPriceTypeId == 0) return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Please select price type!"); var additionalPriceType = new AdditionalTierPrice { TypeId = model.TierPriceTypeId, TierPriceId = model.TierPriceId, Price = model.Price, Code = model.Code, }; _additionalTierPriceService.UpdateAdditionalTierPrice(additionalPriceType); return new NullJsonResult(); }
public void InsertAdditionalTierPrice(AdditionalTierPrice additionalPriceType) { if (additionalPriceType == null) throw new ArgumentNullException("additionalPriceType"); var pPrice = _dataProvider.GetParameter(); pPrice.ParameterName = "Price"; pPrice.Value = additionalPriceType.Price; pPrice.DbType = DbType.Decimal; var pCode = _dataProvider.GetParameter(); pCode.ParameterName = "Code"; pCode.Value = additionalPriceType.Code; pCode.DbType = DbType.String; var pTypeId = _dataProvider.GetParameter(); pTypeId.ParameterName = "TypeId"; pTypeId.Value = additionalPriceType.TypeId; pTypeId.DbType = DbType.Int32; var pTierPriceId = _dataProvider.GetParameter(); pTierPriceId.ParameterName = "TierPriceId"; pTierPriceId.Value = additionalPriceType.TierPriceId; pTierPriceId.DbType = DbType.Int32; _dbContext.ExecuteSqlCommand("insert into AdditionalTierPrice values(@TierPriceId,@TypeId,@Price,@Code)", true, null, pTierPriceId, pTypeId, pPrice, pCode); //event notification _eventPublisher.EntityInserted(additionalPriceType); }