My solution name is; PersonnelEFCoreApp.

My project name is Personnel.EFCore.UI$.$

I am adding a Class Library named Personnel.EFCore.Domain. There are classes such as personnel, personneldetails, address, gender, department.

$//$ STAFF

usingsystem;

using System.Collections.Generic;

using System.Ling;

using System.Text;

using System.Threading.Tasks;

namespace Personnel.EFCore.Domain

$\{\{$public string FirstName $\{$ get; set; $\}$public string IdentityNumber $\{$ get; set; $\}$public int GenderID $\{$ get; set; $\}$public bool IsActive $\{$ get; set; $\}//$there will be a one to one relationship$\}$

$\}$ First, Windows Form Application will open.

My solution name is; PersonnelEFCoreApp.

My project name is Personnel.EFCore.UI$.$

I am adding a Class Library named Personnel.EFCore.Domain. There are classes such as personnel, personneldetails, address, gender, department.

$//$ STAFF

usingSystem;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Personnel.EFCore.Domain

$\{$

public class Personnel

$\{$

public int PersonnelID $\{$ get; set; $\}$

public string FirstName $\{$ get; set; $\}$

public string LastName $\{$ get; set; $\}$

public string IdentityNumber $\{$ get; set; $\}$

public DateTime? BirthDate $\{$ get; set; $\}$

public int GenderID $\{$ get; set; $\}$

public int DepartmentID $\{$ get; set; $\}$

public bool IsActive $\{$ get; set; $\}$

public string FullName $=>$ $$"\{$FirstName$\}\{$LastName$\}"$;

$//$there will be a one to one relationship

public PersonnelDetail PersonnelDetail $\{$ get; set; $\}$

$\}$

$\}$

$//$ PERSONNEL DETAIL

usingSystem;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Personnel.EFCore.Domain

$\{$

public class PersonnelDetail

$\{$

public int PersonnelDetailID $\{$ get; set; $\}$

public int PersonnelID $\{$ get; set; $\}$

public Personnel Personnel $\{$ get; set; $\}$

public string Email $\{$ get; set; $\}$

public string Phone $\{$ get; set; $\}$

public string Address $\{$ get; set; $\}$

$\}$

$\}$ like..

We will perform mapping operations with Fluent API. We will use DBSet, Dbcontext. After performing these operations in the business and data layers, we will send the data to MSSQL with the connection string. With the forms added to Personnel.EFCore.UI$,$ we will first view the personnel in the data grid view. Then, we will bring the information to the user with the form and the data grid view. We will create forms in which we will update, delete and filter personnel information and add new personnel. We can do this filtering by name, id$,$ etc. In summary, we will create a Windows form application and use a $3-$layer architecture to allow the user to add, delete, update and filter operations through the form.

Here, I wanted you to create address, gender and department classes and make appropriate mappings for them. Apart from the information I bring from the form with the datagrid view, I want you to write a code that explains in detail how to perform operations such as AddPersonelForm, UpdatePersonel, DeletePersonel, and FilterPersonel, and which button, which textbox, and which event to put.