/// <summary> /// Delete a pickup area ZIP /// </summary> public virtual void DeletePickupAreaZip(PickupAreaZip data) { string sql = "EXEC PickupAreasZIP_Delete @PickInStoreZipGroupId"; var sqlParams = new List<SqlParameter> { new SqlParameter("PickInStoreZipGroupId", data.Id) }; var result = _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray()); }
public ActionResult DeletePickupAreaZip(PickupAreaZip data) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings)) return AccessDeniedView(); try { _shippingService.DeletePickupAreaZip(data); return new HttpStatusCodeResult(200); } catch { return new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest); } }
/// <summary> /// Edit a pickup area ZIP /// </summary> public virtual void UpdatePickupAreaZip(PickupAreaZip data) { string sql = "EXEC PickupAreasZIP_Update @Name, @ZipCode"; var sqlParams = new List<SqlParameter> { new SqlParameter("Name", data.Name ?? (object)DBNull.Value), new SqlParameter("ZipCode", data.ZipCode ?? (object)DBNull.Value), }; var result = _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray()); }