public List <StudentResultVM> GetAllCourseResult(int studentId)
{
Query =
"Select c.Code, c.Name,ce.Grade from CourseEnrollment ce inner join Course c on c.Id = ce.CourseId where ce.StudentId =@id";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("id", SqlDbType.VarChar);
Command.Parameters["id"].Value = studentId;
Connection.Open();
Reader = Command.ExecuteReader();
List <StudentResultVM> studentResults = new List <StudentResultVM>();
while (Reader.Read())
{
StudentResultVM studentResult = new StudentResultVM();
studentResult.CourseCode = Reader["Code"].ToString();
studentResult.CourseName = Reader["Name"].ToString();
studentResult.Grade = Reader["Grade"].ToString();
if (studentResult.Grade == "")
{
studentResult.Grade = "Not Graded Yet";
}
studentResults.Add(studentResult);
}
Reader.Close();
Connection.Close();
return(studentResults);
}
//Single Student Result......
public ActionResult SingleStudentResult(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Student student = db.Students.Find(id);
if (student == null)
{
return(HttpNotFound());
}
var subjects = db.Subjects.Where(s => s.ClassID == student.ClassID).ToList();
List <StudentResultVM> studentResultVms = new List <StudentResultVM>();
foreach (var subject in subjects)
{
StudentResultVM studentResultVm = new StudentResultVM();
studentResultVm.Subject = subject.Name;
studentResultVm.HalfYearly = student.Results.Single(s => s.SubjectID == subject.ID && s.ExamTypeID == 1).Number;
studentResultVm.Final =
student.Results.Single(s => s.SubjectID == subject.ID && s.ExamTypeID == 2).Number;
studentResultVms.Add(studentResultVm);
}
ViewBag.StudentName = student.Name;
return(View(studentResultVms));
}
public ActionResult EditResult(int id, StudentResultVM obj, decimal OMarks)
{
DB35Entities db = new DB35Entities();
db.StudentResults.Find(id).ObtainedMarks = OMarks;
db.SaveChanges();
return(RedirectToAction("ResultSection", new { id = db.StudentResults.Find(id).ResultId }));
}
public ActionResult EditResult(int id)
{
DB35Entities db = new DB35Entities();
StudentResultVM sr = new StudentResultVM();
foreach (StudentResult s in db.StudentResults)
{
// if (s.Id == id)
{
sr.ResultId = s.ResultId;
sr.StudentId = s.StudentId;
ViewBag.Obt = s.ObtainedMarks;
ViewBag.Title = db.Results.Find(s.ResultId).Title;
ViewBag.Total = db.Results.Find(s.ResultId).TotalMarks;
break;
}
}
return(View(sr));
}
public ActionResult FindResult(int sessionId, int studentClassId, int assignRollId)
{
try
{
List <ResultVM> resultList = new List <ResultVM>();
List <StudentInfoVM> infoList = new List <StudentInfoVM>();
List <StudentResultVM> studentResult = new List <StudentResultVM>();
var session = db.Session.Where(x => x.Id == sessionId).Select(x => x.Name).FirstOrDefault();
var className = db.StudentClass.Where(x => x.Id == studentClassId).Select(x => x.ClassName.Name).FirstOrDefault();
var roll = db.AssignRoll.Where(x => x.SessionId == sessionId && x.StudentClassId == studentClassId).Select(s => s.Roll).FirstOrDefault();
#region retrieve & bind studentInfo
var studentInfo = db.Admission.Where(x => x.SessionId == sessionId && x.StudentClassId == studentClassId).Select(s => new
{
StudentName = s.Student.Name,
FatherName = s.Student.FatherName,
MotherName = s.Student.MotherName,
BirtDate = s.Student.DateOfBirth,
Session = session,
Shift = s.StudentClass.Shift.Name,
Section = s.StudentClass.Section.Name,
GroupName = s.Group.Name,
ClassName = className,
Roll = roll
}).ToList();
foreach (var item in studentInfo)
{
StudentInfoVM vm = new StudentInfoVM();
vm.StudentName = item.StudentName;
vm.FatherName = item.FatherName;
vm.MotherName = item.MotherName;
vm.BirtDate = item.BirtDate;
vm.Session = item.Session;
vm.Shift = item.Shift;
vm.Section = item.Section;
vm.GroupName = item.GroupName;
vm.ClassName = item.ClassName;
vm.Roll = item.Roll;
infoList.Add(vm);
}
#endregion
#region retrieve & bind studentResult
var result = db.ExamMark.Where(x => x.SessionId == sessionId && x.StudentClassId == studentClassId && x.AssignRollId == assignRollId)
.Select(s => new
{
subjectCode = s.Course.Code,
subjectName = s.Course.Name,
Theory = s.Theory,
Mcq = s.Mcq,
Practical = s.Practical,
Total = s.Total,
Grade = s.Grade,
}).ToList();
foreach (var item in result)
{
ResultVM vm = new ResultVM();
vm.SubjectCode = item.subjectCode;
vm.SubjectName = item.subjectName;
vm.Theory = item.Theory;
vm.Mcq = item.Mcq;
vm.Practical = item.Practical;
vm.Total = item.Total;
vm.Grade = item.Grade;
resultList.Add(vm);
}
#endregion
StudentResultVM Sr = new StudentResultVM
{
ResultVM = resultList,
StudentInfoVM = infoList
};
studentResult.Add(Sr);
#region send viewBag
var studentClass = db.StudentClass.Select(c => new
{
Id = c.Id,
Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
}).OrderBy(o => o.Name).ToList();
ViewBag.SessionId = new SelectList(db.Session, "Id", "Name");
ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
ViewBag.AssignRollId = new SelectList(db.AssignRoll, "Id", "Roll");
#endregion
return(View(studentResult));
}
catch (Exception ex)
{
return(null);
}
}
