public ActionResult ListAllJobPost( )
{
ListOfJobPost listofpost = new ListOfJobPost();
List <JobLocDetViewModel> loc = (from l in db.Cities
join j in db.JobLocDets
on l.Id equals j.CityID
select new JobLocDetViewModel
{
Id = j.CityID,
CityName = l.CityName,
JobPostId = j.JobPostId
}).ToList();
List <JobSkillDetViewModel> Skill = (from S in db.Skills
join j in db.JobPostSkills
on S.id equals j.SkillId
select new JobSkillDetViewModel
{
Id = j.SkillId,
SkillName = S.SkillName,
JobPostId = j.JobPostId
}).ToList();
List <JobPost> jbp = db.JobPosts.ToList();
listofpost.city = loc;
listofpost.jobPostSkill = Skill;
//listofpost.jobPgDets = Pgdet;
listofpost.JobPost = jbp;
return(View(listofpost));
}
public ActionResult RelatedJob(int Id)
{
ListOfJobPost listofpost = new ListOfJobPost();
List <JobPostFieldsViewModel> jbp = (from j in db.JobPosts
join f in db.FunctionalAreas
on j.FunctionalAreaId equals f.Id
join i in db.IndustryTypes
on j.IndustryId equals i.Id
join r in db.Roles
on j.RoleId equals r.Id
join c in db.Companies
on j.CompanyId equals c.Id
where j.Id == Id
select new JobPostFieldsViewModel
{
Id = j.Id,
JobTittle = j.JobTittle,
ExpFrom = j.ExpFrom,
ExpTo = j.ExpTo,
CTCFrom = j.CTCFrom,
CTCTo = j.CTCTo,
Description = j.Description,
FunctionalAreaName = f.FunctionalAreaName,
BusinessStreamName = i.BusinessStreamName,
RoleType = r.RoleType,
CompanyName = c.CompanyName,
AboutCompany = c.AboutCompany,
NoOfvacancies = j.NoOfvacancies,
RoleId = r.Id,
FunctionalAreaId = j.FunctionalAreaId,
Requirement = j.Requirement,
ContactPerson = c.ContactPerson,
SpecifyDoc = j.SpecifyDoc,
CompanyPresentation = c.CompanyPresentation,
ComapnyWebsite = c.ComapnyWebsite
}).ToList();
listofpost.JobPostfields = jbp;
List <JobLocDetViewModel> loc = (from l in db.Cities
join j in db.JobLocDets
on l.Id equals j.CityID
where j.JobPostId == Id
select new JobLocDetViewModel
{
Id = j.CityID,
CityName = l.CityName,
JobPostId = j.JobPostId
}).ToList();
listofpost.city = loc;
List <JobSkillDetViewModel> Skill = (from S in db.Skills
join j in db.JobPostSkills
on S.id equals j.SkillId
where j.JobPostId == Id
select new JobSkillDetViewModel
{
Id = j.SkillId,
SkillName = S.SkillName,
JobPostId = j.JobPostId
}).ToList();
listofpost.jobPostSkill = Skill;
List <UGViewModel> ug = (from u in db.UGs
join j in db.JobUgDets
on u.Id equals j.UgId
where j.JobPostId == Id
select new UGViewModel
{
value = j.UgId,
text = u.UQqualification
}).ToList();
listofpost.JobUgDet = ug;
List <PGViewModel> pg = (from p in db.PGs
join j in db.JobPgDets
on p.Id equals j.PGiD
where j.JobPostId == Id
select new PGViewModel
{
value = j.PGiD,
text = p.PGQualification
}).ToList();
listofpost.jobPgDets = pg;
//return View(listofpost);
return(Json(listofpost, JsonRequestBehavior.AllowGet));
}
public ActionResult ListOfJobPost(int id)
{
ListOfJobPost listofpost = new ListOfJobPost();
List <JobPostFieldsViewModel> jbp = (from j in db.JobPosts
join f in db.FunctionalAreas
on j.FunctionalAreaId equals f.Id
join i in db.IndustryTypes
on j.IndustryId equals i.Id
join r in db.Roles
on j.RoleId equals r.Id
join c in db.Companies
on j.CompanyId equals c.Id
where j.Id == id
select new JobPostFieldsViewModel
{
Id = j.Id,
JobTittle = j.JobTittle,
ExpFrom = j.ExpFrom,
ExpTo = j.ExpTo,
CTCFrom = j.CTCFrom,
CTCTo = j.CTCTo,
Description = j.Description,
FunctionalAreaName = f.FunctionalAreaName,
BusinessStreamName = i.BusinessStreamName,
RoleType = r.RoleType,
CompanyName = c.CompanyName,
AboutCompany = c.AboutCompany
}).ToList();
// db.JobPosts.Where(a => a.Id == id).ToList();
listofpost.JobPostfields = jbp;
List <JobLocDetViewModel> loc = (from l in db.Cities
join j in db.JobLocDets
on l.Id equals j.CityID
where j.JobPostId == id
select new JobLocDetViewModel
{
Id = j.CityID,
CityName = l.CityName,
JobPostId = j.JobPostId
}).ToList();
listofpost.city = loc;
List <JobSkillDetViewModel> Skill = (from S in db.Skills
join j in db.JobPostSkills
on S.id equals j.SkillId
where j.JobPostId == id
select new JobSkillDetViewModel
{
Id = j.SkillId,
SkillName = S.SkillName,
JobPostId = j.JobPostId
}).ToList();
listofpost.jobPostSkill = Skill;
List <UGViewModel> ug = (from u in db.UGs
join j in db.JobUgDets
on u.Id equals j.UgId
where j.JobPostId == id
select new UGViewModel
{
value = j.UgId,
text = u.UQqualification
}).ToList();
listofpost.JobUgDet = ug;
List <PGViewModel> pg = (from p in db.PGs
join j in db.JobPgDets
on p.Id equals j.PGiD
where j.JobPostId == id
select new PGViewModel
{
value = j.PGiD,
text = p.PGQualification
}).ToList();
listofpost.jobPgDets = pg;
return(View(listofpost));
}
