In my Create action I have given many checkbox for selecting items for eg, suppose I have 5 checkbox items and I selected 3 out of that and these selected checkboxes are stored in db and here my problem is, from the index page when I click on the edit link I want to list the checkboxes that are selected with check mark and also the other which are not selected must also be shown in edit page so that if user wants any change in the checked checkbox must edit or can add other item to db, this is the part which i am not able to do
controller
public async Task Edit(int? id )
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
AgentPostMapping agentPostMapping = await db.AgentPostMappings.FindAsync(id);
var ListItems = (from ap in db.AgentPostMappings
join a in db.AgentMasters on ap.AgentId equals a.ID
join p in db.PostMasters on ap.PostId equals p.Id
select new AgentMappingList
{
id = ap.Id,
Agentid = ap.AgentId,
postid = ap.PostId,
EffectDate = ap.EffectDate,
firstname = a.FirstName,
Postname = p.PostName
}).Where(r=>r.Agentid == id).ToList();
var grp = ListItems.GroupBy(r => r.Agentid).Select(r => new AgentMappingList
{
Agentid = r.Key,
id = r.Key,
PostNames = string.Join(" , ", r.Select(g => g.Postname)),
firstname = ListItems.FirstOrDefault(q => q.Agentid == r.Key).firstname,
EffectDate = ListItems.FirstOrDefault(q => q.Agentid == r.Key).EffectDate
}).FirstOrDefault();
AgentPostMapping agentPostMappings = new AgentPostMapping();
{
agentPostMappings.Id = grp.id.Value;
agentPostMappings.AgentId = grp.Agentid;
agentPostMappings.EffectDate = grp.EffectDate;
agentPostMappings.CheckBoxes = grp.PostNames;
}
var m = db.AgentMasters.Where(r => r.ID == id).Select(p=>p.FirstName);
ViewBag.AgentId = new SelectList(m, "FirstName");
ViewBag.DistrictId = new SelectList(db.DistrictMasters, "Id", "DistrictName");
if (agentPostMappings == null)
{
return HttpNotFound();
}
return View(agentPostMappings);
}
[HttpPost]
[ValidateAntiForgeryToken]
public async Task Edit(AgentPostMapping agentPostMapping)
{
string combindedString = string.Join(",", agentPostMapping.GetAllSelctedCheckBoxes.ToArray());
List check = new List(combindedString.Split(',').Select(int.Parse));
if (ModelState.IsValid)
{
for (int i = 0; i < check.Count(); i++)
{
agentPostMapping.PostId = Convert.ToInt32(check[i]);
agentPostMapping.PostId = agentPostMapping.PostId;
agentPostMapping.AgentId = agentPostMapping.AgentId;
agentPostMapping.EffectDate = agentPostMapping.EffectDate;
db.AgentPostMappings.Add(agentPostMapping);
await db.SaveChangesAsync();
}
//db.Entry(agentPostMapping).State = EntityState.Modified;
//await db.SaveChangesAsync();
return RedirectToAction("Index");
}
return View(agentPostMapping);
}
view page
@Html.LabelFor(model => model.PostId, "PostName", htmlAttributes: new { @class = "control-label col-md-2" })
@Html.HiddenFor(m => m.GetAllSelctedCheckBoxes)
@Html.ValidationMessageFor(model => model.PostId, "", new { @class = "text-danger" })
when hiting on save button the second script will work and this value is passing to the HttpPost of edit method . here my problem is how can I get the selceted checkbox as checked when I go to the edit page?
Saineshwar BageriPosted Apr 18, 2017, 5:23 AM
athira kPosted Apr 18, 2017, 4:49 AM
Saineshwar BageriPosted Apr 18, 2017, 4:34 AM