I have a crud page setup with main, add and edit pages. In the add and edit page, after I access the main table (called Deals), I also access another table (called DealSummary) Adding the records (both Deal and DealSummary} is not a problem. I am having an issue with the Form Submit on the Edit page
Since the Form Submit on the edit updates using a close dialog with result it doesn't allow me to update 2 tables.
can someone please tell me how to update DealSummary records?
Hello,
Instead of execute c# use Invoke datasource option and use updateDealSummary method and pass result as parameter to it
Ok, i tried that, both immediately after the getDealSummaries and in the Form Submit
I get the same error each time, so I am missing something.
error CS7036: There is no argument given that corresponds to the required formal parameter 'dealSummary' of 'SmgDataService.UpdateDealSummary(int?, DealSummary)' [c:\smg\server\Smg.csproj]
Your result should be of type DealSummary.
I "invoke data source method" getDealSummaries
I use the filter query to set the filter to StoreNumber(Summary_StoreNo) equals Deals.Deal_StoreNo AND Deal Number (Summary_DMSID} = Deals.Deal_DMSID AND Fit (Summary_Fit} Starts With Deal.Deal_Fit1
I then set property get getDealSummariesResult1 to ${result}
I then execute c#
${result.FirstOrDefault().Summary_Fit}=${deal.Deal_Fit1} ... this may be wrong
I the invoke data source method updateDealSummary and set the first parameter to DealSummary with a value of ${result}
when I try to run it, i get the error
error CS7036: There is no argument given that corresponds to the required formal parameter 'dealSummary' of 'SmgDataService.UpdateDealSummary(int?, DealSummary)' [c:\smg\server\Smg.csproj]
So must be missing something, looks like a parameter of some kind...
Really not a clue. It was very easy to set this up in the Add Deal page as I was adding new, but this part is beyond my knowledge
the filter query filters down to the one record I want to make a change to.
As the compiler suggest you are missing a method argument for the id parameter. It is usually the ID of your entity (DealSummary).
Thank you, I set the summary_ID in the page load event, the in the Save Button "click" event I used invoke datasource method using getDealSummaryBySummaryID with a ${result} value named dealsummary.
It then let me set up the updateDealSummary correctly. My mistake, in the end, was using the getDealSummaries invoke datasource method instead of getDealSummaryBySummaryID. Your help with the Summary_ID put me on the right track. Thank You!!!
