public FormVerUtentesRegistados(Enfermeiro enf, FormMenu formM)
{
InitializeComponent();
conn.ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=SiltesSaude;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
enfermeiro = enf;
formMenu = formM;
}
public MenuMarcacoes(Enfermeiro enf, FormMenu formM)
{
InitializeComponent();
enfermeiro = enf;
formMenu = formM;
conn.ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=SiltesSaude;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
UpdateGridViewConsultas();
dataConsulta.MinDate = DateTime.Today;
dataConsulta.Enabled = false;
dataConsultaAdiar.MinDate = DateTime.Today;
horaConsultaAdiar.Format = DateTimePickerFormat.Custom;
horaConsultaAdiar.CustomFormat = "HH:mm";
horaConsultaAdiar.ShowUpDown = true;
errorProvider.ContainerControl = this;
errorProvider.BlinkStyle = System.Windows.Forms.ErrorBlinkStyle.NeverBlink;
//dataGridViewMarcacoes.CurrentCell.RowIndex;
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
conn.Open();
com.Connection = conn;
byte[] hash;
hash = new MD5CryptoServiceProvider().ComputeHash(ASCIIEncoding.ASCII.GetBytes(txtPassword.Text));
System.Text.StringBuilder sb = new System.Text.StringBuilder();
for (int i = 0; i < hash.Length; i++)
{
sb.Append(hash[i].ToString("X2"));
}
SqlCommand cmd = new SqlCommand("select * from Enfermeiro where username = @username AND password = @password", conn);
cmd.Parameters.AddWithValue("@username", txtUsername.Text);
cmd.Parameters.AddWithValue("@password", sb.ToString());
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
//string data = DateTime.ParseExact(reader["data"].ToString(), "dd/MM/yyyy HH:mm:ss", null);
string data = DateTime.ParseExact(reader["dataNascimento"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
Enfermeiro enfermeiro = new Enfermeiro
{
IdEnfermeiro = (int)reader["IdEnfermeiro"],
nome = (string)reader["nome"],
funcao = (string)reader["funcao"],
username = (string)reader["username"],
contacto = Convert.ToDouble(reader["contacto"]),
email = (string)reader["email"],
permissao = (int)reader["permissao"],
DataNascimento = data
};
if ((bool)reader["passwordDefault"] == true)
{
PrimeiroAcesso redefenirPrimeiroAcesso = new PrimeiroAcesso(enfermeiro);
redefenirPrimeiroAcesso.Show();
txtUsername.Text = "";
txtPassword.Text = "";
}
else
{
MessageBox.Show("Login Efetuado com Sucesso", "Parabéns", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormMenu formMenu = new FormMenu(enfermeiro);
formMenu.Show();
this.Close();
}
}
else
{
MessageBox.Show("Nome de utilizador ou palavra passe errados. Volte a tentar.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conn.Close();
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível iniciar sessão!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public FormDefinicoesPessoais(Enfermeiro enf, FormMenu form)
{
InitializeComponent();
enfermeiro = enf;
parent = form;
}