public void AddProduct(Product product)
{
using (var dbContext = new BFUContext())
{
dbContext.Products.Add(product);
dbContext.SaveChanges();
}
}
public void AddClient(Client client)
{
using (var dbContext = new BFUContext())
{
dbContext.Clients.Add(client);
dbContext.SaveChanges();
}
}
public void DeleteProduct(long id)
{
using (var dbContext = new BFUContext())
{
var pr = FindProduct(id);
dbContext.Entry(pr).State = EntityState.Modified;
dbContext.Products.Remove(pr);
dbContext.SaveChanges();
}
}
public void ChangeProduct(Product product)
{
using (var dbContext = new BFUContext())
{
Product pr = FindProduct(product.Id);
pr = product;
dbContext.Entry(pr).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void TakeFromCart(long id)
{
using (var dbContext = new BFUContext())
{
Product pr = FindProduct(id);
pr.ProductReturn();
dbContext.Entry(pr).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void Sale(long prodId)
{
using (var dbContext = new BFUContext())
{
Product pr = FindProduct(prodId);
pr.SaleProduct();
dbContext.Entry(pr).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void ChangeClient(Client client)
{
using (var dbContext = new BFUContext())
{
Client cl = FindClient(client.Id);
cl = client;
dbContext.Entry(cl).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void DeleteAllProducts()
{
using (var dbContext = new BFUContext())
{
foreach (var p in dbContext.Products)
{
dbContext.Products.Remove(p);
}
dbContext.SaveChanges();
}
}
public void DeleteAllClients()
{
using (var dbContext = new BFUContext())
{
foreach (var c in dbContext.Clients)
{
dbContext.Clients.Remove(c);
}
dbContext.SaveChanges();
}
}
public void DeleteClient(int id)
{
using (var dbContext = new BFUContext())
{
foreach (var c in dbContext.Clients)
{
if (c.Id == id)
{
dbContext.Clients.Remove(c);
}
}
dbContext.SaveChanges();
}
}
public void ReturnToSale()
{
using (var dbContext = new BFUContext())
{
foreach (var p in dbContext.Products)
{
if ((DateTime.Now - p.DateBay) >= TimeSpan.FromMinutes(2) && p.Sold == 2)
{
p.ProductReturn();
dbContext.Entry(p).State = EntityState.Modified;
}
}
dbContext.SaveChanges();
}
}
public Product PutToCart(long prodId, long userId)
{
using (var dbContext = new BFUContext())
{
Product pr = FindProduct(prodId);
pr.Sold = 1;
pr.DateBay = DateTime.Now;
if (userId != 0)
{
pr.UserId = userId;
}
dbContext.Entry(pr).State = EntityState.Modified;
dbContext.SaveChanges();
return(pr);
}
}