POST request fail

Hello Tuhin Paul

This is my current revise code, but the Ajax post request is not able to data in the table to the controller.

   function SavePurchases()
    {
            debugger;
           
            var purchaseModel = {};
            var ListOfPurchaseItemsViewModel = new Array();
            purchaseModel.PurchaseID = $.trim($('#PurchaseID').val() + '--' + $('#SelectSupplier').val()),
            purchaseModel.Date = $('#InvocingDate').val().trim(),
            purchaseModel.SupplierID = $('#SelectSupplier').val(),
            purchaseModel.Amount = $('#Amount').val(),
            purchaseModel.Discount = $('#Discount').val(),
            purchaseModel.Tax = $('#Tax').val(),
            purchaseModel.GrandTotal = $('#GrandTotal').val(),
            purchaseModel.IsPaid = $('#Payment').is(":checked") ? 1 : 0,
            purchaseModel.Description = $('#Description').val(),
             
            $("#orderItems").find("tr:gt(0)").each(function () {
                var PurchaseItemModel = {};
                PurchaseItemModel.ItemID = $('#selectItem').val(),
                    PurchaseItemModel.ItemName = $('#selectItem option:selected').text(),
                    PurchaseItemModel.Batch = $('#Batch').val(),
                    PurchaseItemModel.Qty = $('#Qty').val(),
                    PurchaseItemModel.CostPrice = $('#CP').val(),
                    PurchaseItemModel.SellingPrice = $('#SP').val(),
                    PurchaseItemModel.Expiry = $('#Expiry').val(),
                    PurchaseItemModel.PurchaseID = $('#PurchaseID').val() + ' / ' + $('#SelectSupplier').val(),
                    PurchaseItemModel.BonusIncluded = 0
                ListOfPurchaseItemsViewModel.push(PurchaseItemModel);
            });
            purchaseModel.ListOfPurchaseItemsViewModel = ListOfPurchaseItemsViewModel;
               
                //post data to server
                $.ajax({
                    contentType: "application/json; charset=utf-8",
                    type: "POST",
                    dataType: "JSON",
                    url: "/PurchaseEntry/SavePurchase",
                    data: JSON.stringify(purchaseModel),
                    //data:data,
                    success: function (d) {
                        //check is successfully save to database
                        if (d.status == true) {
                            //will send status from server side
                            alert('Successfully done.');
                            location.reload(true);
                            //clear form
                            purchaseItems = [];
                            $('#PurchaseID').val('');
                            $('#InvocingDate').val('');
                            $('#SelectSupplier').val('0');

                        }
                        else {
                            alert('Failed');
                        }
                        $('#submit').val('Save');
                    },
                    error: function () {
                        alert('Error. Please try again.');
                        $('#btnSubmit').val('Save');
                    }
                });
            
}

 

 public ActionResult SavePurchase(PurchaseItem purchaseModel)
        {
            var result = false;
            try
            {

                tblPurchase objPurchase = new tblPurchase();
                if (purchaseModel.PurchaseID > 0)
                {
                    objPurchase = objASPNETPHARMACYDBEntities.tblPurchases.Where(x => x.PurchaseID == purchaseModel.tblPurchase.PurchaseID).FirstOrDefault();
                }
                objPurchase.Date = purchaseModel.tblPurchase.Date;
                objPurchase.SupplierID = purchaseModel.tblPurchase.SupplierID;
                objPurchase.Amount = purchaseModel.tblPurchase.Amount;
                objPurchase.Discount = purchaseModel.tblPurchase.Discount;
                objPurchase.Tax = purchaseModel.tblPurchase.Tax;
                objPurchase.GrandTotal = purchaseModel.tblPurchase.GrandTotal;
                objPurchase.IsPaid = purchaseModel.tblPurchase.IsPaid;
                objPurchase.Description = purchaseModel.tblPurchase.Description;
                objASPNETPHARMACYDBEntities.SaveChanges();
                purchaseModel.PurchaseID = purchaseModel.tblPurchase.PurchaseID;

                tblPurchaseItem updatePurchase = new tblPurchaseItem();
                if (purchaseModel.PurchaseItemID > 0)
                {
                    updatePurchase = objASPNETPHARMACYDBEntities.tblPurchaseItems.Where(x => x.PurchaseItemID == purchaseModel.PurchaseItemID).FirstOrDefault();
                }
                else
                {
                    updatePurchase.PurchaseID = purchaseModel.PurchaseID;
                    updatePurchase.ItemID = purchaseModel.ItemID;
                    updatePurchase.Batch = purchaseModel.Batch;
                    updatePurchase.Qty = purchaseModel.Qty;
                    updatePurchase.CostPrice = purchaseModel.CostPrice;
                    updatePurchase.SellingPrice = purchaseModel.SellingPrice;
                    updatePurchase.Expiry = purchaseModel.Expiry;
                    objASPNETPHARMACYDBEntities.tblPurchaseItems.Add(updatePurchase);
                }
                if (purchaseModel.PurchaseItemID <= 0)
                {
                    objASPNETPHARMACYDBEntities.tblPurchaseItems.Add(updatePurchase);
                }
                objASPNETPHARMACYDBEntities.SaveChanges();
                result = true;
            }
            catch (Exception)
            {

                return Json(new { result = true, message = "Purchase fails to save!" }, JsonRequestBehavior.AllowGet);
            }
            return Json(new { result = true, message = "Purchase successfully saved!" }, JsonRequestBehavior.AllowGet);
        }

Hello Mr Paul, initially that was how I wrote the severside method in the controller but it didn't work so I had to change it to current revise code I posted here, but with your explanation if can you remodified it for me I will be grateful 

And with the JavaScript function I will check it again.

If you are expecting purchaseModel.tblPurchaseItem on the server side,

[HttpPost]
public JsonResult SavePurchase(PurchaseModel purchaseModel)
{
    try
    {
        // Process the purchase model and its items
        var purchaseId = purchaseModel.PurchaseID;
        var purchaseItems = purchaseModel.tblPurchaseItem;

        // Perform the necessary database operations here

        return Json(new { status = true });
    }
    catch (Exception ex)
    {
        return Json(new { status = false, message = ex.Message });
    }
}

Also check that your model binding works correctly on the server-side and that the PurchaseModel class has a property for tblPurchaseItem of type List or something similar.

 

In your GeneratedItemsTable function, the issue might be that the input fields (e.g., #selectItem, #Batch, #Qty) inside the table rows are not being populated correctly.

Hello Team,

This is my revise code, and as at now the textboxes data is reaching the controller but the table data is not reaching the controller.

     function SavePurchases()
    {
            debugger;
            var tblPurchaseItem = [];
            var purchaseModel = new Object();
            purchaseModel.PurchaseID = $.trim($('#PurchaseID').val() + '--' + $('#SelectSupplier').val()),
            purchaseModel.Date = $('#InvocingDate').val().trim(),
            purchaseModel.SupplierID = $('#SelectSupplier').val(),
            purchaseModel.Amount = $('#Amount').val(),
            purchaseModel.Discount = $('#Discount').val(),
            purchaseModel.Tax = $('#Tax').val(),
            purchaseModel.GrandTotal = $('#GrandTotal').val(),
            purchaseModel.IsPaid = $('#Payment').is(":checked") ? 1 : 0,
            purchaseModel.Description = $('#Description').val(),

             PurchaseItemModel = new Object();
            $("#orderItems").find("tr:gt(0)").each(function () {               
                PurchaseItemModel.ItemID = $('#selectItem').val(),
                    PurchaseItemModel.ItemName = $('#selectItem option:selected').text(),
                    PurchaseItemModel.Batch = $('#Batch').val(),
                    PurchaseItemModel.Qty = $('#Qty').val(),
                    PurchaseItemModel.CostPrice = $('#CP').val(),
                    PurchaseItemModel.SellingPrice = $('#SP').val(),
                    PurchaseItemModel.Expiry = $('#Expiry').val(),
                    PurchaseItemModel.PurchaseID = $('#PurchaseID').val() + ' / ' + $('#SelectSupplier').val(),
                    PurchaseItemModel.BonusIncluded = 0
                PurchaseItemModel.tblPurchaseItem = purchaseModel
                var data=JSON.stringify({
                    purchaseModel:purchaseModel
                });
                //post data to server
                $.ajax({
                    contentType: "application/json; charset=utf-8",
                    type: "POST",
                    dataType: "JSON",
                    url: "/PurchaseEntry/SavePurchase",
                    //data: JSON.stringify(purchaseModel),
                    data:data,
                    success: function (d) {
                        //check is successfully save to database
                        if (d.status == true) {
                            //will send status from server side
                            alert('Successfully done.');
                            location.reload(true);
                            //clear form
                            purchaseItems = [];
                            $('#PurchaseID').val('');
                            $('#InvocingDate').val('');
                            $('#SelectSupplier').val('0');

                        }
                        else {
                            alert('Failed');
                        }
                        $('#submit').val('Save');
                    },
                    error: function () {
                        alert('Error. Please try again.');
                        $('#btnSubmit').val('Save');
                    }
                });
            })

 

Table

  function GeneratedItemsTable() {
        if (purchaseItems.length > 0) {
            var $table = $('

');
            $table.append('');
            var $tbody = $('');

            // var $table = $('.tableList');
            // var $tbody = $('

');

            $.each(purchaseItems, function (i, val) {
                var $row = $('

');
                //$row.append($('

Item	Batch	Qty	CP	SP	Expiry	Delete
').html(val.ItemID));                 $row.append($('	').html(val.ItemName));                 $row.append($('	').html(val.Batch));                 $row.append($('	').html(val.Qty));                 $row.append($('	').html(val.CostPrice));                 $row.append($('	').html(val.SellingPrice));                 $row.append($('	').html(val.Expiry));                 $row.append($('	').html(''));                 $tbody.append($row);             });             $table.append($tbody);             $('#orderItems').html($table);         }         else {             alert("List is empty !");         }     }   EF Emmmanuel FIADUFE1y agoPosted Jan 17, 2025, 6:15 AM Hello Sreenath Kappoor I change it, and when I tried saving the data, the error message that came is localhost:10435 says failed, the function is not able to post data to the controller Sreenath Kappoor1y agoPosted Jan 17, 2025, 4:19 AM Hi Emmanual, Can you please change and check this - the url as url: '/PurchaseEntry/SavePurchase' and data as, data: JSON.stringify(purchaseModel). EF Emmmanuel FIADUFE1y agoPosted Jan 16, 2025, 11:46 PM Hello Team, Any help will be highly appreciated. Thanks Amira Bedhiafi1y agoPosted Jan 16, 2025, 12:25 PM Can you please detail more your input and your expected output ? EF Emmmanuel FIADUFE1y agoPosted Jan 16, 2025, 6:57 AM Thank you Amira  Bedhiafi for your response. I have corrected but it is still not working. the is my server-side action method   public ActionResult SavePurchase(PurchaseItem purchaseModel)         {             var result = false;             try             {                 tblPurchase objPurchase = new tblPurchase();                 if (purchaseModel.PurchaseID > 0)                 {                     objPurchase = objASPNETPHARMACYDBEntities.tblPurchases.Where(x => x.PurchaseID == purchaseModel.PurchaseID).FirstOrDefault();                 }                 objPurchase.Date = purchaseModel.Purchase.Date;                 objPurchase.SupplierID = purchaseModel.Purchase.SupplierID;                 objPurchase.Amount = purchaseModel.Purchase.Amount;                 objPurchase.Discount = purchaseModel.Purchase.Discount;                 objPurchase.Tax = purchaseModel.Purchase.Tax;                 objPurchase.GrandTotal = purchaseModel.Purchase.GrandTotal;                 objPurchase.IsPaid = purchaseModel.Purchase.IsPaid;                 objPurchase.Description = purchaseModel.Purchase.Description;                 objASPNETPHARMACYDBEntities.SaveChanges();                 purchaseModel.PurchaseID = purchaseModel.PurchaseID;                 tblPurchaseItem updatePurchase = new tblPurchaseItem();                 if (purchaseModel.PurchaseItemID > 0)                 {                      updatePurchase = objASPNETPHARMACYDBEntities.tblPurchaseItems.Where(x => x.PurchaseItemID == purchaseModel.PurchaseItemID).FirstOrDefault();                 }                 else                 {                     updatePurchase.PurchaseID = purchaseModel.PurchaseID;                     updatePurchase.ItemID = purchaseModel.ItemID;                     updatePurchase.Batch = purchaseModel.Batch;                     updatePurchase.Qty = purchaseModel.Qty;                     updatePurchase.CostPrice = purchaseModel.CostPrice;                     updatePurchase.SellingPrice = purchaseModel.SellingPrice;                     updatePurchase.Expiry = purchaseModel.Expiry;                     objASPNETPHARMACYDBEntities.tblPurchaseItems.Add(updatePurchase);                 }                 if (purchaseModel.PurchaseItemID <= 0)                 {                     objASPNETPHARMACYDBEntities.tblPurchaseItems.Add(updatePurchase);                 }                 objASPNETPHARMACYDBEntities.SaveChanges();                  result = true;              }                          catch (Exception)             {                 return Json(new { result = true, message = "Purchase fails to save!" }, JsonRequestBehavior.AllowGet);             }             return Json(new { result = true, message = "Purchase successfully saved!" }, JsonRequestBehavior.AllowGet);         } Amira Bedhiafi1y agoPosted Jan 16, 2025, 12:06 AM The contentType is set as "application/json; chasert=utf-8", but it seems there is a typo (chasert instead of charset). Also I ghave a sdoubt about the server-side action method not being able to accept the incoming JSON object because the parameter in the SavePurchase action should match the JSON structure. [HttpPost] public JsonResult SavePurchase(PurchaseModel purchaseModel) { // put here your locig to save data return Json(new { status = true }); } Another thought, did you verify if the CORS is enabled on the serve ?