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); } } }