public void delete(Food_Dish obj)
{
using (ModelContext db = new ModelContext())
{
db.Entry <Food_Dish>(obj).State = EntityState.Deleted;
db.SaveChanges();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure want to delete this dish ?", "Waring", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
Food_Dish fdish = foodDishBindingSource.Current as Food_Dish;
Food_DishBUS.delete(fdish);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
}
}
private void btnChangeQuan_Click(object sender, EventArgs e)
{
CusOrders cusO = cusOrdersBindingSource.Current as CusOrders;
Food_Dish fd = Food_DishBUS.GetByName(cusO.name);
CusOrders cusOder = CusOrderBUS.GetByName(cusO.name);
int tempDish = 0;
int changeQuan = int.Parse(txtChangeQuan.Text);
if (changeQuan == 0 || txtChangeQuan.Text == " " || txtChangeQuan.Text == "")
{
MessageBox.Show("Number of dish can not be 0!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtChangeQuan.Clear();
txtChangeQuan.Focus();
foodDishBindingSource.DataSource = Food_DishBUS.dish_NotLocked();
return;
}
else
{
if (cusO != null)
{
if (changeQuan > fd.stock)
{
MessageBox.Show("Only " + fd.stock + "left!", "Sorry", MessageBoxButtons.OK, MessageBoxIcon.Error);
cusOrdersBindingSource.DataSource = CusOrderBUS.GetAll();
return;
}
else
{
if (changeQuan > cusOder.numberDish)
{
tempDish = changeQuan - cusOder.numberDish;
CusOrderBUS.changeQuantity(cusO);
Food_DishBUS.stockCalulate(fd.Id, tempDish, true);
foodDishBindingSource.DataSource = Food_DishBUS.dish_NotLocked();
labelCost.Text = CusOrderBUS.TotalCost().ToString() + "$";
}
else
{
tempDish = cusOder.numberDish - changeQuan;
CusOrderBUS.changeQuantity(cusO);
Food_DishBUS.stockCalulate(fd.Id, tempDish, false);
foodDishBindingSource.DataSource = Food_DishBUS.dish_NotLocked();
labelCost.Text = CusOrderBUS.TotalCost().ToString() + "$";
}
}
}
else
{
return;
}
}
}
private void btnLock_Unclock_Click(object sender, EventArgs e)
{
Food_Dish fd = foodDishBindingSource.Current as Food_Dish;
if (fd == null)
{
return;
}
else
{
int id = fd.Id;
Food_DishBUS.dishLock_Unlock(id);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
}
}
private void btnBrowse_Click(object sender, EventArgs e)
{
using (OpenFileDialog ofd = new OpenFileDialog()
{
Filter = "(*.jpg;*.jpeg;*.bmp;) | *.jpg;*.jpeg;*.bmp;"
})
{
ofd.Multiselect = false;
if (ofd.ShowDialog() == DialogResult.OK)
{
picBox.Image = Image.FromFile(ofd.FileName);
Food_Dish fd = foodDishBindingSource.Current as Food_Dish;
if (fd != null)
{
fd.imaGeURL = ofd.FileName;
}
}
}
}
private void dataGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
Food_Dish fdish = foodDishBindingSource.Current as Food_Dish;
if (fdish.Id != 0)
{
int typeID = fdish.TypeId;
int sizeID = fdish.SizeId;
foodTypeBindingSource.DataSource = Food_TypeBUS.showType(typeID);
foodSizeBindingSource.DataSource = Food_SizeBUS.showSize(sizeID);
if (fdish.imaGeURL != null)
{
picBox.Image = Image.FromFile(fdish.imaGeURL);
}
else
{
picBox.Image = null;
}
}
}
public void edit(Food_Dish dishEdit, string E_Dname, double E_DPrice, string E_DDescription, string E_DImage, string E_DType, string E_DSize, int E_DId, int E_DStock)
{
using (ModelContext db = new ModelContext())
{
Food_Size fsi = db.size_list.FirstOrDefault(fsize => fsize.name == E_DSize);
Food_Type ftyp = db.type_list.FirstOrDefault(typ => typ.nameType == E_DType);
dishEdit = (from dish in db.dish_list
where dish.Id == E_DId
select dish).First();
dishEdit.name = E_Dname;
dishEdit.price = E_DPrice;
dishEdit.description = E_DDescription;
dishEdit.imaGeURL = E_DImage;
dishEdit.TypeId = ftyp.Id;
dishEdit.SizeId = fsi.Id;
dishEdit.stock = E_DStock;
db.SaveChanges();
}
}
private void dataDishView_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtChangeQuan.Enabled = false;
btnChangeQuan.Enabled = false;
txtNumberD.Enabled = true;
btnOrder.Enabled = true;
Food_Dish fdish = foodDishBindingSource.Current as Food_Dish;
if (fdish.Id != 0)
{
int typeID = fdish.TypeId;
int sizeID = fdish.SizeId;
foodTypeBindingSource.DataSource = Food_TypeBUS.showType(typeID);
foodSizeBindingSource.DataSource = Food_SizeBUS.showSize(sizeID);
//picBox.Image = Image.FromFile(fdish.imaGeURL);
txtNumberD.Clear();
}
else
{
return;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
CusOrders cusOrder = cusOrdersBindingSource.Current as CusOrders;
CusOrders cusO = CusOrderBUS.GetByName(cusOrder.name);
Food_Dish fd = Food_DishBUS.GetByName(cusO.name);
if (cusOrder != null)
{
Food_DishBUS.stockCalulate(fd.Id, cusO.numberDish, false);
CusOrderBUS.delete(cusOrder);
cusOrdersBindingSource.RemoveCurrent();
labelCost.Text = CusOrderBUS.TotalCost().ToString() + "$";
foodDishBindingSource.DataSource = Food_DishBUS.dish_NotLocked();
}
else
{
if (MessageBox.Show("List is empty! Please choose your food.", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error) == DialogResult.OK)
{
dataDishView.Focus();
}
return;
}
}
public static void edit(Food_Dish dishEdit, string E_Dname, double E_DPrice, string E_DDescription, string E_DImage, string E_DType, string E_DSize, int E_DId, int E_DStock)
{
dish_act.edit(dishEdit, E_Dname, E_DPrice, E_DDescription, E_DImage, E_DType, E_DSize, E_DId, E_DStock);
}
public static void delete(Food_Dish Fdish)
{
dish_act.delete(Fdish);
}
private void btnSave_Click(object sender, EventArgs e)
{
Food_Dish fdish = foodDishBindingSource.Current as Food_Dish;
Food_Size fsize = foodSizeBindingSource.Current as Food_Size;
Food_Type ftype = foodTypeBindingSource.Current as Food_Type;
string sizeName = fsize.name;
string typeName = ftype.nameType;
string D_Name = txtD_Name.Text;
double D_Price = double.Parse(txtD_Price.Text);
string D_Descript = txtD_Description.Text;
string D_ImageURL = fdish.imaGeURL;
int D_Stock = int.Parse(txtStock.Text);
int D_Id = fdish.Id;
if (fdish == null)
{
MessageBox.Show("Nothing to edit!", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
return;
}
else
{
if (string.IsNullOrEmpty(txtD_Name.Text) || string.IsNullOrEmpty(txtD_Price.Text) || string.IsNullOrEmpty(txtD_Description.Text))
{
MessageBox.Show("Please type all the information!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (fdish.Id == 0)
{
if (Food_DishBUS.chekName(txtD_Name.Text))
{
MessageBox.Show("This name is already exist!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtD_Name.Clear();
txtD_Price.Clear();
txtD_Description.Clear();
}
else
{
Food_DishBUS.insert(D_Name, D_Price, D_Descript, D_ImageURL, typeName, sizeName, D_Stock);
MessageBox.Show("Insert successfully!", "Insert dish name", MessageBoxButtons.OK, MessageBoxIcon.Information);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
foodDishBindingSource.MoveLast();
panCRUD.Enabled = true;
panFilter.Enabled = true;
panSave.Enabled = false;
dataGridDish.Enabled = true;
}
}
else
{
Food_DishBUS.edit(fdish, D_Name, D_Price, D_Descript, D_ImageURL, typeName, sizeName, D_Id, D_Stock);
MessageBox.Show("Update successfully!", "Update dish name", MessageBoxButtons.OK, MessageBoxIcon.Information);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
panCRUD.Enabled = true;
panSave.Enabled = false;
panFilter.Enabled = true;
dataGridDish.Enabled = true;
}
}
}
}
private void btnOrder_Click(object sender, EventArgs e)
{
cusOrdersBindingSource.Add(new CusOrders());
cusOrdersBindingSource.MoveLast();
Food_Dish fd = foodDishBindingSource.Current as Food_Dish;
if (fd != null)
{
Regex pattern = new Regex(@"[0-9]");
if (pattern.IsMatch(txtNumberD.Text))
{
string dName = fd.name;
double dPrice = fd.price;
int quantity;
DateTime orderdate = DateTime.Now;
if (int.TryParse(txtNumberD.Text, out quantity))
{
if (CusOrderBUS.check_DishExist(dName) == false)
{
if (fd.stock < quantity)
{
MessageBox.Show("Only " + fd.stock + "left!", "Sorry", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNumberD.Focus();
}
else
{
CusOrderBUS.insert(dName, dPrice, quantity, orderdate);
cusOrdersBindingSource.MoveLast();
cusOrdersBindingSource.DataSource = CusOrderBUS.GetAll();
labelCost.Text = CusOrderBUS.TotalCost().ToString() + "$";
txtNumberD.Clear();
Food_DishBUS.stockCalulate(fd.Id, quantity, true);
foodDishBindingSource.DataSource = Food_DishBUS.dish_NotLocked();
}
}
else
{
MessageBox.Show("This food is already in your list! Please chood another food.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dataDishView.Focus();
cusOrdersBindingSource.RemoveCurrent();
}
}
else
{
MessageBox.Show("Wrong number! Please type your number again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNumberD.Focus();
cusOrdersBindingSource.RemoveCurrent();
}
}
else
{
if (MessageBox.Show("Please type the quantity of your dish!", "Missing your dish quantity!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Information) == DialogResult.Retry)
{
cusOrdersBindingSource.MoveLast();
txtNumberD.Focus();
txtNumberD.Select();
cusOrdersBindingSource.RemoveCurrent();
}
}
}
else
{
if (MessageBox.Show("Pleas choose your dish!", "Your order is empty!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Information) == DialogResult.Retry)
{
txtNumberD.Clear();
dataDishView.Focus();
cusOrdersBindingSource.RemoveCurrent();
}
}
}
public void uploadImage(Food_Dish obj)
{
using (ModelContext db = new ModelContext())
{
}
}
