} //Usuários
public ModelUser ValidaUsuario(ModelUser User)
{
ModelUser user = new ModelUser();
string senHash = "";
erroExecSQL = "";
try
{
conexao = new SqlCeConnection(Funcoes.Busca_Conexao());
string conSql = "SELECT codUser, usuario, senUser, perfilUser, staUser FROM USUARIOS " +
"WHERE (usuario = @user)";
cmd = new SqlCeCommand(conSql, conexao);
cmd.Parameters.AddWithValue("@user", User.Usuario);
conexao.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
user.CodUser = reader.GetInt32(0);
user.Usuario = reader.GetString(1);
senHash = reader.GetString(2);
user.PerfUser = reader.GetString(3);
user.StaUser = reader.GetString(4);
}
conexao.Close();
}
catch (Exception ex)
{
erroExecSQL = ex.Message;
return(null);
}
if (user.CodUser > 0)
{
if (Funcoes.VerifyMd5Hash(User.Senha, senHash))
{
return(user);
}
else
{
user.CodUser = 0;
return(user);
}
}
return(user);
} //ValidaUsuario
