Retrieving a list data by JSON in MVC4

Question

0.00/5 (No votes)

See more:

I am a beginner in MVC. Now i am trying to retrieve a list data from a controller. I am not getting any error while fetching the data. But its not working.

My code is,

Client Side

JavaScript

function ff_bind(drop_compny, drop_survey) {
        alert("test");
        debugger;
        $.ajax({
            type: "POST",
            url: "../ManageEmployeNumber/ff_bind_dept",
            contentType: "application/json; charset=utf-8",
            data: "{ 'comp_id': " + drop_compny + ",'surv_id':" + drop_survey + " }",            
            //data: { comp_id: drop_compny },
            dataType: "json",
            success: function (data) {
                debugger;
                alert(result)
            },
            error: function (response) {
                debugger;
                alert(response.d);
            }
        });
    }

server side

C#

public tblDepartment[] ff_bind_dept(int comp_id, int surv_id)
        {
           
            List<tblDepartment> lis_dept = new List<tblDepartment>();
            lis_dept = db.tblDepartments.Where(s => s.CompID == comp_id).ToList();

            return lis_dept.ToArray();
        }

Class

XML

public partial class tblDepartment
    {
        public decimal DeptID { get; set; }
        public Nullable<decimal> CompID { get; set; }
        public string DeptName { get; set; }
        public Nullable<decimal> NoEmployee { get; set; }
        public Nullable<double> TrgScore { get; set; }

        public virtual tblCompany tblCompany { get; set; }
    }

please help me...

thanks in advance..

Posted 16-Jul-15 23:58pm

vineeth raju

Updated 17-Jul-15 0:36am

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anil Vaghasiya · Accepted Answer · 2015-07-17T00:55:00

Solution 1

JavaScript

function ff_bind(drop_compny, drop_survey) {
        alert("test");
        debugger;
        $.ajax({
            type: "POST",
            data: "{ comp_id: '" + drop_compny + "',surv_id:'" + drop_survey + "' }",
            url: "../ManageEmployeNumber/ff_bind_dept",
            contentType: "application/json; charset=utf-8",
           //data: { comp_id: drop_compny },
            dataType: "json",
            success: function (data) {
                debugger;
                alert(result)
            },
            error: function (response) {
                debugger;
                alert(response.d);
            }
        });
    }

Posted 17-Jul-15 0:55am

Anil Vaghasiya

Updated 17-Jul-15 1:01am

v3

Comments

Anil Vaghasiya 17-Jul-15 7:04am

Hello,

have you use webapi for ff_bind_dept Methods??

vineeth raju 17-Jul-15 7:10am

yes..
Actually ff_bind_dept function is working fine. but lis_dept.ToArray() value is not getting into success fieldof json. Instead of that its going to error and showing undefined.

Anil Vaghasiya 17-Jul-15 7:24am

//Just Use this Method
function ff_bind(drop_compny, drop_survey) {
$http.post("http://localhost:16208/api/ManageEmployeNumber/ff_bind_dept", { headers: { 'data': '{ comp_id: '" + drop_compny + "',surv_id:'" + drop_survey + "' }','Content-Type': 'application/JSON', 'data-Type': 'JSON' } })
.success(function (response) {
alert(response);
});
}

//In WebAPI add Headers
[System.Web.Http.AcceptVerbs("GET", "POST")]
[System.Web.Http.HttpGet]
public tblDepartment[] ff_bind_dept(int comp_id, int surv_id)
{

List<tblDepartment> lis_dept = new List<tblDepartment>();
lis_dept = db.tblDepartments.Where(s => s.CompID == comp_id).ToList();

return lis_dept.ToArray();
}

vineeth raju 17-Jul-15 7:42am

Which js is used for $http. Angular js?

Anil Vaghasiya 17-Jul-15 7:46am

Yes I Used Angular JS and which You are Using and which you want??

vineeth raju 17-Jul-15 7:52am

I tried the same but I am getting console error in $http.

Anil Vaghasiya 17-Jul-15 7:30am

Have You Tried to test the method by using debug point to check whether the method is called or not ??

[no name] 17-Jul-15 7:32am

Hi,

it's working fine for me. i have also used WebAPI and it's very good solution for me.

Thanks alot Mr.Anil Vaghasiya

vineeth raju 17-Jul-15 7:45am

Still its not working for me.. Can you please explain that?

Anil Vaghasiya 17-Jul-15 8:06am

Hello,
have you added angular.min.js in your head section if not then put the angular.min.js in your head section.
<script src="JS/angular.min.js"></script>

vineeth raju 20-Jul-15 0:30am

I have used this one.
<script src="//ajax.googleapis.com/ajax/libs/angularjs/1.4.3/angular.min.js"></script>

Anil Vaghasiya 20-Jul-15 0:59am

Okay then do it
//Just Use this Method
function ff_bind(drop_compny, drop_survey) {
$http.post("http://localhost:16208/api/ManageEmployeNumber/ff_bind_dept", { headers: { 'data': '{ comp_id: '" + drop_compny + "',surv_id:'" + drop_survey + "' }','Content-Type': 'application/JSON', 'data-Type': 'JSON' } })
.success(function (response) {
alert(response);
});
}

//In WebAPI add Headers
[System.Web.Http.AcceptVerbs("GET", "POST")]
[System.Web.Http.HttpGet]
public tblDepartment[] ff_bind_dept(int comp_id, int surv_id)
{

List<tblDepartment> lis_dept = new List<tblDepartment>();
lis_dept = db.tblDepartments.Where(s => s.CompID == comp_id).ToList();

return lis_dept.ToArray();
}

After that Please Debug it and check the methods whether it Successfully called or not :)

vineeth raju 20-Jul-15 3:53am

Still its not working. So i used

location.href = '@Url.Action("LoadNew","ManageEmployeNumber")?drop_compny=' + drop_compny + '&drop_survey=' + drop_survey + '';

----------------------------------------------------

[HttpGet]
public ActionResult LoadNew(int drop_compny, int drop_survey)
{

List<tblEmployeetarget> lis_emp_targt = new List<tblEmployeetarget>();
lis_emp_targt = db.tblEmployeetargets.Where(s => s.COMP_ID == drop_compny && s.SURVEY_ID == drop_survey).ToList();

List<tblDepartment> lis_dept = new List<tblDepartment>();
lis_dept = db.tblDepartments.Where(s => s.CompID == drop_compny).ToList();

var joined = (from dep in lis_dept
join emp in lis_emp_targt
on dep.DeptID equals emp.DEPT_ID // join on some property
//into grouping
//from emp in grouping.DefaultIfEmpty()
select new mang_emp { tblDepartment = dep, tblEmpTarget = emp }).ToList();

TempData["drop_compny"] = drop_compny;
TempData["drop_survey"] = drop_survey;

TempData["lis_dept"] = joined;

return RedirectToAction("Load");
}

Anil Vaghasiya 20-Jul-15 5:02am

ok now it's work correctly If Yes then closed the Question. Thank You

Retrieving a list data by JSON in MVC4

1 solution

Solution 1

Add your solution here

Preview 0

Retrieving a list data by JSON in MVC4

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us