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