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); } }