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