public static List <Product> getlistProduct()
{
using (var _context = new DBproductqrbarcodeEntities())
{
var product = (from u in _context.Products
select u).ToList();
return(product);
}
}
public static bool DeleteProduct(Product product)
{
using (var _context = new DBproductqrbarcodeEntities())
{
var products = (from u in _context.Products
where u.codeBarQR == product.codeBarQR
select u).SingleOrDefault();
_context.Products.Remove(products);
_context.SaveChanges();
return(true);
}
}
public static bool UpdateProduct(Product product)
{
try
{
using (var _context = new DBproductqrbarcodeEntities())
{
_context.Products.AddOrUpdate(product);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static Product getProduct(string codebarqr)
{
using (var _context = new DBproductqrbarcodeEntities())
{
var product = (from u in _context.Products
where u.codeBarQR == codebarqr
select u).ToList();
if (product.Count == 1)
{
return(product[0]);
}
else
{
return(null);
}
}
}
public static List <Product> getlistProduct(string productbarqrcode)
{
using (var _context = new DBproductqrbarcodeEntities())
{
var product = (from u in _context.Products.AsEnumerable()
where u.nameProduct.Contains(productbarqrcode)
select u
).Select(x => new Product
{
codeBarQR = x.codeBarQR,
nameProduct = x.nameProduct,
Price = x.Price,
dateCreate = x.dateCreate,
Descriptions = x.Descriptions,
pathImage = x.pathImage
}).ToList();
return(product);
}
}
