❔ Httppost Edit Action Update error
my httppost edit action does not store the form values.Shows an Update Sql exception regarding Country checkbox saving.
here is the view for Country checkboxes in Edit.cshtml:
@foreach(var country in new List<string> { "India", "America", "Australia", "China" })
{
<input type="checkbox" value="@country" id="@country" @(Model.Country.Contains(@country) ? "checked" : "")/>@country
<br/>
}
<span asp-validation-for="Country" class="text-danger"></span>
</div>
here is my httppost edit action method:
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Edit(int id, RegistTable registration, IFormFile ProfileImage)
{
string wwwRootPath = _hostEnvironment.WebRootPath;
if (id != registration.Id)
{
return NotFound();
}
if (ModelState.IsValid)
{
// Get the selected country values from the form
string[] countryValues = Request.Form["Country"];
var countries = string.Join(",", countryValues);
registration.Country = countries;
var fileName = Path.GetFileName(ProfileImage.FileName);
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/Images", fileName);
using (var stream = new FileStream(path, FileMode.Create))
{
ProfileImage.CopyTo(stream);
}
registration.ProfileImage = fileName;
}
try
{
_context.Update(registration);
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return NotFound();
}
return RedirectToAction(nameof(Index);
here is the view for Country checkboxes in Edit.cshtml:
@foreach(var country in new List<string> { "India", "America", "Australia", "China" })
{
<input type="checkbox" value="@country" id="@country" @(Model.Country.Contains(@country) ? "checked" : "")/>@country
<br/>
}
<span asp-validation-for="Country" class="text-danger"></span>
</div>
here is my httppost edit action method:
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Edit(int id, RegistTable registration, IFormFile ProfileImage)
{
string wwwRootPath = _hostEnvironment.WebRootPath;
if (id != registration.Id)
{
return NotFound();
}
if (ModelState.IsValid)
{
// Get the selected country values from the form
string[] countryValues = Request.Form["Country"];
var countries = string.Join(",", countryValues);
registration.Country = countries;
var fileName = Path.GetFileName(ProfileImage.FileName);
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/Images", fileName);
using (var stream = new FileStream(path, FileMode.Create))
{
ProfileImage.CopyTo(stream);
}
registration.ProfileImage = fileName;
}
try
{
_context.Update(registration);
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return NotFound();
}
return RedirectToAction(nameof(Index);
