/// <summary> /// Delete a zip code /// </summary> public virtual void DeleteDeliveryAreaZipCode(DeliveryZipCode zip) { string sql = "EXEC DeliveryAreas_DeleteZipCode @AreaId"; var sqlParams = new List<SqlParameter> { new SqlParameter("AreaId", zip.AreaId) }; _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray()); }
public ActionResult UpdateDeliveryZipCode(DataSourceRequest command, DeliveryZipCode data) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings)) return AccessDeniedView(); try { _shippingService.UpdateDeliveryAreaZipCode(data); return new HttpStatusCodeResult(200); } catch { return new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest); } }
/// <summary> /// Edit a zip code /// </summary> public virtual void UpdateDeliveryAreaZipCode(DeliveryZipCode zip) { string sql = "EXEC DeliveryAreas_UpdateZipCode @AreaId, @CityId, @Name, @ZipCode, @StateProvinceId, @ShippingChargeAmount"; var sqlParams = new List<SqlParameter> { new SqlParameter("AreaId", zip.AreaId), new SqlParameter("CityId", zip.CityId), new SqlParameter("Name", zip.Name), new SqlParameter("ZipCode", zip.ZipCode), new SqlParameter("StateProvinceId", zip.StateProvinceId), new SqlParameter("ShippingChargeAmount", zip.ShippingChargeAmount) }; _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray()); }