public async Task <Result <PersonContactView> > Handle(GetPersonContactViewCommand request, CancellationToken cancellationToken)
{
using (_unitOfWork)
{
try
{
var result = await _unitOfWork.Repository <PersonContactView>()
.Get(x => x.PersonId == request.personId).FirstOrDefaultAsync();
return(Result <PersonContactView> .Valid(result));
}
catch (Exception e)
{
Log.Error(e.Message);
return(Result <PersonContactView> .Invalid(e.Message));
}
}
}
public async Task <Result <PersonContactView> > Handle(GetPersonContactViewCommand request, CancellationToken cancellationToken)
{
using (_unitOfWork)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append("exec pr_OpenDecryptedSession;");
sql.Append($"SELECT * FROM PersonContactView WHERE PersonId = {request.personId} AND DeleteFlag = 0; ");
sql.Append("exec [dbo].[pr_CloseDecryptedSession];");
var result = await _unitOfWork.Repository <PersonContactView>().FromSql(sql.ToString());
return(Result <PersonContactView> .Valid(result.FirstOrDefault()));
}
catch (Exception e)
{
Log.Error(e.Message);
return(Result <PersonContactView> .Invalid(e.Message));
}
}
}
