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()); }
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); }
public int UpdateSkill(TblSkillMaster tblSkill) { return(MastersDAL.UpdateSkill(tblSkill)); }
public int CreateSkill(TblSkillMaster tblSkill) { return(MastersDAL.CreateSkill(tblSkill)); }
public IActionResult Skill(int id, [FromBody] TblSkillMaster tblSkill) { int result = _imasters.UpdateSkill(tblSkill); return(Ok(result)); }
public IActionResult Skill(int id) { TblSkillMaster result = _imasters.GetSkillByCriteria(id); return(Ok(result)); }