public ActionResult CreatePickupAreaAddress(PickupAreaAddress data)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return AccessDeniedView();
try
{
_shippingService.CreatePickupAreaAddress(data);
return new HttpStatusCodeResult(System.Net.HttpStatusCode.OK);
}
catch
{
return new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest);
}
}
/// <summary>
/// Edit a pickup area address
/// </summary>
public virtual void UpdatePickupAreaAddress(PickupAreaAddress data)
{
string sql = "EXEC PickupAreasAddress_Update @AddressId, @FirstName, @LastName, @StateProvinceId, @City, @Address1, @Address2, @ZipPostalCode, @PhoneNumber";
var sqlParams = new List<SqlParameter>
{
new SqlParameter("AddressId", data.AddressId),
new SqlParameter("FirstName", data.FirstName ?? (object)DBNull.Value),
new SqlParameter("LastName", data.LastName ?? (object)DBNull.Value),
new SqlParameter("StateProvinceId", data.StateProvinceId),
new SqlParameter("City", data.City ?? (object)DBNull.Value),
new SqlParameter("Address1", data.Address1 ?? (object)DBNull.Value),
new SqlParameter("Address2", data.Address2 ?? (object)DBNull.Value),
new SqlParameter("ZipPostalCode", data.ZipPostalCode ?? (object)DBNull.Value),
new SqlParameter("PhoneNumber", data.PhoneNumber ?? (object)DBNull.Value)
};
var result = _dbContext.ExecuteSqlCommand(sql, false, null, sqlParams.ToArray());
}
