Need help creating new child record with foreign key of paren

alcam1965 — Fri, 02 Sep 2022 09:32:48 +0000

I'm building a CRUD Application to manage my company's back end and having issues with creating a new child record for a parent. The standard auto-generated controller based on the model is set up to create a new record but not a new child record so I need to modify the controller and or the models. The models involved are: Bundle.cs and Agreement.cs:

using System;
using System.Collections.Generic;

namespace AdminPortal.Models
{
    public partial class Bundle
    {
        public int Id { get; set; }
        public DateTime StartUtc { get; set; }
        public DateTime EndUtc { get; set; }
        public int Quantity { get; set; }
        public int? AgreementId { get; set; }
        public decimal? BundlePrice { get; set; }

        public virtual Agreement? Agreement { get; set; }
    }
}

using System;
using System.Collections.Generic;

namespace AdminPortal.Models
{
    public partial class Agreement
    {
        public Agreement()
        {
            AgreementAmendments = new HashSet<AgreementAmendment>();
            Bundles = new HashSet<Bundle>();
            Invoices = new HashSet<Invoice>();
        }

        public int Id { get; set; }
        public int OrgId { get; set; }
        public string? AgreementNumber { get; set; }
        public string? IrespondReference { get; set; }
        public string? DocumentLink { get; set; }

        public virtual Organization Org { get; set; } = null!;
        public virtual ICollection<AgreementAmendment> AgreementAmendments { get; set; }
        public virtual ICollection<Bundle> Bundles { get; set; }
        public virtual ICollection<Invoice> Invoices { get; set; }
    }
}

This is the create method in the Controller

[HttpPost]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> Create([Bind("Id,StartUtc,EndUtc,Quantity,AgreementId,BundlePrice")] Bundle bundle)
        {
            if (ModelState.IsValid)
            {
                _context.Add(bundle);
                await _context.SaveChangesAsync();
                return RedirectToAction(nameof(Index));
            }
            return View(bundle);
        }

I'm new to EF Core so don't even know where to start.

React Table not loading data

alcam1965 — Tue, 09 Aug 2022 14:00:45 +0000

First post here so thanks in advance to any kind folk out there who can help me. I'm working on a CRUD app using PERN stack and I'm having an issue with an edit form which is supposed to inherit the data from the row selected in an organization table. The component code is as follows:
`import React, { useState, useContext, useEffect } from "react";
import { useParams, useNavigate } from "react-router-dom";
import { AppContext } from '../context/AppContext';
import AdminPortal from '../apis/AdminPortal'

const OrganizationUpdateForm = (props) => {
const {id} = useParams()
const [name, setName] = useState("");
const [shortName, setShortName] = useState("");
const [parentOrg, setParentOrg] = useState("");
const [website, setWebsite] = useState("");
const [comments, setComments] = useState("");

useEffect(() => {
async function fetchData () {
const response = await AdminPortal.get(organizations/${id});
console.log(response.data.data);
setName(response.data.data.organizations.name);
setShortName(response.data.data.organizations.short_name);
setParentOrg(response.data.data.organizations.parent_org);
setWebsite(response.data.data.organizations.website);
setComments(response.data.data.organizations.comments);
};

fetchData();

}, []);

return (

Name
value={name}
onChange={(e) => setName(e.target.value)}
id="name"
className="form-control"
type="text"
/>

Short Name
value={shortName}
onChange={(e) => setShortName(e.target.value)}
id="short_name"
className="form-control"
type="text"
/>

Parent Organization
value={parentOrg}
onChange={(e) => setParentOrg(e.target.value)}
id="parent_org"
className="form-control"
type="text"
/>

Website
value={website}
onChange={(e) => setWebsite(e.target.value)}
id="website"
className="form-control"
type="text"
/>

Comments
value={comments}
onChange={(e) => setComments(e.target.value)}
id="name"
className="form-control"
type="text"
/>

{/* type="submit"
onClick={handleSubmit}
className="btn btn-primary"
>
Submit
*/}

</div>

)
}

export default OrganizationUpdateForm

`
I get the correct response when I hit the API from Postman and the browser creates the correct URL but I am getting the following error: "A component is changing a controlled input to be uncontrolled. This is likely caused by the value changing from a defined to undefined, which should not happen. Decide between using a controlled or uncontrolled input element for the lifetime of the component." After extensive Googling I haven't been able to find a solution so I'm hoping someone here can take a quick look and be able to figure out what I am doing wrong. Thanks in advance.

DEV Community: alcam1965

Need help creating new child record with foreign key of paren

React Table not loading data