public void Update(Driver driver)
{
using (var context = new IkarContext())
{
context.SaveChanges();
}
}
public async Task <IList <Driver> > GetAsync()
{
using (var context = new IkarContext())
{
return(await context.Drivers.ToListAsync());
}
}
public IList <Driver> Get()
{
using (var context = new IkarContext())
{
return(context.Drivers.ToList());
}
}
public Driver Get(int id)
{
using (var context = new IkarContext())
{
return(context.Drivers.SingleOrDefault(d => d.DriverId == id));
}
}
public async Task <CMR> GetAsync(int id)
{
using (var context = new IkarContext())
{
var cmr = await context.CMRs
.SingleOrDefaultAsync(s => s.CMRId == id);
// Pobieranie wskazanej kolekcji
await context.Entry(cmr).Collection(p => p.WarehouseDocuments).LoadAsync();
await context.Entry(cmr).Reference(p => p.ArrivalAddress).LoadAsync();
await context.Entry(cmr).Reference(p => p.DeliveryAddress).LoadAsync();
// Pobranie wskaznej właściwości
await context.Entry(cmr).Reference(p => p.Truck).LoadAsync();
// Zachłanne pobieranie
//var cmr = await context.CMRs
// .Include(p=>p.Truck)
// .Include(p=>p.Driver)
// .Include(p=>p.WarehouseDocuments.Select(x=>x.Vehicle))
// .SingleOrDefaultAsync(s => s.CMRId == id);
return(cmr);
}
}
public async Task <Driver> GetAsync(int id)
{
using (var context = new IkarContext())
{
return(await context.Drivers
.SingleOrDefaultAsync(d => d.DriverId == id));
}
}
public async Task DeleteAsync(Driver driver)
{
using (var context = new IkarContext())
{
context.Drivers.Remove(driver);
await context.SaveChangesAsync();
}
}
public void Add(Driver driver)
{
using (var context = new IkarContext())
{
context.Drivers.Add(driver);
context.SaveChanges();
}
}
public async Task AddAsync(CMR cmr)
{
using (var context = new IkarContext())
{
context.CMRs.Add(cmr);
await context.SaveChangesAsync();
}
}
public async Task AddAsync(Driver driver)
{
using (var context = new IkarContext())
{
context.Drivers.Add(driver);
System.Diagnostics.Debug.WriteLine(context.Entry(driver).State);
await context.SaveChangesAsync();
}
}
public async Task UpdateAsync(Driver driver)
{
using (var context = new IkarContext())
{
// context.Drivers.Attach(driver);
context.Entry(driver).State = EntityState.Modified;
System.Diagnostics.Debug.WriteLine(context.Entry(driver).State);
await context.SaveChangesAsync();
}
}
