save multiple selected checkbox value to database mvc

athira k

9y13.3k.NET

I am developing an MVC project and I have the task to select more than one item in checkbox and want to save these selected item to database. For this I have created three table. First one is DistrictMaster

public partial class DistrictMaster

{

public int Id { get; set; }

public string DistrictName { get; set; }

public virtual ICollection PostMasters { get; set; }

}

Here Iam entering various districts and this saves to database second table PostMaster

public partial class PostMaster

{

public int Id { get; set; }

public string PostName { get; set; }

public string PIN { get; set; }

public Nullable DistrictID { get; set; }

public virtual DistrictMaster DistrictMaster { get; set; }

}

here I am entering different post based on the district selected from drop down list . The DistrictID is Foreign key and will save the pincode and names to the corresponding district in table

The third table is AgentPostMapping

public partial class AgentPostMapping

{

public int Id { get; set; }

public Nullable AgentId { get; set; }

public Nullable PostId { get; set; }

public Nullable EffectDate { get; set; }

}

Here the PostId is not foreign key and I need to save the selected or checked items in checkbox as interger to this postId. This is the part where Iam trouble in doing.

controller

public ActionResult Create()

{

ViewBag.AgentId = new SelectList(db.AgentMasters, "ID", "FirstName");

ViewBag.DistrictId = new SelectList(db.DistrictMasters, "Id", "DistrictName");

return View();

}

public JsonResult GetPosts(string id)

{

List posts = new List();

var postList = this.Getpost(Convert.ToInt32(id));

ViewBag.Postdata= this.Getpost(Convert.ToInt32(id));

var postData = postList.Select(m => new SelectListItem()

{

Text = m.PostName,

Value = m.Id.ToString(),

});

return Json(postData, JsonRequestBehavior.AllowGet);

}

public IList Getpost(int DistrictId)

{

return db.PostMasters.Where(m => m.DistrictID == DistrictId).ToList();

}

[HttpPost]

[ValidateAntiForgeryToken]

public async Task Create([Bind(Include = "Id,AgentId,PostId,EffectDate")] AgentPostMapping agentPostMapping, FormCollection formdata)

{

if (ModelState.IsValid)

{

db.AgentPostMappings.Add(agentPostMapping);

await db.SaveChangesAsync();

return RedirectToAction("Index");

}

ViewBag.AgentId = new SelectList(db.AgentMasters, "ID", "FirstName", agentPostMapping.AgentId);

return View(agentPostMapping);

}

This is my controller part And I didn't write the code in [HttpPost]. Can anyone please help me to write code to save to db.

view(create)

@Html.LabelFor(model => model.AgentId,"AgentName", htmlAttributes: new { @class = "control-label col-md-2" })

@Html.DropDownList("AgentId", null, "select", htmlAttributes: new { @class = "form-control" })

@Html.ValidationMessageFor(model => model.AgentId, "", new { @class = "text-danger" })

@Html.Label("District", htmlAttributes: new { @class = "control-label col-md-2" })

@Html.DropDownList("DistrictId", ViewBag.DistrictId as SelectList, "-- Please Select --", new { style = "width:250px" })

@Html.LabelFor(model => model.PostId,"PostName", htmlAttributes: new { @class = "control-label col-md-2" })

@Html.ValidationMessageFor(model => model.PostId, "", new { @class = "text-danger" })

}

When I hit on the create button by selecting the checkbox the selected checkbox is not listing in [HttpPost] of create parameter.How can I save the selected checkbox value as integer to db ?

why is that the value not showing in PostId. Can anyone please help me find a solution for this. How can I solve this ???

7 Replies

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

Vaibhav Deshmukh9y ago
Accepted answer
HI Athira, Your are going right way you just need to perform follwong modification and add little bit code
//Add ListGetAllSelctedCheckBoxes{get;set;} to your model and  Maintain Hidden field to assign and post data to controller
@Html.HiddenFor(m=>m.GetAllSelctedCheckBoxes)


// Correct this line
$("#PostMaster").append(' + post.Text + '>' + post.Text + '
');

//On input type=submit button click
Take care of id's of your html elements.
Hope above code will help you
Vaibhav Deshmukh9y ago
I think Its's not Possible to store a comma seperated list to the int field.
You have to change a Data Type of that filed (int to varchar) if you want to store list. then you can follow belows steps.
just you have to implement foreach loop and hit db with where condition to get the id's of selected Postnames and add into an array and insert to field in your table as comma seperated value.
athira k9y ago
Now Iam getting the selected checkbox item as string , but I need the Id instead of String and want to store these selected Id to PostId field in AgentpostMapping table as coma seperated list, because my PostId is integer. Is it possible ?
Vaibhav Deshmukh9y ago
How you populate AgentPostMapping table.?
As per shared code by you making sense that you have to store values of PostId into AgentPostMapping table. But how you insert multiple PostId to single record of AgentPostMapping table.Either you have to create association table of AgentPostMapping and PostMaster table or You can insert whole string of your hidden field value into db if you dont want to create association table but its not a proper way.
athira k9y ago
I have get the selected checkbox field to the controller as string I need to save the Id od the selected checkbox to database. how can I do that ?
Vaibhav Deshmukh9y ago
Hi athira,
Have you maintain hidden field beacuse all the value will you get from that hidden field to your controller's action. Please debug and see if value is binding properly then you can save accordingly into your db.
And make sure about all the id's beacuse the shared code is working properly from my side
athira k9y ago
But when I run the code with the changes as you said
@Vaibhav Deshmukh the code is working but the main thing I need is to save the selected checkbox to database, this is not working and also the the value is not passing to the controller. how can I solve this problem ?