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