//inicio do métod testar usuário
public void TestarUsuario(modelLogin user)
{
MySqlCommand cmd = new MySqlCommand("select * from tbLogin where usuario = @usuario and senha = @Senha", con.MyConectarBD());
cmd.Parameters.Add("@usuario", MySqlDbType.VarChar).Value = user.usuario;
cmd.Parameters.Add("@Senha", MySqlDbType.VarChar).Value = user.senha;
//comando que divide os dados selecionados para pegar individualmente
MySqlDataReader leitor;
leitor = cmd.ExecuteReader();
if (leitor.HasRows)
{
while (leitor.Read())
{
user.usuario = Convert.ToString(leitor["usuario"]);
user.senha = Convert.ToString(leitor["senha"]);
user.tipo = Convert.ToString(leitor["tipo"]);
}
}
else
{
user.usuario = null;
user.senha = null;
user.tipo = null;
}
con.MyDesconectarBD();
}
public void TestarUsuario(modelLogin user)
{
MySqlCommand cmd = new MySqlCommand("select * from tbLogin where usuario = @usuario and senha = @senha", con.MyConectarBD());
cmd.Parameters.Add("@usuario", MySqlDbType.VarChar).Value = user.usuario;
cmd.Parameters.Add("@senha", MySqlDbType.VarChar).Value = user.senha;
MySqlDataReader leitor;
leitor = cmd.ExecuteReader();
if (leitor.HasRows)
{
while (leitor.Read())
{
{
user.usuario = Convert.ToString(leitor["usuario"]);
user.senha = Convert.ToString(leitor["senha"]);
user.perm = Convert.ToString(leitor["perm"]);
}
}
}
else
{
user.usuario = null;
user.senha = null;
user.perm = null;
}
con.MyDesconectarBD();
}
public ActionResult Index(modelLogin verLogin)
{
acLg.TestarUsuario(verLogin);
if (verLogin.usuario != null && verLogin.senha != null)
{
//criando a auteticação da sessao dentro do login
FormsAuthentication.SetAuthCookie(verLogin.usuario, false);
Session["usuarioLogado"] = verLogin.usuario.ToString();
Session["senhaLogado"] = verLogin.senha.ToString();
//verificadando o tipo de usuario
if (verLogin.tipo == "1")
{
Session["tipoLogado1"] = verLogin.tipo.ToString(); //=1;
}
else
{
Session["tipoLogado2"] = verLogin.tipo.ToString();//=2
}
//pagina para onde sera direcionado o usuario logado
return(RedirectToAction("About", "Home"));
}
else
{
ViewBag.msgLogar = "Usuário não encontrado. Verifique o nome do usuário e a senha";
Response.Write("<script>alert('Erro no Login')</script>");
return(View());
}
}
public void inserirLogin(modelLogin cm)
{
MySqlCommand cmd = new MySqlCommand("insert into tblogin values(@usuario, @senha, @perm)", con.MyConectarBD());
cmd.Parameters.Add("@usuario", MySqlDbType.VarChar).Value = cm.usuario;
cmd.Parameters.Add("@senha", MySqlDbType.VarChar).Value = cm.senha;
cmd.Parameters.Add("@perm", MySqlDbType.VarChar).Value = cm.perm;
cmd.ExecuteNonQuery();
con.MyDesconectarBD();
}
public async Task <ActionResult> Login(modelLogin model)
{
ApplicationUser user = await userManager.FindByNameAsync(model.Username);
var result = await signInManager.PasswordSignInAsync(user, model.Password, isPersistent : true, false);
//string awit = db.ApplicationUsers.Select(u => u.SecurityStamp).FirstOrDefault();
//string awit2 = db.ApplicationUsers.FirstOrDefault(u => u.SecurityStamp == "").SecurityStamp;
if (user != null && result.Succeeded == true)
{
if (user.userStatus != "active")
{
return(BadRequest(responseMessage = new ResponseMessage()
{
Code = "400",
Message = new List <string>()
{
"Account is not active"
}
}));
}
else
{
var claims = new[]
{
new Claim(JwtRegisteredClaimNames.Sub, model.Username),
new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString())
};
var signingKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes("QWEASDZXCzETMBEGA1UECAwKU29tZS1TdGF0ZTESMBA"));
var token = new JwtSecurityToken(
issuer: "issuer",
audience: "reader",
expires: DateTime.UtcNow.AddHours(6),
claims: claims,
signingCredentials: new SigningCredentials(signingKey, SecurityAlgorithms.HmacSha256)
);
return(Ok(new
{
user = new
{
Id = user.Id, UserName = user.UserName, firstName = user.firstName,
department = user.department, Email = user.Email, lastName = user.lastName,
middleName = user.middleName, rank = user.rank, userType = user.userType,
DateAcctCreated = user.DateAcctCreated.ToString("MM/dd/yyyy HH:mm"),
TriggredColor = "Yellow"
},
token = new JwtSecurityTokenHandler().WriteToken(token),
expiration = token.ValidTo
}));
}
}
else
{
logger.LogError("incorrect email password");
return(Unauthorized(responseMessage = new ResponseMessage()
{
Code = "401",
Message = new List <string>()
{
"Incorrect Username or password"
}
}));
}
}
