public Boolean removeSkillFromJob(Job obj, String skillId)
{
try
{
IJobSvc svc = (IJobSvc)this.getService(typeof(IJobSvc).Name);
return svc.removeSkillFromJob(obj, skillId);
}
catch (Exception ex)
{
return false;
}
}
public Boolean deleteJob(Job obj)
{
try
{
IJobSvc svc = (IJobSvc)this.getService(typeof(IJobSvc).Name);
return svc.deleteJob(obj);
}
catch (ServiceLoadException ex)
{
return false;
}
}
public static JobDto createJobDTO(Job obj)
{
JobDto job = new JobDto();
job.JobId = obj.JobId;
job.JobName = obj.JobName;
job.CompensationId = obj.CompensationId;
job.EmployerId = obj.EmployerId;
job.JobDescription = obj.JobDescription;
job.JobQuota = obj.JobQuota;
job.JobExperienceLevel = (double)obj.JobExperienceLevel;
job.JobCompensationValue = (double)obj.JobCompensationValue;
return job;
}
public Boolean addSkillToJob(Job obj, String skillId)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Job Job = db.Jobs.SqlQuery("dbo.SelectJobById @JobId='" + obj.JobId.ToString() + "'").Single();
Skill skillAdd = db.Skills.SqlQuery("dbo.SelectSkillById @SkillId='" + skillId + "'").Single();
if (Job != null)
{
if (skillAdd != null)
{
Job.Skills.Add(skillAdd);
}
#region Database Submission with Rollback
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean deleteJob(Job obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Job job = db.Jobs.SqlQuery("dbo.SelectJobById @JobId='" + obj.JobId.ToString() + "'").Single();
if (job != null)
{
db.Jobs.Remove(job);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean insertJob(Job obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
db.Jobs.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean updateJob(Job obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Job job = db.Jobs.SqlQuery("dbo.SelectJobById @JobId='" + obj.JobId.ToString() + "'").Single();
if (job != null)
{
job.JobName = obj.JobName;
job.CompensationId = obj.CompensationId;
job.EmployerId = obj.EmployerId;
job.JobDescription = obj.JobDescription;
job.JobQuota = obj.JobQuota;
job.JobExperienceLevel = obj.JobExperienceLevel;
job.JobCompensationValue = obj.JobCompensationValue;
#region Database Submission with Rollback
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Job selectJobById(Job obj)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Jobs.SqlQuery("dbo.SelectJobById @JobId='" + obj.JobId.ToString() + "'").Single();
}
catch (Exception ex)
{
return null;
}
}
public Job selectJobById(Job obj)
{
try
{
IJobSvc svc = (IJobSvc)this.getService(typeof(IJobSvc).Name);
return svc.selectJobById(obj);
}
catch (ServiceLoadException ex)
{
return null;
}
}
public static Job createJob(System.Guid JobId, String JobName, String CompensationId, System.Guid EmployerId,
String JobDescription, int JobQuota, decimal JobExperienceLevel, decimal JobCompensationValue)
{
Job obj = new Job();
obj.JobId = JobId;
obj.JobName = JobName;
obj.CompensationId = CompensationId;
obj.EmployerId = EmployerId;
obj.JobDescription = JobDescription;
obj.JobQuota = JobQuota;
obj.JobExperienceLevel = JobExperienceLevel;
obj.JobCompensationValue = JobCompensationValue;
return obj;
}
