private void LoadItems()
{
DataSet ds = new DataSet();
cMeals cat = new cMeals();
ds = cat.mealsGetActive();
//ds.Tables[0].DefaultView.Sort = "Category asc";
cmbItems.DataSource = ds.Tables[0].DefaultView;
cmbItems.ValueMember = "MealID";
cmbItems.DisplayMember = "Name";
cmbCategory.DataSource = cmbItems.DataSource;
cmbCategory.ValueMember = "CategoryID";
cmbCategory.DisplayMember = "Category";
cmbQty.DataSource = cmbItems.DataSource;
cmbQty.ValueMember = "QuanTypeID";
cmbQty.DisplayMember = "QuanType";
cmbPrice.DataSource = cmbItems.DataSource;
cmbPrice.ValueMember = "Price";
cmbPrice.DisplayMember = "Price";
//cmbItems.SelectedIndex = -1;
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim() == "")
{
MessageBox.Show("Name of the meal required");
return;
}
if (cmbCtgy.SelectedIndex < 0)
{
MessageBox.Show("Select a category");
return;
}
if (cmbQtyType.SelectedIndex < 0)
{
MessageBox.Show("Select a quantity type");
return;
}
if (numPrice.Value == 0)
{
MessageBox.Show("Input a price amount");
return;
}
//bool hasStock =
cMeals meal = new cMeals(0, txtName.Text, numPrice.Value, Convert.ToUInt32(cmbCtgy.SelectedValue), Convert.ToUInt32(cmbQtyType.SelectedValue), dtpDtAdd.Value.ToString(), rdbHaveStock.Checked);
if (meal.checkMeal())
{
MessageBox.Show("This meal already exists");
return;
}
if (meal.saveRecord())
{
MessageBox.Show("Added");
}
else
{
MessageBox.Show("Sorry could not be added");
return;
}
clear();
}
private void button1_Click(object sender, EventArgs e)
{
cMeals meal = new cMeals();
meal.MealID = Convert.ToUInt32(cmbItems.SelectedValue);
meal.Deleted = false;
meal.Name = Convert.ToString(cmbItems.Text);
meal.Price = Convert.ToDecimal(cmbPrice.SelectedValue);
meal.CategoryID = Convert.ToUInt32(cmbCategory.SelectedValue);
meal.QuanTypeID = Convert.ToUInt32(cmbQty.SelectedValue);
meal.DateAdded = DateTime.Now.ToString();
meal.HasStock = false;
if (meal.saveRecord())
{
MessageBox.Show("Not Tracking " + meal.Name + ".\nYou may add stock.");
}
else
MessageBox.Show("Tracking");
}
private void btnDel_Click(object sender, EventArgs e)
{
if (!loggedUser.access(Convert.ToInt16(btnDel.Tag)))
{
return;
}
cMeals meal = new cMeals();
meal.MealID = Convert.ToUInt32(dgvCat["MealID", dgvCat.CurrentCell.RowIndex].Value);
//meal.Name = txtName.Text;
//meal.QuanTypeID = Convert.ToUInt32(cmbQtyType.SelectedValue);
//MessageBox.Show(meal.Name);
//MessageBox.Show(meal.QuanTypeID.ToString());
if (meal.mealDelete())
{
MessageBox.Show("Deleted.\nWill not display in Sale Items.");
clear();
}
else
MessageBox.Show("Not Deleted");
LoadMeals();
}
private void LoadMeals()
{
DataSet ds = new DataSet();
cMeals meals = new cMeals();
try
{
meals.MealID = 0;
ds = meals.mealsGet();
dgvCat.DataSource = ds.Tables[0];
dgvCat.Columns[0].HeaderText = "Meal ID";
dgvCat.Columns[1].HeaderText = "Name";
dgvCat.Columns[2].HeaderText = "Price";
dgvCat.Columns[3].HeaderText = "Category ID";
dgvCat.Columns[4].HeaderText = "Category";
dgvCat.Columns[5].HeaderText = "Quantity Type ID";
dgvCat.Columns[6].HeaderText = "Quantity Type";
dgvCat.Columns[7].HeaderText = "Date Added";
dgvCat.Columns[8].HeaderText = "Track Stock";
dgvCat.Columns[0].Visible = false;
dgvCat.Columns[1].Width = 200;
dgvCat.Columns[2].Width = 100;
dgvCat.Columns[3].Visible = false;
dgvCat.Columns[4].Width = 150;
dgvCat.Columns[5].Visible = false;
dgvCat.Columns[6].Width = 150;
dgvCat.Columns[7].Width = 120;
dgvCat.Columns[8].Width = 100;
dgvCat.Columns[10].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
ds.Dispose();
}
pEdt.Enabled = false;
numPrice.Minimum = 0;
//dgvCat.Sort(dgvCat.Columns["Name"], ListSortDirection.Ascending);
// enabld(false);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!loggedUser.access(Convert.ToInt16(btnSave.Tag)))
{
return;
}
if (!pEdt.Enabled)
{
MessageBox.Show("Select an item and edit before saving");
return;
}
if (txtName.Text.Trim() == "")
{
MessageBox.Show("Name of the meal required");
return;
}
if (cmbCtgy.SelectedIndex < 0)
{
MessageBox.Show("Select a category");
return;
}
if (cmbQtyType.SelectedIndex < 0)
{
MessageBox.Show("Select a quantity type");
return;
}
if (numPrice.Value == 0)
{
MessageBox.Show("Input a price amount");
return;
}
cMeals meal = new cMeals();
meal.MealID = Convert.ToUInt32(dgvCat["MealID", dgvCat.CurrentCell.RowIndex].Value);
meal.Deleted = rdbDeleted.Checked;
meal.Name = txtName.Text;
meal.Price = Convert.ToDecimal(numPrice.Value);
meal.CategoryID = Convert.ToUInt32(cmbCtgy.SelectedValue);
meal.QuanTypeID = Convert.ToUInt32(cmbQtyType.SelectedValue);
meal.DateAdded = dtpDtAdd.Value.ToString();
meal.HasStock = rdbHaveStock.Checked;
//if (meal.checkMeal())
//{
// MessageBox.Show("This meal already exists!");
// return;
//}
if (meal.saveRecord())
{
MessageBox.Show("Saved");
clear();
}
else
MessageBox.Show("Not Saved");
LoadMeals();
}
private void LoadStaffDiscountView(ListView LstVw)
{
DataSet ds = new DataSet();
cMeals meals = new cMeals();
try
{
ds = meals.staffDiscountGet();
LstVw.Columns.Add("Name", 250, HorizontalAlignment.Left);
LstVw.Columns.Add("Price", 100, HorizontalAlignment.Left);
LstVw.Columns.Add("Quantity Type", 150, HorizontalAlignment.Left);
// Get the table from the data set
DataTable dtable = ds.Tables[0];
// or DataTable dtable = ds.Tables["Meals"];
// Clear the ListView control
LstVw.Items.Clear();
// Location of Large Icon images
//lstVwBrkfst.LargeImageList = imgLst;
// Display items in the ListView control
for (int i = 0; i < dtable.Rows.Count; i++)
{
DataRow drow = dtable.Rows[i];
// Only row that have not been deleted
if (drow.RowState != DataRowState.Deleted)
{
// Define the list items
ListViewItem lvi = new ListViewItem(drow["Name"].ToString().ToUpper());
lvi.SubItems.Add(drow["Price"].ToString());
lvi.SubItems.Add(drow["QuanType"].ToString());
// Hold the id ---------------
lvi.SubItems.Add(drow["MealID"].ToString());
lvi.Name = drow["MealID"].ToString();
// del add the hasstock here
lvi.SubItems.Add(drow["HasStock"].ToString());
lvi.ToolTipText = "Select this to choose " + drow["Name"].ToString();
//imgLst = new ImageList();
//Image j = new Image();
//Bitmap image = new Bitmap(drow["Name"].ToString().Trim());
//imgLst.Images.Add(Resources.ReferenceEquals());
//-----------------------------------------------------
// Text representing image
lvi.ImageKey = drow["Name"].ToString().Trim() + ".jpg";
//if the ImageList does not contain the key set it to the default
if (!imgLst.Images.ContainsKey(lvi.ImageKey))
{
lvi.ImageIndex = 0;
}
// Add the list items to the ListView
LstVw.Items.Add(lvi);
// this.Controls.Add(lstVwBrkfst);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
ds.Dispose();
}
}
