public async Task Should_Success_UpdateThenAddMany()
        {
            var dbContext = _dbContext(GetCurrentMethod());
            DeliveryOrderFacade facade = new DeliveryOrderFacade(dbContext, GetServiceProvider(GetCurrentMethod()).Object);
            DeliveryOrder       model  = await _dataUtil(facade, dbContext, GetCurrentMethod()).GetTestData(USERNAME);

            foreach (var item in model.Items)
            {
                foreach (var detail in item.Details)
                {
                    detail.DOQuantity -= 1;
                }
            }
            var Response = await facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(0, Response);

            var newModelForAddItem = await _dataUtil(facade, dbContext, GetCurrentMethod()).GetNewData(USERNAME);

            DeliveryOrderItem newModelItem = newModelForAddItem.Items.FirstOrDefault();

            model.Items.Add(newModelItem);
            model.Items.Add(newModelItem);
            var ResponseAddItem = await facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(0, ResponseAddItem);
        }
Ejemplo n.º 2
0
        public IActionResult DeleteDeliveryOrderItem(long id)
        {
            DeliveryOrderItem DeliveryOrderItem = Deliveryorderitem_repo.Find(id);

            if (DeliveryOrderItem == null)
            {
                return(NotFound());
            }

            Deliveryorderitem_repo.Delete(DeliveryOrderItem);
            return(Ok());
        }
Ejemplo n.º 3
0
        private void wizardFromDOToolStripButton_Click(object sender, EventArgs e)
        {
            IList addedPI = new ArrayList();

            for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
            {
                DeliveryOrderItem pi = (DeliveryOrderItem)itemsDataGrid[GRNNoColumn.Index, i].Tag;
                if (pi == null)
                {
                    continue;
                }
                addedPI.Add(pi.ID);
            }
            using (SearchDOForCussInvoiceForm frm = new SearchDOForCussInvoiceForm(
                       ((Customer)supplierkryptonComboBox.SelectedItem), addedPI, m_mainForm.CurrentUser, dateKryptonDateTimePicker.Value))
            {
                frm.ShowDialog();
                IList result = frm.RESULT;
                foreach (DeliveryOrderItem item in result)
                {
                    if (item.SO_ITEM.ID > 0)
                    {
                        item.SO_ITEM = r_po.FindSalesOrderItem(item.SO_ITEM.ID);
                    }
                    Part p   = item.PART;
                    int  row = itemsDataGrid.Rows.Add();
                    itemsDataGrid[codeColumn.Index, row].Tag    = p;
                    itemsDataGrid[GRNNoColumn.Index, row].Tag   = item;
                    itemsDataGrid[scanColumn.Index, row].Value  = p.BARCODE;
                    itemsDataGrid[GRNNoColumn.Index, row].Value = item.EVENT.CODE;
                    itemsDataGrid[codeColumn.Index, row].Value  = p.CODE;
                    itemsDataGrid[nameColumn.Index, row].Value  = p.NAME;
                    itemsDataGrid[QtyColumn.Index, row].Value   = item.OUTSTANDING_AMOUNT_TO_SR;
                    p.UNIT = (Unit)r_unit.GetById(item.UNIT);
                    itemsDataGrid[unitColumn.Index, row].Value = p.UNIT.ToString();
                    //itemsDataGrid[unitColumn.Index, row].Value = item.UNIT.ToString();
                    // if (item.UNIT.ID == item.SO_ITEM.UNIT.ID)
                    //{
                    //itemsDataGrid[priceColumn.Index, row].Value = item.SO_ITEM != null ? item.SO_ITEM.PRICE : 0d;
                    itemsDataGrid[priceColumn.Index, row].Value       = item.SO_ITEM != null ? item.SO_ITEM.PRICE_IN_SMALLEST_UNIT : 0d;
                    itemsDataGrid[discpercentColumn.Index, row].Value = item.SO_ITEM != null ? item.SO_ITEM.DISC_PERCENT : 0;
                    itemsDataGrid[discAmountColumn.Index, row].Value  = item.SO_ITEM != null ? item.SO_ITEM.DISC_AMOUNT : 0d;
                    itemsDataGrid[totalDiscColumn.Index, row].Value   = item.SO_ITEM != null ? item.SO_ITEM.TOTAL_DISCOUNT : 0d;
                    itemsDataGrid[notesColumn.Index, row].Value       = item.SO_ITEM != null ? item.SO_ITEM.NOTES : "";
                    itemsDataGrid[discabcColumn.Index, row].Value     = item.SO_ITEM != null ? item.SO_ITEM.DISC_ABC : "";
                    itemsDataGrid[totalAmountColumn.Index, row].Value = item.SO_ITEM != null ? item.SO_ITEM.SUBTOTAL : 0d;
                    itemsDataGrid[warehouseColumn.Index, row].Value   = r_warehouse.GetById(item.WAREHOUSE).ToString();
                    // }
                    updateSubtotal(row);
                }
            }
        }
Ejemplo n.º 4
0
 private void AddResult()
 {
     for (int i = 0; i < gridData.Rows.Count; i++)
     {
         bool check = Convert.ToBoolean(gridData[checkColumn.Index, i].Value);
         if (!check)
         {
             continue;
         }
         DeliveryOrderItem pi = (DeliveryOrderItem)gridData.Rows[i].Tag;
         RESULT.Add(pi);
     }
 }
Ejemplo n.º 5
0
        public ActionResult SubmitOrder(long orderId)
        {
            Order order = new Order();

            try
            {
                order = _orderRepository.GetOrderByOrderId(orderId);
                _orderRepository.UpdateOrder(order);

                //Generate delivery order
                string beginSerialNumber    = "CK-" + DateTime.Now.ToString("yyyyMMdd");
                string maxDeliveryNumberStr = _deliveryOrderRepository.GetMaxDeliveryOrderNumber(beginSerialNumber);

                DeliveryOrder deliveryOrder = new DeliveryOrder();
                deliveryOrder.DeliveryOrderNumber = beginSerialNumber + "-" + maxDeliveryNumberStr;
                deliveryOrder.DeliveryDate        = DateTime.Now;
                deliveryOrder.TotalRMBInChinese   = MathHelper.ConvertToChinese((Double)order.TotalAmount);
                deliveryOrder.TotalRMBInNumberic  = order.TotalAmount.ToString();
                deliveryOrder.OrderId             = order.Id;

                long             currentDeliveryOrderId = _deliveryOrderRepository.AddDeliveryOrder(deliveryOrder);
                List <OrderItem> orderItems             = order.OrderItems.ToList();
                foreach (var item in orderItems)
                {
                    DeliveryOrderItem deliveryOrderItem = new DeliveryOrderItem();
                    deliveryOrderItem.ProductName     = item.Product.ProductName;
                    deliveryOrderItem.Unit            = "件";
                    deliveryOrderItem.OutNumber       = item.Quantity;
                    deliveryOrderItem.PricePerProduct = item.UnitPrice;
                    deliveryOrderItem.TotalPrice      = item.Quantity * item.UnitPrice;
                    deliveryOrderItem.DeliveryOrderId = currentDeliveryOrderId;

                    _deliveryOrderItemRepository.AddDeliveryOrderItem(deliveryOrderItem);
                }

                //Generate delivery note
                DeliveryNote deliveryNote = new DeliveryNote();
                deliveryNote.DeliveryNoteNumber = "PS-" + DateTime.Now.ToString("yyyyMMdd") + "-" + maxDeliveryNumberStr;
                //Generate QR Code
                deliveryNote.QRCodeImgURL = QRCodeHelper.GetQRImage(deliveryNote.DeliveryNoteNumber);
                deliveryNote.OrderId      = order.Id;

                _deliveryNoteRepository.AddDeliveryNote(deliveryNote);
            }
            catch (Exception ex)
            {
            }
            return(View("SubmitOrder", order));
        }
Ejemplo n.º 6
0
        private IList getItems()
        {
            IList items = new ArrayList();

            for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
            {
                Part p = (Part)itemsDataGrid[codeColumn.Index, i].Tag;
                if (itemsDataGrid[unitColumn.Index, i].Value == null)
                {
                    continue;
                }
                Unit u = (Unit)Utils.FindEntityInList(itemsDataGrid[unitColumn.Index, i].Value.ToString(), m_units);
                if ((p == null) || (u == null))
                {
                    continue;
                }
                POSItem st = (POSItem)itemsDataGrid.Rows[i].Tag;
                if (st == null)
                {
                    st = new POSItem();
                }
                itemsDataGrid.Rows[i].Tag = st;
                st.EVENT          = m_si;
                st.PART           = p;
                st.WAREHOUSE      = (Warehouse)Utils.FindEntityInList(itemsDataGrid[warehouseColumn.Index, i].Value.ToString(), m_warehouses);
                st.QYTAMOUNT      = Convert.ToDouble(itemsDataGrid[QtyColumn.Index, i].Value);
                st.UNIT           = u;
                st.PRICE          = Convert.ToDouble(itemsDataGrid[priceColumn.Index, i].Value);
                st.DISC_PERCENT   = Convert.ToDouble(itemsDataGrid[discpercentColumn.Index, i].Value);
                st.DISC_AMOUNT    = Convert.ToDouble(itemsDataGrid[discAmountColumn.Index, i].Value);
                st.TOTAL_DISCOUNT = Convert.ToDouble(itemsDataGrid[totalDiscColumn.Index, i].Value);
                st.NOTES          = itemsDataGrid[notesColumn.Index, i].Value == null ? "" : itemsDataGrid[notesColumn.Index, i].Value.ToString();
                st.DISC_ABC       = itemsDataGrid[discabcColumn.Index, i].Value == null ? "" : itemsDataGrid[discabcColumn.Index, i].Value.ToString();
                st.DISC_A         = splitDiscString(st.DISC_ABC, 0);
                st.DISC_B         = splitDiscString(st.DISC_ABC, 1);
                st.DISC_C         = splitDiscString(st.DISC_ABC, 2);
                st.SUBTOTAL       = Convert.ToDouble(itemsDataGrid[totalAmountColumn.Index, i].Value);
                DeliveryOrderItem grn = (DeliveryOrderItem)itemsDataGrid[GRNNoColumn.Index, i].Tag;
                st.DO_ITEM = grn;
                if (st.QYTAMOUNT == 0)
                {
                    continue;
                }
                items.Add(st);
            }
            return(items);
        }
Ejemplo n.º 7
0
 private void updateReturned()
 {
     for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
     {
         DeliveryOrderItem st = (DeliveryOrderItem)itemsDataGrid.Rows[i].Tag;
         if (st == null)
         {
             continue;
         }
         Part p = (Part)itemsDataGrid[codeColumn.Index, i].Tag;
         if (itemsDataGrid[unitColumn.Index, i].Value == null)
         {
             continue;
         }
         p.UNIT = (Unit)r_unit.GetById(p.UNIT);
         itemsDataGrid[returnedColumn.Index, i].Value     = r_grn.GetReturned(st.ID);
         itemsDataGrid[returnedunitColumn.Index, i].Value = p.UNIT.ToString();
     }
 }
Ejemplo n.º 8
0
        private IList getItems()
        {
            IList items = new ArrayList();

            for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
            {
                SalesOrderItem poi = (SalesOrderItem)itemsDataGrid[scanColumn.Index, i].Tag;
                if (poi == null)
                {
                    continue;
                }
                Part p = (Part)itemsDataGrid[codeColumn.Index, i].Tag;
                if (itemsDataGrid[unitColumn.Index, i].Value == null)
                {
                    continue;
                }
                Unit u = (Unit)Utils.FindEntityInList(itemsDataGrid[unitColumn.Index, i].Value.ToString(), m_units);
                if ((p == null) || (u == null))
                {
                    continue;
                }
                DeliveryOrderItem st = (DeliveryOrderItem)itemsDataGrid.Rows[i].Tag;
                if (st == null)
                {
                    st = new DeliveryOrderItem();
                }
                itemsDataGrid.Rows[i].Tag = st;
                st.EVENT     = m_do;
                st.PART      = p;
                st.WAREHOUSE = (Warehouse)Utils.FindEntityInList(itemsDataGrid[warehouseColumn.Index, i].Value.ToString(), m_warehouses);
                st.QYTAMOUNT = Convert.ToDouble(itemsDataGrid[QtyColumn.Index, i].Value);
                st.UNIT      = u;
                st.SO_ITEM   = poi;
                st.NOTES     = itemsDataGrid[notesColumn.Index, i].Value == null ? "" : itemsDataGrid[notesColumn.Index, i].Value.ToString();
                if (st.QYTAMOUNT == 0)
                {
                    continue;
                }
                items.Add(st);
            }
            return(items);
        }
Ejemplo n.º 9
0
 void Post(object sender, EventArgs e)
 {
     try
     {
         this.Cursor = Cursors.WaitCursor;
         if (m_prn.POSTED)
         {
             r_prn.Revise(m_prn.ID);
             m_prn.POSTED = false;
             KryptonMessageBox.Show("Transaction has been UNPOSTED", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
         else
         {
             r_prn.Confirm(m_prn.ID);
             m_prn.POSTED = true;
             KryptonMessageBox.Show("Transaction has been POSTED", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
         setEnableForm(false);
         setEditMode(EditMode.View);
         for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
         {
             DeliveryOrderItem poi = (DeliveryOrderItem)itemsDataGrid[scanColumn.Index, i].Tag;
             if (poi == null)
             {
                 continue;
             }
             itemsDataGrid[OutstandingPOColumn.Index, i].Value = r_grn.GetReturned(poi.ID);
         }
     }
     catch (Exception x)
     {
         KryptonMessageBox.Show(x.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
Ejemplo n.º 10
0
 void dataItemskryptonDataGridView_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
 {
     if (m_editMode == EditMode.View)
     {
         return;
     }
     itemsDataGrid.Rows[e.RowIndex].ErrorText = "";
     if (!itemsDataGrid[e.ColumnIndex, e.RowIndex].IsInEditMode)
     {
         return;
     }
     if (e.ColumnIndex == scanColumn.Index)
     {
         if (!((DataGridViewTextBoxCell)itemsDataGrid[scanColumn.Index, e.RowIndex]).IsInEditMode)
         {
             return;
         }
         if (e.FormattedValue.ToString() == "")
         {
             return;
         }
         IList result = r_part.SearchActivePart(e.FormattedValue.ToString(), true);
         if (result.Count == 1)
         {
             Part p = (Part)result[0];
             for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
             {
                 if (i == e.RowIndex)
                 {
                     continue;
                 }
                 Part pi = (Part)itemsDataGrid[codeColumn.Index, i].Tag;
                 if (pi == null)
                 {
                     continue;
                 }
                 if (pi.ID == p.ID)
                 {
                     itemsDataGrid.Rows[e.RowIndex].ErrorText = "Part : " + p.NAME + " already add.";
                     e.Cancel = true;
                     return;
                 }
             }
             itemsDataGrid[codeColumn.Index, e.RowIndex].Tag    = p;
             itemsDataGrid[GRNNoColumn.Index, e.RowIndex].Tag   = null;
             itemsDataGrid[GRNNoColumn.Index, e.RowIndex].Value = "";
             itemsDataGrid[scanColumn.Index, e.RowIndex].Value  = p.BARCODE;
             itemsDataGrid[codeColumn.Index, e.RowIndex].Value  = p.CODE;
             itemsDataGrid[nameColumn.Index, e.RowIndex].Value  = p.NAME;
             //dataItemskryptonDataGridView[QtyColumn.Index, e.RowIndex].Value = 0;
             //unitColumn.Items.Clear();
             // IList units = r_part.GetAllUnit(p.ID, p.UNIT.ID);
             //Utils.GetListCode(unitColumn.Items, units);
             p.UNIT = (Unit)r_unit.GetById(p.UNIT);
             itemsDataGrid[unitColumn.Index, e.RowIndex].Value  = p.UNIT.ToString();
             itemsDataGrid[priceColumn.Index, e.RowIndex].Value = r_si.GetTheLatestSIPrice(((Customer)supplierkryptonComboBox.SelectedItem).ID, p.ID, p.UNIT.ID);
             //dataItemskryptonDataGridView[totalAmountColumn.Index, e.RowIndex].Value = 0;
             itemsDataGrid[warehouseColumn.Index, e.RowIndex].Value = m_warehouses[0].ToString();
         }
         if ((result.Count == 0) || (result.Count > 1))
         {
             using (SearchPartForm fr = new SearchPartForm(e.FormattedValue.ToString(), result))
             {
                 fr.ShowDialog();
                 Part p = fr.PART;
                 if (p == null)
                 {
                     p = (Part)itemsDataGrid[codeColumn.Index, e.RowIndex].Tag;
                     if (p == null)
                     {
                         e.Cancel = true;
                         return;
                     }
                 }
                 else
                 {
                     for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
                     {
                         if (i == e.RowIndex)
                         {
                             continue;
                         }
                         Part pi = (Part)itemsDataGrid[codeColumn.Index, i].Tag;
                         if (pi == null)
                         {
                             continue;
                         }
                         if (pi.ID == p.ID)
                         {
                             itemsDataGrid.Rows[e.RowIndex].ErrorText = "Part : " + p.NAME + " already add.";
                             e.Cancel = true;
                             return;
                         }
                     }
                     itemsDataGrid[codeColumn.Index, e.RowIndex].Tag    = p;
                     itemsDataGrid[GRNNoColumn.Index, e.RowIndex].Tag   = null;
                     itemsDataGrid[GRNNoColumn.Index, e.RowIndex].Value = "";
                     itemsDataGrid[scanColumn.Index, e.RowIndex].Value  = p.BARCODE;
                     itemsDataGrid[codeColumn.Index, e.RowIndex].Value  = p.CODE;
                     itemsDataGrid[nameColumn.Index, e.RowIndex].Value  = p.NAME;
                     //dataItemskryptonDataGridView[QtyColumn.Index, e.RowIndex].Value = 0;
                     //unitColumn.Items.Clear();
                     //IList units = r_part.GetAllUnit(p.ID, p.UNIT.ID);
                     //Utils.GetListCode(unitColumn.Items, units);
                     p.UNIT = (Unit)r_unit.GetById(p.UNIT);
                     itemsDataGrid[unitColumn.Index, e.RowIndex].Value  = p.UNIT.ToString();
                     itemsDataGrid[priceColumn.Index, e.RowIndex].Value = r_si.GetTheLatestSIPrice(((Customer)supplierkryptonComboBox.SelectedItem).ID, p.ID, p.UNIT.ID);
                     // dataItemskryptonDataGridView[totalAmountColumn.Index, e.RowIndex].Value = 0;
                     itemsDataGrid[warehouseColumn.Index, e.RowIndex].Value = m_warehouses[0].ToString();
                 }
             }
         }
     }
     if (e.ColumnIndex == discabcColumn.Index)
     {
         if (e.FormattedValue.ToString() == "")
         {
             return;
         }
         else
         {
             try
             {
                 splitDiscString(e.FormattedValue.ToString(), 0);
                 splitDiscString(e.FormattedValue.ToString(), 1);
                 splitDiscString(e.FormattedValue.ToString(), 2);
             }
             catch (Exception x)
             {
                 itemsDataGrid.Rows[e.RowIndex].ErrorText = x.Message;
                 e.Cancel = true;
                 return;
             }
         }
     }
     if (e.ColumnIndex == QtyColumn.Index || e.ColumnIndex == unitColumn.Index)
     {
         DeliveryOrderItem item = (DeliveryOrderItem)itemsDataGrid[GRNNoColumn.Index, e.RowIndex].Tag;
         if (item != null)
         {
             if (item.ID == 0)
             {
                 return;
             }
             e.Cancel = true;
             itemsDataGrid.Rows[e.RowIndex].ErrorText = "DO Qty / Unit  can not change";
         }
     }
 }
Ejemplo n.º 11
0
        private void loadMovement()
        {
            movemntkryptonDataGridView.Rows.Clear();
            if (m_part.ID == 0)
            {
                return;
            }
            IList movs = r_part.GetAllEvents(m_part.ID);

            foreach (EventItem itm in movs)
            {
                int r = movemntkryptonDataGridView.Rows.Add();
                movemntkryptonDataGridView[dateMovementColumn.Index, r].Value      = itm.EVENT.TRANSACTION_DATE;
                movemntkryptonDataGridView[eventCodeMovementColumn.Index, r].Value = itm.EVENT.CODE;
                movemntkryptonDataGridView[eventTypeMovementColumn.Index, r].Value = itm.STOCK_CARD_ENTRY_TYPE.ToString();
                movemntkryptonDataGridView[QtyMovementColumn.Index, r].Value       = itm.GetAmountInSmallestUnit();
                movemntkryptonDataGridView[unitMovementColumn.Index, r].Value      = m_part.UNIT.CODE;
                movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value    = "-";
                switch (itm.STOCK_CARD_ENTRY_TYPE)
                {
                case StockCardEntryType.PurchaseOrder:
                    PurchaseOrderItem pi = (PurchaseOrderItem)itm;
                    PurchaseOrder     p  = (PurchaseOrder)pi.EVENT;
                    p.SUPPLIER = (Supplier)r_sup.GetById(p.SUPPLIER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = p.SUPPLIER.NAME;
                    break;

                case StockCardEntryType.SalesOrder:
                    SalesOrderItem soi = (SalesOrderItem)itm;
                    SalesOrder     so  = (SalesOrder)soi.EVENT;
                    so.CUSTOMER = (Customer)r_cus.GetById(so.CUSTOMER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = so.CUSTOMER.NAME;
                    break;

                case StockCardEntryType.GoodReceiveNote:
                    GoodReceiveNoteItem grni = (GoodReceiveNoteItem)itm;
                    GoodReceiveNote     grn  = (GoodReceiveNote)grni.EVENT;
                    grn.SUPPLIER = (Supplier)r_sup.GetById(grn.SUPPLIER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = grn.SUPPLIER.NAME;
                    break;

                case StockCardEntryType.DeliveryOrder:
                    DeliveryOrderItem doi = (DeliveryOrderItem)itm;
                    DeliveryOrder     dor = (DeliveryOrder)doi.EVENT;
                    dor.CUSTOMER = (Customer)r_cus.GetById(dor.CUSTOMER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = dor.CUSTOMER.NAME;
                    break;

                case StockCardEntryType.SupplierInvoice:
                    SupplierInvoiceItem sii = (SupplierInvoiceItem)itm;
                    SupplierInvoice     si  = (SupplierInvoice)sii.EVENT;
                    si.SUPPLIER = (Supplier)r_sup.GetById(si.SUPPLIER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = si.SUPPLIER.NAME;
                    break;

                case StockCardEntryType.CustomerInvoice:
                    CustomerInvoiceItem cii = (CustomerInvoiceItem)itm;
                    CustomerInvoice     ci  = (CustomerInvoice)cii.EVENT;
                    ci.CUSTOMER = (Customer)r_cus.GetById(ci.CUSTOMER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = ci.CUSTOMER.NAME;
                    break;

                case StockCardEntryType.PurchaseReturn:
                    PurchaseReturnItem pri = (PurchaseReturnItem)itm;
                    PurchaseReturn     pr  = (PurchaseReturn)pri.EVENT;
                    pr.SUPPLIER = (Supplier)r_sup.GetById(pr.SUPPLIER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = pr.SUPPLIER.NAME;
                    break;

                case StockCardEntryType.SalesReturn:
                    SalesReturnItem sri = (SalesReturnItem)itm;
                    SalesReturn     sr  = (SalesReturn)sri.EVENT;
                    sr.CUSTOMER = (Customer)r_cus.GetById(sr.CUSTOMER);
                    movemntkryptonDataGridView[vendorMovementColumn.Index, r].Value = sr.CUSTOMER.NAME;
                    break;
                }
                movemntkryptonDataGridView[statusMovementColumn.Index, r].Value = itm.EVENT.POSTED.ToString();
            }
            UserSetting.AddNumberToGrid(movemntkryptonDataGridView);
        }
        public async Task Should_Success_UpdateThenAdd()
        {
            var dbContext = _dbContext(GetCurrentMethod() + "ThenAdd");
            DeliveryOrderFacade facade = new DeliveryOrderFacade(dbContext, GetServiceProvider(GetCurrentMethod() + "ThenAdd").Object);
            DeliveryOrder       model  = await _dataUtil(facade, dbContext, GetCurrentMethod() + "ThenAdd").GetTestData(USERNAME);

            foreach (var item in model.Items)
            {
                foreach (var detail in item.Details)
                {
                    detail.DOQuantity -= 1;
                }
            }

            foreach (var item in dbContext.InternalPurchaseOrderFulfillments.ToList())
            {
                dbContext.Entry(item).State = EntityState.Detached;
            }

            var Response = await facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(0, Response);

            DeliveryOrderItem   oldItem          = model.Items.FirstOrDefault();
            DeliveryOrderDetail oldDetail        = oldItem.Details.FirstOrDefault();
            DeliveryOrderItem   newDuplicateItem = new DeliveryOrderItem
            {
                EPOId   = oldItem.EPOId,
                EPONo   = oldItem.EPONo,
                Details = new List <DeliveryOrderDetail>()
            };
            DeliveryOrderDetail oldDuplicateDetail = new DeliveryOrderDetail
            {
                EPODetailId     = oldDetail.EPODetailId,
                POItemId        = oldDetail.POItemId,
                PRId            = oldDetail.PRId,
                PRNo            = oldDetail.PRNo,
                PRItemId        = oldDetail.PRItemId,
                ProductId       = oldDetail.ProductId,
                ProductCode     = oldDetail.ProductCode,
                ProductName     = oldDetail.ProductName,
                ProductRemark   = oldDetail.ProductRemark,
                DOQuantity      = oldDetail.DOQuantity,
                DealQuantity    = oldDetail.DealQuantity,
                UomId           = oldDetail.UomId,
                UomUnit         = oldDetail.UomUnit,
                ReceiptQuantity = oldDetail.ReceiptQuantity,
                IsClosed        = oldDetail.IsClosed,
            };
            DeliveryOrderDetail newDuplicateDetail = new DeliveryOrderDetail
            {
                EPODetailId     = oldDetail.EPODetailId,
                POItemId        = oldDetail.POItemId,
                PRId            = oldDetail.PRId,
                PRNo            = oldDetail.PRNo,
                PRItemId        = oldDetail.PRItemId,
                ProductId       = "PrdId2",
                ProductCode     = "PrdCode2",
                ProductName     = "PrdName2",
                ProductRemark   = oldDetail.ProductRemark,
                DOQuantity      = oldDetail.DOQuantity,
                DealQuantity    = oldDetail.DealQuantity,
                UomId           = oldDetail.UomId,
                UomUnit         = oldDetail.UomUnit,
                ReceiptQuantity = oldDetail.ReceiptQuantity,
                IsClosed        = oldDetail.IsClosed,
            };

            newDuplicateItem.Details.Add(oldDuplicateDetail);
            newDuplicateItem.Details.Add(newDuplicateDetail);
            model.Items.Add(newDuplicateItem);
            var ResponseAddDuplicateItem = await facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(0, ResponseAddDuplicateItem);
        }
Ejemplo n.º 13
0
 public IActionResult AddDeliveryOrderItem([FromBody] DeliveryOrderItem model)
 {
     Deliveryorderitem_repo.Add(model);
     return(new OkObjectResult(new { DeliveryOrderItemID = model.DeliveryOrderItemId }));
 }
        public async void Should_Success_Update_Data()
        {
            DeliveryOrder model = await DataUtil.GetTestData(USERNAME);

            foreach (var item in model.Items)
            {
                foreach (var detail in item.Details)
                {
                    detail.DOQuantity -= 1;
                }
            }
            var Response = await Facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(Response, 0);

            DeliveryOrderItem   oldItem          = model.Items.FirstOrDefault();
            DeliveryOrderDetail oldDetail        = oldItem.Details.FirstOrDefault();
            DeliveryOrderItem   newDuplicateItem = new DeliveryOrderItem
            {
                EPOId   = oldItem.EPOId,
                EPONo   = oldItem.EPONo,
                Details = new List <DeliveryOrderDetail>()
            };
            DeliveryOrderDetail oldDuplicateDetail = new DeliveryOrderDetail
            {
                EPODetailId     = oldDetail.EPODetailId,
                POItemId        = oldDetail.POItemId,
                PRId            = oldDetail.PRId,
                PRNo            = oldDetail.PRNo,
                PRItemId        = oldDetail.PRItemId,
                ProductId       = oldDetail.ProductId,
                ProductCode     = oldDetail.ProductCode,
                ProductName     = oldDetail.ProductName,
                ProductRemark   = oldDetail.ProductRemark,
                DOQuantity      = oldDetail.DOQuantity,
                DealQuantity    = oldDetail.DealQuantity,
                UomId           = oldDetail.UomId,
                UomUnit         = oldDetail.UomUnit,
                ReceiptQuantity = oldDetail.ReceiptQuantity,
                IsClosed        = oldDetail.IsClosed,
            };
            DeliveryOrderDetail newDuplicateDetail = new DeliveryOrderDetail
            {
                EPODetailId     = oldDetail.EPODetailId,
                POItemId        = oldDetail.POItemId,
                PRId            = oldDetail.PRId,
                PRNo            = oldDetail.PRNo,
                PRItemId        = oldDetail.PRItemId,
                ProductId       = "PrdId2",
                ProductCode     = "PrdCode2",
                ProductName     = "PrdName2",
                ProductRemark   = oldDetail.ProductRemark,
                DOQuantity      = oldDetail.DOQuantity,
                DealQuantity    = oldDetail.DealQuantity,
                UomId           = oldDetail.UomId,
                UomUnit         = oldDetail.UomUnit,
                ReceiptQuantity = oldDetail.ReceiptQuantity,
                IsClosed        = oldDetail.IsClosed,
            };

            newDuplicateItem.Details.Add(oldDuplicateDetail);
            newDuplicateItem.Details.Add(newDuplicateDetail);
            model.Items.Add(newDuplicateItem);
            var ResponseAddDuplicateItem = await Facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(ResponseAddDuplicateItem, 0);

            var newModelForAddItem = await DataUtil.GetNewData(USERNAME);

            DeliveryOrderItem newModelItem = newModelForAddItem.Items.FirstOrDefault();

            model.Items.Add(newModelItem);
            model.Items.Add(newModelItem);
            var ResponseAddItem = await Facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(ResponseAddItem, 0);

            model.Items.Remove(newModelItem);
            model.Items.FirstOrDefault().Details.Remove(oldDetail);
            var ResponseRemoveItemDetail = await Facade.Update((int)model.Id, model, USERNAME);

            Assert.NotEqual(ResponseRemoveItemDetail, 0);
        }
Ejemplo n.º 15
0
        public bool Valid()
        {
            errorProvider1.Clear();
            bool a = textBoxCode.Text == "" && !r_prn.IsAutoNumber();
            bool b = employeeKryptonComboBox.SelectedItem == null;
            bool k = supplierkryptonComboBox.SelectedItem == null;
            bool e = false;
            bool f = m_prn.ID > 0 ? false : r_prn.IsCodeExist(textBoxCode.Text);

            if (a)
            {
                errorProvider1.SetError(textBoxCode, "Code Can not Empty");
            }
            if (b)
            {
                errorProvider1.SetError(employeeKryptonComboBox, "Employee Can not Empty");
            }
            if (k)
            {
                errorProvider1.SetError(supplierkryptonComboBox, "Customer Can not Empty");
            }
            if (f)
            {
                errorProvider1.SetError(textBoxCode, a ? "Code Can not Empty & Code already used" : "Code already used");
            }

            int j = 0;

            for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
            {
                DeliveryOrderItem pi = (DeliveryOrderItem)itemsDataGrid[scanColumn.Index, i].Tag;
                if (pi == null)
                {
                    continue;
                }
                Part p = (Part)itemsDataGrid[codeColumn.Index, i].Tag;
                if (p == null)
                {
                    continue;
                }
                if (itemsDataGrid[unitColumn.Index, i].Value == null)
                {
                    itemsDataGrid.Rows[i].ErrorText = "Please choose unit.";
                    e = true;
                }
                //if (itemsDataGrid[warehouseColumn.Index, i].Value == null)
                //{
                //    itemsDataGrid.Rows[i].ErrorText = "Please choose warehouse.";
                //    e = true;
                //}
                double qty = Convert.ToDouble(itemsDataGrid[QtyColumn.Index, i].Value);
                if (qty == 0)
                {
                    itemsDataGrid.Rows[i].ErrorText = itemsDataGrid.Rows[i].ErrorText + " Quantity must not 0(zero)";
                    e = true;
                }
                j++;
            }

            bool g = j == 0;

            if (g)
            {
                errorProvider1.SetError(itemsDataGrid, "Items must at least 1(one)");
            }
            return(!a && !b && !e && !f && !g);
        }
Ejemplo n.º 16
0
        void dataItemskryptonDataGridView_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
        {
            if (m_editMode == EditMode.View)
            {
                return;
            }
            itemsDataGrid.Rows[e.RowIndex].ErrorText = "";
            if (!itemsDataGrid[e.ColumnIndex, e.RowIndex].IsInEditMode)
            {
                return;
            }

            if (e.ColumnIndex == scanColumn.Index)
            {
                if (e.FormattedValue.ToString() == "")
                {
                    return;
                }

                IList addedPI = new ArrayList();
                for (int i = 0; i < itemsDataGrid.Rows.Count; i++)
                {
                    if (i == e.RowIndex)
                    {
                        continue;
                    }
                    SalesOrderItem pi = (SalesOrderItem)itemsDataGrid[scanColumn.Index, i].Tag;
                    if (pi == null)
                    {
                        continue;
                    }
                    addedPI.Add(pi.ID);
                }
                IList res = r_po.FindSObyPartAndSONo(e.FormattedValue.ToString(), addedPI, ((Customer)supplierkryptonComboBox.SelectedItem).ID, dateKryptonDateTimePicker.Value);
                if (res.Count == 0)
                {
                    using (SearchSOForDOForm fr = new SearchSOForDOForm(e.FormattedValue.ToString(), ((Customer)supplierkryptonComboBox.SelectedItem), addedPI, m_mainForm.CurrentUser, dateKryptonDateTimePicker.Value))
                    {
                        fr.ShowDialog();
                        IList result = fr.RESULT;
                        m_poItems = result;
                    }
                }
                else
                {
                    m_poItems = res;
                }
            }
            if (QtyColumn.Index == e.ColumnIndex)
            {
                SalesOrderItem pi = (SalesOrderItem)itemsDataGrid[scanColumn.Index, e.RowIndex].Tag;
                if (pi == null)
                {
                    return;
                }
                Part p = (Part)itemsDataGrid[codeColumn.Index, e.RowIndex].Tag;
                if (p == null)
                {
                    return;
                }
                Unit u = (Unit)Utils.FindEntityInList(itemsDataGrid[unitColumn.Index, e.RowIndex].Value.ToString(), m_units);
                if (u == null)
                {
                    return;
                }
                p.UNIT_CONVERSION_LIST = r_part.GetUnitConversions(p.ID);
                DeliveryOrderItem sample = new DeliveryOrderItem();
                sample.PART      = p;
                sample.UNIT      = u;
                sample.QYTAMOUNT = Convert.ToDouble(e.FormattedValue);
                double qty  = sample.GetAmountInSmallestUnit();
                double rest = r_po.GetOutstandingDelivered(pi.ID) - qty;
                if (rest < 0)
                {
                    e.Cancel = true;
                    itemsDataGrid.Rows[e.RowIndex].ErrorText = "Quantity exceed outstanding quantity";
                }
                //itemsDataGrid[OutstandingPOColumn.Index, e.RowIndex].Value = rest;
            }
            if (unitColumn.Index == e.ColumnIndex)
            {
                SalesOrderItem pi = (SalesOrderItem)itemsDataGrid[scanColumn.Index, e.RowIndex].Tag;
                if (pi == null)
                {
                    return;
                }
                Part p = (Part)itemsDataGrid[codeColumn.Index, e.RowIndex].Tag;
                if (p == null)
                {
                    return;
                }
                Unit u = (Unit)Utils.FindEntityInList(e.FormattedValue.ToString(), m_units);
                if (u == null)
                {
                    return;
                }
                p.UNIT_CONVERSION_LIST = r_part.GetUnitConversions(p.ID);
                DeliveryOrderItem sample = new DeliveryOrderItem();
                sample.PART      = p;
                sample.UNIT      = u;
                sample.QYTAMOUNT = Convert.ToDouble(itemsDataGrid[QtyColumn.Index, e.RowIndex].Value);
                double qty  = sample.GetAmountInSmallestUnit();
                double rest = r_po.GetOutstandingDelivered(pi.ID) - qty;
                if (rest < 0)
                {
                    e.Cancel = true;
                    itemsDataGrid.Rows[e.RowIndex].ErrorText = "Quantity exceed outstanding quantity";
                }
                //itemsDataGrid[OutstandingPOColumn.Index, e.RowIndex].Value = rest;
            }
        }
Ejemplo n.º 17
0
 public void AddDeliveryOrderItem(DeliveryOrderItem deliveryOrderItem)
 {
     _context.DeliveryOrderItem.Add(deliveryOrderItem);
     _context.SaveChanges();
 }