public static List <StudentHistoryModel> GetStudentHistory(Guid id)
{
try
{
List <StudentHistoryModel> modelList = new List <StudentHistoryModel>();
IEnumerable <tblStudentHistory> historyEntityList = new List <tblStudentHistory>();
historyEntityList = from ordered in _unitOfWork.StudentHistoryRepository.Get(filter: prop => prop.StudentID == id)
orderby ordered.Semester descending
select ordered;
foreach (var history in historyEntityList)
{
tblCollege collegeEntity = new tblCollege();
collegeEntity = _unitOfWork.CollegeRepository.Get(filter: prop => prop.CollegeID == history.CollegeID).FirstOrDefault();
tblDepartment departmentEntity = new tblDepartment();
departmentEntity = _unitOfWork.DepartmentRepository.Get(filter: prop => prop.DepartmentID == history.DepartmentID).FirstOrDefault();
StudentHistoryModel newHistory = new StudentHistoryModel()
{
StudentID = history.StudentID,
CollegeName = collegeEntity.CollegeName,
DepartmentName = departmentEntity.DepartmentName,
Semester = history.Semester,
DateOfJoining = history.DateOfJoining
};
modelList.Add(newHistory);
}
return(modelList);
}
catch (Exception e)
{
string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName();
ErrorLogger.LogException(e, currentFile);
List <StudentHistoryModel> modelList = new List <StudentHistoryModel>();
return(modelList);
}
}
public ActionResult Index(int studentId, string cameFromTitle, bool showRawScale = false, int summaryCount = 0, int detailCount = 0)
{
try
{
base.SetNavigationLinksUrl();
ModelServices modelServices = new ModelServices();
StudentHistoryModel data = new StudentHistoryModel();
ViewBag.StudentId = studentId;
ViewBag.ShowRawScale = showRawScale;
ViewBag.Count = detailCount + 1;
ViewBag.SummaryCount = summaryCount + 1;
SiteUser su = ((SiteUser)Session["SiteUser"]);
data.History = modelServices.GetStudentHistoryReport(studentId, showRawScale, su.Districts.First().Id);
tblStudent tempStudent = modelServices.GetStudentById(studentId);
data.CameFromTitle = cameFromTitle;
data.Student = tempStudent.FirstName + " " + tempStudent.LastName;
data.District = modelServices.GetDistrictName(int.Parse(tempStudent.DistrictId.ToString()));
data.School = modelServices.GetSchoolNameByStudentId(studentId);
return(View("Index", data));
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return(View("GeneralError"));
}
}
public List <StudentHistoryModel> GetStudentHistory(Guid studentId)
{
var getStudentsHistoryQuery = (from sHistoty in _context.tblStudentHistory
where sHistoty.StudentID == studentId
orderby sHistoty.Semester descending
select sHistoty).ToList();
List <StudentHistoryModel> lstStudentHistory = new List <StudentHistoryModel>();
foreach (var entry in getStudentsHistoryQuery)
{
var getCollege = (from college in _context.tblCollege
where college.CollegeID == entry.CollegeID
select college.CollegeName).FirstOrDefault();
var getStudentEmail = (from sName in _context.tblStudent
where sName.StudentID == studentId
select sName.EmailAddress).FirstOrDefault();
var getDepartment = (from dept in _context.tblDepartment
where dept.DepartmentID == entry.DepartmentID
select dept).FirstOrDefault();
StudentHistoryModel newEntry = new StudentHistoryModel()
{
StudentID = studentId,
EmailAddress = getStudentEmail,
CollegeName = getCollege,
DepartmentName = getDepartment.DepartmentName,
Semester = entry.Semester,
DateOfJoining = entry.DateOfJoining,
};
lstStudentHistory.Add(newEntry);
}
return(lstStudentHistory);
}