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

Question

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?

Sachin Singh · 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 Vasile · Answer

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 Vasile · Answer

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 Vasile · Answer

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 Vasile · Answer

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 Singh · Answer

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 Vasile · Answer

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 Singh · Answer

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();

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

Answers (8)