public async Task <GetAccountByEmailPasswordResponseDTO> GetAccountByUsernamePassword(GetAccountByEmailPasswordRequestDTO accountRequest)
{
return(await _accountService.GetAccountByEmailPassword(accountRequest));
}
public async Task <GetAccountByEmailPasswordResponseDTO> GetAccountByEmailPassword(GetAccountByEmailPasswordRequestDTO accountrequestDTO)
{
try
{
return(await _unitOfWokDapper.AccountQueries.GetAccountByEmailPassword(accountrequestDTO));
}
catch (Exception ex)
{
_logger.LogExceptionError(ex.ToString());
throw ex;
}
}
public async Task <GetAccountByEmailPasswordResponseDTO> GetAccountByEmailPassword(GetAccountByEmailPasswordRequestDTO accountrequestDTO)
{
var query = @$ "
SELECT A.*
FROM Account A
WHERE Email = @Email
AND Password = @Password
AND IsActive = @IsActive";
DynamicParameters param = new DynamicParameters();
param.Add("@Email", accountrequestDTO.Email);
param.Add("@Password", accountrequestDTO.Password);
param.Add("@IsActive", true);
return(await _db.QuerySingleOrDefaultAsync <GetAccountByEmailPasswordResponseDTO>(sql : query, param : param, commandType : CommandType.Text));
}
