Esempio n. 1
0
        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");
            }
        }