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