// (SqlCommand)Database1Entities.GetCommand(jobs);
//var joblist=jobs.ToList();
//var sqlString = jobs.ToString();
//return sqlString;
// IQueryable<JobPost> jobs1 = jobs;
//if (jobs1.Any()) {
/// jobs1 = jobs1.Select(b => b.Id()).ToList();
// return jobs1;
//}
//string a = o.JobPosts.Find(location);
// return a;
// return jobs1;
//return;
//}
public void insertJob()
{
Database1Entities o = new Database1Entities();
JobPost j = new JobPost();
j.Title = "Android developer";
j.Designation = "android dev";
j.Department = "CS";
j.Id = 1;
j.Locationn = "lahore";
j.jobTyoe = "asd";
j.RequiredSkills = "abc";
j.Salary = 1231456;
j.StartTime = "12-21-19";
o.JobPosts.Add(j);
o.SaveChanges();
}
public List <JobPost> searchRelevantJob(String skills, String location, String category)
{
Database1Entities o = new Database1Entities();
JobPost j = new JobPost();
j.Locationn = "lahore";
j.RequiredSkills = "java";
j.Designation = "Android developer";
j.jobTyoe = "full";
j.Salary = 1200;
j.StartTime = "9am";
j.EndTime = "6am";
j.Title = "Software Engineeer";
o.JobPosts.Add(j);
o.SaveChanges();
using (Database1Entities context = new Database1Entities())
{
return((from x in context.JobPosts
where x.Locationn == (location) && x.RequiredSkills == (skills)
select x).ToList());
// return context.JobPosts.Where(b ==> b.Location.)
// Query for all blogs with names starting with B
// var jobs = from b in context.JobPosts
// where b.Locationn.Equals(location) && b.RequiredSkills.Equals(skills) && b.Department.Equals(category)
// select b.Id;
}
//using (Database1Entities context = new Database1Entities())
//{
// var query = from x in
}