private void searchControl_OnSearch(object sender, Misc.SearchEventArgs e) { using (var p = new POSEntities()) { var s = p.Customers.Where(x => x.Name.Contains(e.Text)); if (s.Count() == 0) { MessageBox.Show("Entry not found.", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } e.SearchFound = true; customerTable.Rows.Clear(); foreach (var i in s) { customerTable.Rows.Add( i.Id, i.Name, i.Address, i.ContactDetails, "Delete", "Transactions" ); } } }
private async void searchControl1_OnSearch(object sender, Misc.SearchEventArgs e) { using (var p = new POSEntities()) { IEnumerable <StockinHistory> s = null; s = p.StockinHistories.Where(x => x.SerialNumber == e.Text); if (s.Count() == 0) { s = p.StockinHistories.AsEnumerable().Where(x => x.ItemName.Contains(e.Text)); } if (dateTimePicker1.Checked) { s = s.Where(x => x.Date.Value.Date == dateTimePicker1.Value.Date); } if (s.Count() == 0) { MessageBox.Show("No items found.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } e.SearchFound = true; histTable.Rows.Clear(); var row = await createRowAsync(s); histTable.Rows.AddRange(row); } }
private void searchControl1_OnSearch(object sender, Misc.SearchEventArgs e) { using (var p = new POSEntities()) { var supps = p.Suppliers.Where(x => x.Name.Contains(e.Text)); if (supps.Count() != 0) { e.SearchFound = true; supplierTable.Rows.Clear(); foreach (var i in supps) { supplierTable.Rows.Add(i.Id, i.Name, i.ContactDetails, "Delete"); } return; } MessageBox.Show("Entry not found"); } }
private void searchControl1_OnSearch(object sender, Misc.SearchEventArgs e) { using (var p = new POSEntities()) { var searchedItems = p.InventoryItems.Where(x => x.Product.Item.Barcode == e.Text); if (searchedItems.Count() == 0) { searchedItems = p.InventoryItems.Where(x => x.SerialNumber == e.Text); if (searchedItems.Count() == 0) { searchedItems = p.InventoryItems.Where(x => x.Product.Item.Name.Contains(e.Text)); } } e.SearchFound = true; itemTables.Rows.Clear(); foreach (var i in searchedItems) { itemTables.Rows.Add(i.Id, i.Quantity == 0 ? "Inifinite" : i.Quantity.ToString(), i.Product.Item.Barcode, i.SerialNumber, i.Product.Item.Name, i.Product.Supplier.Name); } } }