public async Task AddTransaction(Transaction transaction) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { showRoomDbContext.Transactions.Add(transaction); await showRoomDbContext.SaveChangesAsync(); } }
public async Task AddCustomer(Customer customer) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { showRoomDbContext.Customers.Add(customer); await showRoomDbContext.SaveChangesAsync(); } }
public async Task AddBrand(Brand brand) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { showRoomDbContext.Brands.Add(brand); await showRoomDbContext.SaveChangesAsync(); } }
public async Task AddBike(Bike bike) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { showRoomDbContext.Bikes.Add(bike); await showRoomDbContext.SaveChangesAsync(); } }
public async Task DeleteBike(int bikeId) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { var d = showRoomDbContext.Bikes.Single(x => x.BikeId == bikeId); showRoomDbContext.Bikes.Remove(d); await showRoomDbContext.SaveChangesAsync(); } }
public async Task <Customer> GetCustomer(string name) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { var nofcustomer = showRoomDbContext.Customers.First(x => x.Email.Equals(name)); await showRoomDbContext.SaveChangesAsync(); return(nofcustomer); } }
public async Task <Bike> GetBikeDetails(int bikeId) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { Bike bike = showRoomDbContext.Bikes.First(x => x.BikeId == bikeId); await showRoomDbContext.SaveChangesAsync(); return(bike); } }
public async Task UpdateBike(Bike bike) { using (ShowRoomDbContext showRoomDbContext = new ShowRoomDbContext()) { Bike bikeUpdate = showRoomDbContext.Bikes.Find(bike.BikeId); bikeUpdate.BikeName = bike.BikeName; bikeUpdate.BikeCC = bike.BikeCC; bikeUpdate.DiscBrakes = bike.DiscBrakes; bikeUpdate.BikePrice = bike.BikePrice; bikeUpdate.Milage = bike.Milage; await showRoomDbContext.SaveChangesAsync(); } }