public List <SearchJobListViewModel> RecommendedJobs(int roleid)
{
DataTable dt = _jobPostProcessor.RecommendedJobs(roleid);
if (dt.Rows.Count > 0)
{
List <SearchJobListViewModel> lstRecommendedJobs = new List <SearchJobListViewModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel RecommendedJob = new SearchJobListViewModel
{
JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]),
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]),
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]),
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]),
City = Convert.ToString(dt.Rows[i]["City"]),
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]),
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]),
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]),
};
lstRecommendedJobs.Add(RecommendedJob);
}
return(lstRecommendedJobs);
}
throw new DataNotFound("Data not found");
}
public List <SearchJobListViewModel> ViewAllFeaturedJobs()
{
DataTable dt = _homeRepositories.ViewAllFeaturedJobs();
if (dt.Rows.Count > 0)
{
List <SearchJobListViewModel> lstfeautredJobs = new List <SearchJobListViewModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel feautredJob = new SearchJobListViewModel
{
JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]),
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]),
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]),
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]),
City = Convert.ToString(dt.Rows[i]["City"]),
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]),
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]),
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]),
FeaturedJobDisplayOrder = (dt.Rows[i]["FeaturedJobDisplayOrder"] as int?) ?? 0,
};
lstfeautredJobs.Add(feautredJob);
}
return(lstfeautredJobs);
}
throw new DataNotFound("Data not found");
}
public List <SearchJobListViewModel> FreelancerJobs()
{
DataTable dt = _homeRepositories.FreelancerJobs();
if (dt.Rows.Count > 0)
{
List <SearchJobListViewModel> lstFreelancerJobs = new List <SearchJobListViewModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
string picpath = System.IO.Path.GetFullPath(hostingEnviroment.WebRootPath + dt.Rows[i]["CompanyLogo"]);
if (!System.IO.File.Exists(picpath))
{
string fName = $@"\ProfilePic\" + "Avatar_company.jpg";
dt.Rows[i]["CompanyLogo"] = fName;
}
SearchJobListViewModel freelancerJobs = new SearchJobListViewModel
{
JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]),
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]),
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]),
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]),
City = Convert.ToString(dt.Rows[i]["City"]),
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]),
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]),
CTC = Convert.ToString(dt.Rows[i]["CTC"]),
NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]),
};
lstFreelancerJobs.Add(freelancerJobs);
}
return(lstFreelancerJobs);
}
throw new DataNotFound("Data not found");
}
public List <SearchJobListViewModel> GetFeaturedJobs()
{
DataTable dt = _homeRepositories.GetFeaturedJobs();
List <SearchJobListViewModel> lstfeautredJobs = new List <SearchJobListViewModel>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel feautredJob = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "",
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "",
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "",
City = Convert.ToString(dt.Rows[i]["City"]) ?? "",
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "",
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "",
JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0,
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "",
FeaturedJobDisplayOrder = (dt.Rows[i]["FeaturedJobDisplayOrder"] as int?) ?? 0,
JobDetails = Convert.ToString(dt.Rows[i]["JobDetails"]) ?? "",
CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "",
NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? ""
};
lstfeautredJobs.Add(feautredJob);
}
}
return(lstfeautredJobs);
}
public List <SearchJobListViewModel> GetWalkInsJobs()
{
DataTable dt = _homeRepositories.GetWalkInJobs();
List <SearchJobListViewModel> lstWalkinJobs = new List <SearchJobListViewModel>();
try
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel WalkinJobs = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "",
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "",
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "",
City = Convert.ToString(dt.Rows[i]["City"]) ?? "",
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "",
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "",
JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0,
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "",
CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "",
NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? ""
};
lstWalkinJobs.Add(WalkinJobs);
}
}
}
catch
{
throw new DataNotFound("data not found!");
}
return(lstWalkinJobs);
}
public List <SearchJobListViewModel> GetJobseekerAppliedJobs(int userId)
{
DataTable dt = _userProfileRepository.GetJobseekerAppliedJobs(userId);
List <SearchJobListViewModel> lstAppliedJobs = new List <SearchJobListViewModel>();
try
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel AppliedJobs = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "",
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "",
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "",
City = Convert.ToString(dt.Rows[i]["City"]) ?? "",
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "",
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "",
JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0,
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "",
CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "",
NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? "",
CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"])
};
lstAppliedJobs.Add(AppliedJobs);
}
}
}
catch
{
throw new DataNotFound("data not found!");
}
return(lstAppliedJobs);
}
public List <SearchJobListViewModel> GetAllCompanyList()
{
DataTable dt = _homeRepositories.GetAllCompanyList();
List <SearchJobListViewModel> list = new List <SearchJobListViewModel>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel model = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]),
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]),
};
list.Add(model);
}
}
return(list);
}
public List <SearchJobListViewModel> GetWalkInsJobs()
{
DataTable dt = _homeRepositories.GetWalkInJobs();
List <SearchJobListViewModel> lstWalkinJobs = new List <SearchJobListViewModel>();
try
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string picpath = System.IO.Path.GetFullPath(hostingEnviroment.WebRootPath + dt.Rows[i]["CompanyLogo"]);
if (!System.IO.File.Exists(picpath))
{
string fName = $@"\ProfilePic\" + "Avatar_company.jpg";
dt.Rows[i]["CompanyLogo"] = fName;
}
SearchJobListViewModel WalkinJobs = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "",
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "",
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "",
City = Convert.ToString(dt.Rows[i]["City"]) ?? "",
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "",
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "",
JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0,
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "",
CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "",
NumberOfDays = Convert.ToString(dt.Rows[i]["NumberOfDays"]) ?? ""
};
lstWalkinJobs.Add(WalkinJobs);
}
}
}
catch
{
throw new DataNotFound("data not found!");
}
return(lstWalkinJobs);
}
public List <SearchJobListViewModel> JobSeekerJobsOnSkills(string skills, int UserId)
{
DataTable dt = _userProfileRepository.JobSeekerJobsOnSkills(skills, UserId);
List <SearchJobListViewModel> lstJobs = new List <SearchJobListViewModel>();
try
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string picpath = System.IO.Path.GetFullPath(_hostingEnviroment.WebRootPath + dt.Rows[i]["CompanyLogo"]);
if (!System.IO.File.Exists(picpath))
{
string fName = $@"\ProfilePic\" + "Avatar_company.jpg";
dt.Rows[i]["CompanyLogo"] = fName;
}
SearchJobListViewModel Jobs = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]) ?? "",
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]) ?? "",
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]) ?? "",
City = Convert.ToString(dt.Rows[i]["City"]) ?? "",
HiringCriteria = Convert.ToString(dt.Rows[i]["HiringCriteria"]) ?? "",
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]) ?? "",
JobPostId = (dt.Rows[i]["JobPostId"] as int?) ?? 0,
JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]) ?? "",
Skills = Convert.ToString(dt.Rows[i]["Skills"]) ?? "",
CTC = Convert.ToString(dt.Rows[i]["CTC"]) ?? "",
};
lstJobs.Add(Jobs);
}
}
}
catch
{
throw new DataNotFound("data not found!");
}
return(lstJobs);
}
public List <SearchJobListViewModel> NasscomJobs()
{
DataTable dt = _homeRepositories.NasscomJobsList();
List <SearchJobListViewModel> list = new List <SearchJobListViewModel>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SearchJobListViewModel model = new SearchJobListViewModel
{
CompanyLogo = Convert.ToString(dt.Rows[i]["CompanyLogo"]),
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]),
JobPostId = Convert.ToInt32(dt.Rows[i]["JobPostId"]),
JobTitle = Convert.ToString(dt.Rows[i]["JobTitle"]),
City = Convert.ToString(dt.Rows[i]["City"]),
EmploymentStatus = Convert.ToString(dt.Rows[i]["EmploymentStatus"]),
};
list.Add(model);
}
}
return(list);
}
