private void GetRenewAgreement()
{
RenewAgreement = Houses.Where(h => h.DateTo <= DateTime.Now)
.Select(
rh =>
new RenewAgreement
{
Tenant = rh.Tenant1,
Address = rh.Address1 + " " + rh.Address4,
DateFrom = rh.DateFrom,
DateTo = rh.DateTo,
Email = rh.Email,
Mobile = rh.Mobile,
Rent = rh.Rent
}).ToArray();
Globals.RenewAgreementSheet.renewAgreementBindingSource.DataSource = RenewAgreement;
}