Cfrgtkky

It turns out that I have a Jquery from a dropdownlist in casacade, this contains data from districts and services and I want that when a user logs in, only shows the data of the district where the user is from, the user has an assigned district.

This is my code on the controller:

public JsonResult GetServices(int districtId)

    {

        db.Configuration.ProxyCreationEnabled = false;

        var services = db.Services.Where(s => s.DistrictId == districtId).OrderBy(s => s.Name);

        return Json(services);

    }

This is my Jquery Script:

<script type="text/javascript">

   $(document).ready(function () {

       $("#DistrictId").change(function () {

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

           $.ajax({

               type: 'POST',

               url: '@Url.Action("GetServices")',

               dataType: 'json',

               data: { districtId: $("#DistrictId").val() },

               success: function (districts) {

                   $.each(districts, function (i, service) {

                       $("#ServiceId").append('<option value="'

                           + service.ServiceId + '">'

                           + service.Name + '</option>');

                   });

               },

               error: function (ex) {

                   alert('Failed to retrieve services.' + ex);

               }

           });

           return false;

       })

   });

</script>

My View:

<div class="form-group">

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

        <div class="col-md-10">

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

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

        </div>

    </div>



    <div class="form-group">

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

        <div class="col-md-10">

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

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

        </div>

    </div>

Assuming the logged user is consuming the controller method. You can obtain the user and filter by his district id without sending it as a parameter. If you have both dropdowns in the same View, what you are doing seems to be OK. If the problem is that it never goes inside the method, be sure you are using the corresponding Http Verb in this case POST.

[HttpPost]

public JsonResult GetUserServices()

{

    var user = userManager.FindByNameAsync(User.Identity.Name);

    db.Configuration.ProxyCreationEnabled = false;

    var services = db.Services

                    .Where(s => s.DistrictId == user.DistrictId)

                    .OrderBy(s => s.Name);

    return Json(services);

}