Wednesday, October 28, 2015

JSON for generate - combobox value


JSON for generate - combobox value

var Isd = $('#Id').textbox('getValue');

var lIsd = $('#Line_Id').textbox('getValue');

get value from a text box for param that generate combobox value

    var urlTrx = '/controller/method';

url to access method that implemented in controller

    $.ajax({
        url: urlTrx,

implement url to ajax call

        type: 'POST',

ajax call type

        dataType: "JSON",

ajax call data type

        data: { reqID: Isd, lineID: lIsd },

ajax call pass data value that required for Controller.method in url
variable name must have same in method controller for sample method in controller:

public JsonResult GetVehicleName(String reqID, String lineID)

is have same variable name like JSON data (reqID, lineID):

data: { reqID: heq_request_Isd, lineID: heq_requestLine_Isd },

sample Controller method:

public JsonResult GetVehicleName(String reqID, String lineID)
        {
            String Query = "SELECT * from Tabel where id="+reqID+" and lineid="+lineID;

 List<amodel> itemList = new List<amodel>();
            SqlDataReader Reader = OkiDbTools.ReadDb(Query);
            if (Reader.HasRows)
            {
                while (Reader.Read())
                {
                    amodel Itm = new amodel();
                    Itm.Vehicle_Id = Reader.GetInt32(0);
                    Itm.Vehicle_Name = Reader.GetString(1);
                    itemList.Add(Itm);
                }
            }
            Reader.Close();
            Reader.Dispose();
            return Json(itemList);
        }  
        success: function (result) {
            $('#Vehicle_Id').combobox({
                valueField: 'Vehicle_Id',
                textField: 'Vehicle_Name',
                data: result
            });
        }

    });}

populate json result to combobox

        success: function (result) {
            $('#Vehicle_Id').combobox({
                valueField: 'Vehicle_Id',
                textField: 'Vehicle_Name',
                data: result
            });



        }


full AJAX CALL:

var Isd = $('#Id').textbox('getValue');

var lIsd = $('#Line_Id').textbox('getValue');
    var urlTrx = '/HeqDispatchers/GetVehicleName';

    $.ajax({
        url: urlTrx,
        type: 'POST',
        dataType: "JSON",
        //data: formData,
        data: { reqID: heq_request_Isd, lineID: heq_requestLine_Isd },
        success: function (result) {
            $('#Vehicle_Id').combobox({
                valueField: 'Vehicle_Id',
                textField: 'Vehicle_Name',
                data: result
            });
        }

    });}

No comments:

Post a Comment