Skip to content

Coding Bootcamp ----> 2) Assignment : " CRUD "

License

Notifications You must be signed in to change notification settings

zafeirisdimi/2.Assignment_CRUD

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

43 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation


ProjectLogo


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


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

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