public Product AddOrUpdate(Product product, Price price)
{
if (product != null && price != null)
{
using (var db = new BlockShopContext())
{
var result = db.Products.Include(p => p.Prices).SingleOrDefault(p => p.ProductId == product.ProductId);
if (result != null)
{
result.Name = product.Name;
result.Unit = product.Unit;
result.Barcode = product.Barcode != "" ? product.Barcode : result.Barcode;
price.PriceId = 0;
price.From = DateTime.Now;
result.Prices.Add(price);
db.SaveChanges();
return(result);
}
else
{
product.ProductId = 0;
product.Prices.Clear();
var result2 = db.Products.Add(product);
price.PriceId = 0;
price.From = DateTime.Now;
result2.Entity.Prices.Add(price);
db.SaveChanges();
return(result2.Entity);
}
}
}
return(null);
}
public Product GetProductByName(string name)
{
Product ret = null;
using (var db = new BlockShopContext()){
ret = db.Products.Include(p => p.Prices).First(p => p.Name.Equals(name));
}
return(ret);
}
public List <Product> GetProducts()
{
List <Product> ret = null;
using (var db = new BlockShopContext())
{
ret = db.Products.Include(p => p.Prices).ToList();
}
return(ret);
}
public List <Product> GetProductsbyName(string name)
{
List <Product> ret = null;
using (var db = new BlockShopContext())
{
ret = db.Products.Where(p => p.Name.StartsWith(name)).ToList();
}
return(ret);
}
public Product GetProductById(int id)
{
Product ret = null;
using (var db = new BlockShopContext())
{
ret = db.Products.Include(p => p.Prices).First(p => p.ProductId.Equals(id));
}
return(ret);
}
public Block SaveBlock(Block block)
{
using (var db = new BlockShopContext())
{
block.Date = DateTime.Now;
db.ChangeTracker.TrackGraph(block, node => node.Entry.State = !node.Entry.IsKeySet ? EntityState.Added : EntityState.Unchanged);
db.SaveChanges();
return(block);
}
}
