private void ProductReturnControl_Load(object sender, EventArgs e) { ProductReturnMapper productReturnedMapper = new ProductReturnMapper(base.masterController.DataBaseController.mySqlDB); DataTable dt = new DataTable(); productReturnedMapper.loadTable(dt); dataGridView1.DataSource = dt; }
void editDataGrid() { InputDialog inputDialog = new InputDialog("Product Return", "Reason for return"); DialogResult result = inputDialog.ShowDialog(); if (result == DialogResult.OK) { const int DESC_INDEX = 0; const int UNIT_PRICE_INDEX = 1; const int QUANTITY_INDEX = 2; const int GROUP_PRICE_INDEX = 3; if (dgProductTransaction.SelectedRows.Count == 1) { DataGridViewRow row = dgProductTransaction.SelectedRows[0]; string desc = getValueFromDatagridCell(dgProductTransaction, row.Index, DESC_INDEX).ToString(); int old_qty = 0; int.TryParse(getValueFromDatagridCell(dgProductTransaction, row.Index, QUANTITY_INDEX).ToString(), out old_qty); int return_qty = 0; int.TryParse(txtQty.Text, out return_qty); int new_qty = old_qty; if (return_qty <= old_qty) { new_qty = old_qty - return_qty; } else { MessageBox.Show("Value cannot be higher than the sold qyt"); } dgProductTransaction.SelectedRows[0].Cells[QUANTITY_INDEX].Value = new_qty; decimal unit_price = (decimal)getValueFromDatagridCell(dgProductTransaction, row.Index, UNIT_PRICE_INDEX); decimal new_group_price = unit_price * new_qty; dgProductTransaction.SelectedRows[0].Cells[GROUP_PRICE_INDEX].Value = new_group_price; computeTotalPrice(); // TODO ProductReturned productReturned = new ProductReturned(int.Parse(txtTransactionno.Text), return_qty, DateTime.Now, inputDialog.prompt); ProductReturnMapper prm = new ProductReturnMapper(dbController.mySqlDB); prm.insertProductReturn(productReturned); updateProductTransaction(desc, parseTransactionNo(), return_qty, new_group_price); dbController.updateTotalPrice(parseTransactionNo().ToString(), new_group_price); } txtQty.Clear(); searchTransaction(); } }
void editDataGrid() { InputDialog inputDialog = new InputDialog("Product Return", "Reason for return"); DialogResult result = inputDialog.ShowDialog(); if (result == DialogResult.OK) { const int DESC_INDEX = 0; const int UNIT_PRICE_INDEX = 1; const int QUANTITY_INDEX = 2; const int GROUP_PRICE_INDEX = 3; if (dgProductTransaction.SelectedRows.Count == 1) { DataGridViewRow row = dgProductTransaction.SelectedRows[0]; string desc = getValueFromDatagridCell(dgProductTransaction, row.Index, DESC_INDEX).ToString(); int old_qty = 0; int.TryParse(getValueFromDatagridCell(dgProductTransaction, row.Index, QUANTITY_INDEX).ToString(), out old_qty); int return_qty = 0; int.TryParse(txtQty.Text, out return_qty); int new_qty = old_qty; if (return_qty <= old_qty) new_qty = old_qty - return_qty; else MessageBox.Show("Value cannot be higher than the sold qyt"); dgProductTransaction.SelectedRows[0].Cells[QUANTITY_INDEX].Value = new_qty; decimal unit_price = (decimal)getValueFromDatagridCell(dgProductTransaction, row.Index, UNIT_PRICE_INDEX); decimal new_group_price = unit_price * new_qty; dgProductTransaction.SelectedRows[0].Cells[GROUP_PRICE_INDEX].Value = new_group_price; computeTotalPrice(); // TODO ProductReturned productReturned = new ProductReturned(int.Parse(txtTransactionno.Text), return_qty, DateTime.Now, inputDialog.prompt); ProductReturnMapper prm = new ProductReturnMapper(dbController.mySqlDB); prm.insertProductReturn(productReturned); updateProductTransaction(desc, parseTransactionNo(), return_qty, new_group_price); dbController.updateTotalPrice(parseTransactionNo().ToString(), new_group_price); } txtQty.Clear(); searchTransaction(); } }