public List <StudentMaster> GetDueFeeList(int SchoolId, int FinancialYearID, int ClassID, int SectionID, int FromMonth, int ToMonth) { DALCommon obj = new DALCommon(ConStr); DALFee dal = new DALFee(ConStr); List <StudentMaster> Studentlist = new List <StudentMaster>(); List <FeeHeadList> _FeeHeadList = new List <FeeHeadList>(); try { Studentlist = obj.GetStudentList(SchoolId, FinancialYearID, ClassID, SectionID, 0, ""); Studentlist.ToList().ForEach(p => { p.UnPaidMonth = getUnPaidMonth(p.PaidMonths, FromMonth, ToMonth); _FeeHeadList = dal.GetFeeHeadListForFeeGroup(p.FeeGroup, SchoolId, p.Adminssionno, FinancialYearID); p.PendingAmount = _FeeHeadList.Count() == 0 ? "N/A" : getTotalPaid(dal.GetFeeHeadListForFeeGroup(p.FeeGroup, SchoolId, p.Adminssionno, FinancialYearID), p.UnPaidMonth, FromMonth, ToMonth); }); } catch (Exception ex) { } return(Studentlist.Where(x => !string.IsNullOrEmpty(x.UnPaidMonth)).ToList()); }
public List <FeeHeadList> GetFeeHeadListForFeeGroup(string FeeGroupName, int SchoolID, string AdmissionNo, int FMid) { DALFee dal = new DALFee(ConStr); return(dal.GetFeeHeadListForFeeGroup(FeeGroupName, SchoolID, AdmissionNo, FMid)); }