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 bool InsertCollege(CollegeDetailsModel collegeDetailsModel) { try { tblCollege entity = new tblCollege(); entity = _unitOfWork.CollegeRepository.Get(filter: prop => prop.CollegeCode.Equals(collegeDetailsModel.CollegeCode)).FirstOrDefault(); if (entity == null) { Guid collegeId = Guid.NewGuid(); tblCollege newCollege = new tblCollege() { IsDeleted = false, CollegeID = collegeId, CollegeCode = collegeDetailsModel.CollegeCode, CollegeName = collegeDetailsModel.CollegeName }; _unitOfWork.CollegeRepository.Insert(newCollege); _unitOfWork.Save(); return(true); } else { return(false); } } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); return(false); } }
public CollegeDetailsModel GetCollege(Guid ID) { try { tblCollege entity = new tblCollege(); entity = _unitOfWork.CollegeRepository.GetByID(ID); CollegeDetailsModel model = new CollegeDetailsModel() { CollegeID = entity.CollegeID, CollegeCode = entity.CollegeCode, CollegeName = entity.CollegeName }; if (entity.IsDeleted) { return(new CollegeDetailsModel()); } else { return(model); } } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); CollegeDetailsModel model = new CollegeDetailsModel(); return(model); } }
public static StudentModel GetStudent(Guid ID) { try { //throw new IndexOutOfRangeException(); tblStudent studentEntity = _unitOfWork.StudentRepository.GetByID(ID); tblStudentHistory historyEntity = _unitOfWork.StudentHistoryRepository.Get(filter: prop => prop.StudentID == studentEntity.StudentID, orderBy: prop => prop.OrderByDescending(d => d.Semester)).FirstOrDefault(); if (historyEntity == null) { return(new StudentModel()); } tblCity cityEntity = _unitOfWork.CityRepository.Get(filter: prop => prop.CityID == studentEntity.CityID).FirstOrDefault(); tblState stateEntity = _unitOfWork.StateRepository.Get(filter: prop => prop.StateID == cityEntity.StateID).FirstOrDefault(); tblCollege collegeEntity = _unitOfWork.CollegeRepository.Get(filter: prop => prop.CollegeID == historyEntity.CollegeID).FirstOrDefault(); tblDepartment departmentEntity = _unitOfWork.DepartmentRepository.Get(filter: prop => prop.DepartmentID == historyEntity.DepartmentID).FirstOrDefault(); StudentModel studentModel = new StudentModel() { StudentCode = studentEntity.StudentCode, StudentID = studentEntity.StudentID, FirstName = studentEntity.FirstName, LastName = studentEntity.LastName, ContactNumber = studentEntity.ContactNumber, EmailAddress = studentEntity.EmailAddress, DateOfBirth = studentEntity.DateOfBirth, Address = studentEntity.Address, DateOfJoining = historyEntity.DateOfJoining, Semester = historyEntity.Semester, CollegeID = collegeEntity.CollegeID, CollegeName = collegeEntity.CollegeName, DepartmentID = departmentEntity.DepartmentID, DepartmentName = departmentEntity.DepartmentName, CityID = cityEntity.CityID, CityName = cityEntity.CityName, StateName = stateEntity.StateName }; return(studentModel); } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); StudentModel student = new StudentModel(); return(student); } }
public bool DeleteCollege(Guid ID) { try { tblCollege entityToDelete = _unitOfWork.CollegeRepository.GetByID(ID); if (entityToDelete == null) { return(false); } entityToDelete.IsDeleted = true; _unitOfWork.CollegeRepository.Update(entityToDelete); _unitOfWork.Save(); return(true); } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); return(false); } }
public bool UpdateCollege(CollegeDetailsModel collegeDetailsModel) { try { tblCollege entityToUpdate = new tblCollege(); entityToUpdate = _unitOfWork.CollegeRepository.GetByID(collegeDetailsModel.CollegeID); if (entityToUpdate == null) { return(false); } List <tblCollege> getAllCollegeCodes = _unitOfWork.CollegeRepository.Get().ToList(); foreach (var entry in getAllCollegeCodes) { //CollegeCode already exists if (entry.CollegeCode == entityToUpdate.CollegeCode) { break; } if (entry.CollegeCode == collegeDetailsModel.CollegeCode) { return(false); } } entityToUpdate.CollegeCode = collegeDetailsModel.CollegeCode; entityToUpdate.CollegeName = collegeDetailsModel.CollegeName; _unitOfWork.CollegeRepository.Update(entityToUpdate); _unitOfWork.Save(); return(true); } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); return(false); } }