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