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; } }