public void loadData()
{
OrderOptions.selectItemName = null;
foreach (Control control in flowLayoutPanel1.Controls)
{
flowLayoutPanel1.Controls.Remove(control);
control.Dispose();
}
flowLayoutPanel1.Controls.Clear();
using (var db = new SunwayCafeContext())
{
var query = db.Items.ToList();
OrderOptions[] order = new OrderOptions[query.Count];
foreach (var itemList in query)
{
order[i] = new OrderOptions(this);
order[i].Name_details = itemList.Name;
if (itemList.ImageURL != null)
{
order[i].displayImage = ConvertBinaryToImage(itemList.ImageURL);
}
order[i].Price = itemList.SellingPrice;
order[i].CostPrice = itemList.CostPrice;
order[i].WasClicked += OrderGrid_WasClicked;
flowLayoutPanel1.Controls.Add(order[i]);
i++;
}
i = 0;
}
}
private void delete_Click_1(object sender, EventArgs e)
{
if (OrderOptions.selectItemName != null)
{
DialogResult dialogResult = MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var db = new SunwayCafeContext())
{
var query = db.Items.ToList();
OrderOptions[] order = new OrderOptions[query.Count];
Item delItem;
foreach (Control c in flowLayoutPanel1.Controls)
{
if (((OrderOptions)c).IsSelected == true)
{
foreach (var itemList in query)
{
foundControl = c;
break;
}
}
}
if (foundControl != null)
{
foreach (var itemList in query)
{
if (OrderOptions.selectItemName == itemList.Name)
{
MessageBox.Show(itemList.Name + " is deleted from database. Reload the page");
delItem = db.Items.Where(d => d.Name == OrderOptions.selectItemName).First();
db.Items.Remove(delItem);
db.SaveChanges();
}
}
}
}
}
else if (dialogResult == DialogResult.No)
{
}
}
else
{
MessageBox.Show("Please select an item");
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OrderOptions.selectItemName = null;
foreach (Control control in flowLayoutPanel1.Controls)
{
flowLayoutPanel1.Controls.Remove(control);
control.Dispose();
}
flowLayoutPanel1.Controls.Clear();
string search = textBox1.Text.Trim();
// Search items in our Jobs ListView, remove those that do not match search
if (search != String.Empty)
{
using (var db = new SunwayCafeContext())
{
// got two ToLower() is because need to allow upper case and lower case both acceptable by the search function
var query = from d in db.Items
where d.Name.ToLower().StartsWith(search.ToLower())
select d;
OrderOptions[] order = new OrderOptions[query.Count()];
foreach (var itemList in query)
{
order[i] = new OrderOptions(this);
order[i].ID = itemList.Id;
order[i].Name_details = itemList.Name;
if (itemList.ImageURL != null)
{
order[i].displayImage = ConvertBinaryToImage(itemList.ImageURL);
}
order[i].WasClicked += OrderGrid_WasClicked;
order[i].Price = itemList.SellingPrice;
order[i].CostPrice = itemList.CostPrice;
flowLayoutPanel1.Controls.Add(order[i]);
i++;
}
i = 0;
}
}
else
{
loadData();
}
}
