public void DeleteById(Guid id)
{
EfUnitOfWork.ThrowIfNoContext();
var user = GetById(id) ?? throw new ArgumentNullException($"Пользователя с {id} нет в базе");
EfUnitOfWork.Context.Users.Remove(user);
}
public void DeleteById(Guid id)
{
EfUnitOfWork.ThrowIfNoContext();
var product = GetById(id) ?? throw new ArgumentNullException($"Продукта с id: {id} нет в базе");
EfUnitOfWork.Context.Products.Remove(product);
}
public IEnumerable <TransactionsStoredItem> GetAll(Filter filter, int skip, int take)
{
EfUnitOfWork.ThrowIfNoContext();
return(EfUnitOfWork.Context.Transactions
.Skip(skip)
.Take(take)
.OrderByDescending(p => p.DateAdded));
}
public IEnumerable <UserStoredItem> GetAll(Filter filter, int skip, int take)
{
EfUnitOfWork.ThrowIfNoContext();
//todo фильтр можно припилить на что угодно, это пример
return(EfUnitOfWork.Context.Users
.Where(u => u.Name.Contains(filter.AnythingContains))
.Skip(skip)
.Take(take)
.OrderByDescending(u => u.Name));
}
public IEnumerable <ProductsStoredItem> GetAll(Filter filter, int skip, int take)
{
EfUnitOfWork.ThrowIfNoContext();
//todo фильтр можно припилить на что угодно, это пример
return(EfUnitOfWork.Context.Products
.Where(p => p.Title.Contains(filter.AnythingContains) ||
p.Description.Contains(filter.AnythingContains) ||
p.Note.Contains(filter.AnythingContains))
.Skip(skip)
.Take(take)
.OrderByDescending(p => p.Title));
}
public ProductsStoredItem GetById(Guid id)
{
EfUnitOfWork.ThrowIfNoContext();
return(EfUnitOfWork.Context.Products.FirstOrDefault(p => p.Id == id));
}
public void AddNew(ProductsStoredItem product)
{
EfUnitOfWork.ThrowIfNoContext();
EfUnitOfWork.Context.Products.Add(product);
}
public UserStoredItem GetById(Guid id)
{
EfUnitOfWork.ThrowIfNoContext();
return(EfUnitOfWork.Context.Users.FirstOrDefault(u => u.Id == id));
}
public void AddNew(UserStoredItem user)
{
EfUnitOfWork.ThrowIfNoContext();
EfUnitOfWork.Context.Users.Add(user);
}
public TransactionsStoredItem GetById(Guid id)
{
EfUnitOfWork.ThrowIfNoContext();
return(EfUnitOfWork.Context.Transactions.FirstOrDefault(t => t.Id == id));
}
public void AddNew(TransactionsStoredItem transaction)
{
EfUnitOfWork.ThrowIfNoContext();
EfUnitOfWork.Context.Transactions.Add(transaction);
}
