Post your any code related problem to www.abctutorial.com

Go end of tutorial for Project Download

Follow the previous video and articles to complete the POS tutorials

Step-1:

• Change the scope name $scope.SalesList to $scope.InvoiceCart inside the HomeInvoiceListController.js inside the method of GetInvoiceSalesBySalesId
• Put the below code inside the HomeInvoiceListController.js and call it from GetInvoiceSalesBySalesId() method.

         function GetProducts() {
            $http.get('/Home/GetAllProduct')
                .then(function (response) {
                    var data = response.data;
                    $scope.ProductList = data;
                });
        }

• We will keep selected the product which already purchase in this invoice. Put this below code inside the <option> tag

ng-selected="product.ProductId==cart.ProductId"

Step-2:

• Pull subtotal from table. Given method is highlighted the additional field that we are newly added to this return object.

    public JsonResult GetInvoiceBySalesId(int salesId)
        {
            POS_TutorialEntities db = new POS_TutorialEntities();
            List<Sale> dataList = (from sd in db.SalesDetails.ToList()
                           join s in db.Sales on sd.SalesId equals s.SalesId
                           where sd.SalesId==salesId
                           select new Sale {
                               SalesId=(int)sd.SalesId,
                               OrderNo=s.OrderNo,
                               CustomerName=s.CustomerName,
                               CustomerPhone = s.CustomerPhone,
                               CustomerAddress = s.CustomerAddress,
                               OrderDate=s.OrderDate,
                               PaymentMethod = s.PaymentMethod,
                               TotalAmout = s.TotalAmout,
                               SalesDetailId = sd.SalesDetailId,
                               ProductId=sd.ProductId,
                               UnitPrice=sd.UnitPrice,
                               Subtotal=s.Subtotal,
                               Quantity=sd.Quantity,
                               LineTotal=sd.LineTotal,
                               DiscountParcentage=s.DiscountParcentage,
                               VatParcentage = s.VatParcentage
                           }).ToList();
            return Json(dataList, JsonRequestBehavior.AllowGet);
        }

• Vat & Discount calculation method will be place inside the HomeInvoiceListController.js and it will be call from GetInvoiceSalesBySalesId when edit button will be click.

$scope.CalculateDiscount = function () {
            $scope.Sale.DiscountAmount = ($scope.Sale.Subtotal * $scope.Sale.DiscountParcentage) / 100;
        }
        $scope.CalculateVat = function () {
            $scope.Sale.VatAmount = (($scope.Sale.Subtotal - $scope.Sale.DiscountAmount) * $scope.Sale.VatParcentage) / 100;
            //$scope.Sale.TotalAmount = ($scope.Sale.Subtotal - $scope.Sale.DiscountAmount) + $scope.Sale.VatAmount;
            //$scope.Sale.TotalAmout = ($scope.Sale.Subtotal - $scope.Sale.DiscountAmount) + $scope.Sale.VatAmount;
        }

Step-3:

• Run the project and see the output.

Download Project