---

---

CRUD

You are required to produce a solution that implements a CRUD using MVC methodologies for the entity Trainers.

Requirements

You need to submit all the produced files in a zip file named by your_name_individual_partb.zip

• Create Trainer [20marks]

• Read Trainer details [20marks]

• Update Trainer details [20marks]

• Delete Trainer [20marks]

• Use of MVC technologies [20marks]

---

📋Table of contents

• CRUD
• ApplicationDatabase
  • ApplicationContext
• Migrations
  • Configurations
• Models
  • Assignment
  • Course
  • Trainer
  • Student
• Interfaces
  • IPerson
• Repositories
  • AssignmentRepository
  • CourseRepository
  • TrainerRepository
  • StudentRepository
• Views
• TrainerView
  • Create
  • Read
  • Edit
  • Delete
• CourseView
  • Create
  • Read
  • Edit
  • Delete
• StudentView
  • Create
  • Read
  • Edit
  • Delete
• AssignmentView
  • Create
  • Read
  • Edit
  • Delete
• Controllers
• Installation
• Technologies and Tools

---

ApplicationDatabase

ApplicationContext

---

Migrations

Configurations

---

Model

Trainer

Type	Properties	Methods	Required	Min	Max
int	ID	get, set	☑️	1	no-limit
string	FirstName	get, set	☑️	10	50
string	LastName	get, set	☑️	10	50
string	PhoneNumber	get, set	☑️	10	20
int	Salary	get, set	☑️	1000	3000

Validation Error Messages

ErrorMessageCode	ErrorMessage
int	ID
string	FirstName
string	LastName
string	PhoneNumber
int	Salary

🔙🏠

Student

Type	Properties	Methods	Required	Min	Max
int	ID	get, set	☑️	1	no-limit
string	FirstName	get, set	☑️	10	50
string	LastName	get, set	☑️	10	50
string	PhoneNumber	get, set	☑️	10	20
int	Salary	get, set	☑️	1000	3000

Validation Error Messages

ErrorMessageCode	ErrorMessage
int	ID
string	FirstName
string	LastName
string	PhoneNumber
int	Salary

Course

Type	Properties	Methods	Required	Min	Max
int	ID	get, set	☑️	1	no-limit
string	Title	get, set	☑️	10	50
string	Description	get, set	☑️	10	50
int	Duration	get, set	☑️	10	50
DateTime	StarDate	get, set	☑️	10	50
string	Catergory	get, set	☑️	10	20
List Trainer	Trainers	get,set	☑️	1	no-limit

Validation Error Messages

ErrorMessageCode	ErrorMessage
int	ID
string	FirstName
string	LastName
string	PhoneNumber
int	Salary

🔙🏠

Assignment

Type	Properties	Methods	Required	Min	Max
int	ID	get, set	☑️	1	no-limit
string	FirstName	get, set	☑️	10	50
string	LastName	get, set	☑️	10	50
string	PhoneNumber	get, set	☑️	10	20
int	Salary	get, set	☑️	1000	3000

Validation Error Messages

ErrorMessageCode	ErrorMessage
int	ID
string	FirstName
string	LastName
string	PhoneNumber
int	Salary

🔙🏠

---

Interfaces

IPerson

Type	Properties	Methods
int	ID	get, set
string	FirstName	get, set
string	LastName	get, set
string	PhoneNumber	get, set
int	Salary	get, set

---

Repository

TrainerRepository

Method	Properties	Methods
int	ID	get, set
string	FirstName	get, set
string	LastName	get, set
string	PhoneNumber	get, set
int	Salary	get, set

StudentRepository

Method	Properties	Methods
int	ID	get, set
string	FirstName	get, set
string	LastName	get, set
string	PhoneNumber	get, set
int	Salary	get, set

CourseRepository

Method	Properties	Methods
int	ID	get, set
string	FirstName	get, set
string	LastName	get, set
string	PhoneNumber	get, set
int	Salary	get, set

AssignmentRepository

Method	Properties	Methods
int	ID	get, set
string	FirstName	get, set
string	LastName	get, set
string	PhoneNumber	get, set
int	Salary	get, set

🔙🏠

---

Views

TrainerView

Methods

Title	PARAMETER	GOAL
GetAll	ID
GetAllWithStudent	FirstName
GetAllWithStudentAndCourses	LastName
GetById	PhoneNumber
Create	Salary
Edit	ID
Delete	FirstName
GetAllWithStudentAndCourses	LastName
GetCourses	PhoneNumber
GetStudents	Salary

Back to >Top<

---

StudentView

Methods

Title	PARAMETER	GOAL
GetAll	ID
GetAllWithStudent	FirstName
GetAllWithStudentAndCourses	LastName
GetById	PhoneNumber
Create	Salary
Edit	ID
Delete	FirstName
GetAllWithStudentAndCourses	LastName
GetCourses	PhoneNumber
GetStudents	Salary

🔙🏠

CourseView

Methods

Title	PARAMETER	GOAL
GetAll	ID
GetAllWithStudent	FirstName
GetAllWithStudentAndCourses	LastName
GetById	PhoneNumber
Create	Salary
Edit	ID
Delete	FirstName
GetAllWithStudentAndCourses	LastName
GetCourses	PhoneNumber
GetStudents	Salary

🔙🏠

---

AssignmentView

Methods

Title	PARAMETER	GOAL
GetAll	ID
GetAllWithStudent	FirstName
GetAllWithStudentAndCourses	LastName
GetById	PhoneNumber
Create	Salary
Edit	ID
Delete	FirstName
GetAllWithStudentAndCourses	LastName
GetCourses	PhoneNumber
GetStudents	Salary

🔙🏠

---

Controllers

TrainerController

Method	Properties	Methods
Action	ID	get, set
Action	FirstName	get, set
Action	LastName	get, set
Action	PhoneNumber	get, set
Action	Salary	get, set

StudentController

Method	Properties	Methods
Action	ID	get, set
Action	FirstName	get, set
Action	LastName	get, set
Action	PhoneNumber	get, set
Action	Salary	get, set

CourseController

Method	Properties	Methods
Action	ID	get, set
Action	FirstName	get, set
Action	LastName	get, set
Action	PhoneNumber	get, set
Action	Salary	get, set

AssignmentController

Method	Properties	Methods
Action	ID	get, set
Action	FirstName	get, set
Action	LastName	get, set
Action	PhoneNumber	get, set
Action	Salary	get, set

---

Technologies and Tools

• C#
• Entity Framework
• ASP.NET MVC Pattern)
• Visual Studio Community Edition
• Microsoft SQL Server
• HTML
• CSS
• Bootstrap 4
• Font Awesome

🔙🏠