Ejemplo n.º 1
0
        public int DeleteSkill(int key)
        {
            TblSkillMaster skill = dbContext.TblSkillMaster.Where(x => x.SkillId == key).FirstOrDefault();

            skill.IsActive = false;
            dbContext.TblSkillMaster.Update(skill);
            return(dbContext.SaveChanges());
        }
Ejemplo n.º 2
0
        public int UpdateSkill(TblSkillMaster tblSkill)
        {
            if (dbContext.TblSkillMaster.Where(r => r.SkillName.ToUpper() == tblSkill.SkillName.ToUpper() && r.SkillId != tblSkill.SkillId && r.IsActive == true).Count() > 0)
            {
                return(-1);
            }
            tblSkill.IsActive = true;
            dbContext.Entry(tblSkill).State = EntityState.Modified;
            dbContext.TblSkillMaster.Update(tblSkill);
            int result = dbContext.SaveChanges();

            dbContext.Entry(tblSkill).State = EntityState.Detached;
            return(result);
        }
Ejemplo n.º 3
0
 public int UpdateSkill(TblSkillMaster tblSkill)
 {
     return(MastersDAL.UpdateSkill(tblSkill));
 }
Ejemplo n.º 4
0
 public int CreateSkill(TblSkillMaster tblSkill)
 {
     return(MastersDAL.CreateSkill(tblSkill));
 }
Ejemplo n.º 5
0
        public IActionResult Skill(int id, [FromBody] TblSkillMaster tblSkill)
        {
            int result = _imasters.UpdateSkill(tblSkill);

            return(Ok(result));
        }
Ejemplo n.º 6
0
        public IActionResult Skill(int id)
        {
            TblSkillMaster result = _imasters.GetSkillByCriteria(id);

            return(Ok(result));
        }