Can not add new Record in Grid

Question

Re: Can not add new Record in Grid via Dialog or Inline.

Am porting an existing ASP .Net Core Spplication

When I click the Button to Save nothing happens.

The Grid is Scaffolded from Syncfusion tool and works as designed except for the ability to add new Record

Model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace MyToolsSync03.Models
{
public class AcctCusts

{
private DateTime _created;

public AcctCusts()

{ }

[Key]
public int AcctCustId { get; set; }
public string AcctName { get; set; }
public string BusinessSec { get; set; }
public string Regulatory { get; set; }

// ******** Start Section - Date and Time Calculations - Created Da private DateTime _created = DateTime.MinValue;

[Display(Name = "Created On")]
[DataType(DataType.DateTime)]
[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
public DateTime Created
{
get
{
return (_created == DateTime.MinValue) ? DateTime.Now : _created;
}
set { _created = value; }
}
// ********Date and Time Calculations - Created

// public DateTime ValidToDate { get; set; }
public string Address1 { get; set; }
public string Address2 { get; set; }
public string City { get; set; }
public string State { get; set; }
public string Country { get; set; }
public string Contact1Name { get; set; }
public string Contact1Phone { get; set; }
public string Contact1Email { get; set; }
public string Contact2Name { get; set; }
public string Contact2Phone { get; set; }
public string Contact2Email { get; set; }
public string WbSiteURL { get; set; }
public string CreatedBy { get; set; }
// public string CreteDate { get; set; }
public string ModifyDate { get; set; }

}
}

Controller
using Syncfusion.EJ2.Base;
using System.Collections;
using Microsoft.EntityFrameworkCore;
using System.Linq;
using Microsoft.AspNetCore.Mvc;
using MyToolsSync03.Models;
using MyToolsSync03.Data;
namespace MyToolsSync03.Controllers
{
public class AcctCustsController : Controller
{
private MyToolsSync03DBContext _context;

public AcctCustsController(MyToolsSync03DBContext Context)
{
this._context=Context;
}
public ActionResult Index()
{
return View();
}
public ActionResult UrlDatasource([FromBody]DataManagerRequest dm)
{

IEnumerable DataSource = _context.AcctCusts.ToList();

DataOperations operation = new DataOperations();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = operation.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = operation.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast().Count();
if (dm.Skip != 0)//Paging
{
DataSource = operation.PerformSkip(DataSource, dm.Skip);
}
if (dm.Take != 0)
{
DataSource = operation.PerformTake(DataSource, dm.Take);
}
return Json(new { result = DataSource, count = count });
}
public ActionResult Insert([FromBody]CRUDModel value)
{
//do stuff
_context.AcctCusts.Add(value.Value);
_context.SaveChanges();
return Json(value);

}
public ActionResult Update([FromBody]CRUDModel value)
{
//do stuff
var ord = value;

AcctCusts val = _context.AcctCusts.Where(or => or.AcctCustId == ord.Value.AcctCustId).FirstOrDefault();
val.AcctCustId=ord.Value.AcctCustId;
val.AcctName=ord.Value.AcctName;
val.BusinessSec=ord.Value.BusinessSec;
val.Regulatory=ord.Value.Regulatory;
val.Created=ord.Value.Created;
val.Address1=ord.Value.Address1;
val.Address2=ord.Value.Address2;
val.City=ord.Value.City;
val.State=ord.Value.State;
val.Country=ord.Value.Country;
val.Contact1Name=ord.Value.Contact1Name;
val.Contact1Phone=ord.Value.Contact1Phone;
val.Contact1Email=ord.Value.Contact1Email;
val.Contact2Name=ord.Value.Contact2Name;
val.Contact2Phone=ord.Value.Contact2Phone;
val.Contact2Email=ord.Value.Contact2Email;
val.WbSiteURL=ord.Value.WbSiteURL;
val.CreatedBy=ord.Value.CreatedBy;
val.ModifyDate=ord.Value.ModifyDate;
_context.SaveChanges();
return Json(value);
}
public ActionResult Delete([FromBody]CRUDModel value)
{
//do stuff
AcctCusts order = _context.AcctCusts.Where(c => c.AcctCustId == (int)value.Key).FirstOrDefault();
_context.AcctCusts.Remove(order);
_context.SaveChanges();
return Json(order);
}
}
}

View

L. · Answer

View

ACCOUNTS

@*

*@ @**@

@**@

@**@@section Scripts{ }

Balaji Sekar · Answer

Hi Customer, 
 
Greetings from the Syncfusion support. 
 
Before proceeding with your query, we need additional information about the mentioned query, so please share with us the details below that will help validate further. 
 

Share the screenshot of Network tab while perform the insert action.
Bind actionFailure event if its triggered then share the arguments details.
Share the video demonstration of the problem.
Ensure the Syncfusion Essential Studio version.
 
Regards, 
Balaji Sekar

L. · Answer

I am attaching a Video as requestedThere are no Errors being thrown.Attachment: Syncfusion157201_215058d9.7z

Balaji Sekar · Answer

Hi Customer,  
 
Thanks for your update. 
 
We have watched your video as well as we suspect that insert method (AcctCusts.cs) has comments on you. Please ensure that such a method is invoked or not, when the insert action of the Grid is being performed. 
 
In our previous update, we have requested the screenshot of network tab when perform the insert action and bind actionFailure event if it is triggered then share the arguments details 

Please share the above requested details regarding your query it will be helpful for us to provide a better solution as soon as possible. 
 
Regards, 
Balaji Sekar

L. · Answer

I am not sure what you mean by Network Tab but I ran in Debug Mode in Visual Studio and now am getting a SystemReferenceException Null Value Error and the only thin I can think of that is Null is the ID Field.

System.NullReferenceException
HResult=0x80004003
Message=Object reference not set to an instance of an object. Source=XfessToolsSync03
StackTrace:
at XfessToolsSync03.Controllers.AcctCustsController.Insert(CRUDModel`1 value) in C:\Users\L\source\Repos\XfessToolsSync03\Controllers\AcctCustsController.cs:line 54

Attaching Image

L. · Answer

Visual Studio Image attachedAttachment: AcctCust_Null_Reference20200820_100837_44cbc035.7z

Balaji Sekar · Answer

Hi Customer,  
  
We have created a new incident under your Direct trac account to follow up with this query. We suggest you to follow up with the incident for further updates. Please log in using the below link.     

https://www.syncfusion.com/account/login  
  
Regards,  
Balaji Sekar