asp.net core razor pages. add an input value to two different tables

Marius Vasile

5y1.3k.NET

I have a form with one input but I want to save the data to two different tables

for="PTWHandover.StartDateNew" class="form-control" style="background-color:aqua" />
for="PTWContent.StartDate" />

What should add to hidden input to have it performing the add?

8 Replies

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

Sachin Singh5y ago
Accepted answer
sir why do you need hidden field at the first place
can't assign the value in page model
PTWContenet.StartDate=PTWHandover.StartDateNew; //
//where PTWHandover is object
Marius Vasile5y ago
working code
var newPTW = await _context.PTWContents.FindAsync(ptwId);
                newPTW.StartDate = newH.StartDateNew;
                newPTW.EndDate = newH.EndDateNew;
                newPTW.Issuer = newH.IssuerNew;
                newPTW.Receiver = newH.ReceiverNew;// so this becomes null? i haven't try this

                await _context.SaveChangesAsync();
Marius Vasile5y ago
I tried
var newPTW = await _context.PTWContents.FindAsync(ptwId);

                PTWContent.StartDate = PTWHandover.StartDateNew;
                PTWContent.EndDate = PTWHandover.EndDateNew;
                PTWContent.Issuer = PTWHandover.IssuerNew;
                PTWContent.Receiver = PTWHandover.ReceiverNew;

                    await _context.SaveChangesAsync();
but it gave me error
Marius Vasile5y ago
this is my update procedure
var newPTW = await _context.PTWContents.FindAsync(ptwId);

                if (await TryUpdateModelAsync(newPTW, "PTWContent",
                        a => a.StartDate,
                        a => a.EndDate,
                        a => a.Issuer,
                        a => a.Receiver
                    ))
                {
                    await _context.SaveChangesAsync();
                    return RedirectToPage("PTWForm", "PTWNoId", new { ptwNoId = newPTW.PTWNo });
                }
yes,  PTWContenet.StartDate=PTWHandover.StartDateNew; and PTWContenet.EndDate=PTWHandover.EndDateNew;
Marius Vasile5y ago
so how it should look like? because
for="PTWHandover.StartDateNew" class="form-control" style="background-color:aqua" />
for="PTWContent.StartDate" />
doesn't work
the hidden value should be the same as the one above but how to?
Sachin Singh5y ago
sir , the value doesn't lost untill the whole method gets executed so if you have one method or even two method one wraps inside other then you can use the same value n number of times.
Marius Vasile5y ago
I am doing an add to one table and update for second using the same value of a text input. I know how to add and update, but how do I pass the input value twice? It might be a silly question but I don't see the resolve right now
Sachin Singh5y ago
sir
what's the problem to save the same value to two different table?
or have you two different values, please clearify, cause... if you have to add same value to two tables then there should not be any issue.
table1 tab1Obj=new table1();
table1Obj.someField=value;
_Context.table1.Add(tab1Obj);
_Context.SaveChanges();

table2 table2Obj=new table2();
table2Obj.someField=value;
_Context.table2.Add(table2Obj);
_Context.SaveChanges();