public static bool UpdateQRProduct(ListProduct product)
{
using (var _context = new DBQuanLyMaQREntities())
{
_context.ListProduct.AddOrUpdate(product);
_context.SaveChanges();
return(true);
}
}
public static List <ListProduct> getListProduct()
{
using (var _context = new DBQuanLyMaQREntities())
{
var product = (from u in _context.ListProduct
select u).ToList();
return(product);
}
}
public static bool DeleteProduct(ListProduct product)
{
using (var _context = new DBQuanLyMaQREntities())
{
var v = _context.ListProduct.Find(product.STT);
_context.ListProduct.Remove(v);
_context.SaveChanges();
return(true);
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
DBQuanLyMaQREntities db = new DBQuanLyMaQREntities();
if (this.txtSearch.Text.Trim().Length <= 0)
{
BindingSource source = new BindingSource();
source.DataSource = QRController.getListProduct();
this.dtgListProduct.DataSource = source;
}
else
{
dtgListProduct.DataSource = db.ListProduct.Where(x => x.ProductName.Contains(txtSearch.Text) || x.ProductID.Contains(txtSearch.Text)).ToList();
}
}
public static bool AddProduct(ListProduct product)
{
try
{
using (var _context = new DBQuanLyMaQREntities())
{
_context.ListProduct.Add(product);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static ListProduct getProduct(string productID)
{
using (var _context = new DBQuanLyMaQREntities())
{
var product = (from u in _context.ListProduct
where u.ProductID == productID
select u).ToList();
if (product.Count == 1)
{
return(product[0]);
}
else
{
return(null);
}
}
}
