public static SkillDto createSkillDTO(Skill obj) { SkillDto skill = new SkillDto(); skill.SkillId = obj.SkillId; skill.SkillName = obj.SkillName; skill.SkillDescription = obj.SkillDescription; return skill; }
public static Skill createSkill(String SkillId, String SkillName, String SkillDescription) { Skill obj = new Skill(); obj.SkillId = SkillId; obj.SkillName = SkillName; obj.SkillDescription = SkillDescription; return obj; }
public Skill selectSkillById(Skill obj) { try { ISkillSvc svc = (ISkillSvc)this.getService(typeof(ISkillSvc).Name); return svc.selectSkillById(obj); } catch (ServiceLoadException ex) { return null; } }
public Boolean deleteSkill(Skill obj) { try { ISkillSvc svc = (ISkillSvc)this.getService(typeof(ISkillSvc).Name); return svc.deleteSkill(obj); } catch (ServiceLoadException ex) { return false; } }
public Skill selectSkillById(Skill obj) { NewRecruiteeBankContext db = new NewRecruiteeBankContext(); try { return db.Skills.SqlQuery("dbo.SelectSkillById @SkillId='" + obj.SkillId.ToString() + "'").Single(); } catch (Exception ex) { return null; } }
public Boolean insertSkill(Skill obj) { using (NewRecruiteeBankContext db = new NewRecruiteeBankContext()) { try { db.Skills.Add(obj); db.SaveChanges(); return true; } 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 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; } } }