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