private void stockTransfer() { bool success = false; uStock.stock_item_code = txtItemCode.Text; uStock.stock_fac_id = Convert.ToInt32(getFactoryID(cmbTo.Text)); uStock.stock_qty = getQty(txtItemCode.Text, cmbTo.Text) + Convert.ToSingle(txtQty.Text); uStock.stock_unit = Unit; uStock.stock_updtd_date = DateTime.Now; uStock.stock_updtd_by = MainDashboard.USER_ID; if (IfExists(txtItemCode.Text, cmbTo.Text)) { success = dalStock.Update(uStock); } else { success = dalStock.Insert(uStock); } if (!success) { MessageBox.Show("Failed to transfer stock"); } else { float temp = Convert.ToSingle(txtQty.Text) - overReceivedQty; dalItem.orderSubtract(txtItemCode.Text, temp.ToString()); //subtract order qty //change pmma zero cost item qty if (cmbSubFrom.Text.Equals(tool.getCustName(1))) { //dalItem.orderSubtract(txtItemCode.Text, txtQty.Text); uItem.item_code = uStock.stock_item_code; uItem.item_last_pmma_qty = dalItem.getLastPMMAQty(uItem.item_code); uItem.item_pmma_qty = dalItem.getPMMAQty(uItem.item_code) + Convert.ToSingle(txtQty.Text); uItem.item_updtd_date = uStock.stock_updtd_date; uItem.item_updtd_by = MainDashboard.USER_ID; bool itemPMMMAQtyUpdateSuccess = dalItem.UpdatePMMAQty(uItem); if (!itemPMMMAQtyUpdateSuccess) { MessageBox.Show("Failed to updated item pmma qty(@item dal)"); } } if (actionEdit) { actionEdit = false; frmOrderActionHistory.editSuccess = true; } if (ifFullyReceived()) { uOrd.ord_id = orderID; uOrd.ord_status = "RECEIVED"; dalOrd.statusUpdate(uOrd); } frmOrder.receivedNumber = txtQty.Text; orderRecordUpdate(); string from; if (string.IsNullOrEmpty(cmbSubFrom.Text)) { from = cmbFrom.Text; } else { from = cmbSubFrom.Text; } dalOrderAction.orderReceive(orderID, transferRecord("Passed"), txtQty.Text, from, cmbTo.Text, txtLotNO.Text); } if (!dalItem.updateTotalStock(txtItemCode.Text)) { MessageBox.Show("Failed to update total stock"); } }