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