//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" } })); } }