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