public LoginUser loginResult([FromBody] LoginUser log) { SqlConnection conn = new SqlConnection("Server=tcp:udfz7di8my.database.windows.net,1433;Database=xpto;User ID=xptodb@udfz7di8my;Password=Xpto123456;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"); conn.Open(); SqlCommand cmd; SqlDataReader reader; cmd = new SqlCommand("select username from usuario_result where senha = '" + log.senha + "'", conn); reader = cmd.ExecuteReader(); reader.Read(); LoginUser a = new LoginUser(); if (!reader.HasRows) { a.acessar = false; return a; } string usuario = reader.GetString(0); if (usuario + log.senha == log.username + log.senha) { a.acessar = true; return a; } else { a.acessar = false; return a; } }
public LoginUser logar([FromBody] string senha) { SqlConnection conn = new SqlConnection("Server=tcp:udfz7di8my.database.windows.net,1433;Database=xpto;User ID=xptodb@udfz7di8my;Password=Xpto123456;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"); conn.Open(); SqlCommand cmd; SqlDataReader reader; cmd = new SqlCommand("select senha from usuario where senha = '" + senha +"'", conn); reader = cmd.ExecuteReader(); reader.Read(); LoginUser a = new LoginUser(); if (reader.HasRows) { a.senha = true; return a; } else { a.senha = false; return a; } }