Ejemplo n.º 1
0
        /// <summary>
        /// Update the purchase order information
        /// </summary>
        /// <param name="poDetail"></param>
        /// <returns></returns>
        public static bool UpdatePORequestDetail(PurchaseOrderViewModel poDetail)
        {
            try
            {
                if (poDetail == null)
                {
                    return(false);
                }

                PurchaseOrder po = DbFactory.Instance.context.PurchaseOrders.Where(y => y.poId == poDetail.poId).First();
                if (po == null)
                {
                    return(false);
                }

                if (po.status == null || po.status.ToLower() == "closed")
                {
                    return(false);
                }

                PurchaseOrderDetail pod = DbFactory.Instance.context.PurchaseOrderDetails.Where(x =>
                                                                                                x.itemNo == poDetail.itemNo &&
                                                                                                x.poId == poDetail.poId).First();

                // change the quantity here
                pod.quantity = poDetail.quantity;
                DbFactory.Instance.context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
        public ActionResult Details(string pon)
        {
            if (pon != null && pon != "")
            {
                PurchaseOrder          po       = purchaseOrderService.FindPurchaseOrderById(pon);
                PurchaseOrderViewModel podModel = new PurchaseOrderViewModel();
                decimal totalAmount             = 0;


                podModel.PurchaseOrderNo = po.PurchaseOrderNo;
                podModel.SupplierName    = po.Supplier.Name;
                podModel.CreatedDate     = po.CreatedDateTime.ToShortDateString() + " " + po.CreatedDateTime.ToShortTimeString();
                podModel.Status          = po.Status.Name;

                foreach (PurchaseOrderDetail pod in po.PurchaseOrderDetails)
                {
                    totalAmount = totalAmount + purchaseOrderService.FindTotalAmountByPurchaseOrderDetail(pod);
                }
                ViewBag.Amount = totalAmount;

                return(View(podModel));
            }

            else
            {
                ViewBag.Message = "Purchase Order is not a valid one. Please try again!";
                return(View("Error"));
            }
        }
        public override ActionResult Index(ContentModel model)
        {
            PurchaseOrder basket      = TransactionLibrary.GetBasket();
            var           basketModel = new PurchaseOrderViewModel();

            foreach (var orderLine in basket.OrderLines)
            {
                var orderLineViewModel = new OrderlineViewModel
                {
                    Quantity          = orderLine.Quantity,
                    ProductName       = orderLine.ProductName,
                    Sku               = orderLine.Sku,
                    VariantSku        = orderLine.VariantSku,
                    Total             = new Money(orderLine.Total.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString(),
                    Discount          = orderLine.Discount,
                    Tax               = new Money(orderLine.VAT, basket.BillingCurrency.ISOCode).ToString(),
                    Price             = new Money(orderLine.Price, basket.BillingCurrency.ISOCode).ToString(),
                    ProductUrl        = UrlService.GetUrl(CatalogContext.CurrentCatalog, CatalogLibrary.GetProduct(orderLine.Sku)),
                    PriceWithDiscount = new Money(orderLine.Price - orderLine.UnitDiscount.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString(),
                    OrderLineId       = orderLine.OrderLineId
                };


                basketModel.OrderLines.Add(orderLineViewModel);
            }

            basketModel.OrderTotal    = new Money(basket.OrderTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();
            basketModel.DiscountTotal = new Money(basket.DiscountTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();
            basketModel.TaxTotal      = new Money(basket.TaxTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();
            basketModel.SubTotal      = new Money(basket.SubTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();

            return(View("/Views/Basket.cshtml", basketModel));
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="viewModel"></param>
        /// <returns></returns>
        public static PurchaseOrder ToEntity(this PurchaseOrderViewModel viewModel)
        {
            return(viewModel == null ? null : new PurchaseOrder
            {
                Id = viewModel.Id,

                Supplier_Id = viewModel.Supplier_Id,
                Created_By = viewModel.Created_By,
                Submitted_Date = viewModel.Submitted_Date,
                Creation_Date = viewModel.Creation_Date,
                Status_Id = viewModel.Status_Id,
                Expected_Date = viewModel.Expected_Date,
                Shipping_Fee = viewModel.Shipping_Fee,
                Taxes = viewModel.Taxes,
                Payment_Date = viewModel.Payment_Date,
                Payment_Amount = viewModel.Payment_Amount,
                Payment_Method = viewModel.Payment_Method,
                Notes = viewModel.Notes,
                Approved_By = viewModel.Approved_By,
                Approved_Date = viewModel.Approved_Date,
                Submitted_By = viewModel.Submitted_By



                               //RowGuid = viewModel.RowGuid,
                               //ModifiedDate = viewModel.ModifiedDate
            });
        }
        private PurchaseOrderViewModel MapOrder()
        {
            var basket = TransactionLibrary.GetBasket(false).PurchaseOrder;

            var basketModel = new PurchaseOrderViewModel();

            basketModel.OrderTotal    = new Money(basket.OrderTotal.GetValueOrDefault(), basket.BillingCurrency).ToString();
            basketModel.SubTotal      = new Money(basket.SubTotal.GetValueOrDefault(), basket.BillingCurrency).ToString();
            basketModel.ShippingTotal = new Money(basket.ShippingTotal.GetValueOrDefault(), basket.BillingCurrency).ToString();
            basketModel.PaymentTotal  = new Money(basket.PaymentTotal.GetValueOrDefault(), basket.BillingCurrency).ToString();
            basketModel.DiscountTotal = new Money(basket.DiscountTotal.GetValueOrDefault(), basket.BillingCurrency).ToString();
            basketModel.TaxTotal      = new Money(basket.TaxTotal.GetValueOrDefault(), basket.BillingCurrency).ToString();

            foreach (var orderLine in basket.OrderLines)
            {
                basketModel.OrderLines.Add(new OrderlineViewModel()
                {
                    OrderLineId = orderLine.OrderLineId,
                    ProductName = orderLine.ProductName,
                    Sku         = orderLine.Sku,
                    VariantSku  = orderLine.VariantSku,
                    Quantity    = orderLine.Quantity,
                    Total       = new Money(orderLine.Total.GetValueOrDefault(), basket.BillingCurrency).ToString()
                });
            }

            return(basketModel);
        }
 public PurchaseOrderView(PurchaseOrderViewModel model)
 {
     InitializeComponent();
     this.pandsViewModel = model;
     //  this.pandsViewModel = PurchaseOrderViewModel.GetInstance();
     this.DataContext = this.pandsViewModel;
     if (pandsViewModel.PODetailsEntity != null)
     {
         this.grdPandS.ItemsSource = this.pandsViewModel.PODetailsEntity;
     }
     if (pandsViewModel.MustCompare == true)
     {
         PART_TextBox.IsReadOnly      = false;
         PART_TextBox1.IsReadOnly     = false;
         POrderDatepicker.IsEnabled   = true;
         PDeliverDatepicker.IsEnabled = true;
     }
     else
     {
         btnNew.IsEnabled             = false;
         PART_TextBox.IsReadOnly      = true;
         PART_TextBox1.IsReadOnly     = true;
         POrderDatepicker.IsEnabled   = false;
         PDeliverDatepicker.IsEnabled = false;
     }
     CustomGridLines.ItemsSource = DataGridTableCollection.GridLines(8, 50).AsEnumerable();
 }
Ejemplo n.º 7
0
 public PurchaseOrderXtraForm(string nmb)
 {
     InitializeComponent();
     SetControlsTextLength();
     viewModel = (PurchaseOrderViewModel)Program.Kernel.Get <PurchaseOrderViewModel>(new ConstructorArgument("number", nmb));
     number.SetAsIdentifier();
 }
Ejemplo n.º 8
0
        public IActionResult MailPurchaseOrder(long id)
        {
            var purchaseOrderEmailTo = appConfig["PurchaseOrderEmailTo"];
            var purchaseOrderEmailCC = appConfig["PurchaseOrderEmailCC"];

            // read multiline string from json config file
            var purchaseOrderEmailNote = appConfig.GetSection("PurchaseOrderEmailNote").Get <string[]>();
            var emailNote = string.Join("\n", purchaseOrderEmailNote);

            // try to get the line item list from the session
            List <PurchaseOrderLineItem> purchaseOrderLineItems = null;

            if ((purchaseOrderLineItems = HttpContext.Session.Get <List <PurchaseOrderLineItem> >(SessionKeyPurchaseOrderLineItems)) == null)
            {
                // if not found, look it up
                var order = DataFactory.GetShopifyOrder(appConfig, id);
                purchaseOrderLineItems = GetPurchaseOrderLineItemsFromShopifyOrder(order);
            }

            string orderName = purchaseOrderLineItems.FirstOrDefault().OrderID;
            var    model     = new PurchaseOrderViewModel()
            {
                OrderId   = id,
                OrderName = orderName,
                EmailTo   = purchaseOrderEmailTo,
                EmailCC   = purchaseOrderEmailCC,
                EmailBody = emailNote,
                PurchaseOrderLineItems = purchaseOrderLineItems
            };

            return(MailPurchaseOrderAction(model));
        }
Ejemplo n.º 9
0
        public ActionResult NewPurchaseOrder()
        {
            string[] uri = Request.UrlReferrer == null ? new string[] { "PurchaseOrdersList" } : Request.UrlReferrer.ToString().Split('/');

            PurchaseOrderViewModel PurchaseOrderModel = new PurchaseOrderViewModel();

            if (uri.Contains("PurchaseOrdersList") || uri.Contains("AvailableStock"))
            {
                //ViewBag.PurchaseOrderId = DateTime.Now.ToString("ffffssmmhhMMddyyyy");
                //PurchaseOrderModel.PurchaseOrder = new PurchaseOrder { PurchaseOrderId = Convert.ToInt64(DateTime.Now.ToString("ffffssmmhhMMddyyyy")) };
                Session["PurchaseOrderId"] = DateTime.Now.ToString("ffffssmmhhMMddyyyy");
                Session.Remove("PurchaseOrderModel");
            }
            else
            {
                PurchaseOrderModel = (PurchaseOrderViewModel)Session["PurchaseOrderModel"];
                //PurchaseOrderModel.PurchaseOrder = new PurchaseOrder { PurchaseOrderId = Convert.ToInt64(DateTime.Now.ToString("ffffssmmhhMMddyyyy")) };
            }

            PurchaseOrderModel.PurchaseOrder = new PurchaseOrder {
                PurchaseDate = DateTime.Now
            };

            FillDropdowns();
            return(View(PurchaseOrderModel));
        }
        private PurchaseOrderViewModel MapPurchaseOrder(PurchaseOrder basket)
        {
            var model = new PurchaseOrderViewModel();

            model.DiscountTotal =
                new Money(basket.Discount.GetValueOrDefault(), basket.BillingCurrency.ISOCode)
                .ToString();
            model.SubTotal =
                new Money(basket.SubTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode)
                .ToString();
            model.TaxTotal =
                new Money(basket.TaxTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode)
                .ToString();
            model.ShippingTotal =
                new Money(basket.ShippingTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();
            model.PaymentTotal =
                new Money(basket.PaymentTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();
            model.OrderTotal =
                new Money(basket.OrderTotal.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString();

            model.OrderLines = basket.OrderLines.Select(orderLine => new OrderlineViewModel()
            {
                Quantity    = orderLine.Quantity,
                ProductName = orderLine.ProductName,
                Total       = new Money(orderLine.Total.GetValueOrDefault(), basket.BillingCurrency.ISOCode).ToString(),
                Discount    = orderLine.Discount,
                OrderLineId = orderLine.OrderLineId
            }).ToList();

            return(model);
        }
Ejemplo n.º 11
0
        public ActionResult EditOrder(string OrderId)
        {
            string[] uri = Request.UrlReferrer == null ? new string[] { "PurchaseOrdersList" } : Request.UrlReferrer.ToString().Split('/');

            PurchaseOrderViewModel PurchaseOrderModel = new PurchaseOrderViewModel();


            if (uri.Contains("PurchaseOrdersList"))
            {
                using (PharmAssistantContext db = new PharmAssistantContext())
                {
                    PurchaseOrderModel.PurchaseOrder      = db.PurchaseOrders.Include("Supplier").Where(o => o.PurchaseOrderId == OrderId).FirstOrDefault();
                    PurchaseOrderModel.PurchaseOrderItems = db.PurchaseOrderItems.Where(i => i.PurchaseOrderId == OrderId).ToList();
                }
                Session["PurchaseOrderModel"] = PurchaseOrderModel;
            }
            else
            {
                PurchaseOrderModel = (PurchaseOrderViewModel)Session["PurchaseOrderModel"];
                //PurchaseOrderModel.PurchaseOrder = new PurchaseOrder { PurchaseOrderId = Convert.ToInt64(DateTime.Now.ToString("ffffssmmhhMMddyyyy")) };
            }

            ViewBag.MedicineCategories = new SelectList(db.MedicineCategories.Where(m => m.Suppliers.Contains(db.Suppliers.Where(s => s.SupplierId == PurchaseOrderModel.PurchaseOrder.SupplierId).FirstOrDefault())).ToList(), "CategoryId", "MedicineCategoryName");

            //FillDropdowns();
            return(View(PurchaseOrderModel));
        }
Ejemplo n.º 12
0
        public async Task <IActionResult> Post([FromBody] PurchaseOrderViewModel model)
        {
            const string error = "Failed to save a new order";

            try {
                if (ModelState.IsValid)
                {
                    var newOrder = _mapper.Map <PurchaseOrderViewModel, PurchaseOrder>(model);

                    if (newOrder.OrderDate == DateTime.MinValue)
                    {
                        newOrder.OrderDate = DateTime.Now;
                    }

                    var currentUser = await _userManager.FindByNameAsync(User.Identity.Name);

                    newOrder.User = currentUser;

                    newOrder = _orderRepository.AddOrder(newOrder);

                    return(Created($"/api/orders/{newOrder.Id}",
                                   _mapper.Map <PurchaseOrder, PurchaseOrderViewModel>(newOrder)));
                }
                else
                {
                    return(BadRequest(ModelState));
                }
            }
            catch (Exception ex) {
                _logger.LogError($"{error} : {ex}");
            };

            return(base.BadRequest(error));
        }
Ejemplo n.º 13
0
        public ActionResult PurchaseOrder(PurchaseOrderViewModel model)
        {
            if (!ModelState.IsValid)
            {
                return(RedirectToAction(ActionNames.Index, ControllerNames.Checkout));
            }

            var customer        = HttpContext.GetCustomer();
            var checkoutContext = PersistedCheckoutContextProvider.LoadCheckoutContext(customer);

            var updatedCheckoutContext = new PersistedCheckoutContext(
                creditCard: checkoutContext.CreditCard,
                payPalExpress: checkoutContext.PayPalExpress,
                purchaseOrder: new PurchaseOrderDetails(model.PONumber),
                braintree: checkoutContext.Braintree,
                amazonPayments: null,
                termsAndConditionsAccepted: checkoutContext.TermsAndConditionsAccepted,
                over13Checked: checkoutContext.Over13Checked,
                shippingEstimateDetails: checkoutContext.ShippingEstimateDetails,
                offsiteRequiresBillingAddressId: null,
                offsiteRequiresShippingAddressId: null,
                email: checkoutContext.Email,
                selectedShippingMethodId: checkoutContext.SelectedShippingMethodId);

            PersistedCheckoutContextProvider.SaveCheckoutContext(customer, updatedCheckoutContext);
            customer.UpdateCustomer(requestedPaymentMethod: AppLogic.ro_PMPurchaseOrder);

            return(RedirectToAction(ActionNames.Index, ControllerNames.Checkout));
        }
Ejemplo n.º 14
0
        public PurchaseOrderViewModel GetAsset_master(string ordno)
        {
            db.Configuration.ProxyCreationEnabled = true;
            purchase_order         x       = db.purchase_order.Where(y => y.pd_order_no == ordno).FirstOrDefault();
            PurchaseOrderViewModel pvModel = new PurchaseOrderViewModel();

            if (x == null)
            {
            }

            else
            {
                pvModel.pd_id        = x.pd_id;
                pvModel.pd_order_no  = x.pd_order_no;
                pvModel.pd_ad_id     = x.asset_def.ad_id;
                pvModel.assetname    = x.asset_def.ad_name;
                pvModel.pd_odateStr  = x.pd_odateStr;
                pvModel.pd_ddateStr  = x.pd_ddateStr;
                pvModel.pd_qty       = Convert.ToInt32(x.pd_qty);
                pvModel.pd_status    = x.pd_status;
                pvModel.pd_type_id   = x.asset_type.at_id;
                pvModel.assettype    = x.asset_type.at_name;
                pvModel.pd_vendor_id = x.pd_vendor_id;
                pvModel.vendor_name  = x.vendor_creation.vd_name;
            }

            return(pvModel);
        }
Ejemplo n.º 15
0
 public PurchaseOrderAdd()
 {
     InitializeComponent();
     _vm = new PurchaseOrderViewModel();
     this.DataContext = _vm;
     _vm.PODate       = DateTime.Now;
 }
 public void BuildSelectLists(PurchaseOrderViewModel purchaseOrderViewModel)
 {
     purchaseOrderViewModel.PriceTermDropDown      = priceTermSelectListBuilder.BuildSelectListItemsForPriceTerms(priceTermRepository.GetAllPriceTerms());
     purchaseOrderViewModel.PaymentTermDropDown    = paymentTermSelectListBuilder.BuildSelectListItemsForPaymentTerms(paymentTermRepository.GetAllPaymentTerms());
     purchaseOrderViewModel.ApproverDropDown       = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), purchaseOrderViewModel.UserID);
     purchaseOrderViewModel.PreparedPersonDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), purchaseOrderViewModel.UserID);
 }
Ejemplo n.º 17
0
        public IActionResult PurchaseOrder(long id)
        {
            var order = DataFactory.GetShopifyOrder(appConfig, id);
            var purchaseOrderLineItems = GetPurchaseOrderLineItemsFromShopifyOrder(order);

            // TODO: Due to the grid using ajax rest calls, it shouldn't be neccesary to load the order at all here
            // except right now we are using it to calculate the total cost
            decimal totalCost = 0;

            foreach (var purchaseOrderLineItem in purchaseOrderLineItems)
            {
                totalCost += purchaseOrderLineItem.PriceUSD;
            }

            var purchaseOrderEmailTo = appConfig["PurchaseOrderEmailTo"];
            var purchaseOrderEmailCC = appConfig["PurchaseOrderEmailCC"];

            // read multiline string from jsong config file
            var purchaseOrderEmailNote = appConfig.GetSection("PurchaseOrderEmailNote").Get <string[]>();
            var emailNote = string.Join("\n", purchaseOrderEmailNote);

            var model = new PurchaseOrderViewModel()
            {
                OrderId   = id,
                OrderName = order.Name,
                EmailTo   = purchaseOrderEmailTo,
                EmailCC   = purchaseOrderEmailCC,
                EmailBody = emailNote,
                TotalCost = totalCost,
                PurchaseOrderLineItems = purchaseOrderLineItems
            };

            return(View(model));
        }
Ejemplo n.º 18
0
        public ActionResult ReceivedGoodsPurchaseOrderView(string pon)
        {
            PurchaseOrderViewModel POVM = new PurchaseOrderViewModel();

            POVM.PurchaseOrderNo = pon;

            return(View(POVM));
        }
        /// <summary>
        /// Indexes this instance.
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            ViewBag.CountryList = CountriesHelper.GetCountries();

            var model = new PurchaseOrderViewModel();

            return(View(model));
        }
        public ActionResult Index()
        {
            PurchaseOrderViewModel model = MapOrder();

            model.BillingAddress  = MapOrderAddress(TransactionLibrary.GetBillingInformation());
            model.ShippingAddress = MapOrderAddress(TransactionLibrary.GetShippingInformation());

            return(View("/Views/mc/preview.cshtml", model));
        }
        public IActionResult Update([FromBody] CrudViewModel <PurchaseOrderViewModel> payload)
        {
            PurchaseOrderViewModel value = payload.value;
            var result = _functionalService
                         .Update <PurchaseOrderViewModel, PurchaseOrder>(value, Convert.ToInt32(value.PurchaseOrderId));

            this.UpdatePurchaseOrder(value.PurchaseOrderId);
            return(Ok());
        }
Ejemplo n.º 22
0
        public virtual ActionResult OnCreateItem()
        {
            LogI("OnCreateItem");

            var model = new PurchaseOrderViewModel();

            ViewBag.PartialViewName = "_EditPurchaseOrder";
            return(View("EditNew", model));
        }
Ejemplo n.º 23
0
        public virtual ActionResult GetPurchaseOrder(long id)
        {
            LogI("GetPurchaseOrder, id=" + id);

            var model         = OpenBoxViewModel.BuildFromBoxId(Db, id);
            var purchaseModel = new PurchaseOrderViewModel(model);

            return(JsonGet(new ValueResult <PurchaseOrderViewModel>(true, null, purchaseModel)));
        }
Ejemplo n.º 24
0
        // GET: PurchaseOrder
        public ActionResult Index()
        {
            var purchaseOrderViewModel = new PurchaseOrderViewModel
            {
                PurchaseOrders = AutoMapper.Mapper.Map <ICollection <InvoiceModel> >(invoiceService.GetInvoices(string.Empty))
            };

            return(View("View", purchaseOrderViewModel));
        }
Ejemplo n.º 25
0
        public ActionResult SearchPurchaseOrder(DateTime startDate, DateTime endDate)
        {
            var viewModel = new PurchaseOrderViewModel()
            {
                GroupedItemPurchaseOrders = itemPurchaseOrderService.groupItemPurchaseOrdersByDateRange(startDate, endDate)
            };

            return(View("PurchaseOrder", viewModel));
        }
Ejemplo n.º 26
0
        public PurchaseOrderViewModel ToViewModel(TblPurchaseOrder Model, ApplicationUser AU)
        {
            PurchaseOrderViewModel ToReturn = new PurchaseOrderViewModel();

            if (Model.ApplicationUser == null && Model.ApplicationUserId != null)
            {
                ToReturn.ApplicationUserId = Model.ApplicationUserId.ToString();
            }
            else
            {
                ToReturn.ApplicationUserId = Model.ApplicationUser.Id.ToString();
            }

            ToReturn.FromDetail = AU.PersonName + "<BR />" + AU.Email + "<BR />" + AU.Organisation;


            ToReturn.Budget          = Model.Budget;
            ToReturn.Code            = Model.Code;
            ToReturn.DateFullfilled  = Model.DateFullfilled;
            ToReturn.DateRaised      = Model.DateRaised;
            ToReturn.DateRequired    = Model.DateRequired;
            ToReturn.DeliverTo       = Model.DeliverTo;
            ToReturn.DeliverToDetail = Model.DeliverToDetail;
            ToReturn.Id              = Model.ID.ToString();
            ToReturn.InvoiceTo       = Model.InvoiceTo;
            ToReturn.InvoiceToDetail = Model.InvoiceToDetail;
            ToReturn.Note            = Model.Note;
            ToReturn.Price           = Model.Price;
            ToReturn.RowVersionNo    = Model.RowVersionNo;
            ToReturn.Status          = Model.Status;
            ToReturn.Tax             = Model.Tax;
            ToReturn.To              = Model.To;
            ToReturn.ToDetail        = Model.ToDetail;
            ToReturn.Total           = Model.Total;
            if (Model.Items != null)
            {
                foreach (var I in Model.Items)
                {
                    ToReturn.Items.Add(new PurchaseOrderItemViewModel()
                    {
                        Brand       = I.Brand,
                        Code        = I.Code,
                        Description = I.Description,
                        Id          = I.ID.ToString(),
                        Name        = I.Name,
                        Price       = I.Price,
                        Quantity    = I.Quantity,
                        RowVersion  = I.RowVersionNo,
                        Tax         = I.Tax,
                        TaxCode     = I.TaxCode,
                        Total       = I.Total
                    });
                }
            }
            return(ToReturn);
        }
Ejemplo n.º 27
0
        /// <summary>
        /// Find the purchase order information
        /// </summary>
        /// <param name="itemNo"></param>
        /// <param name="supplierId"></param>
        /// <returns></returns>
        private static PurchaseOrderViewModel getPOViewModel(string itemNo, string supplierId)
        {
            PurchaseOrderViewModel model = new PurchaseOrderViewModel();

            try
            {
                decimal tenderPrice = DbFactory.Instance.context.Pricings.AsNoTracking().Where(x => x.itemNo == itemNo && x.supplierId == supplierId).
                                      Select(x => x.tenderPrice).First();
                var item = DbFactory.Instance.context.Inventories.AsNoTracking().Where(x => x.itemNo == itemNo).
                           Select(x => new
                {
                    x.reorderQuantity,
                    x.description,
                    x.category
                }).First();
                //string supplierName = DbFactory.Instance.context.Suppliers.AsNoTracking().Where(x => x.supplierId == supplierId).Select(x => x.supplierName).First();

                model = new PurchaseOrderViewModel()
                {
                    itemNo = itemNo,

                    quantity    = item.reorderQuantity,
                    description = item.description,
                    category    = item.category,

                    supplierName = supplierId,
                    supplierID   = supplierId,
                    tenderPrice  = tenderPrice
                };
            }
            catch (Exception e)
            {
            }

            return(model);

            //var price = DbFactory.Instance.context.Pricings.Where(x => x.itemNo == itemNo && x.supplierId == supplierId).FirstOrDefault();
            //var item = DbFactory.Instance.context.Inventories.Where(x => x.itemNo == itemNo).FirstOrDefault();


            //if (price != null && item != null)
            //{
            //    model = new PurchaseOrderViewModel()
            //    {
            //        quantity = item.reorderQuantity,
            //        itemNo = item.itemNo,
            //        description = item.description,
            //        category = item.category,

            //        supplierName = price.Supplier == null ? null : price.Supplier.supplierName,
            //        supplierID = price.supplierId,
            //        tenderPrice = price.tenderPrice
            //    };
            //}
            //return model;
        }
        public ActionResult PurchaseOrderCompletedList()
        {
            var purchaseOrderViewModel = new PurchaseOrderViewModel()
            {
                PurchaseOrders = purchaseOrderService.GetAll().Where(po => po.Status == CustomStatus.Completed).OrderByDescending(r => r.createdDateTime)
            };

            ViewBag.PoView = "Showing Results for Completed List";
            return(View("Index", purchaseOrderViewModel));
        }
        public ActionResult PurchaseOrderForm()
        {
            var purchaseOrderViewModel = new PurchaseOrderViewModel()
            {
                ItemPurchaseOrderViewModels = itemService.GetItemsLowerThanReorderLevel(),
                PendingOrderCount           = purchaseOrderService.getPendingOrderCount()
            };

            return(View("PurchaseOrderForm", purchaseOrderViewModel));
        }
Ejemplo n.º 30
0
        public ActionResult DeletePurchaseOrderItem(int id)
        {
            PurchaseOrderViewModel PurchaseOrderModel = (PurchaseOrderViewModel)Session["PurchaseOrderModel"];

            PurchaseOrderModel.PurchaseOrderItems.Remove(PurchaseOrderModel.PurchaseOrderItems.Where(i => i.MedicineId == id).FirstOrDefault());

            FillDropdowns();
            //return View("NewPurchaseOrder", PurchaseOrderModel);
            return(RedirectToAction("NewPurchaseOrder"));
        }