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