POST request fail

Sign in to answer this question.

• 

  Tuhin Paul1y agoPosted Jan 17, 2025, 6:22 PM

  Accepted answer

  The way you are binding the values inside the each loop is problematic. You should collect the values from the table dynamically (i.e., for each row) and push them to an array. The current implementation seems to overwrite the PurchaseItemModel in each iteration, which would mean only the last row is sent to the server.

  And also I think you are assigning purchaseModel to the tblPurchaseItem field of PurchaseItemModel, but it’s not being collected in the final purchaseModel object that’s sent via the AJAX request.
• EF

  Emmmanuel FIADUFE1y agoPosted Jan 18, 2025, 11:18 AM

  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);
          }
• EF

  Emmmanuel FIADUFE1y agoPosted Jan 17, 2025, 7:01 PM

  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.
• 

  Tuhin Paul1y agoPosted Jan 17, 2025, 6:19 PM

  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.
• EF

  Emmmanuel FIADUFE1y agoPosted Jan 17, 2025, 11:56 AM

  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 ?