Create the separate POCO request/response models for the json.

Question

Create the separate POCO request/response models for the json.

sblb 1,231

Hi, I try to implement the Foreign Key in my app to link several actions. So I defined the class model ActionItem with main table Developer.
I used to one-to-many relationship, which more appropriate.
When I run app the ActionItem is null and I have the status 404.
I wrote in other post and I received the answer that to solve and fix the issue I have to create the separate POCO request/response models for the json. I really need some advise to do that.

I will appreciate some help to fix the issue ? I know is the basic item but I really neeed to implement this foreign key.

I put directly the github link AppWebFK.

5 answers

Your answer

Answer 1

The problem is not creating a POCO. The problem is your Blazor client design does not submit a developerId with the ActionItem! The developerId is needed so you can add or edit an ActionItem. While I agree the Web API data interface should use POCOs not entities, it does not change the fact that a developerId - the foreign key - is needed to add the action item to the correct developer.

You really need to go through a few beginning level tutorials before moving forward.

POCO

    public class ActionItemPoco  
    {  
        public string? Tilte { get; set; }  
        public string? Description { get; set; }  
        public string? State { get; set; }  
        public DateTime? OpenDate { get; set; }  
        public DateTime? PlanDate { get; set; }  
        public DateTime? CloseDate { get; set; }  
  
        public int DeveloperId { get; set; }  
    }

Action

        // POST api/<ActionItemController>  
        [HttpPost]  
        public async Task<ActionResult<ActionItemPoco>> Post([FromBody] ActionItemPoco poco)  
        {  
            Developer? developer = await _context.Developers  
                .Include(a => a.ActionItems)  
                .FirstOrDefaultAsync(d => d.DeveloperId == poco.DeveloperId);  
  
            if (developer == null)  
            {  
                return NotFound();  
            }  
  
            ActionItem ac = new ActionItem()  
            {  
                ActionItemId = 0,  
                DeveloperId = poco.DeveloperId,  
                CloseDate = poco.CloseDate,  
                Description = poco.Description,  
                OpenDate = poco.OpenDate,  
                PlanDate = poco.PlanDate,  
                State = poco.State,  
                Tilte = poco.Tilte  
            };  
  
            developer.ActionItems.Add(ac);  
            await _context.SaveChangesAsync();  
  
            return CreatedAtAction(nameof(GetActionItem), new { id = ac.ActionItemId }, poco);  
        }

JSON

{  
  "actionItemId": 0,  
  "tilte": "Action Title 2",  
  "description": "Description 2",  
  "state": "State 2",  
  "openDate": "2022-11-18",  
  "planDate": "2022-11-18",  
  "closeDate": "2022-11-18",  
  "developerId": 1  
}

sblb 1,231 Reputation points

2022-12-13T06:20:18.587+00:00

I understood how to do class model with the foreign key.

The problem is your Blazor client design does not submit a developerId

I didn't see where I've made a mistak. Could you please advise how I can modify the client-sid. Thank sin advance
AgaveJoe 30,126 Reputation points

2022-12-13T12:32:11.507+00:00

I didn't see where I've made a mistak. Could you please advise how I can modify the client-sid. Thank sin advance

You have not made an update to the GitHub repo for 20 days. Clearly, you are not interested in fixing your own code.

Also, the code uses 3rd party Radzen components. Razden support is a better support option if you are having trouble understanding how the components work.
sblb 1,231 Reputation points

2022-12-13T13:32:15.917+00:00

Clearly, you are not interested in fixing your own code.

I am here to fix my problem

As you told me the problem is Blazor client design does not submit a developerId which is not related to the Radzen package.

As I told you I ddin't see how I can introduce the developerId in Edit.razor.
AgaveJoe 30,126 Reputation points

2022-12-13T15:12:03.893+00:00

As you told me the problem is Blazor client design does not submit a developerId which is not related to the Radzen package.

The Razden components display data from the database and accept user inputs. It seems to me the Radzen components are a key part.

As I told you I ddin't see how I can introduce the developerId in Edit.razor.

The code passes the developerId to the Edit.razor.

@page "/developer/edit/{developerId:int}"

If the developerId is empty then the problem is on the page that calls Edit.razor. Use the Visual Studio debugger to troubleshoot your code to find the bugs.

Answer 2

sblb 1,231

ben yes !!
in the @page "/developer/edit/{developerId:int}" I rendering the data from Developer class and in the same page I want to redering all ActionItem associate to DeveloperId.
In my case the DeveloperId is the Foreign Key that associate all items from ActionItems Class.

So I didn't see what I've to change in Edit.razor.

AgaveJoe 30,126

Your response is unclear. I'll assume you have the developerId parameter and are able to populate the ActionItem that belong to a developer using the developerId.

Simply populate the developerId in the POCO class you are using. An alternative is adding the developerId as a route parameter. This type of information been provided several times over many threads. It is not clear why you are unable to populate a type or route parameter in your Blazor code! This is a fundamental concept found in any beginning level tutorial.

Route parameter example

[HttpPost("{id}")]  
public async Task<ActionResult<ActionItemPoco>> Post(int id, [FromBody] ActionItemPoco poco)  
{  
    Developer? developer = await _context.Developers  
        .Include(a => a.ActionItems)  
        .FirstOrDefaultAsync(d => d.DeveloperId == id);  
  
    if (developer == null)  
    {  
        return NotFound();  
    }  
  
    ActionItem ac = new ActionItem()  
    {  
        ActionItemId = 0,  
        DeveloperId = id,  
        CloseDate = poco.CloseDate,  
        Description = poco.Description,  
        OpenDate = poco.OpenDate,  
        PlanDate = poco.PlanDate,  
        State = poco.State,  
        Tilte = poco.Tilte  
    };  
  
    developer.ActionItems.Add(ac);  
    await _context.SaveChangesAsync();  
  
    return CreatedAtAction(nameof(GetActionItem), new { id = ac.ActionItemId }, poco);  
}

sblb 1,231

in Edit.razor I initialize developeractions what is associate with FK DeveloperId

 protected async override Task OnParametersSetAsync()  
    {  
        dev = await http.GetFromJsonAsync<Developer>($"api/developer/{developerId}");  
        actionitems = await http.GetFromJsonAsync<ActionItem[]>("api/developeractions");  
    }

After that I populate Developer as below :

 async Task EditDeveloper()  
    {  
        await http.PutAsJsonAsync("api/developer", dev);  
        await http.GetAsync($"api/developer/GenearteEcoById/{developerId}");       
        await js.InvokeVoidAsync("alert", $"Updated Successfully!");  
        uriHelper.NavigateTo("developer");          
    }

And I tried to populate ACtionItem for each DEveloperId as below, and it's here where I ddin't see how I can do :

ActionItem act = new ActionItem();  
  
async Task CreateActionList()  
        {          
           await http.PostAsJsonAsync($"api/developeractions", act);        
          uriHelper.NavigateTo($"/developer/edit/{developerId}");  
        }

AgaveJoe 30,126 Reputation points

2022-12-13T20:31:10.447+00:00
And I tried to populate ACtionItem for each DEveloperId as below, and it's here where I ddin't see how I can do :

Assuming the "act" variable is populted by the Razden component, then all you have to do is set the developerId.

async Task CreateActionList() { act.DeveloperId = developerId; await http.PostAsJsonAsync($"api/developeractions", act); uriHelper.NavigateTo($"/developer/edit/{developerId}"); }

If the "act" properties are not populated then debug the Blazor application to figure out why. Again, Razden support is better option for help with Razden components.

More importantly, you have not updated the code base for 20 days. Either you're updating a local copy and the GitHub repo is out of sync or you've done nothing to troubleshoot the problem.

Answer 3

sblb 1,231

Yes the github wan't updated. I just updated github. I taken into accoiunt your last comment; I've always the same problem.

I remarks there is a problem with act in Edit.razor with the message :

Erreur (active)	CS1503	Argument 1 : conversion impossible de 'AppWeb.Shared.Models.ActionItem' en 'System.Collections.Generic.IEnumerable<AppWeb.Shared.Models.ActionItem>'

AppWeb.Client C:\App\sbd\AppWeb_v1\AppWeb\Client\Pages\Developer\Edit.razor 32

How I can fix this error?
I think that's not the main problem.

AgaveJoe 30,126 Reputation points

2022-12-14T16:41:53.297+00:00

Your latest question has nothing to do with the subject of this post!

The compiler error is very clear. The code tries to assign an ActionItem to a collection of ActionItems (IEnumerable<ActionItem>).

How I can fix this error?

Learn C# types and collections.
sblb 1,231 Reputation points

2022-12-18T10:45:43.29+00:00

Hi, I solve the last issue. It was the definition of act.

To create an action with act I defined : ActionItem act = new ActionItem();
To display ActionItem I've created action as : ActionItem[]? action { get; set; }

I updated my app in github. I follow up your last recommendation to create an actions with FK; it wasn't created.

Answer 4

sblb 1,231

Now, in action table I found teh data from Developer. Really I don't understand!!

@Aidan Wick {

    [Parameter] public int developerId { get; set; }  
    [Parameter] public int ActionId { get; set; }   
  
    Developer dev = new Developer();  
  
    ActionItem[]? action { get; set; }  
      
    ActionItem act = new ActionItem();  
  
    RadzenDataGrid<ActionItem>? gridaction;  
         
     
    protected async override Task OnParametersSetAsync()  
    {  
        dev = await http.GetFromJsonAsync<Developer>($"api/developer/{developerId}");  
        
    }  
  
    async Task EditDeveloper()  
    {  
        await http.PutAsJsonAsync("api/developer", dev);  
        await http.GetAsync($"api/developer/GenearteEcoById/{developerId}");       
        await js.InvokeVoidAsync("alert", $"Updated Successfully!");  
        uriHelper.NavigateTo("developer");          
    }    
  
     protected override async Task OnInitializedAsync()  
    {  
       action = await http.GetFromJsonAsync<ActionItem[]>("api/developeractions");  
    }        
  
    async Task CreateActionList()  
    {          
     act.DeveloperId =  developerId;      
     await http.PutAsJsonAsync($"api/developeractions", act);        
     uriHelper.NavigateTo($"/developer/edit/{developerId}");  
    }  
  
..  
}

Act is well populate but it's not rendering

AgaveJoe 30,126 Reputation points

2022-12-18T16:01:07.99+00:00

Really I don't understand!!

It is clear that you do not understand. The problem is you're making no effort to learn the basics. When you're given working example code you are unable to integrate the code into your project. You can only copy and paste code. I think the best course of action is either hiring a developer to write the code according to your specifications or making an actual effort to learn basic asp.net Core skills.

Keep in mind, you are using 3rd party Razden components and this is not a Radzen support forum. If you Razden components are not populating/binding to your newly created POCOs, then contact Razden support for assistance.

Out of curiosity, have you actually updated your project to include POCOs - the subject of this post???
sblb 1,231 Reputation points

2022-12-18T17:25:03.18+00:00

have you actually updated your project to include POCOs - the subject of this post???

Yes I've updated my to implement the poco that you propose. See my github

Do you see what is the problem?
AgaveJoe 30,126 Reputation points

2022-12-18T17:59:19.983+00:00

Yes I've updated my to implement the poco that you propose. See my github

I reviewed your code and the code does NOT implement POCOs.

Do you see what is the problem?

Yes. The Web API design implements an entity parameter not a POCO. The main problem is your understanding. I'm not sure how anyone can help you.
sblb 1,231 Reputation points

2022-12-18T18:08:28.75+00:00

I forgot to update The Controller. I just did

Do you see what is the problem?
AgaveJoe 30,126 Reputation points

2022-12-18T19:17:55.807+00:00

I forgot to update The Controller.

You asked me to review old code?

Do you see what is the problem?

Yes. You have no idea what you're doing and you don't care if you waste community member's time. I can't help you.
sblb 1,231 Reputation points

2022-12-18T19:33:08.813+00:00

Thanks anyway

Yes.

It will be great if you can give the way to follow !!

Answer 5

sblb 1,231

If you have the solution it will be great if you can tell me how I can fix my problem?
Really it will be great !!

Share via

Create the separate POCO request/response models for the json.

5 answers

Your answer