public int SaveSkill(ApplicantSkill skill)
{
using (var entities = new atmEntities())
{
var exist = (from a in entities.tblApplicantSkills where a.ApplicantId == skill.ApplicantId && a.SkillCd == skill.SkillCd select a).SingleOrDefault();
if (exist != null)
{
skill.ApplicantSkillId = exist.ApplicantSkillId;
return UpdateSkill(skill);
}
if (skill.ApplicantSkillId != 0) { return UpdateSkill(skill); }
var s = new tblApplicantSkill
{
AchievementCd = skill.AchievementCd,
ApplicantId = skill.ApplicantId,
CreatedBy = skill.CreatedBy,
CreatedDt = skill.CreatedDt,
LanguageSkillSpeak = skill.LanguageSkillSpeak,
LanguageSkillWrite = skill.LanguageSkillWrite,
Others = skill.Others,
SkillCatCd = !string.IsNullOrWhiteSpace(skill.SkillCatCd) ? skill.SkillCatCd.Trim() : skill.SkillCatCd,
SkillCd = !string.IsNullOrWhiteSpace(skill.SkillCd) ? skill.SkillCd.Trim() : skill.SkillCd
};
entities.tblApplicantSkills.Add(s);
if (entities.SaveChanges() > 0)
return s.ApplicantSkillId;
}
return 0;
}
public int UpdateSkill(ApplicantSkill skill)
{
using (var entities = new atmEntities())
{
var exist = (from a in entities.tblApplicantSkills where a.ApplicantSkillId == skill.ApplicantSkillId select a).SingleOrDefault();
if (exist != null)
{
exist.AchievementCd = skill.AchievementCd;
exist.ApplicantId = skill.ApplicantId;
exist.LastModifiedBy = skill.LastModifiedBy;
exist.LastModifiedDt = skill.LastModifiedDt;
exist.LanguageSkillSpeak = skill.LanguageSkillSpeak;
exist.LanguageSkillWrite = skill.LanguageSkillWrite;
exist.Others = skill.Others;
exist.SkillCatCd = !string.IsNullOrWhiteSpace(skill.SkillCatCd) ? skill.SkillCatCd.Trim() : skill.SkillCatCd;
exist.SkillCd = !string.IsNullOrWhiteSpace(skill.SkillCd) ? skill.SkillCd.Trim() : skill.SkillCd;
entities.SaveChanges();
return exist.ApplicantSkillId;
}
}
return 0;
}
public IEnumerable<ApplicantSkill> GetSkill(int applicantid)
{
var list = new List<ApplicantSkill>();
using (var entities = new atmEntities())
{
var l = from a in entities.tblApplicantSkills where a.ApplicantId == applicantid select a;
if (l.Any())
{
foreach (var s in l)
{
var apps = new ApplicantSkill
{
AchievementCd = s.AchievementCd,
CreatedBy = s.CreatedBy,
CreatedDt = s.CreatedDt,
LastModifiedBy = s.LastModifiedBy,
LastModifiedDt = s.LastModifiedDt,
ApplicantId = s.ApplicantId,
ApplicantSkillId = s.ApplicantSkillId,
LanguageSkillSpeak = s.LanguageSkillSpeak,
LanguageSkillWrite = s.LanguageSkillWrite,
Others = s.Others,
Skill = s.tblREFSkill.Skill,
SkillCatCd = !string.IsNullOrWhiteSpace(s.SkillCatCd) ? s.SkillCatCd.Trim() : s.SkillCatCd,
SkillCd = !string.IsNullOrWhiteSpace(s.SkillCd) ? s.SkillCd.Trim() : s.SkillCd
};
if (!string.IsNullOrWhiteSpace(apps.SkillCd) && s.tblREFSkill != null)
apps.Skill = s.tblREFSkill.Skill;
list.Add(apps);
}
}
}
return list;
}