public IEnumerable <WebmasterInfoDTO> GetListWebmasterInfoHaveSearchAndPaging(string keyWord, int page, int pageSize)
{
db = new JobHuntEntities();
List <WebmasterInfoDTO> listDTOs = new List <WebmasterInfoDTO>();
List <WebmasterInfo> listEFs = db.WebmasterInfoes.ToList();
if (!string.IsNullOrEmpty(keyWord))
{
listEFs = db.WebmasterInfoes.Where(x => x.WIFullName.Contains(keyWord) || x.WIUserName.Contains(keyWord) && x.WIStatus != (int)Common.Enum.StatusCandidate.Deleted).ToList();
}
foreach (var mb in listEFs)
{
if (mb.WIPosition == (int)BU.Common.Enum.WIPosition.Admin)
{
continue;
}
else
{
listDTOs.Add(convertData.ConvertToDTO(mb));
}
}
db = null;
return(listDTOs.ToPagedList(page, pageSize));
}
//get list save jobs GetListSaveJobs
public IEnumerable <RecruitJobDTO> GetListSaveJobs(string userID, int page, int pageSize)
{
db = new JobHuntEntities();
List <RecruitJobDTO> listRecruitJobsDTO = new List <RecruitJobDTO>();
List <RecruitJob> ListRecruitJobs = new List <RecruitJob>();
List <SaveJob> ListSaveJobs = new List <SaveJob>();
var GetInfoCandidateByIdUser = GetCandidateInfoByIdAspNetUser(userID);
ListSaveJobs = db.SaveJobs.Where(x => x.SJ_CandidateId == GetInfoCandidateByIdUser.CandidateId).ToList();
if (ListSaveJobs != null)
{
foreach (var sv in ListSaveJobs)
{
ListRecruitJobs.Add(sv.RecruitJob);
}
}
foreach (var mb in ListRecruitJobs)
{
listRecruitJobsDTO.Add(new ConvertDataRecruitJob().ConvertToDTO(mb));
}
db = null;
return(listRecruitJobsDTO.ToPagedList(page, pageSize));
}
//count job
public int Statistical(int typeChoose)
{
db = new JobHuntEntities();
var count = 0;
//typeChoose = 1: count job posted
//typeChoose = 2: count job approval
//typeChoose = 3: count company
//typeChoose = 5: count member
switch (typeChoose)
{
case 1:
count = db.RecruitJobs.Where(x => x.RJStatus != (int?)Common.Enum.EnumStatusJob.Inactive).Count();
break;
case 2:
count = db.RecruitJobs.Where(x => x.RJStatus == (int?)Common.Enum.EnumStatusJob.Active).Count();
break;
case 3:
count = db.Recruits.Where(x => x.RIStatus == (int?)Common.Enum.StatusRecruit.Active).Count();
break;
case 5:
count = db.RecruitJobs.Where(x => x.RJPostDate == DateTime.Today).Count();
break;
default:
count = db.Candidates.Where(x => x.CPStatus == (int?)Common.Enum.StatusCandidate.Active).Count();
break;
}
db = null;
return(count);
}
public AspNetRoleDTO GetRoleById(string idrole)
{
db = new JobHuntEntities();
var ef = db.AspNetRoles.FirstOrDefault(x => x.Id.Equals(idrole));
db = null;
return(new ConvertDataAspNetRole().ConvertToDTO(ef));
}
//public List<string>
public WebmasterInfoDTO GetInfoWebmasterByIdUser(string idUser)
{
db = new JobHuntEntities();
var ef = db.WebmasterInfoes.FirstOrDefault(x => x.WI_AspNetUserId.Equals(idUser));
db = null;
return(convertData.ConvertToDTO(ef));
}
public WebmasterInfoDTO GetInfoWebmasterById(int id)
{
db = new JobHuntEntities();
var dto = convertData.ConvertToDTO(db.WebmasterInfoes.Find(id));
db = null;
return(dto);
}
public IEnumerable <CandidateDTO> GetListCandidateHaveSearchAndPaging(string keyWord, int?idCity, int?idProfesstion, int?idProfesstionRecruit, int page, int pageSize)
{
db = new JobHuntEntities();
List <CandidateDTO> listCandidateDTO = new List <CandidateDTO>();
List <Candidate> SearchList = new List <Candidate>();
var checkIdRecruit = false;
if (SearchList.Count == 0)
{
SearchList = db.Candidates.ToList();
}
if (!string.IsNullOrEmpty(keyWord))
{
SearchList = SearchList.Where(x => x.CddUserName.Contains(keyWord) ||
x.Profession.PFName.Contains(keyWord)).ToList();
checkIdRecruit = true;
}
if (idProfesstion != null)
{
SearchList = SearchList.Where(x => x.CP_ProfessionId == idProfesstion).ToList();
checkIdRecruit = true;
}
if (idCity != null)
{
SearchList = SearchList.Where(x => x.City.CityId == idCity).ToList();
checkIdRecruit = true;
}
if (idProfesstionRecruit != null && checkIdRecruit == false)
{
var getList = SearchList.Where(x => x.CP_ProfessionId == idProfesstionRecruit);
var indexCount = getList.Count();
var count = 0;
foreach (var item in getList.ToList())
{
var get = SearchList.FindIndex(x => x.CandidateId == item.CandidateId);
var temp = SearchList[get];
SearchList[get] = SearchList[count];
SearchList[count] = item;
count++;
}
}
SearchList = SearchList.Where(x => x.CPStatus != (int)Common.Enum.StatusCandidate.Deleted).ToList();
foreach (var mb in SearchList)
{
listCandidateDTO.Add(convertData.ConvertToDTO(mb));
}
db = null;
return(listCandidateDTO.ToPagedList(page, pageSize));
}
public CandidatePostResumeDTO GetDetail(int id)
{
var dto = new CandidatePostResumeDTO();
using (db = new JobHuntEntities())
{
dto = convertData.ConvertToDTO(db.CandidatePostResumes.Find(id));
}
return(dto);
}
public AdvertisementDTO GetAdvertisementByID(int id)
{
var dto = new AdvertisementDTO();
using (var db = new JobHuntEntities())
{
dto = convertData.ConvertToDTO(db.Advertisements.Find(id));
//listEFs = db.Advertisements.Where()
}
return(dto);
}
public bool CheckExistAd(AdvertisementDTO addto)
{
var result = false;
using (var db = new JobHuntEntities())
{
result = db.Advertisements.Any(a => a.AdEndDate >= addto.AdStartDate && a.AdPosition == addto.AdPosition && a.AdvertisementId != addto.AdvertisementId);
//listEFs = db.Advertisements.Where()
}
return(result);
}
//get list recruit job by id recruit paging
public IEnumerable <RecruitJobDTO> GetListRecruitJobsUserIdPaging(int IdRecruit, int pageNumber, int pageSize)
{
db = new JobHuntEntities();
var getEF = db.RecruitJobs.OrderByDescending(x => x.RJPostDate).Where(x => x.RJ_RecruitId == IdRecruit && x.RJType != (int?)BU.Common.Enum.EnumStatusJob.Inactive).ToList();
var listDTO = new List <RecruitJobDTO>();
foreach (var cdd in getEF)
{
listDTO.Add(convertData.ConvertToDTO(cdd));
}
return(listDTO.ToPagedList(pageNumber, pageSize));
}
//get list recruit job by time
public IEnumerable <RecruitJobDTO> GetListRecruitJobsByTime()
{
db = new JobHuntEntities();
var getEF = db.RecruitJobs.OrderByDescending(x => x.RJPostDate).Where(x => x.RJType != (int?)BU.Common.Enum.EnumStatusJob.Inactive && x.RJExpirationDate >= DateTime.Now).ToList();
var listDTO = new List <RecruitJobDTO>();
foreach (var cdd in getEF)
{
listDTO.Add(convertData.ConvertToDTO(cdd));
}
return(listDTO);
}
public List <AspNetRoleDTO> GetListRoles()
{
db = new JobHuntEntities();
var listDTOs = new List <AspNetRoleDTO>();
var listEFs = db.AspNetRoles.ToList();
foreach (var ef in listEFs)
{
listDTOs.Add(new ConvertDataAspNetRole().ConvertToDTO(ef));
}
db = null;
return(listDTOs);
}
//
public List <RecruitDTO> GetListRecruits()
{
db = new JobHuntEntities();
List <RecruitDTO> listRecruitsDTO = new List <RecruitDTO>();
var getLists = db.Recruits.Where(x => x.RIStatus != (int)Common.Enum.StatusRecruit.Deleted).OrderByDescending(x => x.RIRegisterDate).ToList();
foreach (var cdd in getLists)
{
listRecruitsDTO.Add(convertData.ConvertToDTO(cdd));
}
return(listRecruitsDTO);
}
//get top find job
public List <RecruitJobDTO> GetListFindJob()
{
db = new JobHuntEntities();
List <RecruitJobDTO> listRecruitJobDTO = new List <RecruitJobDTO>();
var getLists = db.RecruitJobs.Where(x => x.RJStatus != (int)Common.Enum.EnumStatusJob.Deleted).OrderByDescending(x => x.RJCount).ToList();
foreach (var job in getLists)
{
listRecruitJobDTO.Add(convertData.ConvertToDTO(job));
}
return(listRecruitJobDTO);
}
public List <RecruitDTO> GetAllRecruits()
{
db = new JobHuntEntities();
List <RecruitDTO> listRecruitDTO = new List <RecruitDTO>();
var getListRecruits = db.Recruits.Where(x => x.RIStatus != (int)Common.Enum.StatusRecruit.Deleted).ToList();
foreach (var rc in getListRecruits)
{
listRecruitDTO.Add(convertData.ConvertToDTO(rc));
}
db = null;
return(listRecruitDTO);
}
public IEnumerable <WebmasterInfoDTO> GetListWebmasterInfos()
{
db = new JobHuntEntities();
List <WebmasterInfoDTO> listDTOs = new List <WebmasterInfoDTO>();
List <WebmasterInfo> listEFs = db.WebmasterInfoes.Where(x => x.WIStatus != (int)BU.Common.Enum.StatusAccount.Deleted).ToList();
foreach (var mb in listEFs)
{
listDTOs.Add(convertData.ConvertToDTO(mb));
}
db = null;
return(listDTOs);
}
public List <RecruitJobDTO> GetListRecentJobs(int WorkTypeId, int SalaryId, int?DistrictId)
{
var listDTO = new List <RecruitJobDTO>();
db = new JobHuntEntities();
var getListEF = db.RecruitJobs.Where(x => x.RJ_WorkTypeId == WorkTypeId && x.RJ_SalaryId == SalaryId && x.RJDistrictId == DistrictId && x.RJStatus != (int)Common.Enum.EnumStatusJob.Inactive && x.RJExpirationDate >= DateTime.Now).OrderByDescending(x => x.RJPostDate).ToList();
foreach (var rj in getListEF)
{
listDTO.Add(convertData.ConvertToDTO(rj));
}
db = null;
return(listDTO);
}
//Tên kết nối khi mọi người tạo.
//JobHuntEntities db = null;
public List <CareerDTO> GetAllCareers()
{
db = new JobHuntEntities();
var getEF = repo.SelectAll();
var listDTO = new List <CareerDTO>();
foreach (var ct in getEF)
{
var crdto = convertData.ConvertToDTO(ct);
crdto.CountJob = db.RecruitJobs.Where(x => x.Profession.PFCareerId == ct.CareerId && x.RJExpirationDate >= DateTime.Now && x.RJStatus != (int?)Common.Enum.EnumStatusJob.Inactive).Count();
listDTO.Add(crdto);
}
db = null;
return(listDTO);
}
public List <AdvertisementDTO> GetAll()
{
var listDTOs = new List <AdvertisementDTO>();
var listEFs = new List <Advertisement>();
using (var db = new JobHuntEntities())
{
listEFs = db.Advertisements.Where(x => x.AdStatus != (int)BU.Common.Enum.StatusAdvertisement.Deleted).ToList();
foreach (var ad in listEFs)
{
listDTOs.Add(convertData.ConvertToDTO(ad));
}
//listEFs = db.Advertisements.Where()
}
return(listDTOs);
}
public IEnumerable <RecruitJobDTO> GetListRecruitJobHaveSearchAndPaging(string keyWord, int?idCity, int?idProfesstion, int page, int pageSize)
{
db = new JobHuntEntities();
List <RecruitJobDTO> listRecruitJobDTO = new List <RecruitJobDTO>();
List <RecruitJob> SearchList = new List <RecruitJob>();
if (SearchList.Count == 0)
{
SearchList = db.RecruitJobs.ToList();
}
if (!string.IsNullOrEmpty(keyWord))
{
SearchList = SearchList.Where(x => x.RJTitle.Contains(keyWord) ||
x.Profession.PFName.Contains(keyWord)).ToList();
}
if (idProfesstion != null)
{
SearchList = SearchList.Where(x => x.RJ_ProfessionId == idProfesstion).ToList();
}
if (idCity != null)
{
SearchList = SearchList.Where(x => x.RJCityId == idCity).ToList();
}
SearchList = SearchList.Where(x => x.RJExpirationDate >= DateTime.Now && x.RJType != (int?)BU.Common.Enum.EnumStatusJob.Inactive).ToList();
//find gần đúng profession ~ thuộc nghề
//if(SearchList == null && idProfesstion != null)
//{
// var findProfesstion = new ProfessionManage().GetDetailProfession((int)idProfesstion);
// SearchList = SearchList.Where(x => x.Profession.Career.CareerId == findProfesstion.CareerDTO.CareerId && x.RJExpirationDate >= DateTime.Now && x.RJType != (int?)BU.Common.Enum.EnumStatusJob.Inactive).ToList();
//}
foreach (var mb in SearchList)
{
listRecruitJobDTO.Add(convertData.ConvertToDTO(mb));
}
db = null;
return(listRecruitJobDTO.ToPagedList(page, pageSize));
}
public RecruitDTO GetRecruitInfoByIdAspNetUser(string idAspNetUser)
{
if (string.IsNullOrEmpty(idAspNetUser))
{
return(null);
}
db = new JobHuntEntities();
var RecruitEF = db.Recruits.FirstOrDefault(x => x.RI_AspNetUserId.Equals(idAspNetUser));
if (RecruitEF == null)
{
return(null);
}
var getRecruitInfo = convertData.ConvertToDTO(RecruitEF);
return(getRecruitInfo);
}
//get list job
public List <CandidateDTO> GetListCandidates(int?status)
{
db = new JobHuntEntities();
List <CandidateDTO> listCandidateDTO = new List <CandidateDTO>();
var getLists = db.Candidates.Where(x => x.CPStatus != (int)Common.Enum.StatusCandidate.Deleted).OrderByDescending(x => x.CddRegisterDate).ToList();
if (status != null)
{
getLists = getLists.Where(x => x.CPStatus == status).ToList();
}
foreach (var cdd in getLists)
{
listCandidateDTO.Add(convertData.ConvertToDTO(cdd));
}
return(listCandidateDTO);
}
public CandidateDTO GetCandidateInfoByIdAspNetUser(string idAspNetUser)
{
if (string.IsNullOrEmpty(idAspNetUser))
{
return(null);
}
db = new JobHuntEntities();
var candidateEF = db.Candidates.FirstOrDefault(x => x.Cdd_AspNetUserId.Equals(idAspNetUser));
if (candidateEF == null)
{
return(null);
}
var getCandidateInfo = convertData.ConvertToDTO(candidateEF);
return(getCandidateInfo);
}
//get list recruit job by status
public IEnumerable <RecruitJobDTO> GetListRecruitJobsByType(int?type)
{
db = new JobHuntEntities();
var getEF = db.RecruitJobs.Where(x => x.RJType == type && x.RJExpirationDate >= DateTime.Now && x.RJStatus != (int?)Common.Enum.EnumStatusJob.Inactive).ToList();
if (getEF.Count == 0)
{
getEF = db.RecruitJobs.Where(x => x.RJExpirationDate >= DateTime.Now && x.RJStatus != (int?)Common.Enum.EnumStatusJob.Inactive).ToList();
}
var listDTO = new List <RecruitJobDTO>();
foreach (var cdd in getEF)
{
listDTO.Add(convertData.ConvertToDTO(cdd));
}
return(listDTO);
}
//lấy danh sách quảng cáo trước 3 ngày hết hạn
public List <AdvertisementDTO> GetListAdvertisementDashboard()
{
var datenow = DateTime.Now;
var dateexpired = datenow.AddDays(3);
var listDTOs = new List <AdvertisementDTO>();
var listEFs = new List <Advertisement>();
using (var db = new JobHuntEntities())
{
listEFs = db.Advertisements.Where(x => x.AdStatus != (int)BU.Common.Enum.StatusAdvertisement.Deleted && x.AdEndDate <= dateexpired && x.AdEndDate >= datenow).ToList();
foreach (var ad in listEFs)
{
listDTOs.Add(convertData.ConvertToDTO(ad));
}
//listEFs = db.Advertisements.Where()
}
return(listDTOs);
}
//Get list post resume by id candidate
public IEnumerable <CandidatePostResumeDTO> GetListCandidatePostResumeHaveSearchAndPaging(int?idCandidate, int page, int pageSize)
{
db = new JobHuntEntities();
List <CandidatePostResumeDTO> listCandidatePostResumeDTO = new List <CandidatePostResumeDTO>();
List <CandidatePostResume> GetLists = new List <CandidatePostResume>();
GetLists = db.CandidatePostResumes.Where(x => x.CPR_CandidateId == idCandidate && x.CPRStatus == true).ToList();
foreach (var mb in GetLists)
{
listCandidatePostResumeDTO.Add(convertData.ConvertToDTO(mb));
}
db = null;
return(listCandidatePostResumeDTO.ToPagedList(page, pageSize));
}
public ActionResult Decentralization(string keyWord, int page = 1, int pageSize = 10)
{
var model = _webMasterManage.GetListWebmasterInfoHaveSearchAndPaging(keyWord, page, pageSize);
ViewBag.keyWord = keyWord;
ViewBag.stt = (page - 1) * pageSize;
var GetListRoles = new JobHuntEntities().AspNetRoles.ToList();
var listRolesDTO = new List <AspNetRoleDTO>();
var convertdatarole = new ConvertDataAspNetRole();
foreach (var role in GetListRoles)
{
listRolesDTO.Add(convertdatarole.ConvertToDTO(role));
}
ViewBag.roles = listRolesDTO;
return(View(model));
}
//check posted resume
public bool CheckPostedResume(int?idCandidate, int?idJob)
{
db = new JobHuntEntities();
var getListPostedResume = db.CandidatePostResumes.ToList();
var check = false;
foreach (var cddprs in getListPostedResume)
{
if (cddprs.CPR_CandidateId == idCandidate && cddprs.CPR_RecruitJobId == idJob)
{
check = true;
break;
}
}
db = null;
return(check);
}
public IEnumerable <RecruitDTO> GetListRecruitHaveSearchAndPaging(string keyWord, int?idCity, int?idProfesstion, string chooseDate, List <int?> chooseWorkType, List <int?> chooseSalary, List <int?> chooseExperience, List <int?> chooseGender, List <int?> chooseLevel, int page, int pageSize)
{
db = new JobHuntEntities();
List <RecruitDTO> listRecruitDTO = new List <RecruitDTO>();
List <Recruit> SearchList = new List <Recruit>();
if (SearchList.Count == 0)
{
SearchList = db.Recruits.ToList();
}
if (!string.IsNullOrEmpty(keyWord))
{
SearchList = SearchList.Where(x => x.RIFullName.Contains(keyWord)).ToList();
}
if (!string.IsNullOrEmpty(chooseDate))
{
var currentTime = DateTime.Now;
var getTimeHour = int.Parse(chooseDate.Remove(chooseDate.Length - 1));
if (getTimeHour != 0)
{
TimeSpan aInterval = new TimeSpan(0, getTimeHour, 0, 0);
var getTime = currentTime - aInterval;
SearchList = SearchList.Where(x => x.RIRegisterDate >= getTime).ToList();
}
}
//if (idProfesstion != null)
// SearchList = SearchList.Where(x => x.CP_ProfessionId == idProfesstion).ToList();
SearchList = SearchList.Where(x => x.RIStatus != (int)Common.Enum.StatusRecruit.Deleted).ToList();
foreach (var mb in SearchList)
{
listRecruitDTO.Add(convertData.ConvertToDTO(mb));
}
db = null;
return(listRecruitDTO.ToPagedList(page, pageSize));
}
