public ITeste ObterDescricaoV2(Guid codigo)
{
var sqlQuery = (@"select Codigo, DataCadastro, Descricao from Teste where Codigo = '" + codigo + "'");
var descricao = _context.Teste.FromSql(sqlQuery).AsNoTracking().SingleOrDefault();
//IDEAL
//var param = new SqlParameter
//{
// ParameterName = "codigoTeste",
// DbType = DbType.Guid,
// Value = codigo,
// SqlValue = codigo
//};
//var descricao = _context.Teste.FromSql(
// @"select Codigo, DataCadastro, Descricao from Teste where Codigo = @codigoTeste"
// , param).AsNoTracking().SingleOrDefault();
if (descricao == null)
{
ValidationResult validationResult = _validatorFactory.CreateValidationResult();
validationResult.AddValidationError("DescricaoNaoLocalizada", Mensagens.DescricaoNaoLocalizada);
throw new NotFoundCoreException(validationResult);
}
return(descricao);
}
/// <summary>
/// Execute the validation rule
/// </summary>
/// <param name="entity">Entity on which this validation rule is implemented</param>
/// <param name="result">Validaiont result that is built with the rule</param>
/// <returns>Wheter the rule is OK or not</returns>
public bool Run(TEntity entity, ValidationResult result)
{
if (_rule(entity))
{
return(false);
}
result.AddValidationError(Name, Message);
return(true);
}
public ValidationResult Validate(Target target)
{
ValidationResult validationResult = new ValidationResult();
if (target == null)
{
validationResult.AddValidationError(string.Empty, "Objeto é nulo");
return(validationResult);
}
var fluent = validator.Validate(target);
foreach (var item in fluent.Errors)
{
validationResult.AddValidationError(item.PropertyName, item.ErrorMessage);
}
return(validationResult);
}
public ITeste ObterDescricaoV1(Guid codigo)
{
var descricao = (from e in _context.Teste
where e.Codigo == codigo
select e).FirstOrDefault();
if (descricao == null)
{
ValidationResult validationResult = _validatorFactory.CreateValidationResult();
validationResult.AddValidationError("DescricaoNaoLocalizada", Mensagens.DescricaoNaoLocalizada);
throw new NotFoundCoreException(validationResult);
}
return(descricao);
}
public Interfaces.Aggregates.ITeste ObterDescricaoV2(DescricaoGet descricaoGet)
{
try
{
var descricao = _mensagemRepository.ObterDescricaoV2(descricaoGet.Codigo);
return(_aggregateFactory.CarregarDescricao(descricao.Descricao));
}
catch (CoreException ex)
{
ValidationResult validationResult = _validationFactory.CreateValidationResult();
validationResult.AddValidationError("ObterDescricao", ex.Message);
throw new CoreException(validationResult);
}
}
