private void loginPatient()
{
//Query database for credentials
SqlConnection sqlConn = new SqlConnection(ConnectionString);
SqlCommand sqlCmd = new SqlCommand("SELECT PASSWORD from PatientTable where USER_ID='" + txtUsername.Text + "'", sqlConn);
sqlCmd.Parameters.AddWithValue("@USER_ID", txtUsername.Text);
sqlConn.Open();
SqlDataReader reader = sqlCmd.ExecuteReader();
reader.Read();
if (reader.HasRows == true)
{
if (reader[0].ToString() == txtPassword.Text)
{
//Redirtect user to the patient menu
this.Hide();
PatientMenu PatientMenu = new PatientMenu();
PatientMenu.Show();
}
else
{
MessageBox.Show("Password is incorrect", "Incorrect Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("User does not exist", "Invalid Credentials!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
sqlConn.Close();
}
public void PatientLogin(string email, string password)
{
var patient = this.context.Patients
.Where(d => d.Email.Equals(email) && d.Password.Equals(password))
.FirstOrDefault();
if (patient == null)
{
Console.WriteLine("Invalid credentials.");
Console.WriteLine("Redirecting to main menu...");
System.Threading.Thread.Sleep(1300);
}
else
{
patientMenu = new PatientMenu(patient);
}
}
/// <summary>
/// Method for login user
/// </summary>
private void LoginExecute()
{
string username = mainWindow.NameTextBox.Text;
// Hash password
var hasher = new SHA256Managed();
var unhashed = Encoding.Unicode.GetBytes(mainWindow.passwordBox.Password);
var hashed = hasher.ComputeHash(unhashed);
var hashedPassword = Convert.ToBase64String(hashed);
string password = hashedPassword;
Service s = new Service();
tblPatient patientLogin = s.GetUsernamePasswordPatient(username, password);
if (patientLogin != null)
{
Xceed.Wpf.Toolkit.MessageBox.Show($"{ username}, dobrodošli.", "L-Medical Institution");
PatientMenu patientMenu = new PatientMenu
{
Owner = mainWindow
};
mainWindow.Hide();
patientMenu.ShowDialog();
}
else if (usernameAdmin == mainWindow.NameTextBox.Text.ToString() && passwordAdmin == mainWindow.passwordBox.Password.ToString())
{
Xceed.Wpf.Toolkit.MessageBox.Show($"{usernameAdmin}, dobrodošli.", "L-Medical Institution");
AdminMenu adminMenu = new AdminMenu
{
Owner = mainWindow
};
mainWindow.Hide();
adminMenu.ShowDialog();
}
else
{
Xceed.Wpf.Toolkit.MessageBox.Show("Korisničko ime ili lozinka nisu ispravni,\n pokušajte opet.", "Nalog nije pronađen.");
}
}
public PatientMenuViewModel(PatientMenu patientMenu)
{
this.patientMenu = patientMenu;
}
