Hello Term, I have 4 tables, and table one is tblCLass which contain ClassId and ClassName, and table two is tblRegistrationFeesTable which contain RegistrationId, Fees, and ClassId and the Table 3 is tblTerm which contain TermId and TermName, and in table 4 is tblFeesPayment which contain FeesId,Payment date Student name,TermId, RegistrationId,ClassId, FeesPaid, Wallet and and I want to select ClassName and then it will fetch Fee by RegistrationId and whenever I select ClassName I want the existig fees to show in the approved textbox. But when I select ClassName the fees doesn't show in the approved textbox.
public ActionResult GetStudentFees(int registrationId, int classId) { decimal SchoolFees = objBasicShoolDBEntities.tblRegistrationFees.Single(model => model.RegistrationId == registrationId && model.ClassId == classId).Fees; return Json(SchoolFees, JsonRequestBehavior.AllowGet); }
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) { $("#txtRegistrationFees").val(parseFloat(data).toFixed(2)); }, error: function () { alert("There is some problem to get school fees."); } }); }