public bool Insert(OrderMenu order) { try { string query = "INSERT into SelectedItem VALUES ('" + order.ItemName + "'," + order.ItemQuantity + "," + "(select ItemPrice from Inventroy where ItemName = '" + order.ItemName + "' )" + ") "; DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public List <OrderMenu> GetAllOrderMenu() { string query = "SELECT * from SelectedItem"; List <OrderMenu> orderMenuList = new List <OrderMenu>(); DataBaseConnectionClass dcc = new DataBaseConnectionClass(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { OrderMenu orderMenu = new OrderMenu(); orderMenu.OrderNo = Convert.ToInt32(sdr["OrderNo"].ToString()); orderMenu.ItemName = sdr["ItemName"].ToString(); orderMenu.ItemQuantity = Convert.ToInt32(sdr["ItemQuantity"]); orderMenu.ItemPrice = Convert.ToDouble(sdr["ItemPrice"]); orderMenuList.Add(orderMenu); } dcc.CloseConnection(); return(orderMenuList); }