//Delete
public void DeleteTenant(int tenantId)
{
var db = new TenantContext();
var p = db.Tenants.SingleOrDefault(t => t.Id == tenantId);
if (p != null)
{
db.Tenants.Remove(p);
db.SaveChanges();
}
else
{
throw new ApplicationException("Can not find the tenant");
}
}
//Insert
public void CreateTenant(string fullname,
string rentalPropertyAddress,
DateTime moveInDate,
DateTime leaseEndDate,
decimal monthlyPayment)
{
var db = new TenantContext();
db.Tenants.Add(
new Tenant
{
FullName = fullname,
RentalPropertyAddress = rentalPropertyAddress,
MoveInDate = moveInDate,
LeaseEndDate = leaseEndDate,
MonthlyPayment = monthlyPayment
});
db.SaveChanges();
}
//Edit
public void EditTenant(int id, string fullname,
string rentalPropertyAddress,
DateTime moveInDate,
DateTime leaseEndDate,
decimal monthlyPayment)
{
var db = new TenantContext();
var p = db.Tenants.SingleOrDefault(t => t.Id == id);
if (p != null)
{
p.FullName = fullname;
p.RentalPropertyAddress = rentalPropertyAddress;
p.MoveInDate = moveInDate;
p.LeaseEndDate = leaseEndDate;
p.MonthlyPayment = monthlyPayment;
db.SaveChanges();
}
else
{
throw new ApplicationException("Can not find the tenant");
}
}