Wednesday, May 25, 2016

DropdownList load by change effect with ASP.NET MVC and Javascript

I am loading branch by selecting company. Here is my branch label and dropdownlist for branch.
  <div class="row">
                <div class="col-md-3">
                    @Html.Label("name", "Branch Name")
                </div>
                <div class="col-md-8">
                    @Html.DropDownListFor(model => model.BRANCHID, new SelectList(string.Empty, "Value", "Text"), "--Select--", new { id = "txtBranchID", @class = "form-control", @required = "required" })
                </div>
            </div>


Javascript code:
 $('#txtcompid').change(function () {
                var changedtxt = $('#txtcompid').val();
                $.getJSON(
                  "/AslUserCO/BranchLoad", { "Changedtxt": changedtxt},
                  function (myData) {


                      $("#txtBranchID").empty();
                 


                      $.each(myData.branch, function (i, memo) {

                          $("#txtBranchID").append('<option value="'
                              + memo.Value + '">'
                              + memo.Text + '</option>');

                      });


                  });

            });


Here is my method in AslUserCO controller:

        [AcceptVerbs(HttpVerbs.Get)]
        public JsonResult BranchLoad(Int64 changedtxt)
        {
            var selectdata = from n in db.Asl_BranchDbSet where n.COMPID == changedtxt select new {              n.BRANCHID, n.BRANCHNM};
         

           List<SelectListItem> branchlist = new List<SelectListItem>();

            foreach (var x in selectdata)
                {
                    branchlist.Add(new SelectListItem { Text = x.BRANCHNM, Value =                      Convert.ToString(x.BRANCHID) });
                }




            var result = new { branch = branchlist };

            return Json(result, JsonRequestBehavior.AllowGet);

        }


No comments:

Post a Comment