public UserLoginResponseDto findUser(UserLoginDto userLoginDto, string type)
{
string email = userLoginDto.Email;
string password = userLoginDto.Password;
int id;
UserDto user = null;
using (var connection = factory.CreateConnection())
{
var command = mCommand.GetCommand(connection);
command.CommandText = $"select * from compte where username = '******' and password = '******' and type='{type}'";
using (DbDataReader reader = command.ExecuteReader())
{
if (!reader.HasRows)
{
UserLoginResponseDto response = new UserLoginResponseDto(false, null);
return(response);
}
else
{
while (reader.Read())
{
id = Int16.Parse(reader["id"].ToString());
user = findUserById(id);
}
return(new UserLoginResponseDto(true, user));
}
}
}
}
public async void Login()
{
var authorization = "Basic YUBhLmM6MTIz";
var token = "fakeToken";
var login = "******";
var password = "******";
var userResponse = new UserLoginResponseDto(token);
var httpContext = new DefaultHttpContext();
httpContext.Request.Headers["Authorization"] = authorization;
var mockAuthService = new Mock <IAuthService>();
mockAuthService.Setup(m => m.Login(login, password)).ReturnsAsync(userResponse);
var authController = new AuthController(mockAuthService.Object);
authController.ControllerContext = new ControllerContext {
HttpContext = httpContext
};
var userResponseReturned = await authController.Login();
Assert.Equal(userResponse, userResponseReturned.Value);
}
public UsersDto GetSingle(UserLoginRequestDto request)
{
try
{
var ReturnData = new UserLoginResponseDto();
var EncryptPass = PasswordHelper.EncryptData(request.Password);
#region DynamicQuerryParameters
var list = DynamicQuerryParameters.Create();
list.Add(DynamicQuerryParameters.AddParameter("UserName", request.UserName, DbType.String));
list.Add(DynamicQuerryParameters.AddParameter("Password", EncryptPass, DbType.String));
list.Add(DynamicQuerryParameters.AddParameter("ActivationStatus", (int)ActivationStatusType.Active, DbType.Int16));
#endregion
var querry = QueryGenerator.GenerateQuery(list, QueryGenerator.tableName <UserEntity>());
var result = Db.GetSingleData <UserEntity>(querry);
if (result != null)
{
ReturnData = result.ConvertTo <UserLoginResponseDto>();
ReturnData.TokenKey = Authentication.CreateTokenAuthentication(result.Id);
}
return(ReturnData);
}
catch (KnownException ex)
{
throw ex;
}
catch (Exception ex)
{
Logger.AddLog(LogTypeEnum.Error, "UserManager.GetSingle", null, ex.Message, request.ToJson(), ex);
throw new KnownException(ErrorTypeEnum.UnexpectedExeption, ex.Message, ex);
}
}
public Profile()
{
InitializeComponent();
UserLoginResponseDto response = EmployePanel.GetResponseDto();
user = response.User;
patrimoineRepository = new PatrimoineRepository();
}
private void Dashboard_Load(object sender, EventArgs e)
{
UserLoginResponseDto response = AdminPanel.GetResponseDto();
user = response.User;
dataGridView.DataSource = patrimoineRepository.GetAll();
modifierPatrimoineBtn.Enabled = true;
supprimerPatrimoineBtn.Enabled = true;
}
private UserLoginResponseDto GenerateUserLoginResponse(string jwt, string refreshToken, User user)
{
var response = new UserLoginResponseDto
{
Jwt = jwt,
RefreshToken = refreshToken,
User = Mapper.Map <UserDto>(user)
};
return(response);
}
public async Task <ActionResult> Login([FromBody] UserLoginRequestDto model)
{
if (ModelState.IsValid)
{
var user = await _userManager.FindByNameAsync(model.UserName);
if (user != null)
{
var result = await _signInManager.PasswordSignInAsync(model.UserName, model.Password, false, false);
if (result.Succeeded)
{
// create token
var claims = new[]
{
new Claim(JwtRegisteredClaimNames.Sub, model.UserName),
new Claim(JwtRegisteredClaimNames.UniqueName, user.UserName),
new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString())
};
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_configuration["JwtSettings:Secret"]));
var credentials = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var token = new JwtSecurityToken(
_configuration["JwtSettings:Issuer"],
_configuration["JwtSettings:Audience"],
claims,
expires: DateTime.UtcNow.AddDays(1),
signingCredentials: credentials
);
var response = new UserLoginResponseDto
{
User = new UserDto
{
UserName = user.UserName
},
Token = new JwtSecurityTokenHandler().WriteToken(token),
TokenExpiration = token.ValidTo
};
return(Created("", response));
}
}
ModelState.AddModelError("", "Failed to login");
return(BadRequest(ModelState));
}
return(BadRequest(ModelState));
}
private void employeeLoginBtn_Click(object sender, EventArgs e)
{
string email = emailBox.Text;
string password = passwordBox.Text;
UserLoginDto userLoginDto = new UserLoginDto(email, password);
UserRepository userRepository = new UserRepository();
response = userRepository.findUser(userLoginDto, "employee");
if (response.DoesExist)
{
Profile profile = new Profile();
profile.Show();
}
else
{
MessageBox.Show("Email ou mot de pass est incorrect");
}
}
private void adminLoginBtn_Click(object sender, EventArgs e)
{
string email = emailBox.Text;
string password = passwordBox.Text;
UserLoginDto userLoginDto = new UserLoginDto(email, password);
UserRepository userRepository = new UserRepository();
response = userRepository.findUser(userLoginDto, "admin");
if (response.DoesExist)
{
Dashboard dashboard = new Dashboard();
dashboard.Show();
}
else
{
MessageBox.Show("Email ou mot de pass est incorrect");
}
}
public async Task <UserLoginResponseDto> Login(UserToLoginDto userToLogin)
{
var user = await _dataContext.Users
.Where(u => u.Email == userToLogin.Email)
.FirstOrDefaultAsync();
if (user == null)
{
return(null);
}
if (!IsCorrectPassword(userToLogin.Password, user.PasswordHash, user.PasswordSalt))
{
return(null);
}
var userLoginResponseDto = new UserLoginResponseDto {
Id = user.Id,
Email = user.Email
};
return(userLoginResponseDto);
}
public IHttpActionResult Login(UserLoginRequestDto req)
{
UserLoginResponseDto response;
var user = context.User.Where(x => (x.Email == req.Email || x.Username == req.Email) && x.Password == req.Password).FirstOrDefault();
if (user != null)
{
response = new UserLoginResponseDto()
{
Data = mapper.Map <User, UserLoginDto>(user),
ErrorMessage = null
};
}
else
{
response = new UserLoginResponseDto()
{
Data = null,
ErrorMessage = "incorrect password or email "
};
}
return(Json(response));
}
