public async Task <List <AdminAccount> > GetAllAdminAccountsAsync()
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.AdminAccount.ToListAsync());
}
}
public async Task <List <Customer> > GetAllCustomersAsync()
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Customer.ToListAsync());
}
}
public async Task <Customer> GetCustomerAsync(Customer customer)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Customer.FindAsync(customer.ID));
}
}
public async Task <List <Slot> > GetAllSlotsAsync()
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Slot.ToListAsync());
}
}
public async Task <Staff> GetStaffAsync(Staff staff)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Staff.FindAsync(staff.ID));
}
}
public async Task <Block> GetBlockAsync(Block block)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Block.FindAsync(block.ID));
}
}
public async Task <Slot> GetSlotAsync(Slot slot)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Slot.FindAsync(slot.ID));
}
}
public async Task <List <Block> > GetAllBlocksAsync()
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Block.ToListAsync());
}
}
public async Task <Parking> GetParkingAsync(Parking parking)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Parking.FindAsync(parking.LicensePlate));
}
}
public async Task <List <MonthlyIncome> > GetMonthlyIncomesAsync()
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.MonthlyIncome.ToListAsync());
}
}
public async Task <List <Parking> > GetAllParkingsAsync()
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.Parking.ToListAsync());
}
}
public async Task <MonthlyIncome> GetMonthlyIncomeAsync(MonthlyIncome monthlyIncome)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.MonthlyIncome.FindAsync(monthlyIncome.ID));
}
}
public async Task <ParkingLot> GetParkingLotAsync(ParkingLot parkingLot)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.ParkingLot.FindAsync(parkingLot.ID));
}
}
public async Task <AdminAccount> GetAdminAccountAsync(AdminAccount adminAccount)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
return(await context.AdminAccount.FindAsync(adminAccount.ID));
}
}
public async Task UpdateBlockAsync(Block block)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Entry(block).State = EntityState.Modified;
await context.SaveChangesAsync();
}
}
public async Task AddParkingLotAsync(ParkingLot parkingLot)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.ParkingLot.Add(parkingLot);
await context.SaveChangesAsync();
}
}
public async Task UpdateMonthlyIncomeAsync(MonthlyIncome monthlyIncome)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Entry(monthlyIncome).State = EntityState.Modified;
await context.SaveChangesAsync();
}
}
public async Task UpdateSlotAsync(Slot slot)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Entry(slot).State = EntityState.Modified;
await context.SaveChangesAsync();
}
}
public async Task UpdateCustomerAsync(Customer customer)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Entry(customer).State = EntityState.Modified;
await context.SaveChangesAsync();
}
}
public async Task AddMonthlyIncomeAsync(MonthlyIncome monthlyIncome)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.MonthlyIncome.Add(monthlyIncome);
await context.SaveChangesAsync();
}
}
public async Task DeleteParkingAsync(Parking parking)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
Parking pk = await context.Parking.FindAsync(parking.LicensePlate);
context.Parking.Remove(pk);
await context.SaveChangesAsync();
}
}
public async Task AddBlockAsync(Block block)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Block.Add(block);
await context.SaveChangesAsync();
context.Entry(block).State = EntityState.Detached;
}
}
public async Task DeleteMonthlyIncomeAsync(MonthlyIncome monthlyIncome)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
MonthlyIncome income = await context.MonthlyIncome.FindAsync(monthlyIncome.ID);
context.MonthlyIncome.Remove(income);
await context.SaveChangesAsync();
}
}
public async Task AddAdminAccountAsync(AdminAccount adminAccount)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.AdminAccount.Add(adminAccount);
await context.SaveChangesAsync();
context.Entry(adminAccount).State = EntityState.Detached;
}
}
public async Task DeleteBlockAsync(Block block)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
Block bl = await context.Block.FindAsync(block.ID);
context.Block.Remove(bl);
await context.SaveChangesAsync();
}
}
public async Task DeleteSlotAsync(Slot slot)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
Slot sl = await context.Slot.FindAsync(slot.ID);
context.Slot.Remove(sl);
await context.SaveChangesAsync();
}
}
public async Task AddSlotAsync(Slot slot)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Slot.Add(slot);
await context.SaveChangesAsync();
context.Entry(slot).State = EntityState.Detached;
}
}
public async Task DeleteAdminAccountAsync(AdminAccount adminAccount)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
AdminAccount admin = await context.AdminAccount.FindAsync(adminAccount.ID);
context.AdminAccount.Remove(admin);
await context.SaveChangesAsync();
}
}
public async Task DeleteStaffAsync(Staff staff)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
Staff st = await context.Staff.FindAsync(staff.ID);
context.Staff.Remove(st);
await context.SaveChangesAsync();
}
}
public async Task AddStaffAsync(Staff staff)
{
using (ParkingLotManagementContext context = new ParkingLotManagementContext())
{
context.Staff.Add(staff);
await context.SaveChangesAsync();
context.Entry(staff).State = EntityState.Detached;
}
}
