Empty values on grid update with RemoteSaveAdaptor

Controller:

ViewBag.dsRacuni = model.ToArray();

View:

Thanks!

Bernard.

Hi Bernard, 

 

Thanks for contacting Syncfusion support. 

 

We have analyzed the screenshot and the codes you have shared with us. We could see that you have not handled CRUD model class. You need to define CRUDModel(as generic) like below code example. Please find the below code example and sample for your reference. 

 

 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/RemoteSaveAdaptor1019811572 

 

Please refer the screenshot below, 

 

 

 

Please get back to us if you need further assistance. 

 

Regards, 

Pavithra S. 

I guess that would be also the answer for my latest post about empty update with urladaptor?

Regards,

Bernard.

Update is now working fine, when I used CRUDModel definition.

I added the code for generating random number for it like this

and when I post it to the controller, I see the generated number

But still the value in the controller is null

I tried to set isIdentity="true" the the RacunId column, but it's the same results.

Any help?

Thanks.

Bernard.

Hi Bernard, 

  

We have validated your query and we suspect that the cause of the issue might be the type mismatch while setting the primary key manually. We can see that the primary key value is Whole number but you are setting a decimal Random value so in server you are receiving the null value. So We suggest you to set a whole number for the primary key column in your application. We have prepared a simple sample with RemoteSaveAdaptor with Insert operation in EJ2 Grid. Please refer the following code example and sample for more information. 

 

[Code example] 

[index.cshtml]     <ejs-grid id="Grid" toolbar="@(new List<string>() { "Add","Delete","Update", "Cancel" })" allowPaging="true" actionBegin="onActionBegin" actionComplete="onActionComplete">          <e-data-manager  json ="@ViewBag.datasource" adaptor="RemoteSaveAdaptor" updateUrl="Home/Update" insertUrl="Home/Insert" ></e-data-manager>          <e-grid-editSettings allowDeleting="true" allowEditing="true" allowAdding="true"></e-grid-editSettings>          <e-grid-columns>              <e-grid-column field="OrderID" headerText="Order ID" isPrimaryKey="true" validationRules="@(new { required=true})" textAlign="Right" width="120"></e-grid-column>               .   .   .  .           </e-grid-columns>      </ejs-grid>  </div>

 

 

[HomeController.cs]    public ActionResult Insert([FromBody]CRUDModel<OrdersDetails> value)          {                        OrdersDetails.GetAllRecords().Add(value.value);                   return Json(value.value);        }

 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/RemoteSaveAdaptor-12312018-322191802.zip 

 

Please refer the below screenshot: 

 

 

Please get back to us, if you need further assistance, 

 

Regards, 

Pavithra S. 

Thank you for your answer. So, do I need to assign some value to identity primary key before saving?

The same solution like this I'm using in my ej1 mvc project, and grid is saving my data correctly with that random decimal number.

You have maybe some example with identity primary key?

Thanks.

Regards, Bernard.

Hi Bernard, 

 

We have achieved your requirement “Need to assign a decimal number in primary key value” using ActionBegin event of Grid component. We suggest you to set the primary key column type in server side while defining the field property. Please refer below code example and sample for more information. 

 

[index.cshtml]    <ejs-grid id="Grid" toolbar="@(new List<string>() { "Add","Delete","Update", "Cancel" })" allowPaging="true" actionBegin="onActionBegin" actionComplete="onActionComplete">          <e-data-manager  json ="@ViewBag.datasource" adaptor="RemoteSaveAdaptor" updateUrl="Home/Update" insertUrl="Home/Insert" ></e-data-manager>          <e-grid-editSettings allowDeleting="true" allowEditing="true" allowAdding="true"></e-grid-editSettings>          <e-grid-columns>              <e-grid-column field="OrderID" headerText="Order ID" isPrimaryKey="true" textAlign="Right" width="120" isIdentity="true"></e-grid-column>              .  .  .  .             <e-grid-column field="ShipCountry" headerText="Ship Country" width="150"></e-grid-column>          </e-grid-columns>      </ejs-grid>  </div>  <script>      function onActionBegin(args){             if (args.requestType === 'save' && args.action ==='add') {              args.data['OrderID'] = Math.random(); // Add a random value to primary key field          }      }

 

 

[HomeController.cs] 

 

public class OrdersDetails      {          public static List<OrdersDetails> order = new List<OrdersDetails>();          public OrdersDetails()              {                }              public OrdersDetails(decimal OrderID, string CustomerId, int EmployeeId, double Freight, bool Verified, DateTime OrderDate, string ShipCity, string ShipName, string ShipCountry, DateTime ShippedDate, string ShipAddress)              {              .  .  .  .                 public decimal? OrderID { get; set; }              public string CustomerID { get; set; }              public int? EmployeeID { get; set; }              .  .  .         }

 

 

Note: While enabling the IsIdentity property in a primary key column, then it should be handled in client or server side while inserting records to Grid. If corresponding data source has isIdentity field then it will automatically handle the Is Identity value while adding the record.  

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/RemoteSaveAdaptor-02012019-985797935.zip 

 

Help documentation:  https://ej2.syncfusion.com/documentation/api/grid#actionbegin 

 

Please get back to us, if you need further assistance, 

 

Regards, 

Pavithra S. 

  

 

and thank you for the answer. But, how can I change property from my RacunId field to decimal if it is integer type and autoincrement identity in the sql server database?

Is there then some way to assing new values for the inserted rows in the grid on the client side other than decimal? Because I'm using Math.Random() function.

I tried to avoid all of this by saving all the rows from the grid one by one after my master model is saved, on submit button.

Maybe there is some other and easier way to do this, but all I'm doing is that I'm sending datasource from the grid back to the controller over post action and then I'm checking for the RacunId values smaller than 1 and convert them to negative integer values in a row (-1, -2, -3...). After that I check existing values in the database for all the rows, and if row exists, I update its values. If row don't exists, I create a new row from received values.

My controller, model and view files are in attachment.

I would be grateful for some comment on this.

Thanks!

Regards,

Bernard.

Hi Bernard, 

 

Thanks for you provided sample code as it is helpful to resolve your requirements and we have checked your query and achieved your requirement with your code. 

 

Query #1: how can I change property from my RacunId field to decimal if it is integer type and autoincrement identity in the sql server database? 

 

If we bound the Grid data source using SQL table, we can enable the Auto increment column while table designing time. Please refer to the following online forum for more information, 

 

https://stackoverflow.com/questions/3359170/auto-increment-primary-key-in-sql-tables  

 

Query #2: Is there then some way to assigning new values for the inserted rows in the grid on the client side other than decimal? Because I'm using Math.Random() function. 

 

Yes, We have achieved your query and we suggest to you use following code example to handle the whole number conversion from “Math.Random” method. 

 

Query #3: How can I avoid all of this by saving all the rows from the grid one by one after my master model is saved, on submit button. 

 

As per your requirement,  we have achieved your requirement by using the save action in ‘actionBegin’ event. It is generating the random value to primary field for new records alone not for existing records. Please refer to the below code example for better assistance.  

 

Query 4#:  I'm sending datasource from the grid back to the controller over post action and then I'm checking for the RacunId(primary key field) values smaller than 1 and convert them to negative integer values in a row (-1, -2, -3...) 

 

We have validated you query and you can achieve your requirement by using the below code example. Please refer the below code sample and sample for more information. 

 

 

Sample link: http://www.syncfusion.com/downloads/support/forum/141654/ze/RemoteSaveAdaptor-02012019-1235078216.zip 

 

Please get back to us, if you need further assistance. 

 

Regards, 

Pavithra S. 

that was really helpful. All of you here on the forum are doing really good job by helping us.

Thanks once again.

Regards,

Bernard.

Hi Bernard, 

 

Thanks for your update. 

 

We are happy to hear that the provided information helps you. 

 

Please contact us if you need any further assistance. 

 

Regards, 

Pavithra S.