Field to choose for CRUD for tables with foreign keys.

Akash Patel

I am working on a project in ASP.NET MVC Core. I have 3 tables FitnessClass, ClassSession, ClassEnrollee and following are the fields :

1). FitnessClass -> FitnessClassId, Title, Description, MaxEnrollee, Caloriesburned

2). ClassSession-> ClassSessionId, FitnessClassId, ClassSessionStartTime, LocationId

3). ClassEnrollee-> EnrolleId, ClassSessionId, MemberId.

My question is that I want to create CRUD for ClassEnrollee and as mentioned there are 3 fields in which 2 of them are foreign key. So which filed should I use to insert Foreign Key value in ClassEnrollee table in View part of ASP.NET CORE MVC. Is it CalssSessionStartTime or FitnessClass Title field bcoz classSession table has fitnessclassId as foreign key.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akash Patel4y ago
I was given this sepcific module. FitnessClass Module is given to other team member
0
Sachin Singh4y ago
1. It should be like this
2. step 1.Card View for all Fitness Classes with a button to enroll now. (to achieve this your Index Action should return all Fitness Class data)
4. step 2.When user clicks on Enroll Now button it should redirect to another page or partial view in the same view with a form having
5. Dropdown for Fitness Class (Title as text and FitnessClassId as Value)
6. Dropdown for Location
7. DateTimePicker for Class session Start Date and Time.
8. Step 2. Should redirect to login page if user is not logged in so that you can get MemberId.
9. Finally on Enroll Me button click on Enroll page you will get FitnessClassId from ddl, LocationId from ddl , ClassSessionId from prev step (store it in TempData to reuse in this step) and MemberId from Session (when user logs in Store UserId in session)