Creating a record in one table will update an existing record in another table ASP.NET core MVC

See more:

C#

ASP.NET

MVC

so I am new to asp.net core mvc and I wanted to know how to create a new record in one table and update an existing record in another table for example I have two tables Asset Master and Assigning Asset so when creating a record in Assigning Asset with employee name (eg.Hana) and asset code (eg. Lap001) it should search in Asset Master Table if the asset code exist update employee name if not throw error I have searched for the solution but couldn't find the answer

What I have tried:

p

ublic class AssigningAssetModel
    {
        [Key]
        public int ID { get; set; }

        [Required(ErrorMessage = "Enter Employee Name")]
        public string Employee Name{ get; set; }

        [Required(ErrorMessage = "Enter AssetCode")]
        public string AssetCode { get; set; }
    }


public class AssetMasterModel
{
        [Key]
        public int ID { get ;set; }

        public string AssetCode { get; set; }

        [Required]
        public string EmployeeName{ get; set; }
}


AssigningAssetController

[HttpPost]
[ValidateAntiForgeryToken]
public async Task<iactionresult> Create(int id[Bind("ID,EmployeeName,AssetCode")] AssigningAssetModel assigningAssetModel)
        {
            if (id != assigningAssetModel.ID)
            {
                return NotFound();
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(assigningAssetModel);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!AssigningAssetModelExists(assigningAssetModel.ID))
                    {
                        return NotFound();
                    }
                    else
                    {
                        throw;
                    }
                }
                return RedirectToAction(nameof(Index));
            }
            return View(assigningAssetModel);
        }

How to pass AssetCode here so i can update the existing record in Asset Master Table
note that if the asset code is not found it should not create new record in asset master table