public List <Jobposteddetails> getJobposteddetails()
{
WebApiApplication._log.LogInfoFormat("DefaultController/getJobposteddetails");
List <Jobposteddetails> obj_jobposteddetails = new List <Jobposteddetails>();
var posteddetails = (from t_jobdetail in _jobdetails.jobdetails
join t_category in _jobdetails.lkpcategories on t_jobdetail.FK_CategoryID equals t_category.PK_CategoryID
join t_comapny in _jobdetails.lkpcompanies on t_jobdetail.FK_CompanyID equals t_comapny.PK_CompanyID
join t_location in _jobdetails.lkpcountries on t_jobdetail.FK_CountryID equals t_location.PK_CountryID
join t_state in _jobdetails.lkpStates on t_jobdetail.FK_StateID equals t_state.PK_StateID
join t_exper in _jobdetails.lkpexperiencetypes on t_jobdetail.FK_ExpericeID equals t_exper.PK_ExpericeID
join t_employement in _jobdetails.lkpemployement_type on t_jobdetail.FK_EmployementID equals t_employement.PK_EmployementID
where t_jobdetail.isactive == true && t_comapny.isactive == true && t_state.isactive == true && t_location.isactive == true && t_employement.isactive == true &&
t_exper.isactive == true
select new
{
t_category.Categoryname,
t_comapny.companyname,
t_employement.employementtype,
t_exper.experiencetype,
t_state.statename,
t_jobdetail.image,
t_jobdetail.minsalary,
t_jobdetail.maxsalary,
t_jobdetail.jobdesgination,
t_jobdetail.jobposteddate
}).ToList();
foreach (var postjob in posteddetails)
{
Jobposteddetails _Jobposteddetails = new Jobposteddetails();
_Jobposteddetails.companyname = postjob.companyname;
_Jobposteddetails.categoryname = postjob.Categoryname;
_Jobposteddetails.desgination = postjob.jobdesgination;
_Jobposteddetails.minsalary = postjob.minsalary;
_Jobposteddetails.maxsalary = postjob.maxsalary;
_Jobposteddetails.postedon = Convert.ToDateTime(postjob.jobposteddate);
_Jobposteddetails.location = postjob.statename;
_Jobposteddetails.experiencelevel = postjob.experiencetype;
_Jobposteddetails.employementtype = postjob.employementtype;
_Jobposteddetails.image = postjob.image.ToString();
obj_jobposteddetails.Add(_Jobposteddetails);
}
return(obj_jobposteddetails);
}
public List <Jobposteddetails> getJobsearchbuttondetails(string loc, string cat, [FromUri] string[] day, [FromUri] string[] etype, [FromUri] string[] elevel, [FromUri] string[] ecompany, [FromUri] string[] elocation, string esalary, string ecat)
{
List <Jobposteddetails> obj_jobposteddetails = new List <Jobposteddetails>();
var posteddetails = (from t_jobdetail in _jobdetails.jobdetails
join t_category in _jobdetails.lkpcategories on t_jobdetail.FK_CategoryID equals t_category.PK_CategoryID
join t_comapny in _jobdetails.lkpcompanies on t_jobdetail.FK_CompanyID equals t_comapny.PK_CompanyID
join t_location in _jobdetails.lkpcountries on t_jobdetail.FK_CountryID equals t_location.PK_CountryID
join t_state in _jobdetails.lkpStates on t_jobdetail.FK_StateID equals t_state.PK_StateID
join t_exper in _jobdetails.lkpexperiencetypes on t_jobdetail.FK_ExpericeID equals t_exper.PK_ExpericeID
join t_employement in _jobdetails.lkpemployement_type on t_jobdetail.FK_EmployementID equals t_employement.PK_EmployementID
where t_jobdetail.isactive == true && t_comapny.isactive == true && t_state.isactive == true && t_location.isactive == true && t_employement.isactive == true &&
t_exper.isactive == true
select new
{
t_category.Categoryname,
t_comapny.companyname,
t_employement.employementtype,
t_exper.experiencetype,
t_state.statename,
t_jobdetail.image,
t_jobdetail.minsalary,
t_jobdetail.maxsalary,
t_jobdetail.jobdesgination,
t_jobdetail.jobposteddate
}).ToList();
foreach (var postjob in posteddetails)
{
Jobposteddetails _Jobposteddetails = new Jobposteddetails();
_Jobposteddetails.companyname = postjob.companyname;
_Jobposteddetails.categoryname = postjob.Categoryname;
_Jobposteddetails.desgination = postjob.jobdesgination;
_Jobposteddetails.minsalary = postjob.minsalary;
_Jobposteddetails.maxsalary = postjob.maxsalary;
_Jobposteddetails.postedon = Convert.ToDateTime(postjob.jobposteddate);
_Jobposteddetails.location = postjob.statename;
_Jobposteddetails.experiencelevel = postjob.experiencetype;
_Jobposteddetails.employementtype = postjob.employementtype;
_Jobposteddetails.image = postjob.image.ToString();
_Jobposteddetails.statename = postjob.statename;
obj_jobposteddetails.Add(_Jobposteddetails);
}
if (elocation[0] == "all")
{
if (loc != null && loc != "" && loc != "all")
{
obj_jobposteddetails = obj_jobposteddetails.Where(x => loc.Contains(x.statename)).ToList();
}
}
else
{
string location = string.Empty;
for (int i = 0; i < elocation.Length; i++)
{
location += elocation[i] + ",";
}
if (loc != null && loc != "" && loc != "all")
{
if (!location.Contains(loc))
{
location += loc;
}
}
if (location != null && location != "")
{
obj_jobposteddetails = obj_jobposteddetails.Where(x => location.Contains(x.statename)).ToList();
}
}
if (ecompany[0] == "all")
{
}
else
{
string company = string.Empty;
for (int i = 0; i < ecompany.Length; i++)
{
company += ecompany[i] + ",";
}
if (company != null && company != "")
{
obj_jobposteddetails = obj_jobposteddetails.Where(x => company.Contains(x.companyname)).ToList();
}
}
string category = string.Empty;
if (cat != null && cat != "" && cat != "all")
{
category = cat;
}
if (category != null && category != "")
{
obj_jobposteddetails = obj_jobposteddetails.Where(x => category.Contains(x.categoryname)).ToList();
}
if (etype[0] == "all")
{
}
else
{
string employementtype = string.Empty;
for (int i = 0; i < etype.Length; i++)
{
employementtype += etype[i] + ",";
}
if (employementtype != null && employementtype != "")
{
obj_jobposteddetails = obj_jobposteddetails.Where(x => employementtype.Contains(x.employementtype)).ToList();
}
}
if (elevel[0] == "all")
{
}
else
{
string experience = string.Empty;
for (int i = 0; i < elevel.Length; i++)
{
experience += elevel[i] + ",";
}
if (experience != null && experience != "")
{
obj_jobposteddetails = obj_jobposteddetails.Where(x => experience.Contains(x.experiencelevel)).ToList();
}
}
int salary = 0;
if (esalary != null && esalary != "")
{
salary = int.Parse(esalary);
}
obj_jobposteddetails = obj_jobposteddetails.Where(x => x.minsalary >= salary).ToList();
DateTime posteddate = DateTime.Now;
if (day[0] == "all")
{
posteddate = DateTime.Now;
}
else
{
string date = string.Empty;
for (int i = 0; i < day.Length; i++)
{
date += day[i] + ",";
}
if (date.Contains("30 days"))
{
posteddate = posteddate.AddMonths(-1);
}
else if (date.Contains("7 days"))
{
posteddate = posteddate.AddDays(-7);
}
obj_jobposteddetails = obj_jobposteddetails.Where(x => x.postedon >= posteddate).ToList();
}
return(obj_jobposteddetails);
}
