public void UpdatePayment(TenantPayment payment)
{
using (var db = new ApartmentManagerContext())
{
db.Payment.Update(payment.Payment);
db.SaveChanges();
}
}
public void UpdateApartment(Apartment apartment)
{
using (var db = new ApartmentManagerContext())
{
var record = db.Apartment.Update(apartment);
db.SaveChanges();
}
}
public int AddPersonContact(PersonContact personContact)
{
using (var db = new ApartmentManagerContext())
{
var record = db.PersonContact.Add(personContact);
db.SaveChanges();
return(record.Entity.Id);
}
}
public int AddAddress(Address address)
{
using (var db = new ApartmentManagerContext())
{
var record = db.Address.Add(address);
db.SaveChanges();
return(record.Entity.Id);
}
}
public List<PaymentMethod> GetPaymentMethods()
{
using (var db = new ApartmentManagerContext())
{
var paymentMethods = db.PaymentMethod
.ToList();
return paymentMethods;
}
}
public void UpdateTenant(Tenant tenant)
{
using (var db = new ApartmentManagerContext())
{
tenant.StartBillingCycle = db.BillingCycle.Find(tenant.StartBillingCycleId);
tenant.EndBillingCycle = db.BillingCycle.Find(tenant.EndBillingCycleId);
db.Tenant.Update(tenant);
db.SaveChanges();
}
}
public List <BillingCycle> GetBillingCycles()
{
using (var db = new ApartmentManagerContext())
{
var billingCycles = db.BillingCycle
.OrderByDescending(o => o.Id)
.ToList();
return(billingCycles);
}
}
public List<TenantPayment> GetPaymentHistory(int id)
{
using (var db = new ApartmentManagerContext())
{
var payments = db.TenantPayment
.Include(tp => tp.Payment)
.ThenInclude(pm => pm.PaymentMethod)
.Where(w => w.TenantId == id && w.Payment != null)
.ToList();
return payments;
}
}
public void AddPayment(TenantPayment payment)
{
using (var db = new ApartmentManagerContext())
{
payment.Tenant.Apartment.Address = db.Address.Find(payment.Tenant.Apartment.Address.Id);
payment.Tenant.Apartment = db.Apartment.Find(payment.Tenant.Apartment.Id);
payment.Tenant = db.Tenant.Find(payment.Tenant.Id);
payment.Payment.PaymentMethod = db.PaymentMethod.Find(payment.Payment.PaymentMethod.Id);
payment.Payment.BillingCyclePaid = db.BillingCycle.Find(payment.Payment.BillingCyclePaidId);
db.Payment.Add(payment.Payment);
db.TenantPayment.Update(payment);
db.SaveChanges();
}
}
public List <Apartment> GetApartments()
{
using (var db = new ApartmentManagerContext())
{
var apartments = db.Apartment
.Where(w => w.Active == true)
.Include(a => a.Address)
.OrderBy(o => o.Available ? 0 : 1)
.ThenBy(o => o.Address.ZipCode)
.ThenBy(o => o.Address.StreetAddress)
.ThenBy(o => o.RoomNumber)
.ToList();
return(apartments);
}
}
public List <Tenant> GetTenants()
{
using (var db = new ApartmentManagerContext())
{
var tenants = db.Tenant
.Where(w => w.Active == true)
.Include(p => p.Person)
.ThenInclude(pc => pc.PersonContact)
.Include(a => a.Apartment)
.ThenInclude(ad => ad.Address)
.Include(bc => bc.StartBillingCycle)
.Include(bc => bc.EndBillingCycle)
.OrderBy(o => o.Person.LastName)
.ToList();
return(tenants);
}
}
public void AddTenant(Tenant tenant)
{
using (var db = new ApartmentManagerContext())
{
tenant.Apartment.Address = db.Address.Find(tenant.Apartment.Address.Id);
tenant.Apartment = db.Apartment.Find(tenant.Apartment.Id);
tenant.StartBillingCycle = db.BillingCycle.Find(tenant.StartBillingCycleId);
tenant.EndBillingCycle = db.BillingCycle.Find(tenant.EndBillingCycleId);
tenant.Apartment.Available = false;
db.Tenant.Add(tenant);
var tenantPayment = new TenantPayment()
{
TenantId = tenant.Id
};
db.TenantPayment.Add(tenantPayment);
db.SaveChanges();
}
}
public List<TenantPayment> GetPayments(int billingCycleId)
{
using (var db = new ApartmentManagerContext())
{
var payments = db.TenantPayment
.Include(t => t.Tenant)
.ThenInclude(pe => pe.Person)
.Include(t => t.Tenant)
.ThenInclude(a => a.Apartment)
.ThenInclude(ad => ad.Address)
.Include(p => p.Payment)
.Where(w => w.Tenant.EndBillingCycle.Id >= billingCycleId &&
w.Tenant.StartBillingCycle.Id <= billingCycleId &&
w.Tenant.Active == true)
.OrderBy(o => o.Tenant.Person.LastName)
.ThenBy(o => o.Tenant.Person.FirstName)
.ThenBy(o => o.Tenant.Apartment.Address.StreetAddress)
.ThenBy(o => o.Tenant.Apartment.RoomNumber)
.ToList();
return payments;
}
}
