public async Task <IEnumerable <T> > GetObjectsAsync() { using (var context = new BlackPDbContext()) { return(await context.Set <T>().AsNoTracking().ToListAsync()); } }
//tilføjet: public async Task <T> GetObjectByIdAsync(int id) { using (var context = new BlackPDbContext()) { return(await context.Set <T>().FindAsync(id)); } }
public async Task UpdateObjectAsync(T obj) { using (var context = new BlackPDbContext()) { context.Set <T>().Update(obj); await context.SaveChangesAsync(); } }
public async Task <List <Bracelet> > GetBraceletbyType(Bracelet.BraceletTypes type) { List <Bracelet> brc = new List <Bracelet>(); using (var context = new BlackPDbContext()) { brc = await context.Bracelets .Where(b => b.BraceletType == type) .ToListAsync(); } return(brc); }
public async Task <List <HeadJewelry> > GetHeadJbyType(HeadJewelry.HeadJewelryTypes type) { List <HeadJewelry> hrc = new List <HeadJewelry>(); using (var context = new BlackPDbContext()) { hrc = await context.HeadJewelries .Where(b => b.HeadJewType == type) .ToListAsync(); } return(hrc); }
public async Task <List <Necklace> > GetNecklaceByType(Necklace.NecklaceTypes type) { List <Necklace> nrc = new List <Necklace>(); using (var context = new BlackPDbContext()) { nrc = await context.Necklaces .Where(b => b.NecklaceType == type) .ToListAsync(); } return(nrc); }
public async Task <List <Ring> > GetRingByType(Ring.RingTypes type) { List <Ring> rrc = new List <Ring>(); using (var context = new BlackPDbContext()) { rrc = await context.Rings .Where(b => b.RingType == type) .ToListAsync(); } return(rrc); }
public async Task <List <Earring> > GetEarringbyType(Earring.EarringTypes type) { List <Earring> erc = new List <Earring>(); using (var context = new BlackPDbContext()) { erc = await context.Earrings .Where(b => b.EarringType == type) .ToListAsync(); } return(erc); }
//tilføjet: public async Task <User> GetOrdersByIdAsync(int id) { User user; using (var context = new BlackPDbContext()) { user = context.Users .Include(u => u.Orders) .ThenInclude(j => j.Jewelry) .AsNoTracking() .FirstOrDefault(u => u.Id == id); } return(user); }