public ICollection <Home> GetByLandlordId(string landlordId)
{
using (var db = new CozyDbContext())
{
return(db.Homes.Where(h => h.LandlordId == landlordId).ToList());
}
}
public MaintenanceStatus GetById(int maintenancestatusId)
{
using (var context = new CozyDbContext())
{
return(context.MaintenanceStatuses.Single(m => m.Id == maintenancestatusId));
}
}
public ICollection <Lease> GetByTenantId(string tenantId)
{
using (var db = new CozyDbContext())
{
return(db.Leases.Where(le => le.TenantId == tenantId).ToList());
}
}
public Payment GetById(int paymentId)
{
using (var db = new CozyDbContext())
{
return(db.Payments.Single(p => p.Id == paymentId));
}
}
public ICollection <Lease> GetByHomeId(int homeId)
{
using (var db = new CozyDbContext())
{
return(db.Leases.Where(le => le.HomeId == homeId).ToList());
}
}
public ICollection <Maintenance> GetMaintenanceStatus(int maintenanceStatusId)
{
using (var db = new CozyDbContext())
{
return(db.Maintenances.Where(m => m.MaintenanceStatus == maintenanceStatusId).ToList());
}
}
public Lease GetById(int leaseId)
{
using (var db = new CozyDbContext())
{
return(db.Leases.Single(le => le.Id == leaseId));
}
}
public ICollection <Maintenance> GetByTenantId(string tenantId)
{
using (var db = new CozyDbContext())
{
return(db.Maintenances.Where(lm => lm.TenantId == tenantId).ToList());
}
}
public Lease GetById(int leaseId)
{
using (var context = new CozyDbContext())
{
return(context.Leases.Single(l => l.Id == leaseId));
}
}
public ICollection <Maintenance> GetByHomeId(int homeId)
{
using (var db = new CozyDbContext())
{
return(db.Maintenances.Where(m => m.HomeId == homeId).ToList());
}
}
public Home GetById(int homeId)
{
using (var db = new CozyDbContext())
{
return(db.Homes.Single(h => h.Id == homeId));
}
}
public Maintenance GetById(int maintenanceId)
{
using (var db = new CozyDbContext())
{
return(db.Maintenances.Single(m => m.Id == maintenanceId));
}
}
public ICollection <Payment> GetByLeaseId(int leaseId)
{
using (var db = new CozyDbContext())
{
var paymentLease = db.Payments.Select(p => p.LeaseId == leaseId).ToList() as ICollection <Payment>;
return(paymentLease);
}
}
public MaintenanceStatus GetById(int maintenanceStatusId)
{
using (var db = new CozyDbContext())
{
var maintenanceStatus = db.MaintenanceStatuses.Single(ms => ms.Id == maintenanceStatusId);
return(maintenanceStatus);
}
}
public ICollection <MaintenanceStatus> GetAll()
{
using (var db = new CozyDbContext())
{
var maintenanceStatusAll = db.MaintenanceStatuses.Select(ms => ms.Id);
return(maintenanceStatusAll.ToList() as ICollection <MaintenanceStatus>);
}
}
public ICollection <Lease> GetByTenantId(string tenantId)
{
using (var context = new CozyDbContext())
{
return(context.Leases
.Where(m => m.TenantId == tenantId)
.ToList());
}
}
public ICollection <Maintenance> GetByMaintenanceStatusId(int maintenancestatusId)
{
using (var context = new CozyDbContext())
{
return(context.Maintenances
.Where(m => m.MaintenanceStatusId == maintenancestatusId)
.ToList());
}
}
public Payment Create(Payment newPayment)
{
using (var db = new CozyDbContext())
{
db.Payments.Add(newPayment);
db.SaveChanges();
}
return(newPayment);
}
public ICollection <Payment> GetByTenantdId(string tenantId)
{
using (var context = new CozyDbContext())
{
return(context.Payments
.Where(p => p.TenantId == tenantId)
.ToList());
}
}
public Lease Create(Lease newLease)
{
using (var db = new CozyDbContext())
{
db.Leases.Add(newLease);
db.SaveChanges();
}
return(newLease);
}
//Microsoft Implement EF Core DB
public Home Create(Home newHome)
{
using (var db = new CozyDbContext())
{
db.Homes.Add(newHome);
db.SaveChanges();
}
return(newHome);
}
public ICollection <Payment> GetByLeaseId(int leaseId)
{
using (var context = new CozyDbContext())
{
return(context.Payments
.Where(p => p.LeaseId == leaseId)
.ToList());
}
}
public Maintenance Create(Maintenance newMaintenance)
{
using (var db = new CozyDbContext())
{
db.Maintenances.Add(newMaintenance);
db.SaveChanges();
}
return(newMaintenance);
}
public Maintenance Update(Maintenance updatedMaintenance)
{
using (var db = new CozyDbContext())
{
var update = GetById(updatedMaintenance.Id);
db.Entry(update).CurrentValues.SetValues(updatedMaintenance);
db.SaveChanges();
return(update);
}
}
public Maintenance Create(Maintenance newMaintenance)
{
using (var context = new CozyDbContext())
{
context.Maintenances.Add(newMaintenance);
context.SaveChanges();
return(newMaintenance);
}
}
public bool DeleteById(int leaseId)
{
using (var db = new CozyDbContext())
{
var lease = GetById(leaseId);
db.Leases.Remove(lease);
db.SaveChanges();
}
return(true);
}
public Lease Update(Lease updatedLease)
{
using (var db = new CozyDbContext())
{
var update = GetById(updatedLease.Id);
db.Entry(update).CurrentValues.SetValues(updatedLease);
db.SaveChanges();
return(update);
}
}
public bool DeleteById(int paymentId)
{
using (var db = new CozyDbContext())
{
var payment = GetById(paymentId);
db.Payments.Remove(payment);
db.SaveChanges();
}
return(true);
}
public bool DeleteById(int maintenanceId)
{
using (var db = new CozyDbContext())
{
var maintenance = GetById(maintenanceId);
db.Maintenances.Remove(maintenance);
db.SaveChanges();
}
return(true);
}
public Payment Update(Payment updatedPayment)
{
using (var db = new CozyDbContext())
{
var update = GetById(updatedPayment.Id);
db.Entry(update).CurrentValues.SetValues(updatedPayment);
db.SaveChanges();
return(update);
}
}
