public List<Compensation> selectAllCompensation()
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Database.SqlQuery(typeof(Compensation), "dbo.SelectAllCompensation").Cast<Compensation>().ToList();
}
catch (Exception ex)
{
return null;
}
}
public List<Skill> selectAllSkill()
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Database.SqlQuery(typeof(Skill), "dbo.SelectAllSkill").Cast<Skill>().ToList();
}
catch (Exception ex)
{
return null;
}
}
public List<Employer> selectAllEmployer()
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Database.SqlQuery(typeof(Employer), "dbo.SelectAllEmployer").Cast<Employer>().ToList();
}
catch (Exception ex)
{
return null;
}
}
public List<Category> selectAllCategory()
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Database.SqlQuery(typeof(Category), "dbo.SelectAllCategory").Cast<Category>().ToList();
}
catch (Exception ex)
{
return null;
}
}
public Skill selectSkillById(Skill obj)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Skills.SqlQuery("dbo.SelectSkillById @SkillId='" + obj.SkillId.ToString() + "'").Single();
}
catch (Exception ex)
{
return null;
}
}
public Employer selectEmployerById(Employer obj)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Employers.SqlQuery("dbo.SelectEmployerById @EmployerId='" + obj.EmployerId.ToString() + "'").Single();
}
catch (Exception ex)
{
return null;
}
}
public Category selectCategoryById(Category obj)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Categories.SqlQuery("dbo.SelectCategoryById @CategoryId='" + obj.CategoryId.ToString() + "'").Single();
}
catch (Exception ex)
{
return null;
}
}
public Compensation selectCompensationById(Compensation obj)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Compensations.SqlQuery("dbo.SelectCompensationById @CompensationId='" + obj.CompensationId.ToString() + "'").Single();
}
catch (Exception ex)
{
return null;
}
}
public Boolean insertCategory(Category obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
db.Categories.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean insertSkill(Skill obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
db.Skills.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean insertCompensation(Compensation obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
db.Compensations.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
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 deleteSkill(Skill obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Skill skill = db.Skills.SqlQuery("dbo.SelectSkillById @SkillId='" + obj.SkillId.ToString() + "'").Single();
if (skill != null)
{
db.Skills.Remove(skill);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean deleteEmployer(Employer obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Employer employer = db.Employers.SqlQuery("dbo.SelectEmployerById @EmployerId='" + obj.EmployerId.ToString() + "'").Single();
if (employer != null)
{
db.Employers.Remove(employer);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean deleteCategory(Category obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Category category = db.Categories.SqlQuery("dbo.SelectCategoryById @CategoryId='" + obj.CategoryId.ToString() + "'").Single();
if (category != null)
{
db.Categories.Remove(category);
#region Database Submission
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 deleteCompensation(Compensation obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Compensation compensation = db.Compensations.SqlQuery("dbo.SelectCompensationById @CompensationId='" + obj.CompensationId.ToString() + "'").Single();
if (compensation != null)
{
db.Compensations.Remove(compensation);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean updateSkill(Skill obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Skill skill = db.Skills.SqlQuery("dbo.SelectSkillById @SkillId='" + obj.SkillId.ToString() + "'").Single();
if (skill != null)
{
skill.SkillName = obj.SkillName;
skill.SkillDescription = obj.SkillDescription;
#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 updateCategory(Category obj)
{
using (NewJobBankContext db = new NewJobBankContext())
{
try
{
Category category = db.Categories.SqlQuery("dbo.SelectCategoryById @CategoryId='" + obj.CategoryId.ToString() + "'").Single();
if (category != null)
{
category.CategoryName = obj.CategoryName;
category.CategoryDescription = obj.CategoryDescription;
#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 double[] selectExpressionDifficulty()
{
NewJobBankContext db = new NewJobBankContext();
decimal[] res = ((from a in db.Jobs
orderby a.JobDescription
select a.JobExperienceLevel).ToArray());
double[] arr = new double[res.Length];
for(int i=0; i<res.Length; i++)
{
arr[i] = (double)res[i];
}
return arr;
}
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 List<Job> selectJobNotDoneByRecruiteeIdRecommendation(String recruiteeId)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Database.SqlQuery(typeof(Job), "dbo.SelectJobNotDoneByRecruiteeIdRecommendation @RecruiteeId='" + recruiteeId + "'").Cast<Job>().ToList();
}
catch (Exception ex)
{
return null;
}
}
public List<Job> selectJobBySkillId(String skillId)
{
NewJobBankContext db = new NewJobBankContext();
try
{
return db.Database.SqlQuery(typeof(Job), "dbo.SelectJobBySkillId @SkillId='" + skillId + "'").Cast<Job>().ToList();
}
catch (Exception ex)
{
return null;
}
}
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 Guid[] selectExpressionNames()
{
NewJobBankContext db = new NewJobBankContext();
return ((from a in db.Jobs
orderby a.JobDescription
select a.JobId).ToArray());
}
