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