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();
}
}
public bool insertProductReturn(ProductReturned productReturned)
{
return(create(
insertValues(productReturned.productInvoiceId, productReturned.qtyReturned, MyExtension.MySqlToCSharp.convertDate(productReturned.date), productReturned.reason)
));
}
public bool insertProductReturn(ProductReturned productReturned){
return create(
insertValues(productReturned.productInvoiceId, productReturned.qtyReturned, MyExtension.MySqlToCSharp.convertDate(productReturned.date), productReturned.reason)
);
}
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();
}
}
