public static StudentModel UpdateStudent(StudentModel studentobj)
{
tblStudent tblobj = new tblStudent();
tblStudentHistory tblhistoryobj = new tblStudentHistory();
tblobj.Address = studentobj.Address;
tblobj.City = studentobj.City;
tblobj.ContactNo = studentobj.ContactNo;
tblobj.EmailID = studentobj.EmailID;
tblobj.EnrollNo = studentobj.EnrollNo;
tblobj.FirstName = studentobj.FirstName;
tblobj.Gender = studentobj.Gender;
tblobj.LastName = studentobj.LastName;
tblobj.State = studentobj.State;
tblobj.DOB = studentobj.DOB;
tblobj.DegreeYear = studentobj.DegreeYear;
tblhistoryobj.CollegeCode = studentobj.CollegeCode;
tblhistoryobj.DepartmentCode = studentobj.DepartmentCode;
tblhistoryobj.LogDate = studentobj.LogDate;
tblhistoryobj.Semester = studentobj.Semester;
return(irepository.UpdateStudent(tblobj, tblhistoryobj));
}
public static bool UpdateStudent(StudentModel studentModel)
{
try
{
tblStudent studentEntityToUpdate = new tblStudent();
studentEntityToUpdate = _unitOfWork.StudentRepository.GetByID(studentModel.StudentID);
if (studentEntityToUpdate.Equals(null))
{
return(false);
}
else
{
studentEntityToUpdate.FirstName = studentModel.FirstName;
studentEntityToUpdate.LastName = studentModel.LastName;
studentEntityToUpdate.ContactNumber = studentModel.ContactNumber;
studentEntityToUpdate.EmailAddress = studentModel.EmailAddress;
studentEntityToUpdate.DateOfBirth = studentModel.DateOfBirth;
studentEntityToUpdate.Address = studentModel.Address;
studentEntityToUpdate.CityID = studentModel.CityID;
IEnumerable <tblStudentHistory> historyEntityList = new List <tblStudentHistory>();
historyEntityList = _unitOfWork.StudentHistoryRepository.Get(filter: prop => prop.StudentID == studentModel.StudentID);
bool entryNotExists = true;
foreach (var entry in historyEntityList)
{
if (studentModel.CollegeID.Equals(entry.CollegeID) &&
studentModel.DepartmentID.Equals(entry.DepartmentID) &&
studentModel.DateOfJoining.Equals(entry.DateOfJoining) &&
studentModel.Semester.Equals(entry.Semester))
{
entryNotExists = false;
break;
}
}
if (entryNotExists)
{
Guid newStudentHistoryID = Guid.NewGuid();
tblStudentHistory newStudentHistoryEntry = new tblStudentHistory();
newStudentHistoryEntry.StudentHistoryID = newStudentHistoryID;
newStudentHistoryEntry.CollegeID = studentModel.CollegeID;
newStudentHistoryEntry.DepartmentID = studentModel.DepartmentID;
newStudentHistoryEntry.Semester = studentModel.Semester;
newStudentHistoryEntry.DateOfJoining = studentModel.DateOfJoining;
newStudentHistoryEntry.StudentID = studentModel.StudentID;
_unitOfWork.StudentHistoryRepository.Insert(newStudentHistoryEntry);
}
}
_unitOfWork.Save();
return(true);
}
catch (Exception e)
{
string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName();
ErrorLogger.LogException(e, currentFile);
return(false);
}
}
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 static ErrorEnums InsertStudent(StudentModel studentModel)
{
try
{
tblStudent studentEntity = new tblStudent();
studentEntity = _unitOfWork.StudentRepository.Get(filter: prop => prop.StudentCode == studentModel.StudentCode).FirstOrDefault();
if (studentEntity == null)
{
studentEntity = _unitOfWork.StudentRepository.Get(filter: prop => prop.ContactNumber == studentModel.ContactNumber).FirstOrDefault();
if (studentEntity == null)
{
studentEntity = _unitOfWork.StudentRepository.Get(filter: prop => prop.EmailAddress == studentModel.EmailAddress).FirstOrDefault();
if (studentEntity == null)
{
Guid newStudentId = Guid.NewGuid();
tblStudent newStudent = new tblStudent();
newStudent.StudentID = newStudentId;
newStudent.StudentCode = studentModel.StudentCode;
newStudent.FirstName = studentModel.FirstName;
newStudent.LastName = studentModel.LastName;
newStudent.ContactNumber = studentModel.ContactNumber;
newStudent.EmailAddress = studentModel.EmailAddress;
newStudent.DateOfBirth = studentModel.DateOfBirth;
newStudent.Address = studentModel.Address;
newStudent.CityID = studentModel.CityID;
Guid newStudentHistoryId = Guid.NewGuid();
tblStudentHistory studentHistoryEntity = new tblStudentHistory()
{
StudentHistoryID = newStudentHistoryId,
DepartmentID = studentModel.DepartmentID,
CollegeID = studentModel.CollegeID,
Semester = studentModel.Semester,
DateOfJoining = studentModel.DateOfJoining,
StudentID = newStudentId
};
Guid newUserID = Guid.NewGuid();
//Generating a new MD5 encrypted password
MD5 md5Hash = MD5.Create();
string newPassword = "******";
string newEncryptedPassword = Encryptor.GetMd5Hash(md5Hash, newPassword);
tblUser studentUserEntity = new tblUser()
{
UserID = newUserID,
EmailAddress = studentModel.EmailAddress,
Password = newEncryptedPassword,
RoleID = 3
};
_unitOfWork.StudentRepository.Insert(newStudent);
_unitOfWork.StudentHistoryRepository.Insert(studentHistoryEntity);
_unitOfWork.UserRepository.Insert(studentUserEntity);
_unitOfWork.Save();
return(ErrorEnums.Successful);
}
else
{
//Email address exists
return(ErrorEnums.EmailAddress);
}
}
else
{
//Contact number exists
return(ErrorEnums.PhoneNumber);
}
}
else
{
//Student code exists
return(ErrorEnums.Code);
}
}
catch (Exception e)
{
string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName();
ErrorLogger.LogException(e, currentFile);
return(ErrorEnums.Failed);
}
}
