/// <summary> /// Delete a delivery area /// </summary> public virtual void DeleteDeliveryArea(DeliveryAreas data) { string sql = "EXEC DeliveryAreas_Delete @CityId"; var sqlParams = new List<SqlParameter> { new SqlParameter("CityId", data.CityId) }; _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray()); }
public ActionResult CreateDeliveryArea(DeliveryAreas data) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings)) return AccessDeniedView(); try { _shippingService.CreateDeliveryArea(data); return new HttpStatusCodeResult(System.Net.HttpStatusCode.OK); } catch { return new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest); } }
/// <summary> /// Edit a delivery area /// </summary> public virtual void UpdateDeliveryArea(DeliveryAreas data) { string sql = "EXEC DeliveryAreas_Update @CityId, @Name, @Days"; var sqlParams = new List<SqlParameter> { new SqlParameter("CityId", data.CityId), new SqlParameter("Name", data.Name), new SqlParameter("Days", data.Days) }; _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray()); }