• Tech Writer
• 4
• 663

# Convert Rows to Columns using C# logic with entity framework

Apr 2 2021 4:43 AM
1. The Students studying in BE Final Year. In Final year they have Four Theory Subjects.

List of Subjects and their max and passing marks are as below:

1. EC1 – Max marks 100 . Passing marks 30

2. EC2– Max marks 100 . Passing marks 30

3. EC3– Max marks 100 . Passing marks 30

4. EC4– Max marks 100 . Passing marks 30

5. EC5– Max marks 100 . Passing marks 30

The individual marks are stored in the table like below.

Table Name: Students

 StudentID StudentName SubjectName Marks 1 Savita EC1 50 1 Savita EC2 55 1 Savita EC3 28 1 Savita EC4 30 1 Savita EC5 35

Problem:

1. You have to write a program to display the list of candidates along with their individual subject marks and total marks like below.

 StudentName EC1 EC2 EC3 EC4 EC5 Total Savita 50 55 28 30 30 193 Harish 55 60 30 35 30 210

2. Add logic to your code such that this list of students displayed is in order. The person with maximum total marks is at the top and the person with the least marks is at the bottom.

 StudentName EC1 EC2 EC3 EC4 EC5 Total Harish 55 60 30 35 30 210 Savita 50 55 28 30 30 193

3. Add a button [Show Results of All]. When clicked, displays the Pass or Fail status for all the students.

Logic is simple: If a student has failed in any subject, he is fail.

 StudentName EC1 EC2 EC3 EC4 EC5 Result Total Harish 55 60 30 35 30 Pass 210 Savita 50 55 28 30 30 Fail 193

4. Add a button [Show Results with Grace Marks]. When clicked, display Results with Grace Marks, the program has to add Grace Marks to failed students following a logic. Pass/Fail status has to be displayed for all the students after the Grace Marks are added.

Logic is: Total grace marks per student is max of 6 marks. If the candidate has failed in two subjects with 28 marks in EC1 and 27 marks in EC2, then after grace marks EC1 = 30 and EC2=30. The candidate is declared pass.

If the candidate has secured 25 marks in EC1 and 28 marks in EC2, then the total grace marks needed is 5+2 (7 marks). Hence the student is declared fail and no grace marks are given. Please note that Grace marks can be given to max of 2 subjects only. If Candidate has failed in more than 2 subjects then he is failed and no grace marks are given.

 StudentName EC1 EC2 EC3 EC4 EC5 Result Total Harish 55 60 30 35 30 Pass 210 Savita 50 55 30 30 30 Pass 195
Please Don’t use any SQL functions (stored procedure, views, pivot etc). All logic should be done in BLL