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;
}
}
