private void OrdersGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 4)
{
this.OrdersGV.CommitEdit(DataGridViewDataErrorContexts.Commit);
string s = OrdersGV[0, e.RowIndex].Value.ToString(),
t = OrdersGV[1, e.RowIndex].Value.ToString(),
u = OrdersGV[2, e.RowIndex].Value.ToString();
Entities ent = new Entities();
ORDER_FOOD fo = (from x in ent.ORDER_FOOD
where x.FOOD_NAME == s &&
x.RESTAURANT_NAME == t &&
x.RESTAURANT_LOCATION == u &&
x.ORDER_ID == ordID
select x).FirstOrDefault();
if (OrdersGV[4, e.RowIndex].Value.ToString() == "true")
{
fo.BOUGHT = "y";
}
else
{
fo.BOUGHT = "n";
}
ent.SaveChanges();
enableConfirmBtn();
}
}
private void button2_Click(object sender, EventArgs e)
{
Entities ent = new Entities();
ORDER_FOOD ordf = new ORDER_FOOD();
ordf.BOUGHT = "n";
ordf.FOOD_NAME = name.Text;
ordf.NO_OF_ITEMS_PER_FOOD = Convert.ToInt32(numericUpDown1.Value);
ordf.ORDER_ID = Helper.currentOrderId;
ordf.RESTAURANT_LOCATION = resl.Text;
ordf.RESTAURANT_NAME = resn.Text;
if (ent.ORDER_FOOD.Where(x => x.ORDER_ID == Helper.currentOrderId && x.RESTAURANT_NAME == resn.Text &&
x.RESTAURANT_LOCATION == resl.Text && x.FOOD_NAME == this.name.Text).Count() > 0)
{
ordf.NO_OF_ITEMS_PER_FOOD += ent.ORDER_FOOD.Where(x => x.ORDER_ID == Helper.currentOrderId && x.RESTAURANT_NAME == resn.Text &&
x.RESTAURANT_LOCATION == resl.Text && x.FOOD_NAME == this.name.Text).First().NO_OF_ITEMS_PER_FOOD;
}
ent.ORDER_FOOD.AddOrUpdate(ordf);
ent.SaveChanges();
}