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);
}
