public Boolean HireSeekerFor(Seeker s, Job j)
{
if (s != null && j != null)
{
var v = from job in db.TabJobApplications
where job.Applicant == s.Username && job.JId == GetJobIdByTitle(j.Title)
select job;
TabJobApplication tab = v.First();
tab.Status = "Hired";
db.SubmitChanges();
var w = from sek in db.TabSeekers
where sek.uname == s.Username
select sek;
SendMailTo(w.First().email, "Congratulations!", "You have been seleced for the job: " + j.Title, new Admin());
return(true);
}
else
{
return(false);
}
}
public Boolean DeleteJob(Job job)
{
if (job != null)
{
var v = from j in db.TabJobs
where j.JId == Convert.ToInt32(GetJobIdByTitle(job.Title))
select j;
var w = from k in db.TabJobApplications
where k.JId == GetJobIdByTitle(job.Title)
select k;
var x = from l in db.TabJobSkills
where l.JId == Convert.ToInt32(GetJobIdByTitle(job.Title))
select l;
if (v.Count() == 1)
{
TabJob tab = v.First();
db.TabJobs.DeleteOnSubmit(tab);
if (x != null)
{
foreach (var item in x)
{
TabJobSkill tabSkill = item;
db.TabJobSkills.DeleteOnSubmit(tabSkill);
}
}
if (w != null)
{
foreach (var item in w)
{
TabJobApplication tabApp = item;
db.TabJobApplications.DeleteOnSubmit(tabApp);
}
}
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public Boolean DeleteJobApplication(Seeker s, Job j)
{
if (s != null && j != null)
{
var v = from application in db.TabJobApplications
where application.Applicant == s.Username && application.JId == GetJobIdByTitle(j.Title)
select application;
TabJobApplication app = v.First();
db.TabJobApplications.DeleteOnSubmit(app);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
public Boolean AddJobApplicationDetails(Job job, Seeker sek)
{
if (job != null && sek != null && CheckUserStatus(sek))
{
var v = from m in db.TabJobApplications
where m.JId == this.GetJobIdByTitle(job.Title) && m.Applicant == sek.Username
select m;
var p = from q in db.TabJobs
where q.JId == Convert.ToInt32(GetJobIdByTitle(job.Title))
select q;
if (v.Count() == 0)
{
TabJobApplication application = new TabJobApplication();
application.JId = this.GetJobIdByTitle(job.Title);
application.Applicant = sek.Username;
application.JTitle = job.Title;
application.PostedBy = p.First().PostedBy;
db.TabJobApplications.InsertOnSubmit(application);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}