public async Task <bool> Delete <S>(S id)
{
// overkill reflection attempt
// var idType = id.GetType();
// var idProperty = idType.GetProperty(propertyName);
_context = new VehicleDiaryDbContext();
T res = await _context.Set <T>().FindAsync(id);
_context.Set <T>().Remove(res);
await _context.SaveChangesAsync();
return(true);
}
public async Task <T> Update(T entity)
{
_context = new VehicleDiaryDbContext();
_context.Set <T>().AddOrUpdate(entity);
await _context.SaveChangesAsync();
return(entity);
}
public async Task <T> Create(T entity)
{
_context = new VehicleDiaryDbContext();
var res = _context.Set <T>().Add(entity);
await _context.SaveChangesAsync();
return(res);
}
public async Task <ServiceUserModel> Get(string username)
{
return(await _context.Set <ServiceUserModel>().Where(o => o.User.Username == username).FirstOrDefaultAsync());
}
public async Task <VehicleModel> GetVehicleWithAllData(string vin)
{
return(await _context.Set <VehicleModel>().Where(v => v.Vin == vin).Include(v => v.VehicleSpecification).Include(v => v.Accidents).Include(v => v.Services).Include(v => v.SaleListing).FirstOrDefaultAsync());
}
public async Task <UserModel> CheckCredentials(string username)
{
return(await _context.Set <UserModel>().FindAsync(username));
}
public async Task <IEnumerable <T> > GetAll()
{
_context = new VehicleDiaryDbContext();
return(await _context.Set <T>().ToListAsync());
}
public Task <T> Get <S>(S id)
{
_context = new VehicleDiaryDbContext();
return(_context.Set <T>().FindAsync(id));
}