Click here to Skip to main content
16,020,249 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi All
Please Help me i have 2 List that contains data for School Software in FEES module


one List contains FEES to Applied of the student based on months and FEES structure
second contains FEES to collect from student month wise and structure wise

problem is that if a student deposit his fees for perticular months then how can i calculate
remaining fees based on applied fees list for perticular month wise.and structure wise that


i am not getting any idea .



my code for applied fees list is

C#
var ljoin = from HeadId in lFeestrmaster2
            join structure in lstrdetaillist
            on HeadId.strId equals structure.strId
         select new { HeadId.strHeadId, structure.strmonthId, structure.fAmount };



and

for deposit fees is

C#
var lCollection = from item in ldetail
                   join Collectionmaster in listaccount
                   on item.BillNo equals Collectionmaster.BillNo
                   select new {Collectionmaster.FeeMonthId,  item.FeeHeadId  , item.FeeAmt} ;




i need to show this data in 2 GRID like
month Id | Remaining Fees (Amount)

and

HeadID | Amount

how can i iterate and get that student has deposite or not deposited his /her fees
with matching months and feesheads .


thanks
Posted
Updated 27-Mar-12 4:13am
v2
Comments
El_Codero 27-Mar-12 10:14am    
code tags added
Ganesan Senthilvel 27-Mar-12 20:55pm    
What exactly are you looking for?

1 solution

Just Using Data reader you can do as you want for compare your fees
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900