public override void Update(Customer entity)
{
using (Context = new SysInventoryEntities())
{
var found = Context.Customers.Find(entity.Id);
if (found == null)
{
return;
}
found.Mail = entity.Mail;
found.Name = entity.Name;
found.AddressFk = entity.Address.Id;
found.AddressTypeFk = entity.AddressType.Id;
Context.SaveChanges();
}
}
public override Address GetSingle <TKey>(TKey pkValue)
{
Context = new SysInventoryEntities();
return(Context.Addresses.Find(pkValue));
}
public override IQueryable <Address> GetAll()
{
Context = new SysInventoryEntities();
return(Context.Addresses.Include("City"));
}
public override IQueryable <Customer> GetAll(Expression <Func <Customer, bool> > whereExpression)
{
Context = new SysInventoryEntities();
return(Context.Customers.Include("Address").Where(whereExpression));
}
public override IQueryable <AddressType> GetAll()
{
Context = new SysInventoryEntities();
return(Context.AddressTypes);
}
public override IQueryable <Customer> GetAll()
{
Context = new SysInventoryEntities();
return(Context.Customers.Include("Address"));
}
public override ILogEntry GetSingle <TKey>(TKey pkValue)
{
using (Context = new SysInventoryEntities())
return(Context.v_logentries.Find(pkValue));
}
public override void Update(ILogEntry entity)
{
using (Context = new SysInventoryEntities())
Context.LogClear(entity.Id);
}
public override IQueryable <ILogEntry> GetAll(Expression <Func <ILogEntry, bool> > whereExpression)
{
Context = new SysInventoryEntities();
return(whereExpression != null?Context.v_logentries.Where(whereExpression) : Context.v_logentries);
}
public override IQueryable <ILogEntry> GetAll()
{
Context = new SysInventoryEntities();
return(Context.v_logentries);
}
public override IQueryable <WindowFunction> GetAll()
{
Context = new SysInventoryEntities();
return(Context.WindowFunctions);
}
public override ILocation GetSingle <TKey>(TKey pkValue)
{
using (Context = new SysInventoryEntities())
return(Context.LocationEfs.Find(pkValue));
}
public override IQueryable <ILocation> GetAll()
{
Context = new SysInventoryEntities();
return(Context.LocationEfs.OrderBy(x => x.Name));
}
