private void timer1_Tick(object sender, EventArgs e) { lblLogin.Text = frm_login.email; if (frm_login.cod == "1") { MySqlConnection conn = null; string strConn = @"Server=localhost;Database=tcc;Uid=root;Pwd='';Connect Timeout=30;"; conn = new MySqlConnection(strConn); conn.Open(); string mSQL = "Select * from usuario where Usuario_CodLogin ='******'"; MySqlCommand cmd = new MySqlCommand(mSQL, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); string BancoFoto = dt.Rows[0]["Usuario_Foto"].ToString(); foto.Image = Image.FromFile("C:\\foto\\" + BancoFoto + ".png "); frm_login.cod = "0"; } if (frm_MenSalvar.salvar == "1") { OpenFileDialog dialog = new OpenFileDialog(); foto.Image.Save("C:\\foto\\" + arquivo + ".png", System.Drawing.Imaging.ImageFormat.Png); string dbfile = dialog.FileName; Orientacao i = new Orientacao(); i._UserFoto = arquivo; i._email = lblLogin.Text; i.atualizarFoto(); frm_MenSalvar.salvar = "0"; } else if (frm_MenSalvar.cancelar == "1") { MySqlConnection conn1 = null; string strConn1 = @"Server=localhost;Database=tcc;Uid=root;Pwd='';Connect Timeout=30;"; conn1 = new MySqlConnection(strConn1); conn1.Open(); string mSQL1 = "Select * from usuario where Usuario_CodLogin ='******'"; MySqlCommand cmd1 = new MySqlCommand(mSQL1, conn1); MySqlDataAdapter da1 = new MySqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); da1.Fill(dt1); string BancoFoto1 = dt1.Rows[0]["Usuario_Foto"].ToString(); foto.Image = Image.FromFile("C:\\foto\\" + BancoFoto1 + ".png "); frm_MenSalvar.cancelar = "0"; } }
private void btn_acessar_Click(object sender, EventArgs e) { MySqlConnection conn = null; string strConn = @"Server=localhost;Database=tcc;Uid=root;Pwd='';Connect Timeout=30;"; conn = new MySqlConnection(strConn); conn.Open(); string mSQL = "Select * from login where Login_Email ='" + TelaContaControl.email + "'"; MySqlCommand cmd = new MySqlCommand(mSQL, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); string BancoSenha = dt.Rows[0]["Login_Senha"].ToString(); string SenhaAtual = txt_SenhaAntiga.Text; if (BancoSenha == SenhaAtual) { if (txt_NewSenha.Text == txt_ConfirmSenha.Text) { Orientacao senha = new Orientacao(); senha._senha = txt_ConfirmSenha.Text; senha._senha = txt_ConfirmSenha.Text; senha._email = TelaContaControl.email; senha.atualizar(); } else { MessageBox.Show("Digite senhas iguais", "Acesso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("Usuario ou Senha invalidos", "Acesso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } frm_MenOk ok = new frm_MenOk(); ok.Show(); Close(); }