private void button7_Click(object sender, EventArgs e) { string phrase = txtMenuPrice.Text; int number; bool isNumeric = int.TryParse(phrase, out number); if (isNumeric == true) { Menu_Item item = new Menu_Item(); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Description == cmbMenuItemType.Text); Menu_Item_Price price = new Menu_Item_Price(); price.Menu_Price = Convert.ToDouble(txtMenuPrice.Text); db.Menu_Item_Price.Add(price); item.Menu_Item_Name = txtMenuItemName.Text; item.Menu_Item_Description = richDescription.Text; item.Menu_Item_Type_ID = type.Menu_Item_Type_ID; item.Menu_Item_Price = price.Menu_Price; item.Menu_Price_ID = price.Menu_Price_ID; db.Menu_Item.Add(item); db.SaveChanges(); MessageBox.Show("Menu item added successfully"); this.Close(); } else { MessageBox.Show("Error: Values entered is not in correct format(not numeric)"); } }
private void button7_Click(object sender, EventArgs e) { string phrase = txtMenuPrice.Text; int number; bool isNumeric = int.TryParse(phrase, out number); if (isNumeric == true) { int id = Globals.MenuCombopassing; Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Description == cmbMenuItemType.Text); Menu_Item_Price price = db.Menu_Item_Price.FirstOrDefault(c => c.Menu_Price_ID == id); price.Menu_Price = Convert.ToDouble(txtMenuPrice.Text); // db.Menu_Item_Price.Add(price); item.Menu_Item_Name = txtMenuItemName.Text; item.Menu_Item_Description = richDescription.Text; item.Menu_Item_Type_ID = type.Menu_Item_Type_ID; item.Menu_Item_Price = price.Menu_Price; item.Menu_Price_ID = price.Menu_Price_ID; //item.fileName =fileName = ConvertImageToBinary(pictureBox1.Image); // db.Menu_Item.Add(item); //item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_Name == txtMenuItemName.Text); ItemsPicture itempic = db.ItemsPictures.FirstOrDefault(c => c.Menu_Item_ID == id); { if ((Globals.browse == true) && (itempic != null)) { itempic.ItemName = Globals.fileName; itempic.imageVar = Globals.ConvertImageToBinary(pictureBox1.Image); // itempic.ImageID = item.Combo_ID; // Globals.browse = false; } } //itempic.ImageID = item.Menu_Item_ID; // itempic.Menu_Item_ID = item.Menu_Item_ID; //db.ItemsPictures.Add(itempic); db.SaveChanges(); Globals.refresher = true; MessageBox.Show("Menu item updated successfully"); this.Close(); } else { MessageBox.Show("Error: Values entered is not in correct format(not numeric)"); } }
private void frmMaintainMenuItem_Load(object sender, EventArgs e) { int id = Globals.MenuCombopassing; Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Type_ID == item.Menu_Price_ID); txtMenuItemName.Text = item.Menu_Item_Name; txtMenuPrice.Text = Convert.ToString(item.Menu_Item_Price); richDescription.Text = item.Menu_Item_Description; // cmbMenuItemType.Text = type.Menu_Item_Description; }
private /*async*/ void button7_Click(object sender, EventArgs e) { string phrase = txtMenuPrice.Text; int number; bool isNumeric = int.TryParse(phrase, out number); if (isNumeric == true) { Menu_Item item = new Menu_Item(); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Description == cmbMenuItemType.Text); Menu_Item_Price price = new Menu_Item_Price(); price.Menu_Price = Convert.ToDouble(txtMenuPrice.Text); db.Menu_Item_Price.Add(price); item.Menu_Item_Name = txtMenuItemName.Text; item.Menu_Item_Description = richDescription.Text; item.Menu_Item_Type_ID = type.Menu_Item_Type_ID; item.Menu_Item_Price = price.Menu_Price; item.Menu_Price_ID = price.Menu_Price_ID; //item.fileName =fileName = ConvertImageToBinary(pictureBox1.Image); db.Menu_Item.Add(item); //item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_Name == txtMenuItemName.Text); ItemsPicture itempic = new ItemsPicture(); { itempic.ItemName = item.Menu_Item_Name; itempic.imageVar = Globals.ConvertImageToBinary(pictureBox1.Image); itempic.ImageID = item.Menu_Item_ID; itempic.Menu_Item_ID = item.Menu_Item_ID; db.ItemsPictures.Add(itempic); //db.SaveChanges(); } db.SaveChanges(); Globals.refresher = true; MessageBox.Show("Menu item added successfully"); txtMenuItemName.Text = ""; txtMenuPrice.Text = ""; richDescription.Text = ""; pictureBox1.Image = null; } else { MessageBox.Show("Error: Values entered is not in correct format(not numeric)"); } }
private void frmMaintain_Menu_Item_Load(object sender, EventArgs e) { cmbMenuItemType.ValueMember = "Menu_Item_Type_ID"; cmbMenuItemType.DisplayMember = "Menu_Item_Description"; cmbMenuItemType.DataSource = db.Menu_Item_Type.ToList(); int id = Globals.MenuCombopassing; ItemsPicture pic = db.ItemsPictures.FirstOrDefault(c => c.Menu_Item_ID == id); // Image n = (Bitmap)((new ImageConverter()).ConvertFrom(pic.imageVar)); Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Price price = db.Menu_Item_Price.FirstOrDefault(c => c.Menu_Price_ID == id); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Type_ID == item.Menu_Item_Type_ID); pictureBox1.Image = Globals.converBinToImage(pic.imageVar); txtMenuItemName.Text = item.Menu_Item_Name; txtMenuPrice.Text = Convert.ToString(price.Menu_Price); cmbMenuItemType.Text = type.Menu_Item_Description; richDescription.Text = item.Menu_Item_Description; Globals.browse = false; }