Update the checked values of all user type basing on their id's

Question

1.00/5 (1 vote)

See more:

I have 5 types of users if I check the check boxes and click on update button I have to update all the checked values of each type basing on id on one click

What I have tried:

I just bound the values to web grid by using entity model if I click on the update button I have to update each staff checked checkbox values by using id in asp.net MVC

Posted 8-Mar-16 0:34am

Member 12377320

Updated 5-Apr-16 23:54pm

v3

Add a Solution

Comments

Member 12377320 8-Mar-16 6:35am

postimg.org/image/5qt5k0rd1

John C Rayan 8-Mar-16 7:30am

what's your issue? show us your controller and view.

Member 12377320 8-Mar-16 9:35am

this is view
<div>
@grid.GetHtml(columns: grid.Columns(grid.Column(columnName: "UId", header: "U ID"),
grid.Column(columnName: "UserType_Name", header: "UserTypeName"),
grid.Column(header: "AddR", format: @<text><input type="checkbox" id="chkadd" checked="@item.AddRights" />),
grid.Column(header: "EditR", format: @<text><input type="checkbox" id="chkedit" checked="@item.EditRights" />),
grid.Column(header: "DeleteR", format: @<text><input type="checkbox" id="chkdel" checked="@item.DeleteRights" />),
grid.Column(header: "ChpwdR", format: @<text><input type="checkbox" id="chkpwd" checked="@item.Change_pwd" />),
grid.Column(header: "AssignR", format: @<text><input type="checkbox" id="chkassign" checked="@item.AssignRights" />),
grid.Column(header: "UpdateR", format: @<text><input type="checkbox" id="chkupdate" checked="@item.UpdateRights" />)

))
</div>
</td>
</tr>

</table>

<div>
@Html.ActionLink("Update", "UserPermissionSettings")
</div>

Member 12377320 8-Mar-16 9:36am

this is controller
[HttpGet]
[ActionName("UserPermissionSettings")]
public ActionResult UserPermissionSettings()
{
if (Session["Name"] == null)
{
return RedirectToAction("Login");
}
else
{
var upsettings = new List<userpermissionsetting>();

using (UPSettingsEntities upsettingsEntities = new UPSettingsEntities())
{
upsettings = upsettingsEntities.UserPermissionSettings.ToList();

}

return View(upsettings);
}
}

Member 12377320 8-Mar-16 9:39am

the link above is the output if click on the update button I have to update the all the checked or unchecked values of the checkbox to DB please help me...

Member 12377320 9-Mar-16 1:38am

hi..thanks and if I did by using business layer then.
my view is:
<table>
<tr>
<th>
@Html.DisplayNameFor(model => model.Name)
</th>
<th>
@Html.DisplayNameFor(model => model.AddR)
</th>
<th>
@Html.DisplayNameFor(model => model.EditR)
</th>
<th>
@Html.DisplayNameFor(model => model.DelR)
</th>
<th>
@Html.DisplayNameFor(model => model.ChkpwdR)
</th>
<th>
@Html.DisplayNameFor(model => model.AssignR)
</th>
<th>
@Html.DisplayNameFor(model => model.UpdateR)
</th>
<th></th>
</tr>

@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem => item.Name)
</td>
<td>
@Html.EditorFor(modelItem => item.AddR, new { @id="addr"})
</td>
<td>
@Html.EditorFor(modelItem => item.EditR, new { @id = "editr" })
</td>
<td>
@Html.EditorFor(modelItem => item.DelR, new { @id = "delr" })
</td>
<td>
@Html.EditorFor(modelItem => item.ChkpwdR, new { @id = "chpr" })
</td>
<td>
@Html.EditorFor(modelItem => item.AssignR, new { @id = "assr" })
</td>
<td>
@Html.EditorFor(modelItem => item.UpdateR, new { @id = "upr" })
</td>
@*<td>
@Html.ActionLink("Edit", "Edit", new { id=item.Id }) |
@Html.ActionLink("Details", "Details", new { id=item.Id }) |
@Html.ActionLink("Delete", "Delete", new { id=item.Id })
</td>*@
</tr>
}

</table>
<div>
@Html.ActionLink("Update", "UPS")
</div>

my controller is:

[HttpGet]
public ActionResult UPS()
{
EmployeeBussinessLayer employeeBussinessLayer =
new EmployeeBussinessLayer();

List<upsettings> upSettings = employeeBussinessLayer.UPSettingss.ToList();
return View(upSettings);

}
[HttpPost]
public ActionResult UPS(List< UPSettings> ups)
{

return View(ups);

}
Help me for this also...

John C Rayan 9-Mar-16 7:23am

It doesn't matter if you use webgrid or HTML helper. Remember both produces HTML in the browser so the solution applies to both situations as long as you have a checkbox and the HTML inside a form.

Member 12377320 10-Mar-16 6:34am

it's not coming send me a sample code please, I didn't get any idea how to repeat loop in id

i tried like this

[HttpPost]
[ActionName("UserPermissionSettings")]
public ActionResult UserPermissionSettings(FormCollection form)
{
var chkadd = form.GetValues("chkadd");
var chkedit = form.GetValues("chkedit");
var chkdel = form.GetValues("chkdel");
var chkpwd = form.GetValues("chkpwd");
var chkassign = form.GetValues("chkassign");
var chkupdate = form.GetValues("chkupdate");

return View();

}

John C Rayan 10-Mar-16 7:26am

Show me your checkboxes in the view.

Member 12377320 10-Mar-16 10:13am

this is by using Bussiness layer
@model IEnumerable<bussinesslayer.upsettings>

@{
ViewBag.Title = "UPS";
}

UPS

@*<p>
@Html.ActionLink("Create New", "Create")
</p>*@
<table>
<tr>
<th>
@Html.DisplayNameFor(model => model.Name)
</th>
<th>
@Html.DisplayNameFor(model => model.AddR)
</th>
<th>
@Html.DisplayNameFor(model => model.EditR)
</th>
<th>
@Html.DisplayNameFor(model => model.DelR)
</th>
<th>
@Html.DisplayNameFor(model => model.ChkpwdR)
</th>
<th>
@Html.DisplayNameFor(model => model.AssignR)
</th>
<th>
@Html.DisplayNameFor(model => model.UpdateR)
</th>
<th></th>
</tr>

@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem => item.Name)
</td>
<td>
@Html.EditorFor(modelItem => item.AddR, new { @id="addr"})
</td>
<td>
@Html.EditorFor(modelItem => item.EditR, new { @id = "editr" })
</td>
<td>
@Html.EditorFor(modelItem => item.DelR, new { @id = "delr" })
</td>
<td>
@Html.EditorFor(modelItem => item.ChkpwdR, new { @id = "chpr" })
</td>
<td>
@Html.EditorFor(modelItem => item.AssignR, new { @id = "assr" })
</td>
<td>
@Html.EditorFor(modelItem => item.UpdateR, new { @id = "upr" })
</td>
@*<td>
@Html.ActionLink("Edit", "Edit", new { id=item.Id }) |
@Html.ActionLink("Details", "Details", new { id=item.Id }) |
@Html.ActionLink("Delete", "Delete", new { id=item.Id })
</td>*@
</tr>
}

</table>
<div>
@Html.ActionLink("Update", "UPS")
</div>

and this by using the entity model

@model List< MvcTaskManager.UserPermissionSetting>

@{
ViewBag.Title = "UserPermissionSettings";

var grid = new WebGrid(source: Model, canPage: true, rowsPerPage: 10);
grid.Pager(WebGridPagerModes.All);

}
<table style="font-family:Arial">
<tr>
<td>

UserPermissionSettings

</td></tr>
<tr>
<td>
<div>
@grid.GetHtml(columns: grid.Columns(grid.Column(columnName: "UId", header: "U ID"),
grid.Column(columnName: "UserType_Name", header: "UserTypeName"),
grid.Column(header: "AddR", format: @<text><input type="checkbox" id="chkadd" checked="@item.AddRights" />),
grid.Column(header: "EditR", format: @<text><input type="checkbox" id="chkedit" checked="@item.EditRights" />),
grid.Column(header: "DeleteR", format: @<text><input type="checkbox" id="chkdel" checked="@item.DeleteRights" />),
grid.Column(header: "ChpwdR", format: @<text><input type="checkbox" id="chkpwd" checked="@item.Change_pwd" />),
grid.Column(header: "AssignR", format: @<text><input type="checkbox" id="chkassign" checked="@item.AssignRights" />),
grid.Column(header: "UpdateR", format: @<text><input type="checkbox" id="chkupdate" checked="@item.UpdateRights" />)

))
</div>
</td>
</tr>

</table>

<div>
@Html.ActionLink("Update", "UserPermissionSettings")
</div>
<div>
@Html.ActionLink("Back", "AfterLogin")
</div>

John C Rayan 10-Mar-16 10:46am

You are missing @Html.BeginForm

Member 12377320 11-Mar-16 0:22am

I am a Fresher, please send the sample code for view and post method.

John C Rayan 11-Mar-16 4:41am

The example is given in the solution tab. you have to spend some time and put some effort to learn if you want to do some work. We can only help and we cannot do the work for you.

Member 12377320 11-Mar-16 8:28am

ok

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

John C Rayan · Answer 1 · 2016-03-08T04:19:00

Solution 1

The answer is here for you.

mvc3 checkbox checked rows in the web grid[^]

Posted 8-Mar-16 4:19am

John C Rayan