Fetch data query fails

Am thinking may be the reason why the fees is not coming is how am selecting the class name, from above query 

Thank you team,

I change the class table and registration table to one instead of two and it is working the way I want it.

Hello Emmmanuel,

As you shared SQL server table data in that snippet there is no registrationId = 11. could you please check that table you are getting values for registrationId 11;

If not then please select other which are eixists in table and test it.

Am thinking may be the reason why the fees is not coming is how am selecting the class name, from above query 

Hello Kumar

even though the error is no longer showing, when I select the ClassName it doesn't fetch it associated fee, any other help would be greatly appreciated

Hello Emmmanuel,

As per your last code snnipet, You are passing only registrationId from your AJAX call but in mvc controller you have two parameter 

registrationId and TemlyFeesPaymentViewModel, so this one must change only the registrationId you need to pass in the controller method as well.

As per your table data registration Id is primary key so only one row will be there for one registrationId,

public ActionResult GetStudentFees(int registrationId, int classId)
{
decimal schoolFee= 0m;
            decimal SchoolFees = objBasicShoolDBEntities.tblRegistrationFees.SingleOrDefault(model => model.RegistrationId == registrationId);
if(SchoolFees != 0)
{
 schoolFee = SchoolFees.Fees
}
else
{
schoolFee = 0d;
}            return Json(new { Fees = schoolFee, JsonRequestBehavior.AllowGet);
}

With the debugger in the JavaScript function, is selecting the FeeId  alright but the function says localhost: says there is some problem to get school fees 

Please it is still not working, any other way would be appreciated 

Jobin yes classInfo has ClassId

Hi ,

if (registrationFee == null) Check this condition null criteia 

I need to debug the code to see if the classInfo object has a ClassId property and check whether it's filled in correctly. I can go through the code line by line to make sure everything's as expected

Hello Kumar,

The query works perfectly when I execute in the SQL database, it fetch the first row 

Have you checked registrationId and classId values from the method parameter,

if you are getting the below parameter,

 registrationId =3  , classId =11 

Then below query will execute in the SQL server and return the first row,

select Fees from Registration where registrationId =3  and classId =11 ;

execute below query and check in sql server. 

Hello Emmmanuel,

Are you getting error? if Yes

then you need to check this line,

 decimal SchoolFees = objBasicShoolDBEntities.tblRegistrationFees.Single(model => model.RegistrationId == registrationId && model.ClassId == classId).Fees;

in Linq the .single () extension method expects only single values for specified where clause. In the above case maybe you are not getting values or maybe more than one value for given registrationId and classId.

Hi Emmanuel,

var registrationFee = objBasicShoolDBEntities.tblRegistrationFees .SingleOrDefault(rf => rf.RegistrationId == registrationId && rf.ClassId == classInfo.ClassId);

return Json(new { Fee = registrationFee.Fees }, JsonRequestBehavior.AllowGet);

in Ajax Function some modification

function GetTermlyFees(registrationId) {
    $.ajax({
        async: true,
        type: 'GET',
        dataType: 'JSON',
        contentType: 'application/json; charset=utf-8',
        data: { registrationId: registrationId },
        url: '/Home/GetStudentFees',
        success: function (data) {
            if (data.Error) {
                alert("Error: " + data.Error);
            } else {
                $("#txtRegistrationFees").val(parseFloat(data.Fee).toFixed(2));
            }
        },
        error: function (xhr, status, error) {
            console.error("AJAX error:", status, error);
            console.error("Response text:", xhr.responseText);
            alert("There is some problem to get school fees.");
        }
    });
}