public IActionResult Edit(int id)
{
var restaurant = _restaurantService.GetRestaurantById(id);
var restaurantRegisterModel = new RestaurantRegisterModel(restaurant);
return(View(restaurantRegisterModel));
}
public void UpdateRestaurant(RestaurantRegisterModel restaurant, string image)
{
using var command = _connection.CreateCommand();
var nameParam = command.CreateParameter();
nameParam.ParameterName = "name";
nameParam.Value = restaurant.RestaurantName;
var addressParam = command.CreateParameter();
addressParam.ParameterName = "address";
addressParam.Value = restaurant.Address;
var cityParam = command.CreateParameter();
cityParam.ParameterName = "city";
cityParam.Value = restaurant.City;
var zipCodeParam = command.CreateParameter();
zipCodeParam.ParameterName = "zip_code";
zipCodeParam.Value = restaurant.ZipCode;
var restaurantIdParam = command.CreateParameter();
restaurantIdParam.ParameterName = "restaurant_id";
restaurantIdParam.Value = restaurant.Id;
if (restaurant.Image != null)
{
var imageParam = command.CreateParameter();
imageParam.ParameterName = "restaurant_imageURL";
imageParam.Value = image;
command.Parameters.Add(imageParam);
command.CommandText = "UPDATE restaurants SET name = @name, address = @address, city = @city," +
" zip_code = @zip_code, restaurant_imageUrl = @restaurant_imageUrl WHERE restaurant_id = @restaurant_id";
}
else
{
command.CommandText = "UPDATE restaurants SET name = @name, address = @address, city = @city," +
" zip_code = @zip_code WHERE restaurant_id = @restaurant_id";
}
command.Parameters.Add(nameParam);
command.Parameters.Add(addressParam);
command.Parameters.Add(cityParam);
command.Parameters.Add(zipCodeParam);
command.Parameters.Add(restaurantIdParam);
command.ExecuteNonQuery();
}
public IActionResult Edit(RestaurantRegisterModel restaurant)
{
string imageFileName = restaurant.Image?.FileName;
using Stream imageStream = restaurant.Image?.OpenReadStream();
string image = imageFileName == null ? null : _storageService.Save(imageFileName, imageStream);
_restaurantService.UpdateRestaurant(restaurant, image);
var restaurantId = _restaurantService.GetRestaurantIdByName(restaurant.RestaurantName);
return(RedirectToAction("Details", new { id = restaurantId }));
}
