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; } } }