public async Task UserSkillDelete(User_Skill userSkill) { try { var result = await connection.QueryAsync <int>( SpName.UserSkillDelete, new { userID = userSkill.UserId, skillID = userSkill.SkillId }, dbTransaction, commandType : CommandType.StoredProcedure ); Convert.ToInt32(result.FirstOrDefault()); } catch (SqlException ex) { throw ex; } }
//метод сделан для работы тестов public async Task <bool> IsUserSkillPresent(User_Skill userSkill) { List <User_Skill> result; try { result = connection.Query <User_Skill>( SpName.UserSkillSelect, new { userID = userSkill.UserId, skillID = userSkill.SkillId }, dbTransaction, commandType: CommandType.StoredProcedure ).ToList(); } catch (SqlException ex) { throw ex; } if (result.Count == 1 && result[0].UserId == userSkill.UserId && result[0].SkillId == userSkill.SkillId) { return(true); } return(false); }
[Route("user-skill/{userId}")] //Добавить Skill пользователю public async Task UserSkillAdd([FromBody] User_Skill model) { await userStorage.UserSkillAdd(model); }