values are not updating after clicking of save button

Mahesh Reddy

7y885Learn iOS Programming

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

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya7y ago
Accepted 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.
+1
Mahesh Reddy7y ago
could you please share your mail on messages
I have tried 2 times uploading zip file
but not uploading
0
Mahesh Reddy7y ago
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
0
Mahesh Reddy7y ago
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
0
Mahesh Reddy7y ago
we are using 4.5.2
0
Piyush Pansuriya7y ago
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;
0
Mahesh Reddy7y ago
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
0
Piyush Pansuriya7y ago
Use same as order for Items and subitems

EntityFramework it self provides System.Data.EntityState
0
Mahesh Reddy7y ago
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
0
Piyush Pansuriya7y ago
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();
0
Mahesh Reddy7y ago
Could you please i am getting error like this
https://ibb.co/x6RJZR6
0
Piyush Pansuriya7y ago
Put this line before attach

order.State = EntityState.Modified;
0
Mahesh Reddy7y ago
I have replaced with your code
it was dsiplaying error like this
https://ibb.co/Z8r0sQr
0
Mahesh Reddy7y ago
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
0
Piyush Pansuriya7y ago
Hello,
Please share your code..
0