//adds selected items in order to the database with a unique order ID
private void btnOrder_Click(object sender, EventArgs e)
{
int randomNumber = rnd.Next(0, 100);
int itemNum;
int count = 0;
do
{
orderNumber = randomNumber;
count = 0;
try
{
string myConnection = conection;
MySqlConnection myConn = new MySqlConnection(myConnection);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
MySqlCommand comand = new MySqlCommand("select Order_ID from demo.order where Order_ID = '" + randomNumber.ToString() + "' ;", myConn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
myConn.Open();
MySqlDataReader reader = comand.ExecuteReader();
while (reader.Read())
{
count += 1;
}
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (count == 0)
{
sqlClient.Insert("order", "Order_ID, Table_ID, Status", "'" + randomNumber + "','" + intTableNumber.ToString() + "', 'Recieved'");
if (listBox2.Items.Count > 0)
{
itemNum = 1;
foreach (string s in listBox2.Items)
{
sqlClient.Insert("order_item", "Order_ID, Item_Name, Item_Num", "'" + randomNumber + "', '" + s + "', '" + itemNum + "'");
itemNum++;
}
FrmPayment pay = new FrmPayment(strTotal, this, orderNumber);
pay.Show();
}
else
{
MessageBox.Show("No items");
}
}
else
{
randomNumber = rnd.Next(0, 999);
}
} while (count > 0);
}
//adds selected items in order to the database with a unique order ID
private void btnOrder_Click(object sender, EventArgs e)
{
int randomNumber = rnd.Next(0, 100);
int itemNum;
int count = 0;
do
{
orderNumber = randomNumber;
count = 0;
try
{
string myConnection = conection;
MySqlConnection myConn = new MySqlConnection(myConnection);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
MySqlCommand comand = new MySqlCommand("select Order_ID from demo.order where Order_ID = '" + randomNumber.ToString() + "' ;", myConn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
myConn.Open();
MySqlDataReader reader = comand.ExecuteReader();
while (reader.Read())
{
count += 1;
}
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (count == 0)
{
sqlClient.Insert("order", "Order_ID, Table_ID, Status", "'" + randomNumber + "','" + intTableNumber.ToString() + "', 'Recieved'");
if (listBox2.Items.Count > 0)
{
itemNum = 1;
foreach (string s in listBox2.Items)
{
sqlClient.Insert("order_item", "Order_ID, Item_Name, Item_Num", "'" + randomNumber + "', '" + s + "', '" + itemNum + "'");
itemNum++;
}
FrmPayment pay = new FrmPayment(strTotal, this, orderNumber);
pay.Show();
}
else
{
MessageBox.Show("No items");
}
}
else
{
randomNumber = rnd.Next(0, 999);
}
} while (count > 0);
}
