예제 #1
0
        public bool Insert(facStockBLL u)
        {
            bool          isSuccess = false;
            SqlConnection conn      = new SqlConnection(myconnstrng);

            try
            {
                String     sql = "INSERT INTO tbl_stock (stock_item_code, stock_fac_id, stock_qty, stock_unit, stock_updtd_date, stock_updtd_by) VALUES (@stock_item_code, @stock_fac_id, @stock_qty, @stock_unit, @stock_updtd_date, @stock_updtd_by)";
                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.Parameters.AddWithValue("@stock_item_code", u.stock_item_code);
                cmd.Parameters.AddWithValue("@stock_fac_id", u.stock_fac_id);
                cmd.Parameters.AddWithValue("@stock_qty", u.stock_qty);
                cmd.Parameters.AddWithValue("@stock_unit", u.stock_unit);
                cmd.Parameters.AddWithValue("@stock_updtd_date", u.stock_updtd_date);
                cmd.Parameters.AddWithValue("@stock_updtd_by", u.stock_updtd_by);

                conn.Open();

                int rows = cmd.ExecuteNonQuery();

                //if the query is executed successfully then the rows' value = 0
                if (rows > 0)
                {
                    //query successful
                    isSuccess = true;
                    dalItem.updateTotalStock(u.stock_item_code);
                }
                else
                {
                    //Query falled
                    isSuccess = false;
                }
            }
            catch (Exception ex)
            {
                Module.Tool tool = new Module.Tool(); tool.saveToText(ex);
            }
            finally
            {
                conn.Close();
            }
            return(isSuccess);
        }
        private void addNewStock(string itemCode, string factory)
        {
            int facID = Convert.ToInt32(tool.getFactoryID(factory));

            uStock.stock_item_code  = itemCode;
            uStock.stock_fac_id     = facID;
            uStock.stock_qty        = 1;
            uStock.stock_unit       = "Set";
            uStock.stock_updtd_date = DateTime.Now;
            uStock.stock_updtd_by   = MainDashboard.USER_ID;

            if (dalFacStock.IfExists(itemCode, facID.ToString()))
            {
                //Updating data into database
                bool success = dalFacStock.Update(uStock);

                if (!success)
                {
                    //failed to update user
                    MessageBox.Show("Failed to updated stock");
                }
            }
            else
            {
                //Inserting Data into Database
                bool success = dalFacStock.Insert(uStock);
                //If the data is successfully inserted then the value of success will be true else false
                if (!success)
                {
                    //Failed to insert data
                    MessageBox.Show("Failed to add new stock");
                }
            }

            dalItem.updateTotalStock(itemCode);
        }
예제 #3
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");
            }
        }