public async Task Update(Contractor item)
{
using (var dataContext = new ContractorsDataContext())
{
dataContext.Entry(item).State = EntityState.Modified;
await dataContext.SaveChangesAsync();
}
}
public async Task Add(Contractor item)
{
using (var dataContext = new ContractorsDataContext())
{
dataContext.Contractors.Add(item);
await dataContext.SaveChangesAsync();
}
}
public async Task Expand(Contractor item)
{
byte[] photoRaw;
using (var dataContext = new ContractorsDataContext())
{
photoRaw = await
(from x in dataContext.Contractors.AsNoTracking()
where x.Id == item.Id
select x.PhotoRaw).FirstAsync();
}
item.PhotoRaw = photoRaw;
}
public async Task <IEnumerable <Contractor> > GetItems()
{
using (var dataContext = new ContractorsDataContext())
{
return(await(from x in dataContext.Contractors.AsNoTracking()
select new Contractor
{
Id = x.Id,
Name = x.Name,
Description = x.Description,
Email = x.Email,
Phone = x.Phone,
Web = x.Web,
Address = x.Address,
HasLazyPhoto = x.HasLazyPhoto
}).ToListAsync());
}
}
