public static UsuarioModel BuscaUsuario(string usuario)
{
var ret = new UsuarioModel();
using (var comando = new SqlCommand())
{
comando.Connection = Conexao.connection;
comando.CommandText = string.Format(
"select * from UserSys where Login = '******' or Email = '{1}'", usuario, usuario); Conexao.Desconectar();
Conexao.Desconectar();
Conexao.Conectar();
var reader = comando.ExecuteReader();
while (reader.Read())
{
ret.Id = (int)reader["Id"];
ret.Login = (string)reader["Login"];
ret.Email = (string)reader["Email"];
ret.UserRoleId = (int)reader["UserRoleId"];
}
Conexao.Desconectar();
}
return(ret);
}
