public Boolean insertIncome(Income obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
db.Incomes.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean addSkillToRecruitee(Recruitee obj, String skillId)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Recruitee recruitee = db.Recruitees.SqlQuery("dbo.SelectRecruiteeById @RecruiteeId='" + obj.RecruiteeId.ToString() + "'").Single();
Skill skillAdd = db.Skills.SqlQuery("dbo.SelectSkillById @SkillId='" + skillId + "'").Single();
if (recruitee != null)
{
if (skillAdd != null)
{
recruitee.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 deleteIncome(Income obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Income Income = db.Incomes.SqlQuery("dbo.SelectIncomeById @IncomeId='" + obj.IncomeId.ToString() + "'").Single();
if (Income != null)
{
db.Incomes.Remove(Income);
#region Database Submission
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 (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
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 deleteRanking(Ranking obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Ranking ranking = db.Rankings.SqlQuery("dbo.SelectRankingById @RankingId='" + obj.RankingId.ToString() + "'").Single();
if (ranking != null)
{
db.Rankings.Remove(ranking);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean deleteEducation(Education obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Education edu = db.Educations.SqlQuery("dbo.SelectEducationById @EducationId='" + obj.EducationId.ToString() + "'").Single();
if (edu != null)
{
db.Educations.Remove(edu);
#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 (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
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 updateRecruitee(Recruitee obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Recruitee recruitee = db.Recruitees.SqlQuery("dbo.SelectRecruiteeById @RecruiteeId='" + obj.RecruiteeId.ToString() + "'").Single();
if (recruitee != null)
{
recruitee.RankingId = obj.RankingId;
recruitee.RankingValue = obj.RankingValue;
recruitee.Email = obj.Email;
recruitee.FirstName = obj.FirstName;
recruitee.LastName = obj.LastName;
recruitee.Gender = obj.Gender;
recruitee.AgeId = obj.AgeId;
recruitee.EducationId = obj.EducationId;
recruitee.IncomeId = obj.IncomeId;
#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 updateSkill(Skill obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Skill skill = db.Skills.SqlQuery("dbo.SelectSkillById @Skill='" + 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;
}
}
}