Getting Error while hitting Delete Button?

Praveen Kumar

6y670.NET

Controller

// GET: Admin/UserDefinedFields/Delete/5

public ActionResult Delete(int? id)

{

if (id == null)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

using (var dbContextScope = _dbContextScopeFactory.CreateReadOnly())

{

UserCode userCode = attrRepo.FindBy(uc => uc.Id == id).FirstOrDefault();

if (userCode == null)

{

return HttpNotFound();

}

bool isUsed = false;

foreach (UserCodeValidValue ucvv in userCode.UserCodeValidValues)

{

if (ucvv.UserCodeValues.Count > 0)

{

isUsed = true;

break;

}

UserDefinedFieldsViewModel model = userCode;

model.IsUsed = isUsed;

return PartialView(model);

}

// POST: Admin/UserDefinedFields/Delete/5

[HttpPost, ActionName("Delete")]

[ValidateAntiForgeryToken]

public ActionResult DeleteConfirmed(UserDefinedFieldsViewModel model)

{

using (var dbContextScope = _dbContextScopeFactory.Create())

{

try

{

attrRepo.DeleteUserDefinedField(model.Id, _Login.GetCurrentUser());

dbContextScope.SaveChanges();

}

catch (Exception e)

{

logger.ErrorFormat("Exception deleting attribute", e);

ModelState.AddModelError("", "Error deleting attribute");

return PartialView(model);

}

return RedirectToAction("Index");

}

-------------------------------------------------------------------------------------------------------------------------

@model Redi2.RMIM.Web.Areas.Admin.Models.UserDefinedFieldsViewModel

@using (Html.BeginForm("Delete", "UserDefinedFields", FormMethod.Post))

{

@if (Model.IsUsed)

{

This attribute is in use, so you cannot delete it.

}

else

{

Are you sure you want to delete this attribute?

}

@Html.AntiForgeryToken()

@Html.ValidationSummary(true, "", new { @class = "text-danger" })

@Html.HiddenFor(model => model.Id)

@Html.HiddenFor(model => model.IsUsed)

@Html.DisplayNameFor(model => model.Name)

@Html.DisplayFor(model => model.Name)

@Html.DisplayNameFor(model => model.Description)

@Html.DisplayFor(model => model.Description)

@Html.DisplayNameFor(model => model.UserCodeType)

@Html.DisplayFor(model => model.UserCodeType)

@if (!Model.IsUsed)

{

}

Error

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayank Gaur6y ago
Then you need to apply cascade delete, You can use include keyword so that you delete in your repository. example.
_dbContext.Users.Include(u=>u.address)
Praveen Kumar6y ago
Yes there is relationship with other table
Salman Beg6y ago
I think some foreign key dependency exists. Please do check before deleting it. Thanks
Mayank Gaur6y ago
So , here is my question
1. Have you got Id values in your controller?
2. Is there any dependency of your table in other table i.e foreign key which restrict you to delete?1
Praveen Kumar6y ago
If i create new values and tries to delete it is deleting value. But when i am trying to delete existing value which stored in the table it not allowing to delete and it throws an error
Salman Beg6y ago
Could you please explain in detail what error you are getting exactly. Thanks
Mayank Gaur6y ago
// POST: Admin/UserDefinedFields/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(UserDefinedFieldsViewModel model)
{}

By looking this code, i assume you are using wrong URL Route, as there is no Id available for capture in parameters. So you have to change either your route or you have to change the parameter of action method.

// POST: Admin/UserDefinedFields/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(UserDefinedFieldsViewModel model, int Id)
{}

Getting Error while hitting Delete Button?

Delete Attribute

This attribute is in use, so you cannot delete it.

Are you sure you want to delete this attribute?