The Array is not able to send data from the client side to the server

There are several issues that need to be addressed to check the sales data is correctly sent from the client side to the server side, and that the calculations for taxes and profit are correctly performed.

1. Array Data Not Sent Correctly

The error messages indicate that the SalesItems list is not being accessed correctly in the server-side code. Specifically, the properties StockID, SalesID, Qty, Rate, and Amount are not being recognized.

Solution:

• Check the SalesItems list is correctly populated on the client side and matches the server-side model.

• Update the server-side code to correctly access the properties of each SalesItem in the list.

Updated Client-Side Code:

 

function SaveSales() {
    debugger;
    var ObjSalesModel = {
        tblSales: {
            Amount: parseFloat($('#txtTotal').val()),
            Discount: parseFloat($('#discountPercent').val()),
            GrandTotal: parseFloat($('#grandTotal').val()),
        },
        SalesItems: []
    };

    $("#tblAppendHere").find("tr:gt(0)").each(function () {
        debugger;
        var SalesItem = {
            StockID: parseInt($(this).find("td:eq(1)").text()),
            SalesID: parseInt($(this).find("td:eq(2)").text()),
            Qty: parseInt($(this).find("td:eq(3)").text()),
            Rate: parseFloat($(this).find("td:eq(4)").text()),
            Amount: parseFloat($(this).find("td:eq(5)").text())
        };
        ObjSalesModel.SalesItems.push(SalesItem);
    });

    // Post data to server
    $.ajax({
        async: true,
        contentType: "application/json; charset=utf-8",
        type: "POST",
        dataType: "JSON",
        url: "/SalesEntry/SaveSales",
        data: JSON.stringify(ObjSalesModel),
        success: function (data) {
            if (data.result == true) {
                toastr.success("Sales process successfully!...");
                var orderNumber = data.TransactionNo;
                var printUrl = '/SalesEntry/SalesReceipt?TransactionNo=' + orderNumber;
                window.location = printUrl;
            }
        },
        error: function () {
            alert("There is some problem adding the data");
        }
    });
}

Updated Server-Side Code:

 

public ActionResult SaveSales(SalesModel ObjSalesModel)
{
    if (ObjSalesModel == null || ObjSalesModel.tblSales == null)
    {
        return Json(new { result = false, message = "Invalid data received." }, JsonRequestBehavior.AllowGet);
    }

    try
    {
        decimal vat = Vat; // Assuming Vat is defined somewhere
        decimal costPrice = CostPrice; // Assuming CostPrice is defined somewhere
        decimal sellingPrice = SellingPrice; // Assuming SellingPrice is defined somewhere
        decimal Profit = sellingPrice - costPrice;
        decimal Vatpercent = (vat / 100) * sellingPrice;

        tblSale ObjSales = new tblSale();
        ObjSales.OrderDate = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss");
        ObjSales.TransactionNo = string.Format("{0:ddMMMyyyyHHmmss}", DateTime.Now);
        ObjSales.Amount = ObjSalesModel.tblSales.Amount;
        ObjSales.Discount = ObjSalesModel.tblSales.Discount;
        ObjSales.Tax = Vatpercent;
        ObjSales.GrandTotal = ObjSalesModel.tblSales.GrandTotal;
        ObjSales.Profit = Profit;
        ObjSales.UserID = ObjSalesModel.UserID;

        objASPNETPHARMACYDBEntities.tblSales.Add(ObjSales);
        objASPNETPHARMACYDBEntities.SaveChanges();

        foreach (var sales in ObjSalesModel.SalesItems)
        {
            tblSalesItem ObjSalesItem = new tblSalesItem();
            ObjSalesItem.StockID = sales.StockID;
            ObjSalesItem.SalesID = ObjSales.SalesID; // Use the newly generated SalesID
            ObjSalesItem.Qty = sales.Qty;
            ObjSalesItem.Rate = sales.Rate;
            ObjSalesItem.Amount = sales.Amount;

            objASPNETPHARMACYDBEntities.tblSalesItems.Add(ObjSalesItem);
            objASPNETPHARMACYDBEntities.SaveChanges();

            var ObjtblStock = objASPNETPHARMACYDBEntities.tblStocks.Where(x => x.StockID == sales.StockID).FirstOrDefault();
            if (ObjtblStock != null)
            {
                ObjtblStock.Qty = ObjtblStock.Qty - sales.Qty;
                objASPNETPHARMACYDBEntities.Entry(ObjtblStock).State = EntityState.Modified;
                objASPNETPHARMACYDBEntities.SaveChanges();
            }
        }

        return Json(new { result = true, message = "Sales successfully saved!", TransactionNo = ObjSales.TransactionNo }, JsonRequestBehavior.AllowGet);
    }
    catch (Exception ex)
    {
        return Json(new { result = false, message = ex.Message }, JsonRequestBehavior.AllowGet);
    }
}

2. Calculate Taxes and Profit

The server-side code should calculate taxes and profit for each sale. Check the CostPrice and SellingPrice are retrieved from the tblStock table.

Updated Calculation Logic: 

foreach (var sales in ObjSalesModel.SalesItems)
{
    var stockItem = objASPNETPHARMACYDBEntities.tblStocks.Where(x => x.StockID == sales.StockID).FirstOrDefault();
    if (stockItem != null)
    {
        decimal costPrice = stockItem.CostPrice;
        decimal sellingPrice = stockItem.SellingPrice;
        decimal profit = sellingPrice - costPrice;
        decimal vatAmount = (vat / 100) * sellingPrice;

        // Update the sales item with calculated values
        sales.Amount = sellingPrice * sales.Qty;
        sales.Profit = profit * sales.Qty;
        sales.Tax = vatAmount * sales.Qty;
    }
}

 

4. Update the Stock Table

Check the stock table is updated correctly after each sale. The provided code already handles this, but make sure the tblStock entity is correctly updated.

hope this helps.