Json Result with Date Parameters

In MVC and want create dynamic DropDown which is depending upon Date Filed. How Can I Write Code for Json and use same in View

I write following Json Code

public JsonResult GetAttnList(string ProductionDate)
{
Response.CacheControl = "no-cache";
LPDBContext DB = new LPDBContext();
List AtnList = db.Attens.Where(x => x.ATTNDATE.ToShortDateString().Equals(ProductionDate)).ToList();
return Json(AtnList, JsonRequestBehavior.AllowGet);
}

View Code is

$("#PRDate").change(function () {
$.get("/Dailyproduction/GetAttnList", { ProductionDate: $("#PRDate").val() }, function (data) {
$("#ATTNSYSID").empty();
$.each(data, function (index, row) {
$("#ATTNSYSID").append(" + row.ATTNSYSID + "'>" + row.EmpName + "")
});

Hi Wong,

No, I do not get any error, but Dropdown could not display list.

My Detail code for Add View is as below

@model EasyApp.Models.Process
@{
ViewBag.Title = "Create";
}
"~/Content/PagedList.css" rel="stylesheet" type="text/css" />
"~/Content/TablesStyle.css" rel="stylesheet" type="text/css" />
"~/Content/CustomStyle.css" rel="stylesheet" type="text/css" />
"~/Content/jquery-ui.css" rel="stylesheet" />
"~/Scripts/jquery-1.12.4.js">
"~/Scripts/jquery-ui-1.12.1.js">
"text/javascript">
$(document).ready(function () {
$(function () {
$("#datepicker").datepicker({
dateFormat: 'dd/mm/yy'
});
});
$("#PRDate").change(function () {
$.get("/Dailyproduction/GetAttnList", { ProductionDate: $("#PRDate").val() }, function (data) {
$("#ATTNSYSID").empty();
$.each(data, function (index, row) {
$("#ATTNSYSID").append(" + row.ATTNSYSID + "'>" + row.EmpName + "")
});
});
});
});
Add Daily Production
class="EasyViewDiv">
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
class="form-horizontal">
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
class="form-group">
@Html.LabelFor(model => model.StageID, "Stage Name", htmlAttributes: new { @class = "control-label col-md-2" })
class="col-md-10">
@Html.DropDownList("StageID", null, htmlAttributes: new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.StageID, "", new { @class = "text-danger" })

3 Replies

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

Catcher Wong9y ago
@Raju Fodse

I have tried your code , the code runs well for me !!

If you do not get the result , you need to debug whether the json data is empty or not !

you can add the below code to test or add break points on your GetAttnList method.
$("#PRDate").change(function () {
$.get("/Dailyproduction/GetAttnList",
{ ProductionDate: $("#PRDate").val() },
function (data) {
console.log(data);
$("#ATTNSYSID").empty();
$.each(data, function (index, row) {
$("#ATTNSYSID").append(" + row.ATTNSYSID + "'>" + row.EmpName + "")
});
});
});
Raju Fodse9y ago
Hi Wong,

No, I do not get any error, but Dropdown could not display list.
My Detail code for Add View is as below
@model EasyApp.Models.Process
@{
    ViewBag.Title = "Create";
}



    "~/Content/PagedList.css" rel="stylesheet" type="text/css" />
    "~/Content/TablesStyle.css" rel="stylesheet" type="text/css" />
    "~/Content/CustomStyle.css" rel="stylesheet" type="text/css" />
    "~/Content/jquery-ui.css" rel="stylesheet" />
    "~/Scripts/jquery-1.12.4.js">
    "~/Scripts/jquery-ui-1.12.1.js">

    "text/javascript">

        $(document).ready(function () {

            $(function () {
                $("#datepicker").datepicker({
                    dateFormat: 'dd/mm/yy'
                });

            });

            $("#PRDate").change(function () {
                $.get("/Dailyproduction/GetAttnList", { ProductionDate: $("#PRDate").val() }, function (data) {
                    $("#ATTNSYSID").empty();
                    $.each(data, function (index, row) {
                        $("#ATTNSYSID").append(" + row.ATTNSYSID + "'>" + row.EmpName + "")
                    });

                });
            });

        });




Add Daily Production

    class="EasyViewDiv">
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()

            class="form-horizontal">


                @Html.ValidationSummary(true, "", new { @class = "text-danger" })
                class="form-group">
                    @Html.LabelFor(model => model.StageID, "Stage Name", htmlAttributes: new { @class = "control-label col-md-2" })
                    class="col-md-10">
                        @Html.DropDownList("StageID", null, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.StageID, "", new { @class = "text-danger" })

Json Result with Date Parameters

Add Daily Production