private void LoadItems()
{
DataSet ds = new DataSet();
cInventory inv = new cInventory();
//ds = inv.InventoryGet();
//cmbItems.DataSource = ds.Tables[0];
//cmbItems.ValueMember = "MealID";
//cmbItems.DisplayMember = "Name";
//cmbItems.SelectedIndex = -1;
try
{
ds = inv.InventoryMealsGet();
dgvInv.DataSource = ds.Tables[0];
dgvInv.Columns[0].HeaderText = "Meal ID";
dgvInv.Columns[1].HeaderText = "Meal ID";
dgvInv.Columns[2].HeaderText = "Name";
dgvInv.Columns[3].HeaderText = "Credit";
dgvInv.Columns[4].HeaderText = "Debit";
dgvInv.Columns[5].HeaderText = "Stock Left";
dgvInv.Columns[6].HeaderText = "Last Deduction";
dgvInv.Columns[7].HeaderText = "Last Credit";
//dgvInv.Columns[8].HeaderText = "MealID";
//dgvInv.Columns[9].HeaderText = "Stock Left";
//dgvInv.Columns[10].HeaderText = "Last Modified";
dgvInv.Columns[0].Visible = false;
dgvInv.Columns[1].Width = 50;
dgvInv.Columns[1].Visible = false;
dgvInv.Columns[2].Width = 200;
//dgvInv.Columns[2].Visible = false;
dgvInv.Columns[3].Width = 100;
//dgvInv.Columns[3].Visible = false;
dgvInv.Columns[4].Width = 100;
//dgvInv.Columns[4].Visible = false;
dgvInv.Columns[5].Width = 100;
//dgvInv.Columns[].Visible = false;
dgvInv.Columns[6].Width = 150;
dgvInv.Columns[7].Width = 100;
//dgvInv.Columns[7].Visible = false;
//dgvInv.Columns[8].Width = 80;
//dgvInv.Columns[9].Width = 120;
dgvInv.Columns[8].Visible = false;
dgvInv.Columns[9].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
ds.Dispose();
}
//pEdt.Enabled = false;
//dgvInv.Sort(dgvInv.Columns["Name"], ListSortDirection.Ascending);
}
// selected listview stockcheck
private bool stockCheck(ListView.SelectedListViewItemCollection selectedItems, ListView lst, int qtyToBuy, bool selectedListView)
{
bool status = true;
///////////////////////////////////
/////inventory////stock////////////
int mealID = Convert.ToInt32(selectedItems[0].Name);
bool hasStock = Convert.ToBoolean(selectedItems[0].SubItems[6].Text);
int qtyLeft = 0;
DataSet ds = new DataSet();
cInventory inv = new cInventory();
inv.MealID = Convert.ToUInt32(mealID);
///////////////////////////////// find item in listview and get amount//////////////////////////////////////////////////////
//int qtyInSelectedList = 0;
//// Acquire SelectedItems
////var sel = selectedItems.
//var selectedItem = lst.SelectedItems;
//if (selectedItem.Count > 0 && (lstVwItms.Items.ContainsKey(selectedItem[0].Name)))
//{
// int selectedIntoListViewIndex = lstVwItms.Items.IndexOfKey(selectedItem[0].Name);
// //int a = Convert.ToInt16(lst.Items[selectedIntoListViewIndex].SubItems[0].Text.Trim());
// qtyInSelectedList = (Convert.ToInt16(lstVwItms.Items[selectedIntoListViewIndex].SubItems[2].Text));
// //// multiplier
// //if (multiplier.Contains("x") && Convert.ToInt16(multiplier.Substring(0, multiplier.IndexOf("x"))) > 0)
// //{
// // qty = Convert.ToInt16(multiplier.Substring(0, multiplier.IndexOf("x")));
// //}
// //lstVwItms.Items[selectedIntoListViewIndex].SubItems[2].Text = qty.ToString();
// //lstVwItms.HideSelection = false;
// lstVwItms.Select();
// lstVwItms.Items[selectedIntoListViewIndex].Selected = true;
//}
//lstVwItms.
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// if it's part of the inverntory table
if (hasStock)
{
//try
//{
ds = inv.InventoryMealsGet();
qtyLeft = Convert.ToInt32(ds.Tables[0].Rows[0]["SLeft"].ToString());
//}
//catch (Exception ex)
//{
//}
if (!(qtyLeft > 0))
{
MessageBox.Show("This item has no stock in the inventory. Pelase top up");
status = false;
}
//else if (qtyLeft == 2)
//{
// MessageBox.Show("You have two more of this item left");
// status = true;
//}
//else if (qtyLeft == 1)
//{
// MessageBox.Show("You have one more of this item left. Top up soon");
// //don't allow more
// status = true;
//}
else
{
status = true;
}
if (qtyLeft - qtyToBuy < 0)
{
MessageBox.Show("You can not purchase more of this product.\nTop up inventory\n" + qtyLeft + " left.");
status = false;
}
}
return status;
}
