How to calculate the commision of the member?

from 5 member suppose if ist member give a client to the company then company give to ist member 10% directly of investment of client money and 6,4,3,2% to respective member respectvely or if second member give  a client to the company only 3rd ,fourth, fifth will get 4,3,2 % directly.how i will calculate using c# or sql server

hello bhuvana,
        you can create a trigger or store procedure for that
        Let we have a table to insert amount to the table of customer and as you enter the amount value also reflects to commission table.
as

create trigger com1 on custmor for insert
as
declare @amt float 
select @amt=amount from inserted  ----amount is the column for inserting amount in customer table
declare @m1com float
declare @m2com float
declare @m3com float
declare @m4com float
declare @m5com float
set @m1com=@amt*50/100 ---Calculating commission for 1st memeber
set @m2com=@amt*10/100
set @m3com=@amt*10/100---Calculating commission for other memebers
set @m4com=@amt*10/100
set @m5com=@amt*10/100
inset into commission1 values(.....,@m1com,@m2com,@m3com,@m4com,@m5com,....)    ---adding commission of memebers with other values in table

Note - Trigger automatically called when value is ineserted

How you linke the person so we can get Level of Members