コード例 #1
0
        public DadosUsuarioEnt getProf(String login)
        {
            DadosUsuarioEnt dadosUserEnt = new DadosUsuarioEnt();
            String          loginPesq    = login;

            MySqlConnection con = new MySqlConnection(b.Conex());

            String AlunoCmd = "SELECT Login_Login, nome, email, cpf, telefone FROM Professor WHERE Login_Login = '******'";

            MySqlCommand cmd = new MySqlCommand(AlunoCmd, con);

            con.Open();

            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                dadosUserEnt.Login    = reader["Login_Login"].ToString();
                dadosUserEnt.Nome     = reader["nome"].ToString();
                dadosUserEnt.Email    = reader["email"].ToString();
                dadosUserEnt.Telefone = reader["telefone"].ToString();
            }

            con.Close();

            return(dadosUserEnt);
        }
コード例 #2
0
        public DadosUsuarioEnt getAluno(String login)
        {
            DadosUsuarioEnt dadosUserEnt = new DadosUsuarioEnt();
            String          loginPesq    = login;

            MySqlConnection con = new MySqlConnection(b.Conex());

            String AlunoCmd = "SELECT Login_Login, nome, email, cpf, telefone, Turma_idTurma FROM Aluno, Matricula WHERE Aluno_Login_Login = Login_Login AND Login_Login = '******'";

            MySqlCommand cmd = new MySqlCommand(AlunoCmd, con);

            con.Open();

            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                dadosUserEnt.Login    = reader["Login_Login"].ToString();
                dadosUserEnt.Nome     = reader["nome"].ToString();
                dadosUserEnt.Email    = reader["email"].ToString();
                dadosUserEnt.Telefone = reader["telefone"].ToString();
                dadosUserEnt.IdTurma  = Convert.ToInt32(reader["Turma_idTurma"].ToString());
            }

            con.Close();

            return(dadosUserEnt);
        }
コード例 #3
0
 public void getDados(DadosUsuarioEnt dados)
 {
     userData = dados;
 }
コード例 #4
0
 public DeletarTarefas(DadosUsuarioEnt entUser)
 {
     InitializeComponent();
     ent = entUser;
 }
コード例 #5
0
 public void getUserObj(DadosUsuarioEnt userData)
 {
     ent = userData;
 }
コード例 #6
0
 public CriarTarefa(DadosUsuarioEnt entUser)
 {
     InitializeComponent();
     ent = entUser;
 }