public List <CommonCode2> GetCom2List(string code1)
{
using (var db = new ShopDBContext())
{
return(db.CommonCode2s.Where(c => c.Com1Code1 == code1).ToList());
}
}
public List <CommonCode1> GetCom1List()
{
using (var db = new ShopDBContext())
{
return(db.CommonCode1s.ToList());
}
}
public void CreateProduct(Product product)
{
using (var db = new ShopDBContext())
{
var prod = db.Products.Add(product);
db.SaveChanges();
}
}
public void DeleteProduct(Product product)
{
using (var db = new ShopDBContext())
{
var prod = db.Products.FirstOrDefault(u => u.Code == product.Code);
db.Products.Remove(prod);
db.SaveChanges();
}
}
public void UpdateProduct(Product product)
{
using (var db = new ShopDBContext())
{
var prod = db.Products.FirstOrDefault(u => u.Code == product.Code);
prod.Description = product.Description;
prod.Name = product.Name;
prod.Price = product.Price;
db.SaveChanges();
}
}
public List <Product> GetProductList()
{
using (var db = new ShopDBContext())
{
var pro = db.Products
.Include(p => p.CommonCode1)
.Include(p => p.CommonCode2)
.ToList();
return(pro);
}
}