private void processingOrder()
{
List<OrderHistory> myHist = new List<OrderHistory>();
OrderHistory myItem = new OrderHistory();
string item, quantity, price, id, date;
string orderNumber = getOrderNumber();
for (int RowIndex = 0; RowIndex < cartDataGridView.RowCount - 1; RowIndex++)
{
item = cartDataGridView.Rows[RowIndex].Cells["itemColumn"].Value.ToString();
quantity = cartDataGridView.Rows[RowIndex].Cells["qtyColumn"].Value.ToString();
price = cartDataGridView.Rows[RowIndex].Cells["costColumn"].Value.ToString();
id = cartDataGridView.Rows[RowIndex].Cells["idColumn"].Value.ToString();
date = cartDataGridView.Rows[RowIndex].Cells["dateColumn"].Value.ToString();
myItem.setUserName(item);
myItem.setItemQuantity(int.Parse(quantity));
myItem.setCost(float.Parse(price));
myHist.Add(myItem);
database.orderHistoryInsert(currentUser, orderNumber, id, price, quantity, "processing", date);
}
orderHistNumsComboBox.Items.Clear();
mailFunction(orderNumber, myHist, pymtCardNumMaskTextBox.Text.Substring(15));
clearPymtObjects();
gettingPastOrders();
orderHistNumsComboBox.SelectedIndex = -1;
orderHistNumsComboBox.Text = "Select Order Number";
MessageBox.Show("Order " + orderNumber + " Submited");
makeNextAndPreviousInvisible();
tabControl1.SelectedTab = tabPage2;
}
public void orderHistoryQuery( List<OrderHistory> orderHistory, string username, string orderNum)
{
orderHistory.Clear();
SQLiteCommand orderQuery = conn.CreateCommand();
orderQuery.CommandText = @"SELECT * FROM order_history WHERE order_number = @order_number AND username = @username";
orderQuery.Parameters.Add(new SQLiteParameter("@username", username));
orderQuery.Parameters.Add(new SQLiteParameter("@order_number", orderNum));
orderQuery.CommandType = System.Data.CommandType.Text;
SQLiteDataReader reader = orderQuery.ExecuteReader();
while (reader.Read())
{
OrderHistory gettingHistory = new OrderHistory();
string userName = reader["username"].ToString(),
orderNumber = reader["order_number"].ToString(),
itemId = reader["item_id"].ToString(),
cost = reader["cost"].ToString(),
itemQuantity = reader["item_quantity"].ToString(),
date = reader["date"].ToString();
gettingHistory.setUserName(userName);
gettingHistory.setOrderNumber(int.Parse(orderNumber));
gettingHistory.setItemId(int.Parse(itemId));
gettingHistory.setCost(float.Parse(cost));
gettingHistory.setItemQuantity(int.Parse(itemQuantity));
gettingHistory.setDate(int.Parse(date));
orderHistory.Add(gettingHistory);
}
reader.Dispose();
orderQuery.Dispose();
}
