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