public List <TenantPayment> GetPayments(int billingCycleId)
{
var data = new PaymentData().GetPayments(billingCycleId);
var tenants = data.GroupBy(p => p.TenantId).ToList();
var tenantPayments = new List <TenantPayment>();
tenants.ForEach(t =>
{
var payments = t.ToList();
var tenantPayment = new TenantPayment()
{
Payment = new Payment()
{
Amount = 0, Balance = 0
},
Tenant = new Tenant()
};
payments.ForEach(p =>
{
if (p.Payment == null)
{
p.Payment = new Payment()
{
Amount = 0, BillingCyclePaidId = 0
};
}
tenantPayment.Tenant = p.Tenant;
tenantPayment.Payment.BillingCyclePaidId = p.Payment.BillingCyclePaidId;
if (tenantPayment.Payment.BillingCyclePaidId == billingCycleId)
{
tenantPayment.Payment.Amount += p.Payment.Amount;
}
});
tenantPayments.Add(tenantPayment);
});
tenantPayments.ForEach(tp =>
{
tp.Payment.Balance = Convert.ToDecimal(tp.Tenant.Apartment.RentCost) - tp.Payment.Amount;
});
return(tenantPayments);
}