public int Update_menu(Food_item fi, int food_id)
{
dbc = new DataAccess();
string sql = "UPDATE Food_item SET food_name='" + fi.Food_name + "' ,food_price =" + fi.Food_price + " ,food_des ='" + fi.Food_des + "' ,food_cooktime =" + fi.Food_cT + " ,food_pic ='" + fi.Food_photo + "',food_avl=" + fi.Food_avl + " ,food_cat =" + fi.Food_cat + " where Food_id=" + food_id + " ";
int res = dbc.ExecuteQuery(sql);
return(res);
}
public int AddItem(Food_item fI)
{
dbc = new DataAccess();
string sql = "insert into Food_item(food_name, food_price, food_des, food_cooktime, food_pic, food_avl, food_cat) values('" + fI.Food_name + "'," + fI.Food_price + ", '" + fI.Food_des + "'," + fI.Food_cT + ",'" + fI.Food_photo + "'," + fI.Food_avl + ", " + fI.Food_cat + ")";
int result = dbc.ExecuteQuery(sql);
dbc.Dispose();
if (result > 0)
{
return(1);
}
else
{
return(0);
}
}
