public List <ListStudent> ListFilterUni(Guid UniversityID)
{
var listUser = new UserDao().ListUser();
var listStudent = new UserLearningDao().ListUserLearning();
var listJob = new UserMajorDao().ListUserMajor();
var result = (from user in listUser
join student in listStudent on user.UserId equals student.UserID
join job in listJob on user.UserId equals job.UserID
where student.SchoolID == UniversityID
select new
{
UserName = user.UserName,
UserBirthDay = user.UserBirthDay,
UserEmail = user.UserEmail,
UserMobile = user.UserMobile,
JobName = db.JobMajors.Find(student.Major).JobName,
NameArea = db.Areas.Find(user.UserArea).NameArea,
LanguageLevel = db.UserForeignLanguages.Find(user.UserId).LanguageLevel,
listJob = db.JobMajors.Where(x => x.JobID == job.MajorID).Select(x => x.JobName).ToList(),
}).AsEnumerable().Select(x => new ListStudent()
{
UserName = x.UserName,
UserBirthDay = x.UserBirthDay,
UserEmail = x.UserEmail,
UserMobile = x.UserMobile,
JobName = x.JobName,
NameArea = x.NameArea,
LanguageLevel = x.LanguageLevel,
listJob = x.listJob
});
return(result.ToList());
}
public List <ShowInfoCandidate> InfoUser(Guid UserID)
{
var listUser = new UserDao().ListUsers();
var listMajor = new UserMajorDao().ListUserMajor();
var listStudy = new UserLearningDao().ListUserLearning();
var result = (from user in listUser
join major in listMajor on user.UserId equals major.UserID
join study in listStudy on user.UserId equals study.UserID
where user.UserId == UserID
select new
{
UserName = user.UserName,
UserImage = user.UserImage,
UserBirthDay = user.UserBirthDay,
UserEmail = user.UserEmail,
UserAddress = user.UserAddress,
UserMobile = user.UserMobile,
listJob = db.JobMajors.Where(x => x.JobID == major.MajorID).Select(x => x.JobName).ToList(),
Amount = db.Salaries.Find(user.Salary).Amount,
NamePosition = db.PositionEmployees.Find(user.PositionApply).NamePosition,
UserArea = db.Areas.Find(user.UserArea).NameArea,
StudyLevel = db.LevelLearnings.Find(study.StudyLevel).NameLevel,
SchoolName = study.SchoolName,
TimeStart = study.TimeStart,
TimeEnd = study.TimeEnd,
JobName = db.JobMajors.Find(study.Major).JobName,
}).AsEnumerable().Select(x => new ShowInfoCandidate()
{
UserName = x.UserName,
UserImage = x.UserImage,
UserBirthDay = x.UserBirthDay,
UserEmail = x.UserEmail,
UserAddress = x.UserAddress,
UserArea = x.UserArea,
UserMobile = x.UserMobile,
listJob = x.listJob,
Amount = x.Amount,
NamePosition = x.NamePosition,
StudyLevel = x.StudyLevel,
SchoolName = x.SchoolName,
TimeStart = x.TimeStart,
TimeEnd = x.TimeEnd,
JobName = x.JobName
});
return(result.ToList());
}
public List <CandidateInfo> ListUserFit(string KeyWord, int AreaID, int JobID, int experienceID, int salaryID, int languageID, int levelLanguageID)
{
var listUsers = ListUser();
var listUserMajors = new UserMajorDao().ListUserMajor();
var listJobs = new JobMajorDao().ListJobMain();
var listLanguage = new UserForeignLanguageDao().ReturnList();
var result = (from User in listUsers
join UserMajor in listUserMajors on User.UserId equals UserMajor.UserID
join Language in listLanguage on User.UserId equals Language.UserID
where (AreaID == 0 || User.UserArea == AreaID) &&
(JobID == 0 || UserMajor.MajorID == JobID) &&
(languageID == 0 || Language.LanguageID == languageID) &&
(salaryID == 0 || User.Salary == salaryID) &&
(KeyWord == "0" || User.UserName.Contains(KeyWord))
select new
{
UserId = User.UserId,
UserName = User.UserName,
//UserImage = User.UserImage,
//UserExperience = User.UserExperience,
UserSalary = (User.Salary != null)? User.Salary : 0,
UserArea = db.Areas.Find(User.UserArea).NameArea,
UserMajorName = (from UserMajor in listUserMajors
join JobMajor in listJobs on UserMajor.MajorID equals JobMajor.JobID
where (UserMajor.UserID == User.UserId)
select JobMajor.JobName).ToList()
}).AsEnumerable().Select(x => new CandidateInfo()
{
UserId = x.UserId,
UserName = x.UserName,
//UserImage = x.UserImage,
//UserExperience = x.UserExperience,
UserSalary = new SalaryDao().AmountSalary(x.UserSalary.Value),
UserArea = x.UserArea,
UserSalary = x.UserSalary,
UserMajorName = x.UserMajorName
});
List <CandidateInfo> finalResult = result.ToList();
int n = finalResult.Count;
if (n == 0 || n == 1)
{
return(finalResult);
}
List <CandidateInfo> finalResult2 = new List <CandidateInfo>();
for (int i = 0; i < n; i++)
{
bool check = true;
for (int j = 0; j < finalResult2.Count; j++)
{
if (finalResult[i].UserId == finalResult2[j].UserId)
{
check = false;
break;
}
}
if (check == true)
{
finalResult2.Add(finalResult[i]);
}
}
return(finalResult2);
}
public List <CandidateInfo> ListUserFit(String name, int areaID, int JobId)
{
var listUserMajors = new UserMajorDao().ListUserMajor();
var listJobs = new JobMajorDao().ListJobMain();
var result = (from User in db.Users.ToList()
join UserMajor in listUserMajors on User.UserId equals UserMajor.UserID
where (areaID == 0 || User.UserArea == areaID)
where (JobId == 0 || UserMajor.MajorID == JobId)
where (name == "0" || User.UserName.Contains(name))
select new
{
UserId = User.UserId,
UserName = User.UserName,
//UserImage = User.UserImage,
//UserExperience = User.UserExperience,
//UserSalary = User.GPA,
UserArea = db.Areas.Find(User.UserArea).NameArea,
UserMajorName = (from UserMajor in listUserMajors
join JobMajor in listJobs on UserMajor.MajorID equals JobMajor.JobID
where (UserMajor.UserID == User.UserId)
select JobMajor.JobName).ToList()
}).AsEnumerable().Select(x => new CandidateInfo()
{
UserId = x.UserId,
UserName = x.UserName,
//UserImage = x.UserImage,
//UserExperience = x.UserExperience,
//UserSalary = (float)x.UserSalary,
UserArea = x.UserArea,
UserMajorName = x.UserMajorName
});
List <CandidateInfo> finalResult = result.ToList();
int n = finalResult.Count;
if (n == 0 || n == 1)
{
return(finalResult);
}
List <CandidateInfo> finalResult2 = new List <CandidateInfo>();
for (int i = 0; i < n; i++)
{
bool check = true;
for (int j = 0; j < finalResult2.Count; j++)
{
if (finalResult[i].UserId == finalResult2[j].UserId)
{
check = false;
break;
}
}
if (check == true)
{
finalResult2.Add(finalResult[i]);
}
}
return(finalResult2);
}