values are not updating after clicking of save button

Question

Hi,I have 4 tables and one grid view in grid view we have one button edit after clicking of edit button it was displaying relavant values right now problem is after clciking of save functionality updated values are coming to controller fincally it was showing Order Success but values are not updated Could please any body help me i am facing this probelm since 15days 1) Orders(Parent table) 2)Items(Child table) 3)subitems Based upon OrderId it can display Item values and also Based upon Item Id it can display subitems I am using MVC Note:finally values are coming to debugging but not saved to database Kindly please help me

Piyush Pansuriya · Answer

As shown into your code, You didn't attach the object with dbContext. So, first you have to attach the object before save while updating existing record. else { Orders3 order = new Orders3(); order.OrderId = orders.OrderId; order.OrderName = orders.OrderName; order.OrderDate = orders.OrderDate; order.Description = orders.Description; db.Orders3.Attach(order); db.SaveChanges(); int orderId = order.OrderId; foreach (Item detail in orders.details) { Item item = detail; bool isItemExist = db.Items.Where(x => x.OrderId == orders.OrderId && x.Name==detail.Name).ToList().Count > 0 ? true : false ; if (!isItemExist) { // Add new Item to Item Table. db.Items.Add(item); db.SaveChanges(); } else { item.Name = detail.Name; item.OrderId = orders.OrderId; // Update existing Item to Item Table. db.Items.Attach(item); db.SaveChanges(); } put in your update code wherever.

Piyush Pansuriya · Answer

Which EntityFramework version you are using? For EntityFramework 5 & 6 using System.Data; using System.Data.Entity; add both library and for EntityFrameworkCore using Microsoft.EntityFrameworkCore; Than you can write as db.Entry(orders).State = EntityState.Modified;

Piyush Pansuriya · Answer

Hello, Use same object which you ger in parameter else { //Orders3 order = new Orders3(); //order.OrderId = orders.OrderId; //order.OrderName = orders.OrderName; //order.OrderDate = orders.OrderDate; //order.Description = orders.Description; db.Entry(orders).State = System.Data.EntityState.Modified; db.SaveChanges();

Piyush Pansuriya · Answer

Put this line before attach order.State = EntityState.Modified;

Mahesh Reddy · Answer

could you please share your mail on messages I have tried 2 times uploading zip file but not uploading

Mahesh Reddy · Answer

we have Orders,Items ,subitem and taxes we are populating taxes values from autoPopList table in that we are going to do some modifications At last afrer clciking of save button taxes values can be saved to subitem2(table) every thing is working fine Probelm is only updating values based upon OrderId for example Orderid=2 has only 2 items in further i am going to add n no of new Items finally that can be saved to database kindly please help me

Mahesh Reddy · Answer

I have done this task by using anjularjs and mvc If we ready i can send my entire code and just spend 10 minutes on that and then help me

Mahesh Reddy · Answer

we are using 4.5.2

Mahesh Reddy · Answer

https://ibb.co/4YsHLn9 getting error Like this Brother i can send you my entire code Pelase copy and paste it and then help me since 15 datys i am stuck at this work Kindly help me If you said Ok i can share you my code

Piyush Pansuriya · Answer

Use same as order for Items and subitems EntityFramework it self provides System.Data.EntityState

Mahesh Reddy · Answer

db.Entry(orders).State = System.Data.EntityState.Modified; db.SaveChanges(); whether we have insert this code only for orders what about Items ,subitems suggest me what is nuget package ,manager for System.Data.EntityState

Mahesh Reddy · Answer

Could you please i am getting error like this https://ibb.co/x6RJZR6

Mahesh Reddy · Answer

I have replaced with your code it was dsiplaying error like this https://ibb.co/Z8r0sQr

Mahesh Reddy · Answer

If Orderid =null Iwe have create new record or else if we have update values based upon OrderId Right now add is working fine values are updating to database but if we have toupdate some values based upon Orderid at that time values are not updating Could you please help me

Piyush Pansuriya · Answer

Hello, Please share your code..

values are not updating after clicking of save button

Answers (15)